SAP table A900 (Sales org./Distr. Chl/Division/Customer Hierarchy)

SAP table A900 has 9 primary key fields being MANDT,KAPPL,KSCHL,VKORG,VTWEG,SPART,HIENR,KFRST,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
SPART Division CHAR 2 0 TSPA SPART
HIENR Customer CHAR 10 0 KNA1 KUNNR_KH
KFRST Release Status CHAR 1 0 KFRST
Released
A Blocked
B Released for pricing simulation
C Released for planning and pricing simulation
D In Review
E Rejected
DATBI Validity end date of the condition record DATS 8 0 KODATBI
DATAB Validity start date of the condition record DATS 8 0 KODATAB
KBSTAT Processing status for conditions CHAR 2 0 T686E KBSTAT
KNUMH Number of the Condition Record CHAR 10 0 KNUMH

A900 foreign key relationships

Table Field Check Table Check Field
0 A900 HIENR KNA1 General Data in Customer Master MANDT
0 A900 HIENR KNA1 General Data in Customer Master KUNNR
1 A900 KAPPL T681A Conditions: Applications KAPPL
0 A900 KBSTAT T686E Conditions: Processing Status KBSTAT
1 A900 KSCHL T685 Conditions: Types KAPPL
1 A900 KSCHL T685 Conditions: Types KSCHL
0 A900 MANDT T000 Clients MANDT
1 A900 SPART TSPA Organizational Unit: Sales Divisions MANDT
1 A900 SPART TSPA Organizational Unit: Sales Divisions SPART
0 A900 VKORG TVKO Organizational Unit: Sales Organizations MANDT
0 A900 VKORG TVKO Organizational Unit: Sales Organizations VKORG
1 A900 VTWEG TVTW Organizational Unit: Distribution Channels MANDT
1 A900 VTWEG TVTW Organizational Unit: Distribution Channels VTWEG