SAP table A153 (Sales Org./Distribution Channel/Plant/Sales Unit/Customer)

SAP table A153 has 9 primary key fields being MANDT,KAPPL,KSCHL,VKORG,VTWEG,MATNR,VRKME,KUNNR,DATBI.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
KAPPL Application CHAR 2 0 T681A KAPPL
KSCHL Condition Type CHAR 4 0 T685 KSCHA
VKORG Sales Organization CHAR 4 0 TVKO VKORG
VTWEG Distribution Channel CHAR 2 0 TVTW VTWEG
MATNR Material Number CHAR 40 0 MARA MATNR
VRKME Sales unit UNIT 3 0 T006 VRKME
KUNNR Customer number CHAR 10 0 KNA1 KUNNR_V
DATBI Validity end date of the condition record DATS 8 0 KODATBI
DATAB Validity start date of the condition record DATS 8 0 KODATAB
KNUMH Number of the Condition Record CHAR 10 0 KNUMH

A153 foreign key relationships

Table Field Check Table Check Field
0 A153 KAPPL T681A Conditions: Applications KAPPL
1 A153 KSCHL T685 Conditions: Types KAPPL
1 A153 KSCHL T685 Conditions: Types KSCHL
0 A153 KUNNR KNA1 General Data in Customer Master MANDT
0 A153 KUNNR KNA1 General Data in Customer Master KUNNR
1 A153 MANDT T000 Clients MANDT
0 A153 MATNR MARA General Material Data MATNR
1 A153 VKORG TVKO Organizational Unit: Sales Organizations MANDT
1 A153 VKORG TVKO Organizational Unit: Sales Organizations VKORG
0 A153 VRKME T006 Units of Measurement MANDT
0 A153 VRKME T006 Units of Measurement MSEHI
1 A153 VTWEG TVTW Organizational Unit: Distribution Channels MANDT
1 A153 VTWEG TVTW Organizational Unit: Distribution Channels VTWEG