SAP WRS1 Assortment Table
Overview
WRS1 is a standard SAP S/4HANA table that stores Assortment data. There are total 25 fields in the WRS1 table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WRS1 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 WRS1 to other SAP tables and standard CDS views available based on WRS1 table in S/4HANA 2020.
Techincal Settings of WRS1
Below are technical details of the table WRS1
- Buffering switched on
- Full table is passed to buffer
- Storage type is Column Store
List of WRS1 Fields
The following table gives you an overview of the fields available in WRS1
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| ASORT | Assortment | ASORT | CHAR | 10 | |
| STATU | Status of assortment | W_S_STATUS | CHAR | 1 | |
| KZLIK | Listing Conditions for Assortments | KZLIK | CHAR | 1 | |
| NLMATFB | ID: Carry out subsequent listing | NLMATFB | CHAR | 1 | |
| VKORG | Sales Organization | VKORG | TVKO | CHAR | 4 |
| VTWEG | Distribution Channel | VTWEG | TVTW | CHAR | 2 |
| LSTFL | Listing procedure | LSTVF | TWLV | CHAR | 2 |
| DATAB | Valid-From Date | DATAB | DATS | 8 | |
| DATBI | Valid To Date | DATBI | DATS | 8 | |
| KOPRO | All material groups can be listed - even if there are errors | W_S_KOPRO | CHAR | 1 | |
| LAYPR | Listing check: only use layout defined for the assortment | W_S_LAYPR | CHAR | 1 | |
| SOTYP | Assortment Category | W_SOTYP | CHAR | 1 | |
| LAYVR | Layout | LAYVAR | TWGV | CHAR | 10 |
| POSDS | No data should be sent to assortment user POS systems | W_POS_DS | CHAR | 1 | |
| EXCLU | Existence of Exclusion Listing Conditions | W_S_EXCLU | CHAR | 1 | |
| CATEGORY | Category Nodes | CAT_NODE | CHAR | 18 | |
| LAY_LIST_UTIME | Time the layout module was last processed | LAYOUT_LISTING_UPDTTIME | CHAR | 14 | |
| HIER_ID | Hierarchy | WRF_HIER_CNT | WRF_MATGRP_HIER | CHAR | 2 |
| ASSORTYP | Assortment Type | WRFDE_ASSORTYP | WRFST_TYP | CHAR | 4 |
| ASSORDIMVAL1 | Value in an Assortment Dimension | WRFDE_ASSORDIMVAL | WRFV_TYPDIMVAL1 | CHAR | 4 |
| ASSORDIMVAL2 | Value in an Assortment Dimension | WRFDE_ASSORDIMVAL | WRFV_TYPDIMVAL2 | CHAR | 4 |
| ASSORDIMVAL3 | Value in an Assortment Dimension | WRFDE_ASSORDIMVAL | WRFV_TYPDIMVAL3 | CHAR | 4 |
| LAYGR | Layout Module | LAYGR | TWML | CHAR | 10 |
| AEDAT | Date of Last Change | AEDAT | DATS | 8 |
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 WRS1
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WRS1 | ASSORDIMVAL1 | : | WRFV_TYPDIMVAL1 |
| WRS1 | ASSORDIMVAL2 | : | WRFV_TYPDIMVAL2 |
| WRS1 | ASSORDIMVAL3 | : | WRFV_TYPDIMVAL3 |
| WRS1 | ASSORTYP | : | WRFST_TYP |
| WRS1 | HIER_ID | : | WRF_MATGRP_HIER |
| WRS1 | LAYGR | : | TWML |
| WRS1 | LAYVR | 1: CN | TWGV |
| WRS1 | LSTFL | 1: CN | TWLV |
| WRS1 | MANDT | 1: CN | T000 |
| WRS1 | VKORG | 1: CN | TVKO |
| WRS1 | VTWEG | 1: CN | TVTW |