SAP ABAP Table WRS1 (Assortment)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ WSOR (Package) IS-R: Assortments

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	WRS1	Table Relationship Diagram
Short Description	Assortment

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

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

Foreign Keys

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

History

Last changed by/on	SAP	20131127
SAP Release Created in