SAP WLK11 Listing Conditions SAP Retail / Folder per Distrib. Chain Table
Overview
WLK11 is a standard SAP S/4HANA table that stores Listing Conditions SAP Retail / Folder per Distrib. Chain data. There are total 18 fields in the WLK11 table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WLK11 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 WLK11 to other SAP tables and standard CDS views available based on WLK11 table in S/4HANA 2020.
Techincal Settings of WLK11
Below are technical details of the table WLK11
- Buffering switched on
- Single entries of table were buffered
- Storage type is Column Store
List of WLK11 Fields
The following table gives you an overview of the fields available in WLK11
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| VKORG | Sales Organization | VKORG | TVKO | CHAR | 4 |
| VTWEG | Distribution Channel | VTWEG | TVTW | CHAR | 2 |
| 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 | IS-R assortment module | BAUSTEIN | * | CHAR | 18 |
| QUELL | Listing Source (Transaction / Function Environment) | W_URSAC_LI | CHAR | 1 | |
| PFLKN | Assortment Priority | W_PFLKN | * | 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 |
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 WLK11
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WLK11 | AKTIO | 1: CN | WAKH |
| WLK11 | ARTNR | 1: CN | MARA |
| WLK11 | MANDT | 1: CN | T000 |
| WLK11 | THEMA | 1: CN | TWAT |
| WLK11 | VKORG | 1: CN | TVKO |
| WLK11 | VRKME | 1: CN | T006 |
| WLK11 | VTWEG | 1: CN | TVTW |