SHSM_KNVH

CDS view replacing KNVH for KNVH search help | view: SHSMKNVH | Extraction: Not supported | Component: Basic Functions
Tables used: KNVH
Column Name Description
kunnr FK Customer
hityp FK Customer hierarchy type
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
Column Name Description Domain name
Master Data Relations Join Conditions
Customer hierarchy type
  • Client
  • Customer hierarchy type
  • SHSM_KNVH.MANDT == THIT.MANDT
  • SHSM_KNVH.HITYP == THIT.HITYP
Customer number of the higher-level customer hierarchy
  • Customer number of the higher-level customer hierarchy
  • Client
  • SHSM_KNVH.HKUNNR == KNA1.KUNNR
  • SHSM_KNVH.MANDT == KNA1.MANDT
Higher-level division
  • Client
  • Higher-level division
  • SHSM_KNVH.MANDT == TSPA.MANDT
  • SHSM_KNVH.HSPART == TSPA.SPART
Higher-level sales organization
  • Higher-level sales organization
  • Client
  • SHSM_KNVH.HVKORG == TVKO.VKORG
  • SHSM_KNVH.MANDT == TVKO.MANDT
Higher-level distribution channel
  • Higher-level distribution channel
  • Client
  • SHSM_KNVH.HVTWEG == TVTW.VTWEG
  • SHSM_KNVH.MANDT == TVTW.MANDT
Customer
  • Client
  • Customer
  • SHSM_KNVH.MANDT == KNA1.MANDT
  • SHSM_KNVH.KUNNR == KNA1.KUNNR
Division
  • Client
  • Division
  • SHSM_KNVH.MANDT == TSPA.MANDT
  • SHSM_KNVH.SPART == TSPA.SPART
Sales Organization
  • Client
  • Sales Organization
  • SHSM_KNVH.MANDT == TVKO.MANDT
  • SHSM_KNVH.VKORG == TVKO.VKORG
Distribution Channel
  • Client
  • Distribution Channel
  • SHSM_KNVH.MANDT == TVTW.MANDT
  • SHSM_KNVH.VTWEG == TVTW.VTWEG