The CRMD_MKTLIST_REL table in SAP ERP or S/4HANA stores Staging – Import partner – relationship data. There are total 8 fields in CRMD_MKTLIST_REL table. The Staging – Import partner – relationship table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CRMD_MKTLIST_REL table. It is in CRM Marketing: External List Management – Staging Engine 4.0 (CRM_MKTLIST_STAGING) ABAP package and is part of the External List Management (CRM-MKT-EAL) module.
SAP CRMD_MKTLIST_REL Table Fields
Following is the list of fields that are available in SAP CRMD_MKTLIST_REL table. The primary key fields of the table are CLIENT (Client), PACKAGE_GUID (CRM Marketing: GUID of a Working Package), C_HEAD_GUID (External List Converted Cache Header GUID), C_ITEM_GUID (External List Converted Cache Item GUID).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | * | CLNT (3) |
| PACKAGE_GUID | CRM Marketing: GUID of a Working Package | CRMT_MKTLIST_PACKAGE_GUID | RAW (16) | |
| C_HEAD_GUID | External List Converted Cache Header GUID | CRMT_MKTLIST_C_HEAD | RAW (16) | |
| C_ITEM_GUID | External List Converted Cache Item GUID | CRMT_MKTLIST_C_ITEM | RAW (16) | |
| BP_GUID | Business Partner GUID | BU_PARTNER_GUID | RAW (16) | |
| BP_RELTYP | Business Partner Relationship Category | BU_RELTYP | * | CHAR (6) |
| REL_DIRN_FLG | Direction of the BP Relationship. A->B = ‘ ‘, B->A = ‘X’ | CRMT_MKTLIST_BPREL_DIRN_FLAG | CHAR (1) | |
| BP_ID | Business Partner Number | BU_PARTNER | CHAR (10) |
