CRMT_BW_DS_ACTIVITY SAP (DataSource for Activities) Structure details

Dictionary Type: Structure
Description: DataSource for Activities




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




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

CRMT_BW_DS_ACTIVITY 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 "DataSource for Activities" 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 TYPE CRMT_BW_DS_ACTIVITY.

The CRMT_BW_DS_ACTIVITY table consists of various fields, each holding specific information or linking keys about DataSource for Activities data available in SAP. These include GUID (GUID for a Transaction), OBJECT_ID (Transaction ID), EXTERN_ACT_ID (External Business Transaction Number), 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 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
EXTERN_ACT_IDExternal Business Transaction Number CRMT_EXTERNAL_ACTIVITY_IDCHAR20CRM_EXTERNAL_ACTIVITY_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_ATTransaction Was Created at This Time CRMT_OPPT_CREATED_ATDATS8DATUM
CHANGED_BYTransaction Last Changed By CRMT_CHANGED_BYCHAR12UNAME
NUMBER_OF_HOrder Header Number CRMT_NUMBER_OF_HINT410INT4
RECORDMODEBW Delta Process: Record Mode RODMUPDMODCHAR1RODMUPDMOD
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
COMPLETIONCompletion Rate in Percent CRMT_COMPLETIONNUMC3CRM_COMPLETIONCRM_ACT_COMPLETION
CLASSActivity Class CRMT_ACTIVITY_CLASSCHAR1CRM_ACTIVITY_CLASS
STATUS_SYSTEMObject Status CRM_J_STATUSCHAR5CRM_J_STATUS
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
ACTIVITY_PARTNERActivity Partner: GUID CRMT_ACTIVITY_PARTNER_32CHAR10Assigned to domainALPHABU_PARTNER
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
CC_CATEGORY_GUIDCoherent Cat - GUID Data Element CRM_ERMS_CAT_GUIDRAW16SYSUUID
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
SALES_ORGObject ID OBJEKTIDNUMC8NUM08PON
SALES_OFFICEObject ID OBJEKTIDNUMC8NUM08PON
SALES_GROUPObject ID OBJEKTIDNUMC8NUM08PON
SALES_ORG_RESPObject ID OBJEKTIDNUMC8NUM08PON
DIS_CHANNELDistribution Channel CRMT_DISTRIBUTION_CHANNELCHAR2Assigned to domainCRM_DISTRIBUTION_CHANNELCRM_ORGMAN_DIS_CHANNEL
DIVISIONDivision CRMT_DIVISIONCHAR2Assigned to domainCRM_DIVISIONCRM_DIVISION
SERVICE_ORGObject ID OBJEKTIDNUMC8NUM08PON
SERVICE_ORG_RESPObject ID OBJEKTIDNUMC8NUM08PON
SERVICE_TGRP_ORGObject ID OBJEKTIDNUMC8NUM08PON
PURCH_ORGObject ID OBJEKTIDNUMC8NUM08PON
PURCH_GROUPObject ID OBJEKTIDNUMC8NUM08PON
PURCH_ORG_RESPObject ID OBJEKTIDNUMC8NUM08PON
CALDAYCalendar Day SMOCALDAYDATS8DATUM
CAL_ACT_TIMEActivity Time CRMT_ACTIVITY_TIMETIMS6UZEIT
FTF_DURATIONFace To Face Duration CRMT_FTF_DURATIONFLTP16(16) CRM_REPORT_DURATION_IN_MIN
DURATIONDuration of an Activity CRMT_ACT_DURATIONFLTP16(16) CRM_REPORT_DURATION_IN_MIN
GUID_OPPORTUNITYGUID for a Transaction CRMT_PROCESS_GUID_32CHAR32SYSUUID_C
COUNTERNumber of Activities (always 1) CRMT_NOACTNUMC1NUMC1
USSTATUser Status J_ESTATCHAR5Assigned to domainJ_ESTAT
STSMAStatus Profile J_STSMACHAR8Assigned to domainJ_STSMA
ACT_ONLYLogical Variable CRMT_BOOLEANCHAR1CRM_BOOLEAN
CALDAY_TOCalendar Day SMOCALDAYDATS8DATUM
SALESPARTNERSales Partners CRMT_SALESPARTNERCHAR10Assigned to domainALPHABU_PARTNER
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
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
EXECUTING_CCExecuting Interaction Center CRMT_EXECUTING_CCCHAR10Assigned to domainALPHABU_PARTNER
RESP_GROUPResponsible Group CRMT_RESPONSIBLE_GROUPCHAR10Assigned to domainALPHABU_PARTNER
BWSTONEUSS0BW Status CRMBWSTNUMC2J_STONR
PATH_GUIDPath GUID of Territory 32 CRMT_PATH_GUID_32CHAR32SYSUUID_C
TERR_GUIDTerritory GUID 32 CRMT_TERR_GUID_32CHAR32SYSUUID_C
REF_IOBJECT_IDProduct ID COMT_PRODUCT_IDCHAR40PRID1COM_PRODUCT_IDCOM_PR_COLLECTION
REF_IOBJECT_GUIDInternal Unique ID of Product COMT_PRODUCT_GUIDRAW16SYSUUID
REF_CONF_PROD_IDProduct ID COMT_PRODUCT_IDCHAR40PRID1COM_PRODUCT_IDCOM_PR_COLLECTION
REF_CONF_PROD_GUInternal Unique ID of Product COMT_PRODUCT_GUIDRAW16SYSUUID
REF_PROD_IDProduct ID COMT_PRODUCT_IDCHAR40PRID1COM_PRODUCT_IDCOM_PR_COLLECTION
REF_PROD_GUIDInternal Unique ID of Product COMT_PRODUCT_GUIDRAW16SYSUUID
REF_OBJ_FAMObject Family COMT_PRODUCT_OBJECT_FAMILYCHAR4Assigned to domainCOM_PRODUCT_OBJECT_FAMILYCOM_OBJFAM_PRTYP
REF_BUAG_IDNumber of the Business Agreement CRMT_BUAG_IDCHAR12ALPHACRMT_BUAG_IDCRM_BUAG
REF_BUAG_GUIDGUID of Business Agreement in Character Format CRMT_BUAG_GUID_CCHAR32SYSUUID_C
REF_NO_ITEMSOrder Item Number CRMT_NUMBER_OF_IINT410INT4
CUOBJConfiguration (Internal Object Number) CRMT_INT_OBJ_NONUMC18ALPHAIB_INSTANCE
INSTALL_ATInstalled At CRMT_INSTALL_AT_PARTCHAR10Assigned to domainALPHABU_PARTNER
INSTALL_AT_LISTInstalled At - Name CRMT_INSTALL_AT_LISTCHAR80CHAR80
RESPONS_AT_PARTNERPerson Responsible at Partners (Channel Management) CRMT_RESPONSIBLE_AT_PARTNERCHAR10Assigned to domainALPHABU_PARTNER
END_CUSTOMEREnd Customer (Channel Management) CRMT_END_CUSTOMERCHAR10Assigned to domainALPHABU_PARTNER
RESP_AT_PARTPerson Responsible at Partners (Channel Management) CRMT_RESPONSIBLE_AT_PARTNERCHAR10Assigned to domainALPHABU_PARTNER

Key field Non-key field



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

As CRMT_BW_DS_ACTIVITY 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 as there is no data to select.

How to access SAP table CRMT_BW_DS_ACTIVITY

Within an ECC or HANA version of SAP you can also view further information about CRMT_BW_DS_ACTIVITY 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!