In this post, I will try and describe everything you need to know about the SAP crmd_mktlist_lea 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_LEA 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_LEA....Right lets get started!
Object Name: CRMD_MKTLIST_LEA
Dictionary Type: Transparent table
Description: Staging - Import Leads
| 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 | ||||||
| START_DATE | CRMT_MKTLIST_LEAD_START_DATE | DATS | 8(0) | Lead Start Date | DATUM | CRM | ||||||
| EXP_END_DATE | CRMT_MKTLIST_LEAD_END_DATE | DATS | 8(0) | Lead Expected End Date | DATUM | CRM | ||||||
| USER_STATUS | CRM_J_STATUS | CHAR | 5(0) | Object Status | CRM_J_STATUS | BSV | CRM | |||||
| LEAD_PRIORITY | CRMT_IMPORTANCE | CHAR | 1(0) | * | Opportunity/Lead Priority | CRM_IMPORTANCE | CRM | |||||
| LEAD_GROUP | CRMT_LEAD_TYPE | CHAR | 4(0) | * | Lead Group | CRM_LEAD_TYPE | CRM | |||||
| MANUAL_QUAL_LEV | CRMT_LEAD_QUAL_LEVEL_MAN | CHAR | 2(0) | * | Lead Qualification Level | CRM_LEAD_QUAL_LEVEL | CRM | |||||
| ORIGIN | CRMT_SOURCE | CHAR | 3(0) | * | Origin of Opportunity/Lead | CRM_SOURCE | CRM |