1. Home
  2. Resources
  3. SAP Tables
  4. WRS1 - Assortment

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
MANDT Client MANDT T000 CLNT 3 0
ASORT Assortment ASORT CHAR 10 0
STATU Status of assortment W_S_STATUS CHAR 1 0
NULL Not active
1 Active, can be assigned to assortment users
2 Inactive, flagged for deletion
KZLIK Listing conditions should be created per assortment KZLIK CHAR 1 0
X Yes
NULL No
NLMATFB ID: Carry out subsequent listing NLMATFB CHAR 1 0
1 No subsequent listing; error is being processed
2 Subs. listing
3 Manual decision
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
X Yes
NULL No
LAYPR Listing check: only use layout defined for the assortment W_S_LAYPR CHAR 1 0
X Yes
NULL No
SOTYP Assortment Category W_SOTYP CHAR 1 0
A Store assortment category
B Distribution center assortment category
C Customer assignment category
LAYVR Layout LAYVAR TWGV CHAR 10 0
POSDS No data should be sent to assortment user POS systems W_POS_DS CHAR 1 0
X Yes
NULL No
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