SAP ABAP View JHVGA1 (IS-M/AM: Billing Datasets View (All Item Types))

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	JHVGA1
Short Description	IS-M/AM: Billing Datasets View (All Item Types)
Root table	JHAGA	IS-M/AM: Order-Publishing-Media Billing Dataset

Table

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

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	JHAP	MANDT	JL	EQ				0	0
2	JHAGA	MANDT	JR	EQ			AND	0	0
3	JHAP	AVM_NR	JL	EQ				0	0
4	JHAGA	AVM_NR	JR	EQ			AND	0	0
5	JHAP	POS_NR	JL	EQ				0	0
6	JHAGA	POS_NR	JR	EQ			AND	0	0
7	JHAK	MANDT	JL	EQ				0	0
8	JHAGA	MANDT	JR	EQ			AND	0	0
9	JHAK	AVM_NR	JL	EQ				0	0
10	JHAGA	AVM_NR	JR	EQ			AND	0	0
11	TJHAP	MANDT	JL	EQ				0	0
12	JHAGA	MANDT	JR	EQ			AND	0	0
13	TJHAP	PSTYV	JL	EQ				0	0
14	JHAGA	PSTYV	JR	EQ			AND	0	0
15	JHAISZ	MANDT	JL	EQ				0	0
16	JHAGA	MANDT	JR	EQ			AND	0	0
17	JHAISZ	AVM_NR	JL	EQ				0	0
18	JHAGA	AVM_NR	JR	EQ			AND	0	0
19	JHAISZ	POS_NR	JL	EQ				0	0
20	JHAGA	POS_NR	JR	EQ			AND	0	0
21	JHAISZ	INSERENT	JL	EQ				0	0
22	JHAGA	INSERENT	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	JHAK	MANDT		☐	MANDT	☐	Client
2	AVM_NR	JHAK	AVM_NR		☐	AVM_NR	☐	IS-M/AM: Sales Document Number
3	POS_NR	JHAP	POS_NR		☐	POS_NR	☐	IS-M: Order Item Number
4	GRUPPABRNR	JHAGA	GRUPPABRNR		☐	GRUPPABRNR	☐	IS-M/AM: Billing Dataset
5	BELEGEINH	JHAGA	BELEGEINH		☐	BE_BASIS	☐	IS-M: Basic Booking Unit
6	UR_BELEINH	JHAGA	UR_BELEINH		☐	UR_BELEINH	☐	IS-M: Initial Booking Unit for the OPM Item
7	INSERENT	JHAGA	INSERENT		☐	INSERENT	☐	IS-M: Advertiser
8	AB_BRUTTO	JHAGA	AB_BRUTTO		☐	AB_BRUTTO	☐	IS-M: Contract Gross
9	AB_BR_WAEH	JHAGA	AB_BR_WAEH		☐	AB_BR_WAEH	☐	IS-M: Gross Contract Currency
10	WAERG	JHAGA	WAERG		☐	WAERK	☐	SD document currency
11	FAKSPP	JHAGA	FAKSPP		☐	PAM_FAKSP	☐	IS-M: Billing Block
12	FAKDATUM	JHAGA	FAKDATUM		☐	JHFKTER	☐	IS-M: Planned Billing/Settlement Date
13	XAB_AUS	JHAGA	XAB_AUS		☐	XAB_AUS	☐	IS-M: Contract Exclusion Requirement Applies Yes/No
14	BER_TERMIN	JHAGA	BER_TERMIN		☐	BER_TERMIN	☐	IS-M: Date Services were Created for Settlement Purposes
15	SEITE_FSP	JHAGA	SEITE_FSP		☐	SEITE_FSP	☐	IS-M: Page/column format
16	SEITE_FORM	JHAGA	SEITE_FORM		☐	SEITE_FORM	☐	IS-M: Page Format
17	AZART_AREA	JHAGA	AZART_AREA		☐	AZART_AREA	☐	IS-M/AM: Fixed Format Proposal /Ad Dimensions
18	BREITE	JHAGA	BREITE		☐	BREITE_VER	☐	IS-M: Ad Spec Width for Settlement
19	BREITE_EH	JHAGA	BREITE_EH		☐	BREITE_SEH	☐	IS-M/AM: Unit of Measure for Width
20	HOEHE	JHAGA	HOEHE		☐	HOEHE_VER	☐	IS-M: Clearable Height for Ad Spec
21	HOEHE_EH	JHAGA	HOEHE_EH		☐	ISPEINH_H	☐	IS-M: Unit of Measure for Height
22	AZART_GEST	JHAGA	AZART_GEST		☐	AZART_GEST	☐	IS-M: Design Ad Type
23	AZART_FORM	JHAGA	AZART_FORM		☐	AZART_FORM	☐	IS-M: Shape Ad Type
24	AZART_FARB	JHAGA	AZART_FARB		☐	AZART_FARB	☐	IS-M: Color Scheme Ad Type
25	XFAKT_EE	JHAGA	XFAKT_EE		☐	XFAKT_EE	☐	IS-M: Billed Indicator
26	XABS_EE	JHAGA	XABS_EE		☐	XABS_EE	☐	IS-M: Contract Final Settlement Performed
27	XSTORNIERT	JHAGA	XSTORNIERT		☐	XSTORNIERT	☐	IS-M: Canceled Order Object Indicator
28	SI_TYP	JHAGA	SI_TYP		☐	SITYP	☐	IS-M: Ad Insert Type
29	DISPMENGE	JHAGA	DISPMENGE		☐	DISPMENGE	☐	IS-M: Planning Quantity of Carrying Issue
30	BLGMENGE	JHAGA	BLGMENGE		☐	BLGMENGE	☐	IS-M: Order Quantity for Insertion
31	BERMENGE	JHAGA	BERMENGE		☐	BERMENGE	☐	IS-M: Calculation Quantity (Ad Insert)
32	SI_SEITEN	JHAGA	SI_SEITEN		☐	ANZSEITEN	☐	Number of Pages in Issue
33	PSTYV	JHAGA	PSTYV		☐	PSTYV_PAM	☐	IS-M: Item Category for Sales Document
34	XABSCHLREL	TJHAP	XABSCHLREL		☐	XABSCHLREL	☐	IS-M: Contract Relevance
35	XFORTSCHR	TJHAP	XFORTSCHR		☐	XFORTSCHR	☐	IS-M: Relevant for Contract Update Indicator
36	XGE_GESCH	TJHAP	XGE_GESCH		☐	XGE_GESCH	☐	IS-M: Barter Deal Indicator
37	XMENGE_N	TJHAP	XMENGE_N		☐	XMENGE_N	☐	IS-M/AM: Quantity Sign for Contract Update
38	XBETRG_N	TJHAP	XBETRG_N		☐	XBETRG_N	☐	IS-M: Value amount negatively indicator
39	XMAL_N	TJHAP	XMAL_N		☐	XMAL_N	☐	IS-M: Number Leading Sign for Contract Update
40	POS_ART	JHAP	POS_ART		☐	AVMPOS_ART	☐	IS-M: Order-Publishing-Media - Item Type
41	XAGENAUFTR	JHAP	XAGENAUFTR		☐	XAGENAUFTR	☐	IS-M: Agency order indicator
42	GPAG	JHAK	GPAG		☐	GPAG	☐	Business Partner: Sold-to Party
43	VKORG	JHAK	VKORG		☐	VKORG	☐	Sales Organization
44	VTWEG	JHAK	VTWEG		☐	VTWEG	☐	Distribution Channel
45	SPART	JHAK	SPART		☐	SPART	☐	Division
46	VKGRP	JHAK	VKGRP		☐	VKGRP	☐	Sales group
47	VKBUR	JHAK	VKBUR		☐	VKBUR	☐	Sales office
48	IS_PROZENT	JHAISZ	INS_PROZ		☐	PAM_PROZ	☐	IS-M: Percentage Figure for Cost Distribution
49	AZGR_INS	JHAISZ	AZGR_INS		☐	AZGR_INS	☐	Column MM of the Ad Which the Advertiser is Involved In
50	KAMPAGNE	JHAP	KAMPAGNE		☐	KAMPAGNE	☐	IS-M: Campaign (customer)
51	ZUS_MENGE	JHAGA	ZUS_MENGE		☐	BER_MENGE	☐	IS-M: Number of Additional Ad Spec Calculation Units
52	ZUS_BERECH	JHAGA	ZUS_BERECH		☐	MEINH_ZUS	☐	IS-M: Additional Unit of Measure for Settlement
53	XUNITERROR	JHAGA	XUNITERROR		☐	XUNITERROR	☐	IS-M: Quantity Conversion Error Indicator
54	XRESERV	JHAP	XRESERV		☐	XRESERV	☐	IS-M: Reservation indicator
55	AVM_HRKNFT	JHAK	AVM_HRKNFT		☐	AVM_HRKNFT	☐	IS-M/AM: Order Origin
56	KONDA	JHAGA	KONDA		☐	KONDA	☐	Price Group (Customer)
57	ACT_ABSCHL	JHAGA	ACT_ABSCHL		☐	ABS_VTNR	☐	IS-M: Contract Number
58	ABSCHL_NR	JHAGA	ABSCHL_NR		☐	ABS_VTNR	☐	IS-M: Contract Number
59	ABSCHL_POS	JHAGA	ABSCHL_POS		☐	ABS_POSNR	☐	IS-M: Contract, Item Number
60	XRABATT	JHAGA	XRABATT		☐	XRABATT	☐	IS-M: Assignment Qualifies for Discount
61	XMITZRAB	JHAGA	XMITZRAB		☐	XMITZRAB	☐	IS-M: Assignment Counts Towards Discount Fulfillment
62	XBONUS	JHAGA	XBONUS		☐	XBONUS	☐	IS-M: Assignment Qualifies for Bonus
63	XMITZBON	JHAGA	XMITZBON		☐	XMITZBON	☐	IS-M: Assignment Counts Towards Bonus Fulfillment
64	XMANUELL	JHAGA	XMANUELL		☐	XMANUELL1	☐	IS-M: Contract Assignments Changed Manually Indicator
65	AB_RABATT	JHAGA	AB_RABATT		☐	AB_RABATT	☐	IS-M: Current Valid Contract Discount Rate
66	AB_PREIS	JHAGA	AB_PREIS		☐	AB_PREIS	☐	IS-M: Current Valid Price from Contract
67	AKTBONUS	JHAGA	AKTBONUS		☐	AKTBONUS	☐	IS-M/AM: Current Valid Contract Bonus
68	ACT_ABSCH2	JHAGA	ACT_ABSCH2		☐	ABS_VTNR	☐	IS-M: Contract Number
69	ABSCHL_NR2	JHAGA	ABSCHL_NR2		☐	ABS_VTNR	☐	IS-M: Contract Number
70	ABSCHL_PO2	JHAGA	ABSCHL_PO2		☐	ABS_POSNR	☐	IS-M: Contract, Item Number
71	XRABATT2	JHAGA	XRABATT2		☐	XRABATT	☐	IS-M: Assignment Qualifies for Discount
72	XMITZRAB2	JHAGA	XMITZRAB2		☐	XMITZRAB	☐	IS-M: Assignment Counts Towards Discount Fulfillment
73	XBONUS2	JHAGA	XBONUS2		☐	XBONUS	☐	IS-M: Assignment Qualifies for Bonus
74	XMITZBON2	JHAGA	XMITZBON2		☐	XMITZBON	☐	IS-M: Assignment Counts Towards Bonus Fulfillment
75	XMANUELL2	JHAGA	XMANUELL2		☐	XMANUELL	☐	IS-M: Manual post-editing has taken place
76	AB_RABATT2	JHAGA	AB_RABATT2		☐	AB_RABATT	☐	IS-M: Current Valid Contract Discount Rate
77	AB_PREIS2	JHAGA	AB_PREIS2		☐	AB_PREIS	☐	IS-M: Current Valid Price from Contract
78	AKTBONUS2	JHAGA	AKTBONUS2		☐	AKTBONUS	☐	IS-M/AM: Current Valid Contract Bonus
79	ACT_ABSCH3	JHAGA	ACT_ABSCH3		☐	ABS_VTNR	☐	IS-M: Contract Number
80	ABSCHL_NR3	JHAGA	ABSCHL_NR3		☐	ABS_VTNR	☐	IS-M: Contract Number
81	ABSCHL_PO3	JHAGA	ABSCHL_PO3		☐	ABS_POSNR	☐	IS-M: Contract, Item Number
82	XRABATT3	JHAGA	XRABATT3		☐	XRABATT	☐	IS-M: Assignment Qualifies for Discount
83	XMITZRAB3	JHAGA	XMITZRAB3		☐	XMITZRAB	☐	IS-M: Assignment Counts Towards Discount Fulfillment
84	XBONUS3	JHAGA	XBONUS3		☐	XBONUS	☐	IS-M: Assignment Qualifies for Bonus
85	XMITZBON3	JHAGA	XMITZBON3		☐	XMITZBON	☐	IS-M: Assignment Counts Towards Bonus Fulfillment
86	XMANUELL3	JHAGA	XMANUELL3		☐	XMANUELL	☐	IS-M: Manual post-editing has taken place
87	AB_RABATT3	JHAGA	AB_RABATT3		☐	AB_RABATT	☐	IS-M: Current Valid Contract Discount Rate
88	AB_PREIS3	JHAGA	AB_PREIS3		☐	AB_PREIS	☐	IS-M: Current Valid Price from Contract
89	AKTBONUS3	JHAGA	AKTBONUS3		☐	AKTBONUS	☐	IS-M/AM: Current Valid Contract Bonus
90	MGLME	JHAGA	MGLME		☐	MENGE_D	☐	Quantity
91	LAGME	JHAGA	LAGME		☐	LAGME	☐	Base Unit of Measure

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