1. Home
  2. Resources
  3. SAP Tables
  4. WLK1 - Listing Conditions SAP Retail Assortments

SAP Table WLK1

Listing Conditions SAP Retail Assortments

WLK1 (Listing Conditions SAP Retail Assortments) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link WLK1 to other SAP tables.

WLK1 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
FILIA Assortment ASORT WRS1 CHAR 10 0
ARTNR Material Number MATNR MARA CHAR 18 0
VRKME Sales unit VRKME T006 UNIT 3 0
DATBI Valid To Date DATBI DATS 8 0
LFDNR Sequence number LFDN3 NUMC 3 0
DATAB Valid-From Date DATAB DATS 8 0
URSAC Module that has caused the listing W_URSAC_BS WSOH CHAR 18 0
QUELL Listing source (transaction / function environment) W_URSAC_LI CHAR 1 0
1 Listing via integrated material maintenance
2 Listing via promotion
3 Listing via assortment functions
4 Listing via allocation table
5 Other causes
6 Listing via auto. relisting (not relevant to AL)
9 Listing of a value-only material
7 Listing via initial setup of an assortment according to WRS6
M Listing via manual module selection procedures
C Individual listing change without reference to a module
8 Listing via reclassification
L Listing using layout workbench
P Listing from Planning
PFLKN Assortment Priority W_PFLKN TWSP CHAR 1 0
ANZAL - obsolete - No. of modules that have resulted in listing W_BAU_ZAHL NUMC 3 0
DATAE Date of last change DATAE DATS 8 0
NEGAT Negation of assortment item or materials W_NEG_SORT CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
AKTIO Promotion WAKTION WAKH CHAR 10 0
THEMA Promotion theme IS-R WAKT_THEMA TWAT CHAR 4 0
STRLI List as component of a structured material W_STRULI CHAR 1 0
NULL List individually
X List as component of a structured material
M Obsolete from Release 4.0B
H List as a structure header (set, display, prepack, ...)
SSTAT Assortment status W_SORTSTAT CHAR 1 0
NULL Unrestricted-use assortment
1 Assortment is coming to an end
4 Assortment is being discontinued
5 Assortment has been discontinued
3 Assortment may no longer be ordered externally
2 Assortment may no longer be ordered internally
LIFNR Vendor number of a rack jobber W_RACKJOB LFA1 CHAR 10 0
STRNR Structured material STRNR CHAR 18 0

WLK1 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
WLK1 AKTIO WLK1 AKTIO WAKH Promotion Header Data, IS-R AKTNR
WLK1 AKTIO WLK1 MANDT WAKH Promotion Header Data, IS-R MANDT
WLK1 ARTNR WLK1 MANDT MARA General Material Data MANDT
WLK1 ARTNR WLK1 ARTNR MARA General Material Data MATNR
WLK1 FILIA WLK1 MANDT WRS1 Assortment MANDT
WLK1 FILIA WLK1 FILIA WRS1 Assortment ASORT
WLK1 LIFNR WLK1 MANDT LFA1 Vendor Master (General Section) MANDT
WLK1 LIFNR WLK1 LIFNR LFA1 Vendor Master (General Section) LIFNR
WLK1 MANDT WLK1 MANDT T000 Clients MANDT
WLK1 PFLKN WLK1 MANDT TWSP Assortment priorities IS-R MANDT
WLK1 PFLKN WLK1 PFLKN TWSP Assortment priorities IS-R PFLKS
WLK1 THEMA WLK1 MANDT TWAT Promotion themes, IS-R MANDT
WLK1 THEMA WLK1 THEMA TWAT Promotion themes, IS-R AKTHE
WLK1 URSAC WLK1 MANDT WSOH Assortment Modules SAP Retail MANDT
WLK1 URSAC WLK1 URSAC WSOH Assortment Modules SAP Retail SKOPF
WLK1 VRKME WLK1 MANDT T006 Units of Measurement MANDT
WLK1 VRKME WLK1 VRKME T006 Units of Measurement MSEHI