The A146 table in SAP ERP or S/4HANA stores Customer Hierarchy data. There are total 15 fields in A146 table. The Customer Hierarchy table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database.Additionally we provide an overview of the structure and fields of A146 table. It is in Application development Conditions (VKON) ABAP package and is part of the Conditions (SD-MD-CM) module.
SAP A146 Table Fields
Following is the list of fields that are available in SAP A146 table. The primary key fields of the table are MANDT (Client), KAPPL (Application), KSCHL (Condition type), VKORG (Sales Organization), VTWEG (Distribution Channel), SPART (Division), VKBUR (Sales office), VKGRP (Sales group), KDGRP (Customer Group), KUNRG (Payer), KUNAG (Sold-To Party), KUNWE (Ship-to party), DATBI (Validity end date of the condition record).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| KAPPL | Application | KAPPL | T681A | CHAR (2) |
| KSCHL | Condition type | KSCHA | T685 | CHAR (4) |
| VKORG | Sales Organization | VKORG | TVKO | CHAR (4) |
| VTWEG | Distribution Channel | VTWEG | TVTW | CHAR (2) |
| SPART | Division | SPART | TSPA | CHAR (2) |
| VKBUR | Sales office | VKBUR | TVBUR | CHAR (4) |
| VKGRP | Sales group | VKGRP | TVKGR | CHAR (3) |
| KDGRP | Customer Group | KDGRP | T151 | CHAR (2) |
| KUNRG | Payer | KUNRG | KNA1 | CHAR (10) |
| KUNAG | Sold-To Party | KUNAG | KNA1 | CHAR (10) |
| KUNWE | Ship-to party | KUNWE | KNA1 | CHAR (10) |
| DATBI | Validity end date of the condition record | KODATBI | DATS (8) | |
| DATAB | Validity start date of the condition record | KODATAB | DATS (8) | |
| KNUMH | Number of the Condition Record | KNUMH | CHAR (10) |
