SAP ABAP Table WRF_WRS1_S (Interface Structure of Assortments)

Hierarchy

☛ EA-RETAIL (Software Component) SAP Enterprise Extension Retail
   ⤷ LO-MD-RA-MT (Application Component) Assortment Maintenance
     ⤷ WRF_ASORT (Package) RTFASH: Assortments

Basic Data

Table Category	INTTAB	Structure
Structure	WRF_WRS1_S	Table Relationship Diagram
Short Description	Interface Structure of Assortments

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Assortment
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	ASORT	☐	ASORT	ASORT	CHAR	10	0	Assortment	*
4	STATU	☐	W_S_STATUS	W_S_STATUS	CHAR	1	0	Status of assortment
5	KZLIK	☐	KZLIK	XFELD	CHAR	1	0	Listing conditions should be created per assortment
6	NLMATFB	☐	NLMATFB	NLMATFB	CHAR	1	0	ID: Carry out subsequent listing
7	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
8	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
9	LSTFL	☐	LSTVF	LSTFL	CHAR	2	0	Listing procedure	TWLV
10	DATAB	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
11	DATBI	☐	DATBI	DATUM	DATS	8	0	Valid To Date
12	KOPRO	☐	W_S_KOPRO	XFELD	CHAR	1	0	All material groups can be listed - even if there are errors
13	LAYPR	☐	W_S_LAYPR	XFELD	CHAR	1	0	Listing check: only use layout defined for the assortment
14	SOTYP	☐	W_SOTYP	W_SOTYP	CHAR	1	0	Assortment Category
15	LAYVR	☐	LAYVAR	LAYVAR	CHAR	10	0	Layout	TWGV
16	POSDS	☐	W_POS_DS	XFELD	CHAR	1	0	No data should be sent to assortment user POS systems
17	EXCLU	☐	W_S_EXCLU	CHAR1	CHAR	1	0	Existence of Exclusion Listing Conditions
18	CATEGORY	☐	CAT_NODE	CAT_NODE	CHAR	18	0	Category Nodes
19	LAY_LIST_UTIME	☐	LAYOUT_LISTING_UPDTTIME	TIMESTAMP	CHAR	14	0	Time the layout module was last processed
20	.INCLU--AP	☐				0	0	Assortment Extensions
21	HIER_ID	☐	WRF_HIER_CNT	WRF_HIERCNT	CHAR	2	0	Hierarchy	WRF_MATGRP_HIER
22	ASSORTYP	☐	WRFDE_ASSORTYP	WRFDO_ASSORTYP	CHAR	4	0	Assortment Type	WRFST_TYP
23	ASSORDIMVAL1	☐	WRFDE_ASSORDIMVAL	WRFDO_ASSORDIMVAL	CHAR	4	0	Value in an Assortment Dimension	WRFV_TYPDIMVAL1
24	ASSORDIMVAL2	☐	WRFDE_ASSORDIMVAL	WRFDO_ASSORDIMVAL	CHAR	4	0	Value in an Assortment Dimension	WRFV_TYPDIMVAL2
25	ASSORDIMVAL3	☐	WRFDE_ASSORDIMVAL	WRFDO_ASSORDIMVAL	CHAR	4	0	Value in an Assortment Dimension	WRFV_TYPDIMVAL3
26	LAYGR	☐	LAYGR	LAYGR	CHAR	10	0	Layout Module	TWML
27	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
28	UPD	☐	FLAG	FLAG	CHAR	1	0	General Flag

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	WRF_WRS1_S	ASSORDIMVAL1	WRFV_TYPDIMVAL1	ASSORDIMVAL	KEY
2	WRF_WRS1_S	ASSORDIMVAL2	WRFV_TYPDIMVAL2	ASSORDIMVAL	KEY
3	WRF_WRS1_S	ASSORDIMVAL3	WRFV_TYPDIMVAL3	ASSORDIMVAL	KEY
4	WRF_WRS1_S	ASSORTYP	WRFST_TYP	ASSORTYP	KEY
5	WRF_WRS1_S	HIER_ID	WRF_MATGRP_HIER	HIER_ID	KEY
6	WRF_WRS1_S	LAYGR	TWML	LAYGR	KEY
7	WRF_WRS1_S	LAYVR	TWGV	LAYVR		1	CN
8	WRF_WRS1_S	LSTFL	TWLV	LSTFL		1	CN
9	WRF_WRS1_S	MANDT	T000	MANDT		1	CN
10	WRF_WRS1_S	VKORG	TVKO	VKORG		1	CN
11	WRF_WRS1_S	VTWEG	TVTW	VTWEG		1	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in	111