WLK1

Listing Conditions SAP Retail Assortments | #masterdata | Component: Listing
Column Name Description
MANDT FK Client
FILIA FK Assortment
ARTNR FK Material Number
VRKME FK Sales unit
DATBI Valid To Date
LFDNR Sequence number
Column Name Description
Column Name Description
Column Name Description
DATBI Valid To Date
DATAB Valid-From Date
DATAE Date of last change
Column Name Description
QUELL Listing Source (Transaction / Function Environment) Show values
NEGAT Negation of assortment item or materials Show values
STRLI List as component of a structured material Show values
SSTAT Assortment status Show values
Column Name Description Domain name
ANZAL - obsolete - No. of modules that have resulted in listing NUMC3
STRNR Structured material MATNR
Master Data Relations Join Conditions
Promotion
  • Promotion
  • Client
  • WLK1.AKTIO == WAKH.AKTNR
  • WLK1.MANDT == WAKH.MANDT
Material Number
  • Material Number
  • Client
  • WLK1.ARTNR == MARA.MATNR
  • WLK1.MANDT == MARA.MANDT
Assortment
  • Assortment
  • Client
  • WLK1.FILIA == WRS1.ASORT
  • WLK1.MANDT == WRS1.MANDT
Supplier Number of a Rack Jobber
  • WLK1.MANDT == LFA1.MANDT
  • WLK1.LIFNR == LFA1.LIFNR
Client WLK1.MANDT == T000.MANDT
Assortment Priority
  • WLK1.MANDT == TWSP.MANDT
  • WLK1.PFLKN == TWSP.PFLKS
Promotion theme IS-R
  • WLK1.MANDT == TWAT.MANDT
  • WLK1.THEMA == TWAT.AKTHE
Module that has caused the listing
  • WLK1.MANDT == WSOH.MANDT
  • WLK1.URSAC == WSOH.SKOPF
Sales unit
  • WLK1.MANDT == T006.MANDT
  • WLK1.VRKME == T006.MSEHI