SDXTST_KNVP

Customer Master Partner Functions (only for XPRA test) | #masterdata | Component: Sales
Column Name Description
MANDT FK Client
KUNNR FK Customer Number
VKORG FK Sales Organization
VTWEG FK Distribution Channel
SPART FK Division
PARVW FK Partner Function
PARZA Partner counter
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
PERNR Personnel Number PERNR
Master Data Relations Join Conditions
Customer Number
  • SDXTST_KNVP.MANDT == KNA1.MANDT
  • SDXTST_KNVP.KUNNR == KNA1.KUNNR
Client SDXTST_KNVP.MANDT == T000.MANDT
Partner Function
  • Partner Function
  • Client
  • SDXTST_KNVP.PARVW == TPAR.PARVW
  • SDXTST_KNVP.MANDT == TPAR.MANDT
Division
  • SDXTST_KNVP.MANDT == TSPA.MANDT
  • SDXTST_KNVP.SPART == TSPA.SPART
Sales Organization
  • SDXTST_KNVP.MANDT == TVKO.MANDT
  • SDXTST_KNVP.VKORG == TVKO.VKORG
Distribution Channel
  • Distribution Channel
  • Client
  • SDXTST_KNVP.VTWEG == TVTW.VTWEG
  • SDXTST_KNVP.MANDT == TVTW.MANDT