The CRMC_MKTPL_PHIER table in SAP ERP or S/4HANA stores Product Hierarchies used for Product Assignment to MKTPL data. There are total 4 fields in CRMC_MKTPL_PHIER table. The Product Hierarchies used for Product Assignment to MKTPL 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 CRMC_MKTPL_PHIER table. It is in Product Assignment to Marketing Campaign (CRM_MKTPL_PRODUCT_INTERFACE) ABAP package and is part of the Basic Functions (CRM-MKT-MPL-ST) module.
SAP CRMC_MKTPL_PHIER Table Fields
Following is the list of fields that are available in SAP CRMC_MKTPL_PHIER table. The primary key fields of the table are CLIENT (Client), HIERARCHY_USAGE (Identifier Describing Usage of the Hierarchy).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | CLNT (3) | |
| HIERARCHY_USAGE | Identifier Describing Usage of the Hierarchy | CRM_MKTPL_PROD_HIER_USE | CHAR (2) | |
| HIERARCHY_ID | Category Hierarchy ID | COMT_HIERARCHY_ID | CHAR (10) | |
| SALES_AREA_FLAG | Flag Determines if Product Hierarchy is Read with Sales Data | CRM_MKTPL_PHIER_SALES_DEP_FLAG | CHAR (1) |
