I_CustomerBySalesHierarchyNode

Hierarchy node for Cust by Sales Area | view: ICUSTSLSHIERNODE | HIER | Extraction: Not supported | Component: Business Partners
Tables used: KNVH
Column Name Description
CustomerHierarchyType FK Customer hierarchy type
Customer FK Customer
SalesOrganization FK Sales Organization
DistributionChannel FK Distribution Channel
Division FK Division
ValidityStartDate Start of validity period for assignment
Column Name Description
Column Name Description
Column Name Description
ValidityStartDate Start of validity period for assignment
ValidityEndDate End of validity period for the assignment
Column Name Description
CustomerIsRebateRelevant Indicator: Customer Is Rebate-Relevant Show values
CustIsPrcDetnRlvt Relevant for price determination ID Show values
Column Name Description Domain name
Master Data Relations Join Conditions
Customer
  • Customer
  • Client
  • I_CUSTOMERBYSALESHIERARCHYNODE.CUSTOMER == KNA1.KUNNR
  • I_CUSTOMERBYSALESHIERARCHYNODE.MANDT == KNA1.MANDT
Customer hierarchy type
  • Customer hierarchy type
  • Client
  • I_CUSTOMERBYSALESHIERARCHYNODE.CUSTOMERHIERARCHYTYPE == THIT.HITYP
  • I_CUSTOMERBYSALESHIERARCHYNODE.MANDT == THIT.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • I_CUSTOMERBYSALESHIERARCHYNODE.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • I_CUSTOMERBYSALESHIERARCHYNODE.MANDT == TVTW.MANDT
Division
  • Client
  • Division
  • I_CUSTOMERBYSALESHIERARCHYNODE.MANDT == TSPA.MANDT
  • I_CUSTOMERBYSALESHIERARCHYNODE.DIVISION == TSPA.SPART
Customer number of the higher-level customer hierarchy
  • Customer number of the higher-level customer hierarchy
  • Client
  • I_CUSTOMERBYSALESHIERARCHYNODE.PARENTCUSTOMER == KNA1.KUNNR
  • I_CUSTOMERBYSALESHIERARCHYNODE.MANDT == KNA1.MANDT
Higher-level distribution channel
  • Higher-level distribution channel
  • Client
  • I_CUSTOMERBYSALESHIERARCHYNODE.PARENTDISTRIBUTIONCHANNEL == TVTW.VTWEG
  • I_CUSTOMERBYSALESHIERARCHYNODE.MANDT == TVTW.MANDT
Higher-level division
  • Higher-level division
  • Client
  • I_CUSTOMERBYSALESHIERARCHYNODE.PARENTDIVISION == TSPA.SPART
  • I_CUSTOMERBYSALESHIERARCHYNODE.MANDT == TSPA.MANDT
Higher-level sales organization
  • Higher-level sales organization
  • Client
  • I_CUSTOMERBYSALESHIERARCHYNODE.PARENTSALESORGANIZATION == TVKO.VKORG
  • I_CUSTOMERBYSALESHIERARCHYNODE.MANDT == TVKO.MANDT
Sales Organization
  • Client
  • Sales Organization
  • I_CUSTOMERBYSALESHIERARCHYNODE.MANDT == TVKO.MANDT
  • I_CUSTOMERBYSALESHIERARCHYNODE.SALESORGANIZATION == TVKO.VKORG