In this post, I will try and describe everything you need to know about the SAP crmd_activity_h 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_H 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_H....Right lets get started!
Object Name: CRMD_ACTIVITY_H
Dictionary Type: Transparent table
Description: Activity
| 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 | ||||||
| CATEGORY | CRMT_ACTIVITY_CATEGORY | CHAR | 3(0) | CRMC_ACT_CATEGOR | Activity Category (Communication Type) | CRM_ACTIVITY_CATEGORY | CRM | |||||
| PRIORITY | CRMT_PRIORITY | NUMC | 1(0) | SCPRIO | Activity Priority | SC_PRIO | CRM | |||||
| OBJECTIVE | CRMT_OBJECTIVE | CHAR | 3(0) | CRMC_ACT_OBJ | Goal of an Activity | CRM_OBJECTIVE | CRM | |||||
| DIRECTION | CRMT_DIRECTION | CHAR | 1(0) | Direction of an Activity | CRM_DIRECTION | CRM | ||||||
| EXTERN_ACT_ID | CRMT_EXTERNAL_ACTIVITY_ID | CHAR | 20(0) | External Business Transaction Number | CRM_EXTERNAL_ACTIVITY_ID | CRM | ||||||
| ADDRESS_ID | CRMT_ADDRESS | CHAR | 10(0) | * | Location where Activity takes place | AD_ADDRNUM | CRM | |||||
| PRIVATE_FLAG | CRMT_PRIVAT | CHAR | 1(0) | Indicator: Task is Private | CRM_BOOLEAN | CRM | ||||||
| COMPLETION | CRMT_COMPLETION | NUMC | 3(0) | Completion Rate in Percent | CRM_COMPLETION | CRM_ACT_COMPLETION | COMPLETION | CRM | ||||
| ACT_LOCATION | CRMT_ACTIVITY_LCTN | CHAR | 100(0) | Location | CRM_ACTIVITY_LOCATION | CRM | ||||||
| CALENDAR | CRMT_CALENDAR | CHAR | 1(0) | Include Activity in Calendar | CRM_BOOLEAN | CRM | ||||||
| TASK | CRMT_TASK | CHAR | 1(0) | Indicator: Activity is a Task | CRM_BOOLEAN | CRM | ||||||
| CLASS | CRMT_ACTIVITY_CLASS | CHAR | 1(0) | Activity Class | CRM_ACTIVITY_CLASS | CRM |