SAP table reference
WRS1
AssortmentExplore another table
Enter a table code or keyword to continue exploring.
Explore the structure, fields and relationships of SAP table WRS1.
SAP table WRS1 has 2 primary key fields: MANDT,ASORT.
When analysing data from one SAP instance, MANDT is normally identical across the dataset and may be omitted from relationships. When combining multiple instances, include MANDT.
/ Fields
WRS1 fields.
| Field | Description | Data type | Length | Decimals | Check table | Data element | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Key MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||
| Key ASORT | Assortment | CHAR | 10 | 0 | ASORT | ||||||||
| STATU | Status of assortment | CHAR | 1 | 0 | W_S_STATUS | ||||||||
| |||||||||||||
| KZLIK | Listing Conditions for Assortments | CHAR | 1 | 0 | KZLIK | ||||||||
| NLMATFB | ID: Carry out subsequent listing | CHAR | 1 | 0 | NLMATFB | ||||||||
| |||||||||||||
| VKORG | Sales Organization | CHAR | 4 | 0 | TVKO | VKORG | |||||||
| VTWEG | Distribution Channel | CHAR | 2 | 0 | TVTW | VTWEG | |||||||
| LSTFL | Listing procedure | CHAR | 2 | 0 | TWLV | LSTVF | |||||||
| DATAB | Valid-From Date | DATS | 8 | 0 | DATAB | ||||||||
| DATBI | Valid To Date | DATS | 8 | 0 | DATBI | ||||||||
| KOPRO | All material groups can be listed - even if there are errors | CHAR | 1 | 0 | W_S_KOPRO | ||||||||
| LAYPR | Listing check: only use layout defined for the assortment | CHAR | 1 | 0 | W_S_LAYPR | ||||||||
| SOTYP | Assortment Category | CHAR | 1 | 0 | W_SOTYP | ||||||||
| |||||||||||||
| LAYVR | Layout | CHAR | 10 | 0 | TWGV | LAYVAR | |||||||
| POSDS | No data should be sent to assortment user POS systems | CHAR | 1 | 0 | W_POS_DS | ||||||||
| EXCLU | Existence of Exclusion Listing Conditions | CHAR | 1 | 0 | W_S_EXCLU | ||||||||
| CATEGORY | Category Nodes | CHAR | 18 | 0 | CAT_NODE | ||||||||
| LAY_LIST_UTIME | Time the layout module was last processed | CHAR | 14 | 0 | LAYOUT_LISTING_UPDTTIME | ||||||||
| HIER_ID | Hierarchy | CHAR | 2 | 0 | WRF_MATGRP_HIER | WRF_HIER_CNT | |||||||
| ASSORTYP | Assortment Type | CHAR | 4 | 0 | WRFST_TYP | WRFDE_ASSORTYP | |||||||
| ASSORDIMVAL1 | Value in an Assortment Dimension | CHAR | 4 | 0 | WRFV_TYPDIMVAL1 | WRFDE_ASSORDIMVAL | |||||||
| ASSORDIMVAL2 | Value in an Assortment Dimension | CHAR | 4 | 0 | WRFV_TYPDIMVAL2 | WRFDE_ASSORDIMVAL | |||||||
| ASSORDIMVAL3 | Value in an Assortment Dimension | CHAR | 4 | 0 | WRFV_TYPDIMVAL3 | WRFDE_ASSORDIMVAL | |||||||
| LAYGR | Layout Module | CHAR | 10 | 0 | TWML | LAYGR | |||||||
| AEDAT | Last Changed On | DATS | 8 | 0 | AEDAT | ||||||||
/ Relationships
WRS1 relationships.
| Table | Field | Check table | Description | Check field |
|---|---|---|---|---|
| WRS1 | ASSORDIMVAL1 | WRFV_TYPDIMVAL1 | Generated Table for View | ASSORDIM1 |
| WRS1 | ASSORDIMVAL2 | WRFV_TYPDIMVAL2 | Generated Table for View | ASSORDIM2 |
| WRS1 | ASSORDIMVAL3 | WRFV_TYPDIMVAL3 | Generated Table for View | ASSORDIM3 |
| WRS1 | ASSORTYP | WRFST_TYP | Assortment Types | MANDT |
| WRS1 | HIER_ID | WRF_MATGRP_HIER | Article Hierarchy Properties | MANDT |
| WRS1 | HIER_ID | WRF_MATGRP_HIER | Article Hierarchy Properties | HIER_ID |
| WRS1 | LAYGR | TWML | Layout module | MANDT |
| WRS1 | LAYGR | TWML | Layout module | LAYGR |
| WRS1 | LAYVR | TWGV | Layout | MANDT |
| WRS1 | LAYVR | TWGV | Layout | LAYVR |
| WRS1 | LSTFL | TWLV | Listing procedure, assortments | MANDT |
| WRS1 | LSTFL | TWLV | Listing procedure, assortments | LSTFL |
| WRS1 | MANDT | T000 | Clients | MANDT |
| WRS1 | VKORG | TVKO | Organizational Unit: Sales Organizations | MANDT |
| WRS1 | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
| WRS1 | VTWEG | TVTW | Organizational Unit: Distribution Channels | MANDT |
| WRS1 | VTWEG | TVTW | Organizational Unit: Distribution Channels | VTWEG |