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
X Yes
NULL No
PRIC_REL Relevant for price determination ID PRFRE CHAR 1 0
X Yes
NULL No
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