WLK2

Article Master Data SAP Retail / Part POS Control Data | #masterdata | Component: Article
Column Name Description
MANDT FK Client
MATNR FK Material Number
VKORG FK Sales organization in distribution chain, IS-R
VTWEG FK Distribution channel in distribution chain, IS-R
WERKS FK Retail plant
Column Name Description
Column Name Description
Column Name Description
DATAE Date of last change
VKDAB Date from which sold in the store
VKBIS Date to which sold in the store
MSTDV Date from which distr.-chain-spec. material status is valid
Column Name Description
KWDHT No repeat key Show values
PRERF Price required Show values
RBZUL Discount allowed Show values
Column Name Description Domain name
AENAM Name of Person Who Changed Object USNAM
Master Data Relations Join Conditions
Client WLK2.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • WLK2.MATNR == MARA.MATNR
  • WLK2.MANDT == MARA.MANDT
Distribution-chain-specific material status
  • WLK2.MANDT == TVMS.MANDT
  • WLK2.MSTAV == TVMS.VMSTA
Foreign key for scales group
  • WLK2.MANDT == TWWAG.MANDT
  • WLK2.SCAGR == TWWAG.SCAGR
Sales organization in distribution chain, IS-R
  • WLK2.MANDT == TVKO.MANDT
  • WLK2.VKORG == TVKO.VKORG
Distribution channel in distribution chain, IS-R
  • Distribution channel in distribution chain, IS-R
  • Client
  • WLK2.VTWEG == TVTW.VTWEG
  • WLK2.MANDT == TVTW.MANDT
Retail plant
  • WLK2.MANDT == T001W.MANDT
  • WLK2.WERKS == T001W.WERKS