SAP Table BAPIKNA1_KNVH
BO KNA1: Nodes in SD Customer Hierarchy
BAPIKNA1_KNVH (BO KNA1: Nodes in SD 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 BAPIKNA1_KNVH to other SAP tables.
BAPIKNA1_KNVH table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
CUSTOMER | Customer | KUNNR_KH | KNA1 | CHAR | 10 | 0 | ||||||
SALES_ORG | Sales Organization | VKORG | TVKO | CHAR | 4 | 0 | ||||||
DISTR_CHAN | Distribution Channel | VTWEG | TVTW | CHAR | 2 | 0 | ||||||
DIVISION | Division | SPART | TSPA | CHAR | 2 | 0 | ||||||
VALID_FROM | Start of validity period for assignment | DATAB_KH | DATS | 8 | 0 | |||||||
CUSTHITYP | Customer hierarchy type | HITYP_KH | THIT | CHAR | 1 | 0 | ||||||
PARENT_CUSTOMER | Customer number of the higher-level customer hierarchy | HKUNNR_KH | KNA1 | CHAR | 10 | 0 | ||||||
PARENT_SALES_ORG | Higher-level sales organization | HVKORG | TVKO | CHAR | 4 | 0 | ||||||
PARENT_DISTR_CHAN | Higher-level distribution channel | HVTWEG | TVTW | CHAR | 2 | 0 | ||||||
PARENT_DIVISION | Higher-level division | HSPART | TSPA | CHAR | 2 | 0 | ||||||
BROTHER_CUSTOMER | Customer no. of higher-level customer hierarchy (brother) | BKUNNR_KH | KNA1 | CHAR | 10 | 0 | ||||||
BROTHER_SALES_ORG | Higher-level sales organization (customer hierarchy) | BVKORG | TVKO | CHAR | 4 | 0 | ||||||
BROTHER_DISTR_CHAN | Higher-level distribution channel (customer hierarchy) | BVTWEG | TVTW | CHAR | 2 | 0 | ||||||
BROTHER_DIVISION | Higher-level division (customer hierarchy) | BSPART | TSPA | CHAR | 2 | 0 | ||||||
NODE_LEVEL | NUMC | 2 | 0 | |||||||||
VALID_TO | End of validity period for the assignment | DATBI_KH | DATS | 8 | 0 | |||||||
ROUTINE | Number of the routine used for copying | GRPNO | NUMC | 3 | 0 | |||||||
REBATE_REL | Indicator: Customer Is Rebate-Relevant | BOKRE | CHAR | 1 | 0 |
Possible values
|
||||||
PRIC_REL | Relevant for price determination ID | PRFRE | CHAR | 1 | 0 |
Possible values
|
||||||
ASSIGN_HI | Assignment to Hierarchy | HZUOR | NUMC | 2 | 0 |
BAPIKNA1_KNVH foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
BAPIKNA1_KNVH | BROTHER_CUSTOMER | SYST | MANDT | KNA1 | General Data in Customer Master | MANDT |
BAPIKNA1_KNVH | BROTHER_CUSTOMER | BAPIKNA1_KNVH | BROTHER_CUSTOMER | KNA1 | General Data in Customer Master | KUNNR |
BAPIKNA1_KNVH | BROTHER_DISTR_CHAN | SYST | MANDT | TVTW | Organizational Unit: Distribution Channels | MANDT |
BAPIKNA1_KNVH | BROTHER_DISTR_CHAN | BAPIKNA1_KNVH | BROTHER_DISTR_CHAN | TVTW | Organizational Unit: Distribution Channels | VTWEG |
BAPIKNA1_KNVH | BROTHER_DIVISION | SYST | MANDT | TSPA | Organizational Unit: Sales Divisions | MANDT |
BAPIKNA1_KNVH | BROTHER_DIVISION | BAPIKNA1_KNVH | BROTHER_DIVISION | TSPA | Organizational Unit: Sales Divisions | SPART |
BAPIKNA1_KNVH | BROTHER_SALES_ORG | SYST | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
BAPIKNA1_KNVH | BROTHER_SALES_ORG | BAPIKNA1_KNVH | BROTHER_SALES_ORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
BAPIKNA1_KNVH | CUSTHITYP | BAPIKNA1_KNVH | CUSTHITYP | THIT | Customer Hierarchy Types | HITYP |
BAPIKNA1_KNVH | CUSTHITYP | SYST | MANDT | THIT | Customer Hierarchy Types | MANDT |
BAPIKNA1_KNVH | CUSTOMER | SYST | MANDT | KNA1 | General Data in Customer Master | MANDT |
BAPIKNA1_KNVH | CUSTOMER | BAPIKNA1_KNVH | CUSTOMER | KNA1 | General Data in Customer Master | KUNNR |
BAPIKNA1_KNVH | DISTR_CHAN | BAPIKNA1_KNVH | DISTR_CHAN | TVTW | Organizational Unit: Distribution Channels | VTWEG |
BAPIKNA1_KNVH | DISTR_CHAN | SYST | MANDT | TVTW | Organizational Unit: Distribution Channels | MANDT |
BAPIKNA1_KNVH | DIVISION | SYST | MANDT | TSPA | Organizational Unit: Sales Divisions | MANDT |
BAPIKNA1_KNVH | DIVISION | BAPIKNA1_KNVH | DIVISION | TSPA | Organizational Unit: Sales Divisions | SPART |
BAPIKNA1_KNVH | PARENT_CUSTOMER | SYST | MANDT | KNA1 | General Data in Customer Master | MANDT |
BAPIKNA1_KNVH | PARENT_CUSTOMER | BAPIKNA1_KNVH | PARENT_CUSTOMER | KNA1 | General Data in Customer Master | KUNNR |
BAPIKNA1_KNVH | PARENT_DISTR_CHAN | SYST | MANDT | TVTW | Organizational Unit: Distribution Channels | MANDT |
BAPIKNA1_KNVH | PARENT_DISTR_CHAN | BAPIKNA1_KNVH | PARENT_DISTR_CHAN | TVTW | Organizational Unit: Distribution Channels | VTWEG |
BAPIKNA1_KNVH | PARENT_DIVISION | SYST | MANDT | TSPA | Organizational Unit: Sales Divisions | MANDT |
BAPIKNA1_KNVH | PARENT_DIVISION | BAPIKNA1_KNVH | PARENT_DIVISION | TSPA | Organizational Unit: Sales Divisions | SPART |
BAPIKNA1_KNVH | PARENT_SALES_ORG | SYST | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
BAPIKNA1_KNVH | PARENT_SALES_ORG | BAPIKNA1_KNVH | PARENT_SALES_ORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
BAPIKNA1_KNVH | SALES_ORG | SYST | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
BAPIKNA1_KNVH | SALES_ORG | BAPIKNA1_KNVH | SALES_ORG | TVKO | Organizational Unit: Sales Organizations | VKORG |