SAP WRSZ Assignment of assortment user to assortment Table
Overview
WRSZ is a standard SAP S/4HANA table that stores Assignment of assortment user to assortment data. There are total 18 fields in the WRSZ table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WRSZ 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 WRSZ to other SAP tables and standard CDS views available based on WRSZ table in S/4HANA 2020.
Techincal Settings of WRSZ
Below are technical details of the table WRSZ
- Buffering switched on
- Full buffering as specified by generic key
- Storage type is Column Store
List of WRSZ Fields
The following table gives you an overview of the fields available in WRSZ
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| ASORT | Assortment | ASORT | WRS1 | CHAR | 10 |
| LFDNR | Sequence Number | LFDNR5 | NUMC | 5 | |
| LOCNR | Customer Number for Plant | LOCNR | KNA1 | CHAR | 10 |
| KUNNR | Customer Number | KUNNR | KNA1 | CHAR | 10 |
| VKORG | Sales Organization | VKORG | TVKO | CHAR | 4 |
| VTWEG | Distribution Channel | VTWEG | TVTW | CHAR | 2 |
| SPART | Division | SPART | TSPA | CHAR | 2 |
| SONUT | Category of assortment user | W_SONUT | CHAR | 1 | |
| DATAB | Valid-From Date | DATAB | DATS | 8 | |
| DATBI | Valid To Date | DATBI | DATS | 8 | |
| RANGF | Ranking for assortment assignment | W_S_RANGF | CHAR | 1 | |
| LIGRD | Basic listing rule for assortments | WLIGRD | CHAR | 1 | |
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | |
| ERZET | Entry time | ERZET | TIMS | 6 | |
| AENAM | Name of person who changed object | AENAM | CHAR | 12 | |
| AEDAT | Date of Last Change | AEDAT | DATS | 8 | |
| AEZET | Time last change was made | AEZET | TIMS | 6 |
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 WRSZ
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WRSZ | ASORT | 1: CN | WRS1 |
| WRSZ | KUNNR | 1: CN | KNA1 |
| WRSZ | LOCNR | 1: CN | KNA1 |
| WRSZ | MANDT | 1: CN | T000 |
| WRSZ | SPART | 1: CN | TSPA |
| WRSZ | VKORG | 1: CN | TVKO |
| WRSZ | VTWEG | 1: CN | TVTW |