SAP ABAP Table V_WRSZ (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_WRSZ	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
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	WRS1
3	LFDNR	☑	LFDNR5	NUMC5	NUMC	5	0	Sequence number
4	LOCNR	☐	LOCNR	KUNNR	CHAR	10	0	Customer Number for Plant	KNA1
5	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
6	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
7	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
8	SONUT	☐	W_SONUT	W_SONUT	CHAR	1	0	Category of assortment user
9	DATAB	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
10	DATBI	☐	DATBI	DATUM	DATS	8	0	Valid To Date
11	RANGF	☐	W_S_RANGF	W_S_RANGF	CHAR	1	0	Ranking for assortment assignment
12	NAME1KUN	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
13	VTEXTVTW	☐	VTXTK	TEXT20	CHAR	20	0	Name
14	VTEXTVKO	☐	VTXTK	TEXT20	CHAR	20	0	Name
15	NAME1	☐	ASORTTEXT40	TEXT40	CHAR	40	0	Description of Assortments
16	LIGRD	☐	WLIGRD	WLIGRD	CHAR	1	0	Basic listing rule for assortments
17	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_WRSZ	ASORT	WRS1	ASORT		1	CN
2	V_WRSZ	KUNNR	KNA1	KUNNR		1	CN
3	V_WRSZ	LOCNR	KNA1	KUNNR		1	CN
4	V_WRSZ	MANDT	T000	MANDT		1	CN
5	V_WRSZ	SPART	TSPA	SPART		1	CN
6	V_WRSZ	VKORG	TVKO	VKORG		1	CN
7	V_WRSZ	VTWEG	TVTW	VTWEG		1	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in