A404 table in SAP ERP or S/4HANA stores Customer/Material/Plant data. There are total 9 fields in A404 table. The Customer/Material/Plant 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 A404 table. It is in MAP Marketing, Accounting and Pricing (OIC) ABAP package and is part of the Marketing, Accounting and Pricing (IS-OIL-DS-MAP) module.
SAP A404 Table Fields
Following is the list of fields that are available in SAP A404 table. The primary key fields of Customer/Material/Plant table in SAP are MANDT (Client), KAPPL (Application), KSCHL (Condition type), KUNNR (Customer number), MATNR (Material Number), WERKS (Plant), 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) |
| KUNNR | Customer number | KUNNR_V | KNA1 | CHAR(10) |
| MATNR | Material Number | MATNR | MARA | CHAR(40) |
| WERKS | Plant | WERKS_D | T001W | CHAR(4) |
| DATBI | Validity end date of the condition record | KODATBI | DATS(8) | |
| DATAB | Validity start date of the condition record | KODATAB | DATS(8) | |
| KNUMH | Number of the Condition Record | KNUMH | CHAR(10) |
