A4CM table in SAP ERP or S/4HANA stores Sales org./Distr. Chl/Material/Lock Reaso data. There are total 12 fields in A4CM table. The Sales org./Distr. Chl/Material/Lock Reaso table is available in all major of SAP S/4HANA versions and is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of A4CM table. It is in Customizing for Pricing Integration (CRMS4_PRICING_CUSTOMIZING) ABAP package and is part of the S4CRM: Pricing (CRM-S4-BF-PR) module.
SAP A4CM Table Fields
Following is the list of fields that are available in SAP A4CM table. The primary key fields of Sales org./Distr. Chl/Material/Lock Reaso table in SAP are MANDT (Client), KAPPL (Application), KSCHL (Condition type), VKORG (Sales Organization), VTWEG (Distribution Channel), MATNR (Material Number), PROV_LOCK_REASON (Lock Reason), KFRST (Release Status), DATBI (Validity end date of the condition record).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT(3) |
| KAPPL | Application | KAPPL | T681A | CHAR(2) |
| KSCHL | Condition type | KSCHA | T685 | CHAR(4) |
| VKORG | Sales Organization | VKORG | TVKO | CHAR(4) |
| VTWEG | Distribution Channel | VTWEG | TVTW | CHAR(2) |
| MATNR | Material Number | MATNR | MARA | CHAR(40) |
| PROV_LOCK_REASON | Lock Reason | IST_LOCK_REASON | CRMC_IST_REASN | CHAR(8) |
| KFRST | Release Status | KFRST | CHAR(1) | |
| DATBI | Validity end date of the condition record | KODATBI | DATS(8) | |
| DATAB | Validity start date of the condition record | KODATAB | DATS(8) | |
| KBSTAT | Processing status for conditions | KBSTAT | T686E | CHAR(2) |
| KNUMH | Number of the Condition Record | KNUMH | CHAR(10) |
