SAP Table WRS1
Assortment
WRS1 (Assortment) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link WRS1 to other SAP tables.
WRS1 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||
|
ASORT
Assortment
|
ASORT |
CHAR
|
10 | 0 | ||||||||||
|
STATU
Status of assortment
|
W_S_STATUS |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
KZLIK
Listing conditions should be created per assortment
|
KZLIK |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
NLMATFB
ID: Carry out subsequent listing
|
NLMATFB |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
VKORG
Sales Organization
|
VKORG | TVKO |
CHAR
|
4 | 0 | |||||||||
|
VTWEG
Distribution Channel
|
VTWEG | TVTW |
CHAR
|
2 | 0 | |||||||||
|
LSTFL
Listing procedure
|
LSTVF | TWLV |
CHAR
|
2 | 0 | |||||||||
|
DATAB
Valid-From Date
|
DATAB |
DATS
|
8 | 0 | ||||||||||
|
DATBI
Valid To Date
|
DATBI |
DATS
|
8 | 0 | ||||||||||
|
KOPRO
All material groups can be listed - even if there are errors
|
W_S_KOPRO |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
LAYPR
Listing check: only use layout defined for the assortment
|
W_S_LAYPR |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
SOTYP
Assortment Category
|
W_SOTYP |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
LAYVR
Layout
|
LAYVAR | TWGV |
CHAR
|
10 | 0 | |||||||||
|
POSDS
No data should be sent to assortment user POS systems
|
W_POS_DS |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
EXCLU
Existence of Exclusion Listing Conditions
|
W_S_EXCLU |
CHAR
|
1 | 0 | ||||||||||
|
CATEGORY
Category Nodes
|
CAT_NODE |
CHAR
|
18 | 0 | ||||||||||
|
LAY_LIST_UTIME
Time the layout module was last processed
|
LAYOUT_LISTING_UPDTTIME |
CHAR
|
14 | 0 | ||||||||||
|
HIER_ID
Hierarchy
|
WRF_HIER_CNT | WRF_MATGRP_HIER |
CHAR
|
2 | 0 | |||||||||
|
ASSORTYP
Assortment Type
|
WRFDE_ASSORTYP | WRFST_TYP |
CHAR
|
4 | 0 | |||||||||
|
ASSORDIMVAL1
Value in an Assortment Dimension
|
WRFDE_ASSORDIMVAL | WRFV_TYPDIMVAL1 |
CHAR
|
4 | 0 | |||||||||
|
ASSORDIMVAL2
Value in an Assortment Dimension
|
WRFDE_ASSORDIMVAL | WRFV_TYPDIMVAL2 |
CHAR
|
4 | 0 | |||||||||
|
ASSORDIMVAL3
Value in an Assortment Dimension
|
WRFDE_ASSORDIMVAL | WRFV_TYPDIMVAL3 |
CHAR
|
4 | 0 | |||||||||
|
LAYGR
Layout Module
|
LAYGR | TWML |
CHAR
|
10 | 0 | |||||||||
|
AEDAT
Changed On
|
AEDAT |
DATS
|
8 | 0 | ||||||||||
WRS1 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| WRS1 | ASSORDIMVAL1 | WRS1 | ASSORDIMVAL1 |
WRFV_TYPDIMVAL1
Generated Table for View
|
ASSORDIMVAL |
| WRS1 | ASSORDIMVAL1 | WRS1 | MANDT |
WRFV_TYPDIMVAL1
Generated Table for View
|
MANDT |
| WRS1 | ASSORDIMVAL1 | WRS1 | ASSORTYP |
WRFV_TYPDIMVAL1
Generated Table for View
|
ASSORTYP |
| WRS1 | ASSORDIMVAL1 | * |
WRFV_TYPDIMVAL1
Generated Table for View
|
ASSORDIM1 | |
| WRS1 | ASSORDIMVAL2 | WRS1 | MANDT |
WRFV_TYPDIMVAL2
Generated Table for View
|
MANDT |
| WRS1 | ASSORDIMVAL2 | WRS1 | ASSORTYP |
WRFV_TYPDIMVAL2
Generated Table for View
|
ASSORTYP |
| WRS1 | ASSORDIMVAL2 | * |
WRFV_TYPDIMVAL2
Generated Table for View
|
ASSORDIM2 | |
| WRS1 | ASSORDIMVAL2 | WRS1 | ASSORDIMVAL2 |
WRFV_TYPDIMVAL2
Generated Table for View
|
ASSORDIMVAL |
| WRS1 | ASSORDIMVAL3 | WRS1 | ASSORTYP |
WRFV_TYPDIMVAL3
Generated Table for View
|
ASSORTYP |
| WRS1 | ASSORDIMVAL3 | * |
WRFV_TYPDIMVAL3
Generated Table for View
|
ASSORDIM3 | |
| WRS1 | ASSORDIMVAL3 | WRS1 | ASSORDIMVAL3 |
WRFV_TYPDIMVAL3
Generated Table for View
|
ASSORDIMVAL |
| WRS1 | ASSORDIMVAL3 | WRS1 | MANDT |
WRFV_TYPDIMVAL3
Generated Table for View
|
MANDT |
| WRS1 | ASSORTYP | WRS1 | MANDT |
WRFST_TYP
Assortment Types
|
MANDT |
| WRS1 | ASSORTYP | WRS1 | ASSORTYP |
WRFST_TYP
Assortment Types
|
ASSORTYP |
| WRS1 | HIER_ID | WRS1 | MANDT |
WRF_MATGRP_HIER
Article Hierarchy Properties
|
MANDT |
| WRS1 | HIER_ID | WRS1 | HIER_ID |
WRF_MATGRP_HIER
Article Hierarchy Properties
|
HIER_ID |
| WRS1 | LAYGR | WRS1 | MANDT |
TWML
Layout module
|
MANDT |
| WRS1 | LAYGR | WRS1 | LAYGR |
TWML
Layout module
|
LAYGR |
| WRS1 | LAYVR | WRS1 | LAYVR |
TWGV
Layout
|
LAYVR |
| WRS1 | LAYVR | WRS1 | MANDT |
TWGV
Layout
|
MANDT |
| WRS1 | LSTFL | WRS1 | MANDT |
TWLV
Listing procedure, assortments
|
MANDT |
| WRS1 | LSTFL | WRS1 | LSTFL |
TWLV
Listing procedure, assortments
|
LSTFL |
| WRS1 | MANDT | WRS1 | MANDT |
T000
Clients
|
MANDT |
| WRS1 | VKORG | WRS1 | MANDT |
TVKO
Organizational Unit: Sales Organizations
|
MANDT |
| WRS1 | VKORG | WRS1 | VKORG |
TVKO
Organizational Unit: Sales Organizations
|
VKORG |
| WRS1 | VTWEG | WRS1 | MANDT |
TVTW
Organizational Unit: Distribution Channels
|
MANDT |
| WRS1 | VTWEG | WRS1 | VTWEG |
TVTW
Organizational Unit: Distribution Channels
|
VTWEG |