KNVH

Customer Hierarchies | #hierarchy | Component: Basic Functions
Column Name Description
MANDT FK Client
HITYP FK Customer hierarchy type
KUNNR FK Customer
VKORG FK Sales Organization
VTWEG FK Distribution Channel
SPART FK Division
DATAB Start of validity period for assignment
Column Name Description
Column Name Description
Column Name Description
DATAB Start of validity period for assignment
DATBI End of validity period for the assignment
Column Name Description
BOKRE Indicator: Customer Is Rebate-Relevant Show values
PRFRE Relevant for price determination ID Show values
Column Name Description Domain name
GRPNO Number of the Routine Used for Copying GRPNO
HZUOR Assignment to Hierarchy HZUOR
NODE_GUID GUID for a Customer Hierarchy Node NODE_GUID_KH
NODE_ID ID of a Customer Hierarchy Node NODE_ID_KH
Master Data Relations Join Conditions
Customer hierarchy type
  • KNVH.MANDT == THIT.MANDT
  • KNVH.HITYP == THIT.HITYP
Customer number of the higher-level customer hierarchy
  • KNVH.MANDT == KNA1.MANDT
  • KNVH.HKUNNR == KNA1.KUNNR
Higher-level division
  • KNVH.MANDT == TSPA.MANDT
  • KNVH.HSPART == TSPA.SPART
Higher-level sales organization
  • KNVH.MANDT == TVKO.MANDT
  • KNVH.HVKORG == TVKO.VKORG
Higher-level distribution channel
  • Higher-level distribution channel
  • Client
  • KNVH.HVTWEG == TVTW.VTWEG
  • KNVH.MANDT == TVTW.MANDT
Customer
  • KNVH.MANDT == KNA1.MANDT
  • KNVH.KUNNR == KNA1.KUNNR
Client KNVH.MANDT == T000.MANDT
Division
  • KNVH.MANDT == TSPA.MANDT
  • KNVH.SPART == TSPA.SPART
Sales Organization
  • KNVH.MANDT == TVKO.MANDT
  • KNVH.VKORG == TVKO.VKORG
Distribution Channel
  • Distribution Channel
  • Client
  • KNVH.VTWEG == TVTW.VTWEG
  • KNVH.MANDT == TVTW.MANDT