SAP ABAP View JHVGAV (Values for Calculating the Contract Quantity of a BillDtst)

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	JHVGAV
Short Description	Values for Calculating the Contract Quantity of a BillDtst
Root table	JHAGA	IS-M/AM: Order-Publishing-Media Billing Dataset

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JHAGA	JHAGA
2	JHAISZ
3	JHAP
4	JHAK
5	TJHAP

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	JHAP	MANDT	JL	EQ				0	0
10	JHAGA	MANDT	JR	EQ			AND	0	0
11	JHAP	AVM_NR	JL	EQ				0	0
12	JHAGA	AVM_NR	JR	EQ			AND	0	0
13	JHAP	POS_NR	JL	EQ				0	0
14	JHAGA	POS_NR	JR	EQ			AND	0	0
15	JHAK	MANDT	JL	EQ				0	0
16	JHAGA	MANDT	JR	EQ			AND	0	0
17	JHAK	AVM_NR	JL	EQ				0	0
18	JHAGA	AVM_NR	JR	EQ			AND	0	0
19	TJHAP	MANDT	JL	EQ				0	0
20	JHAGA	MANDT	JR	EQ			AND	0	0
21	TJHAP	PSTYV	JL	EQ				0	0
22	JHAGA	PSTYV	JR	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	INSERENT	JHAGA	INSERENT		☐	INSERENT	☐	IS-M: Advertiser
6	XFAKT_EE	JHAGA	XFAKT_EE		☐	XFAKT_EE	☐	IS-M: Billed Indicator
7	WAERG	JHAGA	WAERG		☐	WAERK	☐	SD document currency
8	BER_TERMIN	JHAGA	BER_TERMIN		☐	BER_TERMIN	☐	IS-M: Date Services were Created for Settlement Purposes
9	AZART_AREA	JHAGA	AZART_AREA		☐	AZART_AREA	☐	IS-M/AM: Fixed Format Proposal /Ad Dimensions
10	AZART_FARB	JHAGA	AZART_FARB		☐	AZART_FARB	☐	IS-M: Color Scheme Ad Type
11	AZART_FORM	JHAGA	AZART_FORM		☐	AZART_FORM	☐	IS-M: Shape Ad Type
12	AZART_GEST	JHAGA	AZART_GEST		☐	AZART_GEST	☐	IS-M: Design Ad Type
13	BREITE	JHAGA	BREITE		☐	BREITE_VER	☐	IS-M: Ad Spec Width for Settlement
14	BREITE_EH	JHAGA	BREITE_EH		☐	BREITE_SEH	☐	IS-M/AM: Unit of Measure for Width
15	HOEHE	JHAGA	HOEHE		☐	HOEHE_VER	☐	IS-M: Clearable Height for Ad Spec
16	HOEHE_EH	JHAGA	HOEHE_EH		☐	ISPEINH_H	☐	IS-M: Unit of Measure for Height
17	ZUS_MENGE	JHAGA	ZUS_MENGE		☐	BER_MENGE	☐	IS-M: Number of Additional Ad Spec Calculation Units
18	ZUS_BERECH	JHAGA	ZUS_BERECH		☐	MEINH_ZUS	☐	IS-M: Additional Unit of Measure for Settlement
19	MGLME	JHAGA	MGLME		☐	MENGE_D	☐	Quantity
20	LAGME	JHAGA	LAGME		☐	LAGME	☐	Base Unit of Measure
21	SI_SEITEN	JHAGA	SI_SEITEN		☐	ANZSEITEN	☐	Number of Pages in Issue
22	SEITE_FSP	JHAGA	SEITE_FSP		☐	SEITE_FSP	☐	IS-M: Page/column format
23	SEITE_FORM	JHAGA	SEITE_FORM		☐	SEITE_FORM	☐	IS-M: Page Format
24	BELEGEINH	JHAGA	BELEGEINH		☐	BE_BASIS	☐	IS-M: Basic Booking Unit
25	UR_BELEINH	JHAGA	UR_BELEINH		☐	UR_BELEINH	☐	IS-M: Initial Booking Unit for the OPM Item
26	ABS_MAL	JHAGA	ABS_MAL		☐	JHRSMAL	☐	IS-M: Number for Contract Standing
27	XSTORNIERT	JHAGA	XSTORNIERT		☐	XSTORNIERT	☐	IS-M: Canceled Order Object Indicator
28	KALSM	JHAGA	KALSM		☐	KALSMASD	☐	Sales and Distribution: Pricing Procedure in Pricing
29	REF_VBELN	JHAGA	REF_VBELN		☐	JJBELNR	☐	IS-M/AM: Billing Document
30	REF_POSNR	JHAGA	REF_POSNR		☐	JJPOSNR	☐	IS-M/AM: Item (number) in settlement document
31	INS_PROZ	JHAISZ	INS_PROZ		☐	PAM_PROZ	☐	IS-M: Percentage Figure for Cost Distribution
32	AZGR_INS	JHAISZ	AZGR_INS		☐	AZGR_INS	☐	Column MM of the Ad Which the Advertiser is Involved In
33	POS_ART	JHAP	POS_ART		☐	AVMPOS_ART	☐	IS-M: Order-Publishing-Media - Item Type
34	PSTYV	JHAP	PSTYV		☐	PSTYV_PAM	☐	IS-M: Item Category for Sales Document
35	XAGENAUFTR	JHAP	XAGENAUFTR		☐	XAGENAUFTR	☐	IS-M: Agency order indicator
36	KAMPAGNE	JHAP	KAMPAGNE		☐	KAMPAGNE	☐	IS-M: Campaign (customer)
37	VKORG	JHAK	VKORG		☐	VKORG	☐	Sales Organization
38	VTWEG	JHAK	VTWEG		☐	VTWEG	☐	Distribution Channel
39	SPART	JHAK	SPART		☐	SPART	☐	Division
40	GPAG	JHAK	GPAG		☐	GPAG	☐	Business Partner: Sold-to Party
41	AVM_HRKNFT	JHAK	AVM_HRKNFT		☐	AVM_HRKNFT	☐	IS-M/AM: Order Origin
42	KNUMV	JHAK	KNUMV		☐	KNUMV	☐	Number of the document condition
43	VBTYP	TJHAP	VBTYP		☐	ISPVBTYP	☐	IS-M/AM: Sales Document Category
44	XGE_GESCH	TJHAP	XGE_GESCH		☐	XGE_GESCH	☐	IS-M: Barter Deal Indicator

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