SAP ABAP View JHVGA (IS-M/AM: Billing Datasets View (Ads))

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

Table

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

Join Conditions

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