SAP CRMD_MKTPL_EPTNR Table – External Partner Assignment List

The CRMD_MKTPL_EPTNR table in SAP ERP or S/4HANA stores External Partner Assignment List data. There are total 9 fields in CRMD_MKTPL_EPTNR table. The External Partner Assignment List 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_MKTPL_EPTNR table. It is in CRM Marketing Planning – Assignments: External Partner (CRM_MKTPL_ASSIGN_EXTPARTNER) ABAP package and is part of the Marketing (CRM-MKT) module.

SAP CRMD_MKTPL_EPTNR Table Fields

Following is the list of fields that are available in SAP CRMD_MKTPL_EPTNR table. The primary key fields of the table are CLIENT (Client), GUID (UUID in X form (binary)).

Field Description Data Element Check Table Data Type
CLIENT Client MANDT * CLNT (3)
GUID UUID in X form (binary) SYSUUID_X RAW (16)
PROJECT_GUID Project Planning: 16-Character GUID for Projects and Activts CGPL_GUID16 RAW (16)
TASK_GUID Project Planning: 16-Character GUID for Projects and Activts CGPL_GUID16 RAW (16)
EXTPARTNER_GUID Business Partner GUID BU_PARTNER_GUID RAW (16)
STATUS Status of Program Partner CRM_MKTPL_LOY_EXTPTNR_STATUS CHAR (10)
PERCENTAGE Percentage for Sponsoring Partner CRM_EXTPARTNER_PER DEC (5)
PARTNERSHIP_GUID LOY : CRM Loyalty GUID CRM_LOY_COM_GUID RAW (16)
MKTPL_EXTPARTNER Dummy function in length 1 DUMMY CHAR (1)