In this post, I will try and describe everything you need to know about the SAP crmd_mktlist_act 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_MKTLIST_ACT 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_MKTLIST_ACT....Right lets get started!
Object Name: CRMD_MKTLIST_ACT
Dictionary Type: Transparent table
Description: Staging - Import Activities
| 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) | T000 | Client | MANDT | TEST | CRM | ||||
| PACKAGE_GUID | CRMT_MKTLIST_PACKAGE_GUID | RAW | 16(0) | CRM Marketing: GUID of a Working Package | CRM_MKTLIST_PACKAGE_GUID | CRM | ||||||
| C_HEAD_GUID | CRMT_MKTLIST_C_HEAD | RAW | 16(0) | External List Converted Cache Header GUID | CRM_MKTLIST_C_HEAD | CRM | ||||||
| TEMPLATE_ID | CRMT_MKTLIST_TEMPLATE_ID | CHAR | 10(0) | Template ID | CRM_OBJECT_ID | CRM | ||||||
| PROCESS_TYPE | CRMT_PROCESS_TYPE | CHAR | 4(0) | * | Business Transaction Type | CRM_PROCESS_TYPE | CRM_PROCESS_TYPE | CRM_PROCESS_TYPE | PROCESS_TYPE | CRM | ||
| DESCRIPTION | CRMT_PROCESS_DESCRIPTION | CHAR | 40(0) | Transaction Description | CRM_PROCESS_DESCRIPTION | CRM | ||||||
| ACTUAL_DATE_FROM | CRMT_MKTLIST_ACTUAL_DATE_FROM | DATS | 8(0) | Actual Date From | DATUM | CRM | ||||||
| ACTUAL_TIME_FROM | CRMT_MKTLIST_ACTUAL_TIME_FROM | TIMS | 6(0) | Actual Time From | SYTIME | CRM | ||||||
| ACTUAL_DATE_TO | CRMT_MKTLIST_ACTUAL_DATE_TO | DATS | 8(0) | Actual Date To | DATUM | CRM | ||||||
| ACTUAL_TIME_TO | CRMT_MKTLIST_ACTUAL_TIME_TO | TIMS | 6(0) | Actual Time To | SYTIME | CRM | ||||||
| USER_STATUS | CRM_J_STATUS | CHAR | 5(0) | Object Status | CRM_J_STATUS | BSV | CRM | |||||
| PRIORITY | CRMT_PRIORITY | NUMC | 1(0) | * | Activity Priority | SC_PRIO | CRM | |||||
| CATEGORY | CRMT_ACTIVITY_CATEGORY | CHAR | 3(0) | * | Activity Category (Communication Type) | CRM_ACTIVITY_CATEGORY | CRM |