1. Home
  2. Resources
  3. SAP Tables
  4. A146 - Customer Hierarchy

SAP Table A146

Customer Hierarchy

A146 (Customer Hierarchy) 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 A146 to other SAP tables.

A146 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
SPART Division SPART TSPA CHAR 2 0
VKBUR Sales Office VKBUR TVBUR CHAR 4 0
VKGRP Sales Group VKGRP TVKGR CHAR 3 0
KDGRP Customer group KDGRP T151 CHAR 2 0
KUNRG Payer KUNRG KNA1 CHAR 10 0
KUNAG Sold-to party KUNAG KNA1 CHAR 10 0
KUNWE Ship-to party KUNWE KNA1 CHAR 10 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

A146 foreign key relationships

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