In this post, I will try and describe everything you need to know about the SAP crmd_mktlist_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_MKTLIST_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_MKTLIST_I....Right lets get started!
Object Name: CRMD_MKTLIST_I
Dictionary Type: Transparent table
Description: External List - Business Partner - Assignment
| 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 | ||||
| ITEM_GUID | CRMT_MKTLIST_I_GUID | RAW | 16(0) | CRM Marketing: Line GUID for External List Item | SYSUUID | CRM | ||||||
| LIST_GUID | CRMT_MKTLIST_LIST_GUID | RAW | 16(0) | * | CRM Marketing: GUID for an External List | CRM_MKTLIST_LIST_GUID | CRM | |||||
| BP_GUID_ORG | CRMT_MKTLIST_BP_GUID | RAW | 16(0) | CRM Marketing: GUID for Business Partner | SYSUUID | CRM | ||||||
| BP_GUID_PER | CRMT_MKTLIST_BP_GUID | RAW | 16(0) | CRM Marketing: GUID for Business Partner | SYSUUID | CRM | ||||||
| POSTAL | CRMT_MKTLIST_ITEM_FLAG | CHAR | 1(0) | CRM Marketing: External List - Item Flag | CRM_MKTLIST_ITEM_FLAG | CRM | ||||||
| DUPLICATE | CRMT_MKTLIST_ITEM_FLAG | CHAR | 1(0) | CRM Marketing: External List - Item Flag | CRM_MKTLIST_ITEM_FLAG | CRM | ||||||
| BP_ORG_CLR_TYPE | CRMT_MKTLIST_BP_ORG_CLR_TYPE | CHAR | 1(0) | CRM Marketing: External List-Cleansing type of Organization | CRM_MKTLIST_BP_CLR_TYPE | CRM | ||||||
| BP_PER_CLR_TYPE | CRMT_MKTLIST_BP_PER_CLR_TYPE | CHAR | 1(0) | CRM Marketing: External List-Cleansing Type of Person | CRM_MKTLIST_BP_CLR_TYPE | CRM | ||||||
| TRANSACTION_GUID | CRMT_MKTLIST_TRANSACTION_GUID | RAW | 16(0) | CRM Marketing: External List - Transaction GUID | CRM_MKTLIST_TRANSACTION_GUID | CRM |