SAP Table WRS1

Assortment

The table WRS1 (Assortment) is a standard table in SAP ERP. It belongs to the package WSOR.

Technical Information

Table	WRS1
Short Text	Assortment
Package	WSOR
Table Type	Transparent Table

Fields for Table WRS1

Field Name	Key	Description	Data Element	Type	Length	Check Table
MANDT	✔	Client	MANDT	CLNT	3	T000
ASORT	✔	Assortment	ASORT	CHAR	10
STATU		Status of assortment	W_S_STATUS	CHAR	1
KZLIK		Listing conditions should be created per assortment	KZLIK	CHAR	1
NLMATFB		ID: Carry out subsequent listing	NLMATFB	CHAR	1
VKORG		Sales Organization	VKORG	CHAR	4	TVKO
VTWEG		Distribution Channel	VTWEG	CHAR	2	TVTW
LSTFL		Listing procedure	LSTVF	CHAR	2	TWLV
DATAB		Valid-From Date	DATAB	DATS	8
DATBI		Valid To Date	DATBI	DATS	8
KOPRO		All material groups can be listed - even if there are errors	W_S_KOPRO	CHAR	1
LAYPR		Listing check: only use layout defined for the assortment	W_S_LAYPR	CHAR	1
SOTYP		Assortment Category	W_SOTYP	CHAR	1
LAYVR		Layout	LAYVAR	CHAR	10	TWGV
POSDS		No data should be sent to assortment user POS systems	W_POS_DS	CHAR	1
EXCLU		Existence of Exclusion Listing Conditions	W_S_EXCLU	CHAR	1
CATEGORY		Category Nodes	CAT_NODE	CHAR	18
LAY_LIST_UTIME		Time the layout module was last processed	LAYOUT_LISTING_UPDTTIME	CHAR	14
HIER_ID		Hierarchy	WRF_HIER_CNT	CHAR	2	WRF_MATGRP_HIER
ASSORTYP		Assortment Type	WRFDE_ASSORTYP	CHAR	4	WRFST_TYP
ASSORDIMVAL1		Value in an Assortment Dimension	WRFDE_ASSORDIMVAL	CHAR	4	WRFV_TYPDIMVAL1
ASSORDIMVAL2		Value in an Assortment Dimension	WRFDE_ASSORDIMVAL	CHAR	4	WRFV_TYPDIMVAL2
ASSORDIMVAL3		Value in an Assortment Dimension	WRFDE_ASSORDIMVAL	CHAR	4	WRFV_TYPDIMVAL3
LAYGR		Layout Module	LAYGR	CHAR	10	TWML
AEDAT		Changed On	AEDAT	DATS	8