The CRMD_DHR_ACTIV table in SAP ERP or S/4HANA stores Activities data. There are total 41 fields in CRMD_DHR_ACTIV table. The Activities table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CRMD_DHR_ACTIV table. It is in Operative Reporting in CRM (CRM_REPORT) ABAP package and is part of the Reporting Framework (CRM-BTX-ANA-RFW) module.
SAP CRMD_DHR_ACTIV Table Fields
Following is the list of fields that are available in SAP CRMD_DHR_ACTIV table. The primary key fields of the table are CLIENT (Client), GUID (GUID of a CRM Order Object).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | CLNT (3) | |
| GUID | GUID of a CRM Order Object | CRMT_OBJECT_GUID | RAW (16) | |
| CHANGED_AT | Changed On (Output in User Time Zone) | CRMT_CHANGED_AT_USR | DEC (15) | |
| OBJECT_ID | Transaction ID | CRMT_OBJECT_ID | CHAR (10) | |
| PRIVATE_FLAG | Indicator: Task is Private | CRMT_PRIVAT | CHAR (1) | |
| CATEGORY | Activity Category (Communication Type) | CRMT_ACTIVITY_CATEGORY | * | CHAR (3) |
| PERSON_RESP | Employee Responsible | CRMT_PERSON_RESP | * | CHAR (10) |
| PRIORITY | Activity Priority | CRMT_PRIORITY | * | NUMC (1) |
| DESCRIPTION_UC | Transaction Description (Uppercase) | CRMT_PROCESS_DESCRIPTION_UC | CHAR (40) | |
| ACTIVITY_PARTNER | Activity Partner | CRMT_ACTIVITY_PARTNER | * | CHAR (10) |
| PROCESS_TYPE | Business Transaction Type | CRMT_PROCESS_TYPE_DB | * | CHAR (4) |
| CONTACT_PERSON | Customer Contact Person | CRMT_CONTACT_PERSON | * | CHAR (10) |
| DIRECTION | Direction of an Activity | CRMT_DIRECTION | CHAR (1) | |
| FROMDATE | Start Date | CRMT_DATES_START_DATE | DATS (8) | |
| TODATE | End Date | CRMT_DATES_END_DATE | DATS (8) | |
| STAT_OPEN | Transaction is Still Open | CRMT_STATUS_OPEN | CHAR (1) | |
| SALES_ORG_RESP | Organizational Unit (Sales) | CRMT_SALES_ORG_RESP | CHAR (14) | |
| STATUS | Object Status | CRM_J_STATUS | CHAR (5) | |
| USER_STAT_PROC | Status Profile | CRM_J_STSMA | * | CHAR (8) |
| ACT_TOT_DURA | Numerical Value of Duration | TIMEDURA | DEC (13) | |
| ACT_TOT_UNIT | Default Value for Time Unit | TIMEUNITDU | * | CHAR (12) |
| RESP_AT_PARTNER | Person Responsible at Partners (Channel Management) | CRMT_RESPONSIBLE_AT_PARTNER | * | CHAR (10) |
| PATH_ID | Territory Hierarchy ID | CRMT_TERRITORY_PATH_ID | CHAR (30) | |
| TERR_ID | Territory ID | CRMT_TERRITORY_ID | CHAR (30) | |
| SALES_ORG | Sales Organization ID | CRMT_SALES_ORG | CHAR (14) | |
| SALES_OFFICE | Sales Office | CRMT_SALES_OFFICE | CHAR (14) | |
| SALES_GROUP | Sales Group | CRMT_SALES_GROUP | CHAR (14) | |
| CODE_ACT_ST | Code | CRM_QCODE | * | CHAR (4) |
| CODEGRP_ACT_ST | Code Group | CRM_IST_CODE_GROUP | * | CHAR (8) |
| KATART_ACT_ST | Catalog | COMT_CATALOG | * | CHAR (2) |
| CATLVLGUID01_IR | Category GUID 1- schema 1 | CRM_REP_CAT_GUID_LEV01_S1 | RAW (16) | |
| CATLVLGUID02_IR | Category GUID 2- schema 1 | CRM_REP_CAT_GUID_LEV02_S1 | RAW (16) | |
| CATLVLGUID03_IR | Category GUID 3- schema 1 | CRM_REP_CAT_GUID_LEV03_S1 | RAW (16) | |
| CATLVLGUID04_IR | Category GUID 4- schema 1 | CRM_REP_CAT_GUID_LEV04_S1 | RAW (16) | |
| CATLVLGUID05_IR | Category GUID 5- schema 1 | CRM_REP_CAT_GUID_LEV05_S1 | RAW (16) | |
| CATLVLGUID06_IR | Category GUID 6- schema 1 | CRM_REP_CAT_GUID_LEV06_S1 | RAW (16) | |
| CATLVLGUID07_IR | Category GUID 7- schema 1 | CRM_REP_CAT_GUID_LEV07_S1 | RAW (16) | |
| CATLVLGUID08_IR | Category GUID 8- schema 1 | CRM_REP_CAT_GUID_LEV08_S1 | RAW (16) | |
| CATLVLGUID09_IR | Category GUID 9- schema 1 | CRM_REP_CAT_GUID_LEV09_S1 | RAW (16) | |
| CATLVLGUID10_IR | Category GUID 10- schema 1 | CRM_REP_CAT_GUID_LEV10_S1 | RAW (16) | |
| EEW_R_ACT_DUMMY | Dummy function in length 1 | DUMMY | CHAR (1) |
