A147 - Customer Hierarchy (Sales Deal)
Customer Hierarchy (Sales Deal) information is stored in SAP table A147.
It is part of development package VKON in software component SD-MD-CM. This development package consists of objects that can be grouped under "Application development Conditions".
It is part of development package VKON in software component SD-MD-CM. This development package consists of objects that can be grouped under "Application development Conditions".
Fields for table A147
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| KAPPL | Application | X | KAPPL | CHAR | 4 | T681A |
| KSCHL | Condition Type | X | KSCHA | CHAR | 8 | T685 |
| VKORG | Sales Organization | X | VKORG | CHAR | 8 | TVKO |
| VTWEG | Distribution Channel | X | VTWEG | CHAR | 4 | TVTW |
| SPART | Division | X | SPART | CHAR | 4 | TSPA |
| VKBUR | Sales office | X | VKBUR | CHAR | 8 | TVBUR |
| VKGRP | Sales group | X | VKGRP | CHAR | 6 | TVKGR |
| KDGRP | Customer Group | X | KDGRP | CHAR | 4 | T151 |
| KUNRG | Payer | X | KUNRG | CHAR | 20 | KNA1 |
| KUNAG | Sold-to Party | X | KUNAG | CHAR | 20 | KNA1 |
| KUNWE | Ship-to Party | X | KUNWE | CHAR | 20 | KNA1 |
| KNUMA_AG | Sales Deal | X | KNUMA_AG | CHAR | 20 | KONA |
| DATBI | Validity end date of the condition record | X | KODATBI | DATS | 16 | |
| DATAB | Validity start date of the condition record | KODATAB | DATS | 16 | ||
| KEXCL_D | Indicator condition exclusive | KEXCL | CHAR | 2 | ||
| KNUMH | Number of the Condition Record | KNUMH | CHAR | 20 |