In this post, I will try and describe everything you need to know about the SAP a004 table. What it is, including what type of data it stores.
A list of fields which make up the table structure and on an S/4Hana System for A004 what does this table look like.
And what relationships it has with other SAP tables.
Also see here for example ABAP code to select data from A004....Right lets get started!
Object Name: A004
Dictionary Type: Pooled table
Description: Material
| Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
| MANDT | MANDT | CLNT | 3(0) | T000 | Client | MANDT | TEST | |||||
| KAPPL | KAPPL | CHAR | 2(0) | T681A | Application | KAPPL | KAP | VF | ||||
| KSCHL | KSCHA | CHAR | 4(0) | T685 | Condition type | KSCHL | VKS | VF | ||||
| VKORG | VKORG | CHAR | 4(0) | TVKO | Sales Organization | VKORG | VKO | V | C_VKORG | VKORG | ||
| VTWEG | VTWEG | CHAR | 2(0) | TVTW | Distribution Channel | VTWEG | VTW | V | C_VTWEG | VTWEG | ||
| MATNR | MATNR | CHAR | 18(0) | MARA | Material Number | MATNR | MAT | MG | S_MAT1 | MATNR | ||
| DATBI | KODATBI | DATS | 8(0) | Validity end date of the condition record | DATUM | VF | ||||||
| DATAB | KODATAB | DATS | 8(0) | Validity start date of the condition record | DATUM | VF | ||||||
| KNUMH | KNUMH | CHAR | 10(0) | Condition record number | KNUMB | VF |