The CRMD_MKTPL_AL03 table in SAP ERP or S/4HANA stores Allocation Data data. There are total 7 fields in CRMD_MKTPL_AL03 table. The Allocation Data 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_AL03 table. It is in Marketing Planning: Allocation (CRM_MKTPL_ALLOC) ABAP package and is part of the Marketing Planner (CRM-MKT-MPL) module.
SAP CRMD_MKTPL_AL03 Table Fields
Following is the list of fields that are available in SAP CRMD_MKTPL_AL03 table. The primary key fields of the table are MANDT (Client), ALLOCDATAGUID (UUID in X form (binary)).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| ALLOCDATAGUID | UUID in X form (binary) | SYSUUID_X | RAW (16) | |
| ALLOCGUID | UUID in X form (binary) | SYSUUID_X | CRMD_MKTPL_AL00 | RAW (16) |
| TARGETGRP_GUID | CRM Marketing: GUID of Target Group | CRMT_TARGETGRP_GUID | CRMD_MKTTG_TG_H | RAW (16) |
| PRODUCT_GUID | Internal Unique ID of Product | COMT_PRODUCT_GUID | RAW (16) | |
| BP_GUID | CRM Marketing: Target Group Business Partner GUID | CRMT_TG_BP_GUID | RAW (16) | |
| ALPRIO | Allocation: Priority | CRM_MKTPL_ALPRIO | CRMC_MKTPL_AL03 | CHAR (1) |
