SAP table WRS1 (Assortment)

SAP table WRS1 has 2 primary key fields being MANDT,ASORT.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
ASORT Assortment CHAR 10 0 ASORT
STATU Status of assortment CHAR 1 0 W_S_STATUS
Not active
1 Active, can be assigned to assortment users
2 Inactive, flagged for deletion
KZLIK Listing Conditions for Assortments CHAR 1 0 KZLIK
NLMATFB ID: Carry out subsequent listing CHAR 1 0 NLMATFB
1 No subsequent listing; error is being processed
2 Subs. listing
3 Manual decision
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
A Store assortment category
B Distribution center assortment category
C Customer assignment category
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

WRS1 foreign key relationships

Table Field Check Table Check Field
0 WRS1 ASSORDIMVAL1 WRFV_TYPDIMVAL1 Generated Table for View ASSORDIM1
1 WRS1 ASSORDIMVAL2 WRFV_TYPDIMVAL2 Generated Table for View ASSORDIM2
0 WRS1 ASSORDIMVAL3 WRFV_TYPDIMVAL3 Generated Table for View ASSORDIM3
1 WRS1 ASSORTYP WRFST_TYP Assortment Types MANDT
0 WRS1 HIER_ID WRF_MATGRP_HIER Article Hierarchy Properties MANDT
0 WRS1 HIER_ID WRF_MATGRP_HIER Article Hierarchy Properties HIER_ID
1 WRS1 LAYGR TWML Layout module MANDT
1 WRS1 LAYGR TWML Layout module LAYGR
0 WRS1 LAYVR TWGV Layout MANDT
0 WRS1 LAYVR TWGV Layout LAYVR
1 WRS1 LSTFL TWLV Listing procedure, assortments MANDT
1 WRS1 LSTFL TWLV Listing procedure, assortments LSTFL
0 WRS1 MANDT T000 Clients MANDT
1 WRS1 VKORG TVKO Organizational Unit: Sales Organizations MANDT
1 WRS1 VKORG TVKO Organizational Unit: Sales Organizations VKORG
0 WRS1 VTWEG TVTW Organizational Unit: Distribution Channels MANDT
0 WRS1 VTWEG TVTW Organizational Unit: Distribution Channels VTWEG