1. Home
  2. Resources
  3. SAP Tables
  4. A004 - Material

SAP Table A004

Material

A004 (Material) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link A004 to other SAP tables.

A004 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
KAPPL Application KAPPL T681A CHAR 2 0
KSCHL Condition type KSCHA T685 CHAR 4 0
VKORG Sales Organization VKORG TVKO CHAR 4 0
VTWEG Distribution Channel VTWEG TVTW CHAR 2 0
MATNR Material Number MATNR MARA CHAR 18 0
DATBI Validity end date of the condition record KODATBI DATS 8 0
DATAB Validity start date of the condition record KODATAB DATS 8 0
KNUMH Condition record number KNUMH CHAR 10 0

A004 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
A004 KAPPL A004 KAPPL T681A Conditions: Applications KAPPL
A004 KSCHL A004 KAPPL T685 Conditions: Types KAPPL
A004 KSCHL A004 KSCHL T685 Conditions: Types KSCHL
A004 KSCHL A004 MANDT T685 Conditions: Types MANDT
A004 KSCHL 'A' T685 Conditions: Types KVEWE
A004 MANDT A004 MANDT T000 Clients MANDT
A004 MATNR A004 MANDT MARA General Material Data MANDT
A004 MATNR A004 MATNR MARA General Material Data MATNR
A004 VKORG A004 MANDT TVKO Organizational Unit: Sales Organizations MANDT
A004 VKORG A004 VKORG TVKO Organizational Unit: Sales Organizations VKORG
A004 VTWEG A004 VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
A004 VTWEG A004 MANDT TVTW Organizational Unit: Distribution Channels MANDT