SAP ABAP View JHVA_VSW (IS-M/AM: Interface View for VSW Companies)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JAS (Package) Application development R/3 Publishing Advertising System***

Basic Data

View Type	D	Database View
Database View	JHVA_VSW
Short Description	IS-M/AM: Interface View for VSW Companies
Root table	JHAISZ	IS-M/AM: Assignment Table of Advertisers for OPM Order

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JHAISZ	JHAISZ
2	JHAGA
3	JHAK

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	JHAISZ	MANDT	JL	EQ				0	0
2	JHAGA	MANDT	JR	EQ			AND	0	0
3	JHAISZ	AVM_NR	JL	EQ				0	0
4	JHAGA	AVM_NR	JR	EQ			AND	0	0
5	JHAISZ	POS_NR	JL	EQ				0	0
6	JHAGA	POS_NR	JR	EQ			AND	0	0
7	JHAISZ	INSERENT	JL	EQ				0	0
8	JHAGA	INSERENT	JR	EQ			AND	0	0
9	JHAK	MANDT	JL	EQ				0	0
10	JHAISZ	MANDT	JR	EQ			AND	0	0
11	JHAK	AVM_NR	JL	EQ				0	0
12	JHAISZ	AVM_NR	JR	EQ			AND	0	0
13	JHAGA	XSTORNIERT		EQ	' '		AND	0	0
14	JHAGA	MERKMAL9		EQ	' '			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	JHAGA	MANDT		☐	MANDT	☐	Client
2	AVM_NR	JHAGA	AVM_NR		☐	AVM_NR	☐	IS-M/AM: Sales Document Number
3	POS_NR	JHAGA	POS_NR		☐	POS_NR	☐	IS-M: Order Item Number
4	GRUPPABRNR	JHAGA	GRUPPABRNR		☐	GRUPPABRNR	☐	IS-M/AM: Billing Dataset
5	BER_TERMIN	JHAGA	BER_TERMIN		☐	BER_TERMIN	☐	IS-M: Date Services were Created for Settlement Purposes
6	UR_BELEINH	JHAGA	UR_BELEINH		☐	UR_BELEINH	☐	IS-M: Initial Booking Unit for the OPM Item
7	BREITE	JHAGA	BREITE		☐	BREITE_VER	☐	IS-M: Ad Spec Width for Settlement
8	HOEHE	JHAGA	HOEHE		☐	HOEHE_VER	☐	IS-M: Clearable Height for Ad Spec
9	MGLME	JHAGA	MGLME		☐	MENGE_D	☐	Quantity
10	XRABATT	JHAGA	XRABATT		☐	XRABATT	☐	IS-M: Assignment Qualifies for Discount
11	KALSM	JHAGA	KALSM		☐	KALSMASD	☐	Sales and Distribution: Pricing Procedure in Pricing
12	MERKMAL9	JHAGA	MERKMAL9		☐	MERK9_GA	☐	IS-M: Characteristic 9 for Individual Use (Billing Dataset)
13	XSTORNIERT	JHAGA	XSTORNIERT		☐	XSTORNIERT	☐	IS-M: Canceled Order Object Indicator
14	KNUMV	JHAK	KNUMV		☐	KNUMV	☐	Number of the document condition
15	GPAG	JHAK	GPAG		☐	GPAG	☐	Business Partner: Sold-to Party
16	BSTNK	JHAK	BSTNK		☐	BSTNK	☐	Customer purchase order number
17	ALTINSGPNR	JHAISZ	ALTINSGPNR		☐	ALTINSGPNR	☐	IS-M: Alternative Customer Number for Advertiser
18	REGULIERER	JHAISZ	REGULIERER		☐	REGULIERER	☐	IS-M: Payer

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	20130529
SAP Release Created in