The CRMD_MKTPL_BPATH table in SAP ERP or S/4HANA stores Table containing the Header of the Buying pattern data. There are total 10 fields in CRMD_MKTPL_BPATH table. The Table containing the Header of the Buying pattern 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_BPATH table. It is in TPM: Customer Defaults (CRM_MKTPL_CUSTOMER_DEFAULTS) ABAP package and is part of the Trade Promotion Management (CRM-MKT-MPL-TPM) module.
SAP CRMD_MKTPL_BPATH Table Fields
Following is the list of fields that are available in SAP CRMD_MKTPL_BPATH table. The primary key fields of the table are CLENT (Client), BPAT_GUID (UUID in X form (binary)).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLENT | Client | MANDT | CLNT (3) | |
| BPAT_GUID | UUID in X form (binary) | SYSUUID_X | RAW (16) | |
| CUSTOMER_GUID | UUID in X form (binary) | SYSUUID_X | RAW (16) | |
| CUSTOMER_GROUP | Customer Group 1 | CRMT_CUST_GROUP1 | CHAR (3) | |
| CUSTOMER_TYPE | Type of Account (BP, Hierarchy Node, Target Group) | CRM_MKTPL_PLCUST_TYPE | CHAR (2) | |
| SALES_ORG | Sales Organization ID | CRMT_SALES_ORG | CHAR (14) | |
| CHANNEL | Distribution Channel | CRMT_DISTRIBUTION_CHANNEL | CHAR (2) | |
| DIVISION | Division | CRMT_DIVISION | CHAR (2) | |
| CAMP_TYPE | Type | CRM_MKTPL_CAMPTYPE | CHAR (4) | |
| BPAT_TYPE | Type of Buying Pattern | CRM_MKTPL_DEF_BPAT_TYPE | CHAR (3) |
