SAP WLK1 Listing Conditions SAP Retail Assortments Table
Overview
WLK1 is a standard SAP S/4HANA table that stores Listing Conditions SAP Retail Assortments data. There are total 19 fields in the WLK1 table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WLK1 belongs to Listing (LO-RFM-MD-LST) module and is located in the package IS-R: Assortments (WSOR).
In addition, following links provide an overview of foreign key relationships, if any, that link WLK1 to other SAP tables and standard CDS views available based on WLK1 table in S/4HANA 2020.
Techincal Settings of WLK1
Below are technical details of the table WLK1
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WLK1 Fields
The following table gives you an overview of the fields available in WLK1
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| FILIA | Assortment | ASORT | WRS1 | CHAR | 10 |
| ARTNR | Material Number | MATNR | MARA | CHAR | 40 |
| VRKME | Sales unit | VRKME | T006 | UNIT | 3 |
| DATBI | Valid To Date | DATBI | DATS | 8 | |
| LFDNR | Sequence number | LFDN3 | NUMC | 3 | |
| DATAB | Valid-From Date | DATAB | DATS | 8 | |
| URSAC | Module that has caused the listing | W_URSAC_BS | WSOH | CHAR | 18 |
| QUELL | Listing Source (Transaction / Function Environment) | W_URSAC_LI | CHAR | 1 | |
| PFLKN | Assortment Priority | W_PFLKN | TWSP | CHAR | 1 |
| ANZAL | - obsolete - No. of modules that have resulted in listing | W_BAU_ZAHL | NUMC | 3 | |
| DATAE | Date of last change | DATAE | DATS | 8 | |
| NEGAT | Negation of assortment item or materials | W_NEG_SORT | CHAR | 1 | |
| AKTIO | Promotion | WAKTION | WAKH | CHAR | 10 |
| THEMA | Promotion theme IS-R | WAKT_THEMA | TWAT | CHAR | 4 |
| STRLI | List as component of a structured material | W_STRULI | CHAR | 1 | |
| SSTAT | Assortment status | W_SORTSTAT | CHAR | 1 | |
| LIFNR | Supplier Number of a Rack Jobber | W_RACKJOB | LFA1 | CHAR | 10 |
| STRNR | Structured material | STRNR | * | CHAR | 40 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for WLK1
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WLK1 | AKTIO | 1: CN | WAKH |
| WLK1 | ARTNR | 1: CN | MARA |
| WLK1 | FILIA | 1: CN | WRS1 |
| WLK1 | LIFNR | 1: CN | LFA1 |
| WLK1 | MANDT | 1: CN | T000 |
| WLK1 | PFLKN | 1: CN | TWSP |
| WLK1 | THEMA | 1: CN | TWAT |
| WLK1 | URSAC | 1: CN | WSOH |
| WLK1 | VRKME | 1: CN | T006 |