SAP table A146 (Customer Hierarchy)

SAP table A146 has 13 primary key fields being MANDT,KAPPL,KSCHL,VKORG,VTWEG,SPART,VKBUR,VKGRP,KDGRP,KUNRG,KUNAG,KUNWE,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
VKBUR Sales office CHAR 4 0 TVBUR VKBUR
VKGRP Sales group CHAR 3 0 TVKGR VKGRP
KDGRP Customer Group CHAR 2 0 T151 KDGRP
KUNRG Payer CHAR 10 0 KNA1 KUNRG
KUNAG Sold-to Party CHAR 10 0 KNA1 KUNAG
KUNWE Ship-to Party CHAR 10 0 KNA1 KUNWE
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

A146 foreign key relationships

Table Field Check Table Check Field
0 A146 KAPPL T681A Conditions: Applications KAPPL
1 A146 KDGRP T151 Customers: Customer Groups MANDT
1 A146 KDGRP T151 Customers: Customer Groups KDGRP
0 A146 KSCHL T685 Conditions: Types KAPPL
0 A146 KSCHL T685 Conditions: Types KSCHL
1 A146 KUNAG KNA1 General Data in Customer Master MANDT
1 A146 KUNAG KNA1 General Data in Customer Master KUNNR
0 A146 KUNRG KNA1 General Data in Customer Master MANDT
0 A146 KUNRG KNA1 General Data in Customer Master KUNNR
1 A146 KUNWE KNA1 General Data in Customer Master MANDT
1 A146 KUNWE KNA1 General Data in Customer Master KUNNR
0 A146 MANDT T000 Clients MANDT
1 A146 SPART TSPA Organizational Unit: Sales Divisions MANDT
1 A146 SPART TSPA Organizational Unit: Sales Divisions SPART
0 A146 VKBUR TVBUR Organizational Unit: Sales Offices MANDT
1 A146 VKGRP TVKGR Organizational Unit: Sales Groups MANDT
0 A146 VKORG TVKO Organizational Unit: Sales Organizations MANDT
0 A146 VKORG TVKO Organizational Unit: Sales Organizations VKORG
1 A146 VTWEG TVTW Organizational Unit: Distribution Channels MANDT
1 A146 VTWEG TVTW Organizational Unit: Distribution Channels VTWEG