SAP ABAP Table JHVGA (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JHVGA	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	AVM_NR	☑	AVM_NR	AVM_NR	CHAR	10	0	IS-M/AM: Sales Document Number	JHAK
3	POS_NR	☑	POS_NR	AVM_PNR	NUMC	3	0	IS-M: Order Item Number	JHAP
4	GRUPPABRNR	☑	GRUPPABRNR	GRUPPABR	NUMC	3	0	IS-M/AM: Billing Dataset
5	XFAKT_EE	☐	XFAKT_EE	XFELD	CHAR	1	0	IS-M: Billed Indicator
6	XABS_EE	☐	XABS_EE	XFELD	CHAR	1	0	IS-M: Contract Final Settlement Performed
7	XSTORNIERT	☐	XSTORNIERT	XFELD	CHAR	1	0	IS-M: Canceled Order Object Indicator
8	SI_TYP	☐	SITYP	SI_TYP	CHAR	2	0	IS-M: Ad Insert Type	TJH29
9	DISPMENGE	☐	DISPMENGE	STMENGE	DEC	9	0	IS-M: Planning Quantity of Carrying Issue
10	BLGMENGE	☐	BLGMENGE	STMENGE	DEC	9	0	IS-M: Order Quantity for Insertion
11	BERMENGE	☐	BERMENGE	STMENGE	DEC	9	0	IS-M: Calculation Quantity (Ad Insert)
12	SI_SEITEN	☐	ANZSEITEN	NUM8	NUMC	8	0	Number of Pages in Issue
13	PLAZIERUNG	☐	PLAZIERANW	PLAZIERANW	CHAR	2	0	IS-M/AM: Positioning Instruction	TJJ65
14	AZART_PLAZ	☐	AZART_PLAZ	AZART_PLAZ	CHAR	4	0	IS-M: Ad Type with Regard to General Positioning	TJJ15
15	PSTYV	☐	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	TJHAP
16	XABSCHLREL	☐	XABSCHLREL	ISM_ABSCHLREL	CHAR	1	0	IS-M: Contract Relevance
17	XFORTSCHR	☐	XFORTSCHR	XFELD	CHAR	1	0	IS-M: Relevant for Contract Update Indicator
18	XGE_GESCH	☐	XGE_GESCH	XFELD	CHAR	1	0	IS-M: Barter Deal Indicator
19	XMENGE_N	☐	XMENGE_N	XMENGE_N	CHAR	1	0	IS-M/AM: Quantity Sign for Contract Update
20	XBETRG_N	☐	XBETRG_N	XFELD	CHAR	1	0	IS-M: Value amount negatively indicator
21	XMAL_N	☐	XMAL_N	XMAL_N	CHAR	1	0	IS-M: Number Leading Sign for Contract Update
22	ACT_ABSCHL	☐	ABS_VTNR	ABS_VTNR	NUMC	6	0	IS-M: Contract Number	JHTVKO
23	WAERG	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
24	SEITE_FSP	☐	SEITE_FSP	SEITE_FSP	CHAR	4	0	IS-M: Page/column format	TJJ47
25	SEITE_FORM	☐	SEITE_FORM	SEITE_FORM	CHAR	2	0	IS-M: Page Format	TJJ01
26	BREITE	☐	BREITE_VER	GROESSE	QUAN	7	3	IS-M: Ad Spec Width for Settlement
27	BREITE_EH	☐	BREITE_SEH	ISPEINHEIT	UNIT	3	0	IS-M/AM: Unit of Measure for Width	TJH57
28	HOEHE	☐	HOEHE_VER	GROESSE	QUAN	7	3	IS-M: Clearable Height for Ad Spec
29	HOEHE_EH	☐	ISPEINH_H	ISPEINH_H	UNIT	3	0	IS-M: Unit of Measure for Height	TJH61
30	XAB_AUS	☐	XAB_AUS	XFELD	CHAR	1	0	IS-M: Contract Exclusion Requirement Applies Yes/No
31	BER_TERMIN	☐	BER_TERMIN	DATUM	DATS	8	0	IS-M: Date Services were Created for Settlement Purposes
32	FAKSPP	☐	PAM_FAKSP	FAKSP	CHAR	2	0	IS-M: Billing Block	TVFS
33	FAKDATUM	☐	JHFKTER	DATUM	DATS	8	0	IS-M: Planned Billing/Settlement Date
34	AB_BRUTTO	☐	AB_BRUTTO	WERTV8	CURR	15	2	IS-M: Contract Gross
35	AB_BR_WAEH	☐	AB_BR_WAEH	WAERS	CUKY	5	0	IS-M: Gross Contract Currency	TCURC
36	BELEGEINH	☐	BE_BASIS	BELEINH	CHAR	10	0	IS-M: Basic Booking Unit	JJTBE
37	UR_BELEINH	☐	UR_BELEINH	BELEINH	CHAR	10	0	IS-M: Initial Booking Unit for the OPM Item	JJTBE
38	INSERENT	☐	INSERENT	GPNR	CHAR	10	0	IS-M: Advertiser	JHAISZ
39	AZART_GEST	☐	AZART_GEST	AZART_GEST	CHAR	4	0	IS-M: Design Ad Type	TJJ19
40	AZART_FORM	☐	AZART_FORM	AZART_FORM	CHAR	4	0	IS-M: Shape Ad Type	TJJ17
41	AZART_FARB	☐	AZART_FARB	AZART_FARB	CHAR	4	0	IS-M: Color Scheme Ad Type	TJJ11
42	AZART_SOND	☐	AZART_SOND	AZART_SOND	CHAR	2	0	IS-M: Ad Type - Special Handling Type	TJJ49
43	INHK_TECH1	☐	INHK_TECH1	INHALTSKOM	CHAR	8	0	IS-M: Technical Content Component (Positioning View)	JJTIKO
44	INHK_TECH2	☐	INHK_SOVER	INHALTSKOM	CHAR	8	0	IS-M: Special Publication Content Component	JJTIKO
45	INHK_KFM	☐	INHK_KFM	INHALTSKOM	CHAR	8	0	IS-M: Business Content Component	JJTIKO
46	PRODH	☐	J_PRODH	J_PRODH	CHAR	18	0	IS-M/AM: Product Hierarchy	JJT179
47	POS_ART	☐	AVMPOS_ART	AVMPOS_ART	CHAR	2	0	IS-M: Order-Publishing-Media - Item Type	TJH17
48	XAGENAUFTR	☐	XAGENAUFTR	XFELD	CHAR	1	0	IS-M: Agency order indicator
49	AZART_AREA	☐	AZART_AREA	AZART_AREA	CHAR	4	0	IS-M/AM: Fixed Format Proposal /Ad Dimensions	TJJ13
50	IS_PROZENT	☐	PAM_PROZ	JHPROZ33	DEC	6	3	IS-M: Percentage Figure for Cost Distribution
51	AZGR_INS	☐	AZGR_INS	NUMC4	NUMC	4	0	Column MM of the Ad Which the Advertiser is Involved In
52	KAMPAGNE	☐	KAMPAGNE	KAMPAGNE	CHAR	6	0	IS-M: Campaign (customer)	TJJKAMP
53	ZUS_MENGE	☐	BER_MENGE	GROESSE	QUAN	7	3	IS-M: Number of Additional Ad Spec Calculation Units
54	ZUS_BERECH	☐	MEINH_ZUS	ISPEINHEIT	UNIT	3	0	IS-M: Additional Unit of Measure for Settlement	TJH57
55	XUNITERROR	☐	XUNITERROR	XFELD	CHAR	1	0	IS-M: Quantity Conversion Error Indicator
56	XRESERV	☐	XRESERV	XFELD	CHAR	1	0	IS-M: Reservation indicator
57	KONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	T188
58	ABS_MAL	☐	JHRSMAL	JHRSMAL	DEC	5	0	IS-M: Number for Contract Standing
59	GPAG	☐	GPAG	GPNR	CHAR	10	0	Business Partner: Sold-to Party	JGTGPNR
60	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TJHVBER
61	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TJHVBER
62	SPART	☐	SPART	SPART	CHAR	2	0	Division	TJHVBER
63	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
64	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVKBZ
65	AVM_HRKNFT	☐	AVM_HRKNFT	AVM_HRKNFT	CHAR	1	0	IS-M/AM: Order Origin
66	ABSCHL_NR	☐	ABS_VTNR	ABS_VTNR	NUMC	6	0	IS-M: Contract Number	JHTVABRUF
67	ABSCHL_POS	☐	ABS_POSNR	ABS_POSNR	NUMC	4	0	IS-M: Contract, Item Number	JHTVABRUF
68	XRABATT	☐	XRABATT	XFELD	CHAR	1	0	IS-M: Assignment Qualifies for Discount
69	XMITZRAB	☐	XMITZRAB	XFELD	CHAR	1	0	IS-M: Assignment Counts Towards Discount Fulfillment
70	XBONUS	☐	XBONUS	XFELD	CHAR	1	0	IS-M: Assignment Qualifies for Bonus
71	XMITZBON	☐	XMITZBON	XFELD	CHAR	1	0	IS-M: Assignment Counts Towards Bonus Fulfillment
72	XMANUELL	☐	XMANUELL1	XFELD	CHAR	1	0	IS-M: Contract Assignments Changed Manually Indicator
73	AB_RABATT	☐	AB_RABATT	RABATT	DEC	5	2	IS-M: Current Valid Contract Discount Rate
74	AB_PREIS	☐	AB_PREIS	WERTV8	CURR	15	2	IS-M: Current Valid Price from Contract
75	AKTBONUS	☐	AKTBONUS	RABATT	DEC	5	2	IS-M/AM: Current Valid Contract Bonus
76	ACT_ABSCH2	☐	ABS_VTNR	ABS_VTNR	NUMC	6	0	IS-M: Contract Number	JHTVKO
77	ABSCHL_NR2	☐	ABS_VTNR	ABS_VTNR	NUMC	6	0	IS-M: Contract Number	JHTVABRUF
78	ABSCHL_PO2	☐	ABS_POSNR	ABS_POSNR	NUMC	4	0	IS-M: Contract, Item Number	JHTVABRUF
79	XRABATT2	☐	XRABATT	XFELD	CHAR	1	0	IS-M: Assignment Qualifies for Discount
80	XMITZRAB2	☐	XMITZRAB	XFELD	CHAR	1	0	IS-M: Assignment Counts Towards Discount Fulfillment
81	XBONUS2	☐	XBONUS	XFELD	CHAR	1	0	IS-M: Assignment Qualifies for Bonus
82	XMITZBON2	☐	XMITZBON	XFELD	CHAR	1	0	IS-M: Assignment Counts Towards Bonus Fulfillment
83	XMANUELL2	☐	XMANUELL	XFELD	CHAR	1	0	IS-M: Manual post-editing has taken place
84	AB_RABATT2	☐	AB_RABATT	RABATT	DEC	5	2	IS-M: Current Valid Contract Discount Rate
85	AB_PREIS2	☐	AB_PREIS	WERTV8	CURR	15	2	IS-M: Current Valid Price from Contract
86	AKTBONUS2	☐	AKTBONUS	RABATT	DEC	5	2	IS-M/AM: Current Valid Contract Bonus
87	ACT_ABSCH3	☐	ABS_VTNR	ABS_VTNR	NUMC	6	0	IS-M: Contract Number	JHTVKO
88	ABSCHL_NR3	☐	ABS_VTNR	ABS_VTNR	NUMC	6	0	IS-M: Contract Number	JHTVABRUF
89	ABSCHL_PO3	☐	ABS_POSNR	ABS_POSNR	NUMC	4	0	IS-M: Contract, Item Number	JHTVABRUF
90	XRABATT3	☐	XRABATT	XFELD	CHAR	1	0	IS-M: Assignment Qualifies for Discount
91	XMITZRAB3	☐	XMITZRAB	XFELD	CHAR	1	0	IS-M: Assignment Counts Towards Discount Fulfillment
92	XBONUS3	☐	XBONUS	XFELD	CHAR	1	0	IS-M: Assignment Qualifies for Bonus
93	XMITZBON3	☐	XMITZBON	XFELD	CHAR	1	0	IS-M: Assignment Counts Towards Bonus Fulfillment
94	XMANUELL3	☐	XMANUELL	XFELD	CHAR	1	0	IS-M: Manual post-editing has taken place
95	AB_RABATT3	☐	AB_RABATT	RABATT	DEC	5	2	IS-M: Current Valid Contract Discount Rate
96	AB_PREIS3	☐	AB_PREIS	WERTV8	CURR	15	2	IS-M: Current Valid Price from Contract
97	AKTBONUS3	☐	AKTBONUS	RABATT	DEC	5	2	IS-M/AM: Current Valid Contract Bonus
98	MGLME	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
99	LAGME	☐	LAGME	MEINS	UNIT	3	0	Base Unit of Measure	T006

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JHVGA	ABSCHL_NR	JHTVABRUF	VTNR	REF	C	CN
2	JHVGA	ABSCHL_NR2	JHTVABRUF	VTNR	REF	C	CN
3	JHVGA	ABSCHL_NR3	JHTVABRUF	VTNR	REF	C	CN
4	JHVGA	ABSCHL_PO2	JHTVABRUF	POSNR	REF	C	CN
5	JHVGA	ABSCHL_PO3	JHTVABRUF	POSNR	REF	C	CN
6	JHVGA	ABSCHL_POS	JHTVABRUF	POSNR	REF	C	CN
7	JHVGA	AB_BR_WAEH	TCURC	WAERS		1	CN
8	JHVGA	ACT_ABSCH2	JHTVKO	VTNR	REF	C	CN
9	JHVGA	ACT_ABSCH3	JHTVKO	VTNR	REF	C	CN
10	JHVGA	ACT_ABSCHL	JHTVKO	VTNR	REF	C	CN
11	JHVGA	AVM_NR	JHAK	AVM_NR	KEY	1	CN
12	JHVGA	AZART_AREA	TJJ13	AZART_AREA		1	CN
13	JHVGA	AZART_FARB	TJJ11	AZART_FARB	KEY	1	CN
14	JHVGA	AZART_FORM	TJJ17	AZART_FORM	KEY	1	CN
15	JHVGA	AZART_GEST	TJJ19	AZART_GEST	KEY	1	CN
16	JHVGA	AZART_PLAZ	TJJ15	AZART_PLAZ		1	CN
17	JHVGA	AZART_SOND	TJJ49	AZART_SOND	REF	1	CN
18	JHVGA	BELEGEINH	JJTBE	BELEINH	KEY	1	CN
19	JHVGA	BREITE_EH	TJH57	ISPEINHEIT	REF	1	CN
20	JHVGA	FAKSPP	TVFS	FAKSP
21	JHVGA	GPAG	JGTGPNR	GPNR	KEY	1	CN
22	JHVGA	HOEHE_EH	TJH61	ISPEINH_H	REF	1	CN
23	JHVGA	INHK_KFM	JJTIKO	INHALTSKOM	REF	1	CN
24	JHVGA	INHK_TECH1	JJTIKO	INHALTSKOM	REF	1	CN
25	JHVGA	INHK_TECH2	JJTIKO	INHALTSKOM	REF	1	CN
26	JHVGA	INSERENT	JHAISZ	INSERENT	KEY	1	CN
27	JHVGA	KAMPAGNE	TJJKAMP	KAMPAGNE	REF	1	CN
28	JHVGA	KONDA	T188	KONDA
29	JHVGA	LAGME	T006	MSEHI	REF	1	CN
30	JHVGA	MANDT	T000	MANDT	KEY	1	CN
31	JHVGA	PLAZIERUNG	TJJ65	PLAZIERANW	REF	1	CN
32	JHVGA	POS_ART	TJH17	AVMPOS_ART	REF	1	CN
33	JHVGA	POS_NR	JHAP	POS_NR	KEY	1	CN
34	JHVGA	PRODH	JJT179	PRODH	REF	1	CN
35	JHVGA	PSTYV	TJHAP	PSTYV	KEY	1	CN
36	JHVGA	SEITE_FORM	TJJ01	SEITE_FORM	KEY	1	CN
37	JHVGA	SEITE_FSP	TJJ47	SEITE_FSP	KEY	1	CN
38	JHVGA	SI_TYP	TJH29	SI_TYP	REF	1	CN
39	JHVGA	SPART	TJHVBER	SPART		1	CN
40	JHVGA	UR_BELEINH	JJTBE	BELEINH	REF	1	CN
41	JHVGA	VKBUR	TVKBZ	VKBUR		C	CN
42	JHVGA	VKGRP	TVBVK	VKGRP		C	CN
43	JHVGA	VKORG	TJHVBER	VKORG		1	CN
44	JHVGA	VTWEG	TJHVBER	VTWEG		1	CN
45	JHVGA	WAERG	TCURC	WAERS		1	CN
46	JHVGA	ZUS_BERECH	TJH57	ISPEINHEIT	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in