SAP ABAP Table JHVGA1 (Generated Table for View)

Basic Data

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

History

Last changed by/on	SAP	20130529
SAP Release Created in