CRMT_BW_DS_ACTIVITY_I SAP (Data Source for CRM Activities, Item Data) Structure details

Dictionary Type: Structure
Description: Data Source for CRM Activities, Item Data




ABAP Code to SELECT data from CRMT_BW_DS_ACTIVITY_I
Related tables to CRMT_BW_DS_ACTIVITY_I
Access table CRMT_BW_DS_ACTIVITY_I




Structure field list including key, data, relationships and ABAP select examples

CRMT_BW_DS_ACTIVITY_I is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Data Source for CRM Activities, Item Data" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_CRMT_BW_DS_ACTIVITY_I TYPE CRMT_BW_DS_ACTIVITY_I.

The CRMT_BW_DS_ACTIVITY_I table consists of various fields, each holding specific information or linking keys about Data Source for CRM Activities, Item Data data available in SAP. These include CLIENT (Client), GUID (GUID for a Transaction), OBJECT_ID (Transaction ID), PROCESS_TYPE (Business Transaction Type).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP CRMT_BW_DS_ACTIVITY_I structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
CLIENTClient MANDTCLNT3Assigned to domainMANDT
GUIDGUID for a Transaction CRMT_PROCESS_GUID_32CHAR32SYSUUID_C
OBJECT_IDTransaction ID CRMT_OBJECT_IDCHAR10ALPHACRM_OBJECT_IDCRM_OBJECT_IDCRM_ORDER_OBJECT_ID
PROCESS_TYPEBusiness Transaction Type CRMT_PROCESS_TYPECHAR4Assigned to domainCRM_PROCESS_TYPECRM_PROCESS_TYPECRM_PROCESS_TYPE
POSTING_DATEPosting Date for a Business Transaction CRMT_POSTING_DATEDATS8
DESCRIPTION_UCTransaction Description (Upper Case) CRMT_PROCESS_DESCRIPTION_UCCHAR40CRM_PROCESS_DESCRIPTION_UC
DESCR_LANGUAGELanguage Key of Description CRMT_PROCESS_DESCRIPTION_LANGULANG1Assigned to domainISOLASPRAS
LOGICAL_SYSTEMLogical System CRMT_LOGSYSCHAR10Assigned to domainALPHALOGSYS
OBJECT_TYPEBusiness Transaction Category CRMT_SUBOBJECT_CATEGORYCHAR10CRMC_SUBOB_CATCRM_OJ_NAME_PROCESSCRM_SUBOBJ_CATEGORYCRM_OBJECT_TYPE_PROCESS
CREATED_ATTransaction Was Created at This Time CRMT_OPPT_CREATED_ATDATS8DATUM
CREATED_BYUser that Created the Transaction CRMT_CREATED_BYCHAR12UNAMEUSER_ADDR
CHANGED_ATTime of Last Change to the Transaction CRMT_OPPT_CHANGED_ATDATS8DATUM
CHANGED_BYTransaction Last Changed By CRMT_CHANGED_BYCHAR12UNAME
RECORDMODEBW Delta Process: Record Mode RODMUPDMODCHAR1RODMUPDMOD
NUM_OF_HEADOrder Header Number CRMT_NUMBER_OF_HINT410INT4
OCCURRENCECounter: Document Cat. Appears at Least Once in Document CRMT_OCC_AT_LEAST_ONCECHAR1CRM_BOOLEAN
SCENARIOScenario Identity CRMT_SCENARIOCHAR10CRM_SCENARIO
TEMPLATE_TYPETemplate Type of CRM Transaction CRMT_TEMPLATE_TYPE_DBCHAR1CRM_TEMPLATE_TYPE
OCCURR_QUOTCounter: Document Cat. Appears at Least Once in Document CRMT_QUO_AT_LEAST_ONCECHAR1CRM_BOOLEAN
OCCURR_CONTCounter: Document Cat. Appears at Least Once in Document CRMT_CON_AT_LEAST_ONCECHAR1CRM_BOOLEAN
REF_UPDATEFlag: Ref. Update (Extract Structure Only Partially Filled) CRMT_FLG_REF_UPDATE_BWCHAR1XFELD
CATEGORYActivity Category (Communication Type) CRMT_ACTIVITY_CATEGORYCHAR3Assigned to domainCRM_ACTIVITY_CATEGORY
PRIORITYActivity Priority CRMT_PRIORITYNUMC1Assigned to domainSC_PRIO
OBJECTIVEGoal of an Activity CRMT_OBJECTIVECHAR3Assigned to domainCRM_OBJECTIVE
DIRECTIONDirection of an Activity CRMT_DIRECTIONCHAR1CRM_DIRECTION
KATALOGARTCatalog COMT_CATALOGCHAR2Assigned to domainCOM_CATALOGQKT
CODEGRUPPECode Group QCODEGRPCHAR8Assigned to domainQCODEGRPCGP
CODECode QCODECHAR4Assigned to domainQCODEQCODE
ACT_REASON_CATCatalog COMT_CATALOGCHAR2Assigned to domainCOM_CATALOGQKT
ACT_REASON_GROUPCode Group QCODEGRPCHAR8Assigned to domainQCODEGRPCGP
ACT_REASON_CODECode QCODECHAR4Assigned to domainQCODEQCODE
EXT_REFOBJExternal Reference Object CRMT_EXT_REFOBJCHAR40CHAR40
REQUESTED_DATEOrder Date CRMT_REQUESTED_DATEDATS8CRM_RPRTNG_DATE
CONFIRMED_DATELatest Confirmation Date for Item Schedule Line CRMT_CONFIRMED_DATEDATS8CRM_RPRTNG_DATE
BEGIN_DATEContract Start Date CRMT_BEGIN_DATEDATS8CRM_RPRTNG_DATE
ENDING_DATEContract End Date CRMT_ENDING_DATEDATS8CRM_RPRTNG_DATE
START_OF_BILLINGStart Date of Billing Plan CRMT_START_OF_BILLINGDATS8CRM_RPRTNG_DATE
VALID_FROM_DATEQuotation Valid from Date CRMT_VALID_FROM_DATEDATS8CRM_RPRTNG_DATE
VALID_TO_DATEQuotation: Valid to Date CRMT_VALID_TO_DATEDATS8CRM_RPRTNG_DATE
BW_POST_DATEPosting Date for BW Reporting CRMT_BW_POST_DATEDATS8CRM_RPRTNG_DATE
PLANNED_TS_FROMTime Stamp: Planned Date/Time from CRMT_PLANNED_TS_FROMDEC15TSTPSBCOS_TSTMP
PLANNED_TS_TOTime Stamp: Planned Date/Time to CRMT_PLANNED_TS_TODEC15TSTPSBCOS_TSTMP
ACTUAL_TS_FROMTime Stamp: Actual Date/Time from CRMT_ACTUAL_TS_FROMDEC15TSTPSBCOS_TSTMP
ACTUAL_TS_TOTime Stamp: Actual Date/Time to CRMT_ACTUAL_TS_TODEC15TSTPSBCOS_TSTMP
PLANNED_FROMPlanned Date from CRMT_PLANNED_FROMDATS8CRM_RPRTNG_DATE
PLANNED_TOPlanned Date to CRMT_PLANNED_TODATS8CRM_RPRTNG_DATE
ACTUAL_FROMActual Date from CRMT_ACTUAL_FROMDATS8CRM_RPRTNG_DATE
ACTUAL_TOActual Date to CRMT_ACTUAL_TODATS8CRM_RPRTNG_DATE
EARLIEST_CONFIRMEarliest Confirmation Date Still Not Delivered CRMT_EARLIEST_CONFIRMEDDATS8CRM_RPRTNG_DATE
DURADuration of Contract/Quotation CRMT_BW_DURATIONDEC13TIMEDURA
DURA_FULLFILLDuration Until Fulfillment of Contract CRMT_BW_DURA_FULLFILLDEC13TIMEDURA
DURA_UNITTime Unit for Duration of Contract/Quotation in Days CRMT_BW_DURA_UNITCHAR12Assigned to domainTIMEUNITNA
BEGIN_TO_COMPLETDuration Start to Conversion or Cancellation of a Quotation CRMT_BW_BEGIN_TO_COMPLETEDEC13TIMEDURA
COMPLETE_TO_ENDDuration Conversion or Cancellation Before End of Quotation CRMT_BW_COMPLETE_TO_ENDDEC13TIMEDURA
REL_TO_BEGINTime Relation: Time to Completion / Validity Interval CRMT_BW_REL_TO_BEGINDEC5(2)
REL_BEFORE_ENDTime Relation: Time Completed Before End / Validity Interval CRMT_BW_REL_BEFORE_ENDDEC5(2)
REQ_DLV_DATETime Stamp: Last Required Delivery Date CRMT_REQ_DELIVERY_DATEDEC15TSTPSBCOS_TSTMP
LAST_DLV_DATETime Stamp: Last Delivery Date CRMT_LAST_DELIVERY_DATEDEC15TSTPSBCOS_TSTMP
LAST_QI_ACT_DATETime Stamp: Last Actual Goods Issue Data CRMT_LAST_QI_ACTUAL_DATEDEC15TSTPSBCOS_TSTMP
LAST_REQ_AVA_DATTime Stamp: Last Material Availability Date (Requested) CRMT_LAST_REQ_AVAILABLE_DATEDEC15TSTPSBCOS_TSTMP
LAST_CONF_AV_DATTime Stamp: Last Material Availability Date (Confirmed) CRMT_LAST_CONF_AVAILABLE_DATEDEC15TSTPSBCOS_TSTMP
LAST_REQ_QI_PLDATime Stamp: Last Planned Goods Issue Date (Requested) CRMT_LAST_REQ_QI_PLANNED_DATEDEC15TSTPSBCOS_TSTMP
LAST_CONF_QI_PLDTime Stamp: Last Planned Goods Issue Date (Confirmed) CRMT_LAST_CONF_QI_PLANNED_DATEDEC15TSTPSBCOS_TSTMP
JOURNAL_GUIDGUID of a CRM Order Object CRMT_OBJECT_GUIDRAW16CRMC_ACT_JRNLSYSUUID
DISCUSSDiscussed CRMT_ACT_DISCUSSEDCHAR1XFLAG
PRPRIOProduct Priority CRMT_ACT_PROD_PRIORITYCHAR4CRMC_ACT_PRPRICRM_ACT_PROD_PRIORITY
STATUSStatus of documented product CRMT_ACT_PROD_STATUSCHAR4CRMC_ACT_PRSTACRM_ACT_PROD_STATUS
PROD_HIERARCHYCategory Hierarchy ID COMT_HIERARCHY_IDCHAR10COM_HIERARCHY_IDCOM_HIER
LAENGLength of the Product or of the Packaging of the Product COMT_LENGTHQUAN13(3) MENG13
BREITWidth of the Product or of the Packaging of the Product COMT_WIDTHQUAN13(3) MENG13
HOEHEHeight of the Product or of the Packaging of the Product COMT_HEIGHTQUAN13(3) MENG13
MEABMUnit in Which Length/Width/Height Is Measured COMT_UNIT_OF_DIMENSIONUNIT3T006CUNITMEINS
PRAVAProduct available after visit at checkout CRMT_ACT_PROD_AVAILABLE_AFTERCHAR3CRMC_ACT_PRAVACRM_ACT_PROD_AVAILABLE_AFTER
PRAVBProduct available before Visit at check out CRMT_ACT_PROD_AVAILABLE_BEFORECHAR3CRMC_ACT_PRAVBCRM_ACT_PROD_AVAILABLE_BEFORE
SUBJECTAFree Text: Subject A CRMT_ACT_SUBJECTACHAR10CRMC_ACT_SBJTACRM_ACT_SUBJECTA
SUBJECTBFree Text: Subject B CRMT_ACT_SUBJECTBCHAR10CRMC_ACT_SBJTBCRM_ACT_SUBJECTB
KV_RESULTResult CRMT_ACT_KVRESFCHAR1CRMC_ACT_RSLTCRM_ACT_KVRESF
RESREASResult Reason CRMT_ACT_RESRASCHAR3CRMC_ACT_RESRSCRM_ACT_RESRAS
KV_DEKODeko-Material CRMT_ACT_DECO_MATERIALCHAR3CRMC_ACT_DECOMCRM_ACT_DECO_MATERIAL
DEKOTPDeko type CRMT_ACT_DECO_TYPECHAR3CRMC_ACT_DECOTCRM_ACT_DECO_TYPE
KV_STOCKNumber of Products in stocks CRMT_ACT_DECO_NUMBER_ON_STOCKDEC6DEC6
POSLOCmain location of placement, eg. pallet, chip etc. CRMT_ACT_MAIN_LOCATIONCHAR3CRMC_ACT_MPLCTCRM_ACT_MAIN_LOCATION
KV_ZPANZNumber of Second placements CRMT_ACT_SECOND_PLACEMENTDEC3DEC3
KV_ZPAVASecond Placement Available CRMT_ACT_SEC_PLACEMENT_AVAILCHAR1Assigned to domainCRM_ACT_SDPMT
NRMSHFNumber of produts in main shelf CRMT_ACT_PROD_IN_MAIN_SHELFDEC6DEC6
NRPSHFNumber of products in promation shelf CRMT_ACT_PROD_IN_PROM_SHELFDEC6DEC6
POSVERvertical position in shelf CRMT_ACT_VERTICAL_POS_IN_SHELFCHAR3CRMC_ACT_POSVRCRM_ACT_VERTICAL_POS_IN_SHELF
POSHORhorizontal position in shelf CRMT_ACT_HORIZONT_POS_IN_SHELFCHAR3CRMC_ACT_POSHRCRM_ACT_HORIZONT_POS_IN_SHELF
POSQLIQualification of the shelf position CRMT_ACT_QUALI_OF_SHEL_POSCHAR3CRMC_ACT_POSQLCRMT_ACT_QUALI_OF_SHELF_POS
ECROPTOptimization of the shelf performed within an ECR agreement CRMT_ACT_SHELF_OPTIMIZATIONCHAR3CRMC_ACT_CURESCRM_ACT_SHELF_OPTIMIZATION
NROFFACNumber of facings CRMT_NUMBER_OF_FACINGDEC4DEC4
FACLENLength of facing CRMT_ACT_LENGTH_OF_FACINGDEC6DEC6
FACWIDWidth of facing CRMT_ACT_WIDTH_OF_FACINGDEC6DEC6
FACDEPDepth of facing CRMT_ACT_DEPTH_OF_FACINGDEC6(2) DEC4_2
FACUNITUnits of Measure of Product COMT_UNITUNIT3T006CUNITMEINS
SPRICESales Price in store CRMT_SALES_PRICE_IN_STORECURR28(2) CRMT_ACT_CURRENCY
OPRICEOrder Price in store CRMT_ACT_ORDER_PRICE_IN_STORECURR28(2) CRMT_ACT_CURRENCY
APRICEPromotion price in store CRMT_ACTION_PRICE_IN_STORECURR28(2) CRMT_ACT_CURRENCY
KVCURR1Currency CRMT_CURRENCYCUKY5Assigned to domainWAERSFWS
PHREFNRPharmaceutical Reference Number CRMT_ACT_PHARMA_REF_NUMBERCHAR10TEXT10
STORNOIndicator: Data to Be Canceled STORNOCHAR1CHAR1_X
LBVALValue of Samples CRMT_ACT_VALUE_LEFT_BEHINDDEC15(2) DEC13_2
EDAY_LOW_PRICEEveryday-Low-Price EVERYDAY_LOW_PRICECURR12(2) EVERYDAY_LOW_PRICE
LISTING_FEEListing Fee LISTING_FEECURR12(2) LISTING_FEE
PRP_RANKRank Indicator of a PPR CRMT_PRP_RANKNUMC10Assigned to domainALPHACRM_PRP_RANKCRM_PRP_SHLP_PRP_RANK
PRAVA0Placeholder for MSA fields CRMT_ACT_MSA_PRAVA0CHAR3Assigned to domainCRM_ACT_MSA_PLACEHOLDERS
PRAVA1Placeholder for MSA fields CRMT_ACT_MSA_PRAVA1CHAR3Assigned to domainCRM_ACT_MSA_PLACEHOLDERS
PRAVA2Placeholder for MSA fields CRMT_ACT_MSA_PRAVA2CHAR3Assigned to domainCRM_ACT_MSA_PLACEHOLDERS
PRAVA3Placeholder for MSA fields CRMT_ACT_MSA_PRAVA3CHAR3Assigned to domainCRM_ACT_MSA_PLACEHOLDERS
PRAVA4Placeholder for MSA fields CRMT_ACT_MSA_PRAVA4CHAR3Assigned to domainCRM_ACT_MSA_PLACEHOLDERS
PRAVB0Placeholder for MSA fields CRMT_ACT_MSA_PRAVB0CHAR3Assigned to domainCRM_ACT_MSA_PLACEHOLDERS
PRAVB1Placeholder for MSA fields CRMT_ACT_MSA_PRAVB1CHAR3Assigned to domainCRM_ACT_MSA_PLACEHOLDERS
PRAVB2Placeholder for MSA fields CRMT_ACT_MSA_PRAVB2CHAR3Assigned to domainCRM_ACT_MSA_PLACEHOLDERS
PRAVB3Placeholder for MSA fields CRMT_ACT_MSA_PRAVB3CHAR3Assigned to domainCRM_ACT_MSA_PLACEHOLDERS
PRAVB4Placeholder for MSA fields CRMT_ACT_MSA_PRAVB4CHAR3Assigned to domainCRM_ACT_MSA_PLACEHOLDERS
COMPETITORCompetitors CRMT_COMPETITORCHAR10Assigned to domainALPHABU_PARTNER
PROSPECTProspect CRMT_PROSPECTCHAR10Assigned to domainALPHABU_PARTNER
ACTIVITY_PARTNERActivity Partner CRMT_ACTIVITY_PARTNERCHAR10Assigned to domainALPHABU_PARTNER
SALES_EMPLOYEEEmployee CRMT_SALES_EMPLOYEECHAR10Assigned to domainALPHABU_PARTNER
PERSON_RESPEmployee Responsible CRMT_PERSON_RESPCHAR10Assigned to domainALPHABU_PARTNER
CONTACT_PERSONCustomer Contact Person CRMT_CONTACT_PERSONCHAR10Assigned to domainALPHABU_PARTNER
SALESPARTNERSales Partners CRMT_SALESPARTNERCHAR10Assigned to domainALPHABU_PARTNER
EXECUTING_CCExecuting Interaction Center CRMT_EXECUTING_CCCHAR10Assigned to domainALPHABU_PARTNER
RESP_GROUPResponsible Group CRMT_RESPONSIBLE_GROUPCHAR10Assigned to domainALPHABU_PARTNER
SALES_ORG_RESPObject ID OBJEKTIDNUMC8NUM08PON
SALES_ORGObject ID OBJEKTIDNUMC8NUM08PON
SALES_OFFICEObject ID OBJEKTIDNUMC8NUM08PON
SALES_GROUPObject ID OBJEKTIDNUMC8NUM08PON
DIS_CHANNELDistribution Channel CRMT_DISTRIBUTION_CHANNELCHAR2Assigned to domainCRM_DISTRIBUTION_CHANNELCRM_ORGMAN_DIS_CHANNEL
DIVISIONDivision CRMT_DIVISIONCHAR2Assigned to domainCRM_DIVISIONCRM_DIVISION
SERVICE_ORG_RESPObject ID OBJEKTIDNUMC8NUM08PON
SERVICE_ORGObject ID OBJEKTIDNUMC8NUM08PON
PURCH_ORG_RESPObject ID OBJEKTIDNUMC8NUM08PON
PURCH_ORGObject ID OBJEKTIDNUMC8NUM08PON
PURCH_GROUPObject ID OBJEKTIDNUMC8NUM08PON
ITEM_GUIDGUID for a Transaction CRMT_PROCESS_GUID_32CHAR32SYSUUID_C
ITEM_CREATED_ATTransaction Was Created at This Time CRMT_OPPT_CREATED_ATDATS8DATUM
ITEM_CREATED_BYUser that Created the Transaction CRMT_CREATED_BYCHAR12UNAMEUSER_ADDR
ITEM_CHANGED_ATTime of Last Change to the Transaction CRMT_OPPT_CHANGED_ATDATS8DATUM
ITEM_CHANGED_BYTransaction Last Changed By CRMT_CHANGED_BYCHAR12UNAME
ORDER_DATEPosting Date CRMT_OPPT_ORDER_DATEDATS8DATUM
NUMBER_INTItem Number in Document CRMT_ITEM_NONUMC10CRM_ITEM_NO
ITEM_OBJECT_TYPECRM Item Object Type CRMT_SWO_OBJTYP_PROCESS_ITEMCHAR10Assigned to domainCRM_OJ_NAME_PROCESS_ITEM
ITM_TYPEItem Category CRMT_ITEM_TYPECHAR4Assigned to domainCRM_ITEM_TYPECRM_ITEM_TYPE
NUMBER_OF_IOrder Item Number CRMT_NUMBER_OF_IINT410INT4
BW_ASSIGNAssign BW and CO CRMT_BW_ASSIGNCHAR1CRMT_BW_ASSIGN
ITM_USAGEUsage of Higher-Level Item CRMT_ITEM_USAGECHAR2CRM_ITEM_USAGE
ITM_TYPE_USAGEItem Category Usage CRMT_IT_TYPE_USAGECHAR4Assigned to domainCRM_IT_TYPE_USAGE
ALTERNATIVEGUID for a Transaction CRMT_PROCESS_GUID_32CHAR32SYSUUID_C
PARENTGUID for a Transaction CRMT_PROCESS_GUID_32CHAR32SYSUUID_C
PRODUCT_IDProduct ID COMT_PRODUCT_IDCHAR40PRID1COM_PRODUCT_IDCOM_PR_COLLECTION
PRODUCT_GUIDGUID for Product CHAR32 CRMT_PRODUCT_GUID_32CHAR32SYSUUID_C
MATERIALDistribution CRM -> R/3: Material CRMT_R3_MATERIALCHAR18CRM_R3_MATERIAL
CATEGORY_IDCategory ID COMT_CATEGORY_IDCHAR20COM_CATEGORY_IDCOM_CATEGORY_IDCOM_CAT_HIER
CATEGORY_GUIDCategory GUID COMT_CATEGORY_GUIDRAW16SYSUUID
SHORT_TEXT_UCProduct Description COMT_PRSHTEXTX_UPCHAR40PRSHTEXTG40
CATALOG_IDCatalog ID, from Which the Line PPR Was Selected CATALOG_PLCHAR20Assigned to domainKATALOGID
CATALOG_ITEM_IDCatalog Item (Unique Key) CRMT_CATALOGITEMCHAR40CRM_CATALOGITEM
PARTNER_PRODProduct Number of Business Partner CRMT_ITEM_DESCR_PARTNERCHAR40PRSHTEXT40
PARENT_PRODUCTGUID for Product CHAR32 CRMT_PRODUCT_GUID_32CHAR32SYSUUID_C
COMPETITOR_PRODGUID for Product CHAR32 CRMT_PRODUCT_GUID_32CHAR32SYSUUID_C
REPLACED_PRODGUID for Product CHAR32 CRMT_PRODUCT_GUID_32CHAR32SYSUUID_C
GROSS_WEIGHTGross Weight CRMT_GROSS_WEIGHTQUAN15(3) MENG15
NET_WEIGHTNet Weight CRMT_NET_WEIGHTQUAN15(3) MENG15
WEIGHT_UNITWeight Unit COMT_WEIGHT_UNITUNIT3Assigned to domainCUNITMEINS
VOLUMEVolume Occupied by the Product per Volume Unit CRMT_VOLUMEQUAN15(3) MENG15
VOLUME_UNITUnit for the Volume of a Product COMT_VOLUME_UNITUNIT3Assigned to domainCUNITMEINS
PROCESS_QTY_NUMNumerator (factor) for conversion trans. quantity in BME CRMT_PROCESS_QTY_NUMINT410CRM_PROCESS_QTY_NUM
PROCESS_QTY_DENDenominator (factor) for conversion trans. quantity in BME CRMT_PROCESS_QTY_DENINT410CRM_PROCESS_QTY_DEN
EXPONENT1010 Exponent for Quantity Conversion CRMT_EXPONENT10INT25CRM_EXPONENT10
PROCESS_QTY_UNITUnit of Measure in Which the Product Is Sold CRMT_PROCESS_QTY_UNITUNIT3Assigned to domainCUNITMEINS
PROD_PR_GROUPProduct Group CRMT_PROD_PR_GROUPCHAR2Assigned to domainCRM_PROD_PR_GROUP
PRC_GROUP1Product Group 1 CRMT_PRC_GROUP1CHAR3Assigned to domainCRM_PRC_GROUP1
PRC_GROUP2Product Group 2 CRMT_PRC_GROUP2CHAR3Assigned to domainCRM_PRC_GROUP2
PRC_GROUP3Product Group 3 CRMT_PRC_GROUP3CHAR3Assigned to domainCRM_PRC_GROUP3
PRC_GROUP4Product Group 4 CRMT_PRC_GROUP4CHAR3Assigned to domainCRM_PRC_GROUP4
PRC_GROUP5Product Group 5 CRMT_PRC_GROUP5CHAR3Assigned to domainCRM_PRC_GROUP5
BASE_QTY_UNITBase Unit of Measure of Product COMT_PRODUCT_BASE_UOMUNIT3Assigned to domainCUNITMEINS
CALDAYCalendar Day SMOCALDAYDATS8DATUM
PREDEC_OBJKEYGUID for a Transaction CRMT_PROCESS_GUID_32CHAR32SYSUUID_C
PREDEC_OBJTYPEObject Type of a Preceding Document CRMT_PRED_OBJECT_TYPECHAR10Assigned to domainOJ_NAME
LOGSYS_PREDLogical System CRMT_LOGSYSCHAR10Assigned to domainALPHALOGSYS
MKT_ELEMENTMarketing Plan Element CRM_MKTPL_MKT_PLAN_TASKIDCHAR24CGPL_EXTID
PRED_LEAD_GUIDGUID for a Transaction CRMT_PROCESS_GUID_32CHAR32SYSUUID_C
LEAD_CREATED_ATTransaction Was Created at This Time CRMT_OPPT_CREATED_ATDATS8DATUM
PRED_OPPT_GUIDGUID for a Transaction CRMT_PROCESS_GUID_32CHAR32SYSUUID_C
OPPT_CREATED_ATTransaction Was Created at This Time CRMT_OPPT_CREATED_ATDATS8DATUM
PRED_ACT_GUIDGUID for a Transaction CRMT_PROCESS_GUID_32CHAR32SYSUUID_C
ACT_CATEGORYActivity Category (Communication Type) CRMT_ACTIVITY_CATEGORYCHAR3Assigned to domainCRM_ACTIVITY_CATEGORY
ACT_DIRECTIONDirection of an Activity CRMT_DIRECTIONCHAR1CRM_DIRECTION
QUOTATION_GUIDGUID for a Transaction CRMT_PROCESS_GUID_32CHAR32SYSUUID_C
QUOT_VALID_FROMQuotation Valid from Date CRMT_VALID_FROM_DATEDATS8CRM_RPRTNG_DATE
PROCESS_CATEGORYActivity Category (Communication Type) CRMT_ACTIVITY_CATEGORYCHAR3Assigned to domainCRM_ACTIVITY_CATEGORY
PROCESS_CATALOGCatalog COMT_CATALOGCHAR2Assigned to domainCOM_CATALOGQKT
PROCESS_CODEGRCode Group QCODEGRPCHAR8Assigned to domainQCODEGRPCGP
PROCESS_CODECode QCODECHAR4Assigned to domainQCODEQCODE
PROCESS_OBJTYPEObject Type of a Preceding Document CRMT_PRED_OBJECT_TYPECHAR10Assigned to domainOJ_NAME
PO_NUMBERTransaction ID CRMT_OBJECT_IDCHAR10ALPHACRM_OBJECT_IDCRM_OBJECT_IDCRM_ORDER_OBJECT_ID
PO_ITEM_NUMBERItem Number in Document CRMT_ITEM_NONUMC10CRM_ITEM_NO
ORDER_QTYCRM: Order Quantity CRMT_QTY_ORDERQUAN13(3) MENG13
CONFIRMED_QTYCRM: Confirmed Quantity CRMT_QTY_CONFIRMEDQUAN13(3) MENG13
BWSTONESYS0BW Status CRMBWSTNUMC2J_STONR
BWSTONESYS1BW Status CRMBWSTNUMC2J_STONR
BWSTONESYS2BW Status CRMBWSTNUMC2J_STONR
BWSTONESYS3BW Status CRMBWSTNUMC2J_STONR
BWSTONESYS4BW Status CRMBWSTNUMC2J_STONR
BWSTONESYS5BW Status CRMBWSTNUMC2J_STONR
BWSTONESYS6BW Status CRMBWSTNUMC2J_STONR
BWSTONESYS7BW Status CRMBWSTNUMC2J_STONR
BWSTONESYS8BW Status CRMBWSTNUMC2J_STONR
BWSTONESYS9BW Status CRMBWSTNUMC2J_STONR
BWSTONESYSABW Status CRMBWSTNUMC2J_STONR
BWSTTECSYS0BW Status CRMBWSTNUMC2J_STONR
BWSTTECSYS1BW Status CRMBWSTNUMC2J_STONR
BWSTTECSYS2BW Status CRMBWSTNUMC2J_STONR
BWSTLOCSYS0BW Status CRMBWSTNUMC2J_STONR
BWSTLOCSYS1BW Status CRMBWSTNUMC2J_STONR
BWSTLOCSYS2BW Status CRMBWSTNUMC2J_STONR
BWSTONESYSBBW Status CRMBWSTNUMC2J_STONR
BWSTONEUSS0BW Status CRMBWSTNUMC2J_STONR
PATH_GUIDPath GUID of Territory 32 CRMT_PATH_GUID_32CHAR32SYSUUID_C
TERR_GUIDTerritory GUID 32 CRMT_TERR_GUID_32CHAR32SYSUUID_C
IOBJECT_IDProduct ID COMT_PRODUCT_IDCHAR40PRID1COM_PRODUCT_IDCOM_PR_COLLECTION
IOBJECT_GUIDInternal Unique ID of Product COMT_PRODUCT_GUIDRAW16SYSUUID
CONFPROD_IDProduct ID COMT_PRODUCT_IDCHAR40PRID1COM_PRODUCT_IDCOM_PR_COLLECTION
CONFPROD_GUIDInternal Unique ID of Product COMT_PRODUCT_GUIDRAW16SYSUUID
PROD_OBJ_FAMObject Family COMT_PRODUCT_OBJECT_FAMILYCHAR4Assigned to domainCOM_PRODUCT_OBJECT_FAMILYCOM_OBJFAM_PRTYP
BATCH_IDBatch Number CRMT_BATCH_IDCHAR10BATCH_IDCHA
SAMPLESample Indicator CRMT_SAMPLE_INVCHAR1CRM_BOOLEAN
SAMPLE_SPECSample CRMT_SAMPLE_SPECCHAR1CRMBWSAMPLE
SAMPLE_QTY_ALLOWNumber of samples CRM_ACT_NUMBER_OF_SAMPLESDEC4DEC4
CUOBJConfiguration (Internal Object Number) CRMT_INT_OBJ_NONUMC18ALPHAIB_INSTANCE
CC_CATEGORY_GUIDCoherent Cat - GUID Data Element CRM_ERMS_CAT_GUIDRAW16SYSUUID

Key field Non-key field



How do I retrieve data from SAP structure CRMT_BW_DS_ACTIVITY_I using ABAP code?

As CRMT_BW_DS_ACTIVITY_I is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on CRMT_BW_DS_ACTIVITY_I as there is no data to select.

How to access SAP table CRMT_BW_DS_ACTIVITY_I

Within an ECC or HANA version of SAP you can also view further information about CRMT_BW_DS_ACTIVITY_I and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!