SAP CRMD_MKTPPG_PGR Table – DB table for MKTPL TPM Product Group Assignments

The CRMD_MKTPPG_PGR table in SAP ERP or S/4HANA stores DB table for MKTPL TPM Product Group Assignments data. There are total 7 fields in CRMD_MKTPPG_PGR table. The DB table for MKTPL TPM Product Group Assignments 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_MKTPPG_PGR table. It is in CRM Marketing: Assignments for PPG (CRM_MKTPPG_ASSIGN_PPG) ABAP package and is part of the Promotion Guidelines (CRM-MKT-MPL-TPM-PPG) module.

SAP CRMD_MKTPPG_PGR Table Fields

Following is the list of fields that are available in SAP CRMD_MKTPPG_PGR 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)
UOM Units of Measure of Product COMT_UNIT * UNIT (3)
GDL_PRICE_LVL_ID Guideline Pricing Level ID CRM_MKTPPG_GDL_PRICE_LVL_ID CHAR (15)
MKTPPG_PGRPLVL Dummy function in length 1 DUMMY CHAR (1)