SAP ABAP View V_WRSZ (Assortment - Assignments)

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

View Type	C	Maintenance View
Maintenance View	V_WRSZ
Short Description	Assortment - Assignments
Root table	WRSZ	Assignment of assortment user to assortment

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	WRSZ	WRSZ
2	KNA1	WRSZ	KUNNR	E
3	TVKO	WRSZ	VKORG	E
4	TVTW	WRSZ	VTWEG	E
5	WRS1	WRSZ	ASORT	E
6	WRST	WRS1	ASORT	I
7	TVKOT	TVKO	VKORG	I
8	TVTWT	TVTW	VTWEG	I

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	WRSZ	MANDT		☐	MANDT	☐	Client
2	ASORT	WRSZ	ASORT		☐	ASORT	☐	Assortment
3	LFDNR	WRSZ	LFDNR		☐	LFDNR5	☐	Sequence number
4	LOCNR	WRSZ	LOCNR		☐	LOCNR	☐	Customer Number for Plant
5	KUNNR	WRSZ	KUNNR		☐	KUNNR	☐	Customer Number
6	VKORG	WRSZ	VKORG		☐	VKORG	☐	Sales Organization
7	VTWEG	WRSZ	VTWEG		☐	VTWEG	☐	Distribution Channel
8	SONUT	WRSZ	SONUT		☐	W_SONUT	☐	Category of assortment user
9	DATAB	WRSZ	DATAB		☐	DATAB	☐	Valid-From Date
10	DATBI	WRSZ	DATBI		☐	DATBI	☐	Valid To Date
11	RANGF	WRSZ	RANGF		☐	W_S_RANGF	☐	Ranking for assortment assignment
12	NAME1KUN	KNA1	NAME1		☐	NAME1_GP	☐	Name 1
13	VTEXTVTW	TVTWT	VTEXT		☐	VTXTK	☐	Name
14	VTEXTVKO	TVKOT	VTEXT		☐	VTXTK	☐	Name
15	NAME1	WRST	NAME1		☐	ASORTTEXT40	☐	Description of Assortments
16	LIGRD	WRSZ	LIGRD		☐	WLIGRD	☐	Basic listing rule for assortments
17	SPART	WRSZ	SPART		☐	SPART	☐	Division

Maintenance Status

Access

☐   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☑   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

History

Last changed by/on	SAP	20131127
SAP Release Created in