SAP Table KNVH
Customer Hierarchies
KNVH (Customer Hierarchies) 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 KNVH to other SAP tables.
KNVH table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| HITYP | Customer hierarchy type | HITYP_KH | THIT | CHAR | 1 | 0 | ||||||
| KUNNR | Customer | KUNNR_KH | KNA1 | CHAR | 10 | 0 | ||||||
| VKORG | Sales Organization | VKORG | TVKO | CHAR | 4 | 0 | ||||||
| VTWEG | Distribution Channel | VTWEG | TVTW | CHAR | 2 | 0 | ||||||
| SPART | Division | SPART | TSPA | CHAR | 2 | 0 | ||||||
| DATAB | Start of validity period for assignment | DATAB_KH | DATS | 8 | 0 | |||||||
| DATBI | End of validity period for the assignment | DATBI_KH | DATS | 8 | 0 | |||||||
| HKUNNR | Customer number of the higher-level customer hierarchy | HKUNNR_KH | KNA1 | CHAR | 10 | 0 | ||||||
| HVKORG | Higher-level sales organization | HVKORG | TVKO | CHAR | 4 | 0 | ||||||
| HVTWEG | Higher-level distribution channel | HVTWEG | TVTW | CHAR | 2 | 0 | ||||||
| HSPART | Higher-level division | HSPART | TSPA | CHAR | 2 | 0 | ||||||
| GRPNO | Number of the routine used for copying | GRPNO | NUMC | 3 | 0 | |||||||
| BOKRE | Indicator: Customer Is Rebate-Relevant | BOKRE | CHAR | 1 | 0 |
Possible values
|
||||||
| PRFRE | Relevant for price determination ID | PRFRE | CHAR | 1 | 0 |
Possible values
|
||||||
| HZUOR | Assignment to Hierarchy | HZUOR | NUMC | 2 | 0 | |||||||
KNVH foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| KNVH | HITYP | KNVH | MANDT | THIT | Customer Hierarchy Types | MANDT |
| KNVH | HITYP | KNVH | HITYP | THIT | Customer Hierarchy Types | HITYP |
| KNVH | HKUNNR | KNVH | MANDT | KNA1 | General Data in Customer Master | MANDT |
| KNVH | HKUNNR | KNVH | HKUNNR | KNA1 | General Data in Customer Master | KUNNR |
| KNVH | HSPART | KNVH | HSPART | TSPA | Organizational Unit: Sales Divisions | SPART |
| KNVH | HSPART | KNVH | MANDT | TSPA | Organizational Unit: Sales Divisions | MANDT |
| KNVH | HVKORG | KNVH | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
| KNVH | HVKORG | KNVH | HVKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
| KNVH | HVTWEG | KNVH | MANDT | TVTW | Organizational Unit: Distribution Channels | MANDT |
| KNVH | HVTWEG | KNVH | HVTWEG | TVTW | Organizational Unit: Distribution Channels | VTWEG |
| KNVH | KUNNR | KNVH | KUNNR | KNA1 | General Data in Customer Master | KUNNR |
| KNVH | KUNNR | KNVH | MANDT | KNA1 | General Data in Customer Master | MANDT |
| KNVH | MANDT | KNVH | MANDT | T000 | Clients | MANDT |
| KNVH | SPART | KNVH | MANDT | TSPA | Organizational Unit: Sales Divisions | MANDT |
| KNVH | SPART | KNVH | SPART | TSPA | Organizational Unit: Sales Divisions | SPART |
| KNVH | VKORG | KNVH | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
| KNVH | VKORG | KNVH | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
| KNVH | VTWEG | KNVH | MANDT | TVTW | Organizational Unit: Distribution Channels | MANDT |
| KNVH | VTWEG | KNVH | VTWEG | TVTW | Organizational Unit: Distribution Channels | VTWEG |
