In this post, I will try and describe everything you need to know about the SAP crmd_activity_i table. What it is, including what type of data it stores.
A list of fields which make up the table structure and on an S/4Hana System for CRMD_ACTIVITY_I what does this table look like.
And what relationships it has with other SAP tables.
Also see here for example ABAP code to select data from CRMD_ACTIVITY_I....Right lets get started!
Object Name: CRMD_ACTIVITY_I
Dictionary Type: Transparent table
Description: Activity Reporting : Activity Line Item Extension
| Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
| CLIENT | MANDT | CLNT | 3(0) | * | Client | MANDT | TEST | CRM | ||||
| GUID | CRMT_OBJECT_GUID | RAW | 16(0) | GUID of a CRM Order Object | SYSUUID | CRM | ||||||
| JOURNAL_GUID | CRMT_OBJECT_GUID | RAW | 16(0) | CRMC_ACT_JRNL | GUID of a CRM Order Object | SYSUUID | CRM | |||||
| REF_OBJECT_GUID | CRMT_OBJECT_GUID | RAW | 16(0) | GUID of a CRM Order Object | SYSUUID | CRM | ||||||
| OBJECT_TYPE | CRMT_SUBOBJECT_CATEGORY | CHAR | 10(0) | * | Business Transaction Category | CRM_OJ_NAME_PROCESS | CRM_SUBOBJ_CATEGORY | CRM_OBJECT_TYPE_PROCESS | SUBOBJ_CATEGORY | CRM | ||
| DISCUSS | CRMT_ACT_DISCUSSED | CHAR | 1(0) | Discussed | XFLAG | CRM | ||||||
| PRPRIO | CRMT_ACT_PROD_PRIORITY | CHAR | 4(0) | CRMC_ACT_PRPRI | Product Priority | CRM_ACT_PROD_PRIORITY | CRM | |||||
| STATUS | CRMT_ACT_PROD_STATUS | CHAR | 4(0) | CRMC_ACT_PRSTA | Status of documented product | CRM_ACT_PROD_STATUS | CRM | |||||
| PROD_HIERARCHY | COMT_HIERARCHY_ID | CHAR | 10(0) | Category Hierarchy ID | COM_HIERARCHY_ID | COM_HIER | HIERARCHY_ID | CRM |