SAP ABAP View OGV1_VAPMA_WSOP (IS-Software VBAP WSOP View for Assortment Module Search)

Hierarchy

☛ ECC-DIMP (Software Component) DIMP
   ⤷ IS-HT-SW (Application Component) Software Management
     ⤷ HT_SW_GENERAL (Package) General package for IS-HT-SW development

Basic Data

View Type	D	Database View
Database View	OGV1_VAPMA_WSOP
Short Description	IS-Software VBAP WSOP View for Assortment Module Search
Root table	VBAK	Sales Document: Header Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	VBAK	VBAK
2	VBAP
3	VBUP
4	WSOP

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	VBUP	VBELN	JL	EQ				0	0
2	VBAP	VBELN	JR	EQ			AND	0	0
3	VBUP	VBELN	JL	EQ				0	0
4	VBAK	VBELN	JR	EQ			AND	0	0
5	VBUP	POSNR	JL	EQ				0	0
6	VBAP	POSNR	JR	EQ			AND	0	0
7	VBAP	SKOPF	JL	EQ				0	0
8	WSOP	SKOPF	JR	EQ			AND	0	0
9	VBUP	MANDT	JL	EQ				0	0
10	VBAP	MANDT	JR	EQ			AND	0	0
11	VBUP	MANDT	JL	EQ				0	0
12	VBAK	MANDT	JR	EQ			AND	0	0
13	VBUP	MANDT	JL	EQ				0	0
14	WSOP	MANDT	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	VBAK	MANDT		☐	MANDT	☐	Client
2	KUNNR	VBAK	KUNNR		☐	KUNAG	☐	Sold-to party
3	VBELN	VBUP	VBELN		☐	VBELN	☐	Sales and Distribution Document Number
4	POSNR	VBUP	POSNR		☐	POSNR	☐	Item number of the SD document
5	TRVOG	VBAK	TRVOG		☐	TRVOG	☐	Transaction group
6	AUDAT	VBAK	AUDAT		☐	AUDAT	☐	Document Date (Date Received/Sent)
7	VBTYP	VBAK	VBTYP		☐	VBTYP	☐	SD document category
8	GBSTA	VBUP	GBSTA		☐	GBSTA	☐	Overall Processing Status of the SD Document Item
9	SKOPF	WSOP	SKOPF		☐	W_SORTK	☐	Assortment Module
10	SPOSI	WSOP	SPOSI		☐	MATNR	☐	Material Number
11	DATUB	WSOP	DATUB		☐	DATUB	☐	Valid-to date
12	UEPOS	VBAP	UEPOS		☐	UEPOS	☐	Higher-level item in bill of material structures
13	GUEBG	VBAK	GUEBG		☐	GUEBG	☐	Valid-from date (outline agreements, product proposals)
14	GUEEN	VBAK	GUEEN		☐	GUEEN	☐	Valid-to date (outline agreements, product proposals)
15	AUART	VBAK	AUART		☐	AUART	☐	Sales Document Type
16	ABRUF_PART	VBAK	ABRUF_PART		☐	ABRUF_PART	☐	Check partner authorizations

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	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20140121
SAP Release Created in