SAP ABAP Table JHVGAV (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JHVGAV	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	INSERENT	☐	INSERENT	GPNR	CHAR	10	0	IS-M: Advertiser	JHAISZ
6	XFAKT_EE	☐	XFAKT_EE	XFELD	CHAR	1	0	IS-M: Billed Indicator
7	WAERG	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
8	BER_TERMIN	☐	BER_TERMIN	DATUM	DATS	8	0	IS-M: Date Services were Created for Settlement Purposes
9	AZART_AREA	☐	AZART_AREA	AZART_AREA	CHAR	4	0	IS-M/AM: Fixed Format Proposal /Ad Dimensions	TJJ13
10	AZART_FARB	☐	AZART_FARB	AZART_FARB	CHAR	4	0	IS-M: Color Scheme Ad Type	TJJ11
11	AZART_FORM	☐	AZART_FORM	AZART_FORM	CHAR	4	0	IS-M: Shape Ad Type	TJJ17
12	AZART_GEST	☐	AZART_GEST	AZART_GEST	CHAR	4	0	IS-M: Design Ad Type	TJJ19
13	BREITE	☐	BREITE_VER	GROESSE	QUAN	7	3	IS-M: Ad Spec Width for Settlement
14	BREITE_EH	☐	BREITE_SEH	ISPEINHEIT	UNIT	3	0	IS-M/AM: Unit of Measure for Width	TJH57
15	HOEHE	☐	HOEHE_VER	GROESSE	QUAN	7	3	IS-M: Clearable Height for Ad Spec
16	HOEHE_EH	☐	ISPEINH_H	ISPEINH_H	UNIT	3	0	IS-M: Unit of Measure for Height	TJH61
17	ZUS_MENGE	☐	BER_MENGE	GROESSE	QUAN	7	3	IS-M: Number of Additional Ad Spec Calculation Units
18	ZUS_BERECH	☐	MEINH_ZUS	ISPEINHEIT	UNIT	3	0	IS-M: Additional Unit of Measure for Settlement	TJH57
19	MGLME	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
20	LAGME	☐	LAGME	MEINS	UNIT	3	0	Base Unit of Measure	T006
21	SI_SEITEN	☐	ANZSEITEN	NUM8	NUMC	8	0	Number of Pages in Issue
22	SEITE_FSP	☐	SEITE_FSP	SEITE_FSP	CHAR	4	0	IS-M: Page/column format	TJJ47
23	SEITE_FORM	☐	SEITE_FORM	SEITE_FORM	CHAR	2	0	IS-M: Page Format	TJJ01
24	BELEGEINH	☐	BE_BASIS	BELEINH	CHAR	10	0	IS-M: Basic Booking Unit	JJTBE
25	UR_BELEINH	☐	UR_BELEINH	BELEINH	CHAR	10	0	IS-M: Initial Booking Unit for the OPM Item	JJTBE
26	ABS_MAL	☐	JHRSMAL	JHRSMAL	DEC	5	0	IS-M: Number for Contract Standing
27	XSTORNIERT	☐	XSTORNIERT	XFELD	CHAR	1	0	IS-M: Canceled Order Object Indicator
28	KALSM	☐	KALSMASD	KALSM	CHAR	6	0	Sales and Distribution: Pricing Procedure in Pricing
29	REF_VBELN	☐	JJBELNR	JJBELNR	CHAR	10	0	IS-M/AM: Billing Document	JHTFK
30	REF_POSNR	☐	JJPOSNR	JJPOSNR	NUMC	6	0	IS-M/AM: Item (number) in settlement document	JHTFP
31	INS_PROZ	☐	PAM_PROZ	JHPROZ33	DEC	6	3	IS-M: Percentage Figure for Cost Distribution
32	AZGR_INS	☐	AZGR_INS	NUMC4	NUMC	4	0	Column MM of the Ad Which the Advertiser is Involved In
33	POS_ART	☐	AVMPOS_ART	AVMPOS_ART	CHAR	2	0	IS-M: Order-Publishing-Media - Item Type	TJH17
34	PSTYV	☐	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	TJHAP
35	XAGENAUFTR	☐	XAGENAUFTR	XFELD	CHAR	1	0	IS-M: Agency order indicator
36	KAMPAGNE	☐	KAMPAGNE	KAMPAGNE	CHAR	6	0	IS-M: Campaign (customer)	TJJKAMP
37	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TJHVBER
38	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TJHVBER
39	SPART	☐	SPART	SPART	CHAR	2	0	Division	TJHVBER
40	GPAG	☐	GPAG	GPNR	CHAR	10	0	Business Partner: Sold-to Party	JGTGPNR
41	AVM_HRKNFT	☐	AVM_HRKNFT	AVM_HRKNFT	CHAR	1	0	IS-M/AM: Order Origin
42	KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
43	VBTYP	☐	ISPVBTYP	ISPVBTYP	CHAR	1	0	IS-M/AM: Sales Document Category
44	XGE_GESCH	☐	XGE_GESCH	XFELD	CHAR	1	0	IS-M: Barter Deal Indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JHVGAV	AVM_NR	JHAK	AVM_NR	KEY	1	CN
2	JHVGAV	AZART_AREA	TJJ13	AZART_AREA		1	CN
3	JHVGAV	AZART_FARB	TJJ11	AZART_FARB	KEY	1	CN
4	JHVGAV	AZART_FORM	TJJ17	AZART_FORM	KEY	1	CN
5	JHVGAV	AZART_GEST	TJJ19	AZART_GEST	KEY	1	CN
6	JHVGAV	BELEGEINH	JJTBE	BELEINH	KEY	1	CN
7	JHVGAV	BREITE_EH	TJH57	ISPEINHEIT	REF	1	CN
8	JHVGAV	GPAG	JGTGPNR	GPNR	KEY	1	CN
9	JHVGAV	HOEHE_EH	TJH61	ISPEINH_H	REF	1	CN
10	JHVGAV	INSERENT	JHAISZ	INSERENT	KEY	1	CN
11	JHVGAV	KAMPAGNE	TJJKAMP	KAMPAGNE	REF	1	CN
12	JHVGAV	LAGME	T006	MSEHI	REF	1	CN
13	JHVGAV	MANDT	T000	MANDT	KEY	1	CN
14	JHVGAV	POS_ART	TJH17	AVMPOS_ART	REF	1	CN
15	JHVGAV	POS_NR	JHAP	POS_NR	KEY	1	CN
16	JHVGAV	PSTYV	TJHAP	PSTYV	REF	1	CN
17	JHVGAV	REF_POSNR	JHTFP	POSNR	REF	1	CN
18	JHVGAV	REF_VBELN	JHTFK	VBELN	REF	1	CN
19	JHVGAV	SEITE_FORM	TJJ01	SEITE_FORM	KEY	1	CN
20	JHVGAV	SEITE_FSP	TJJ47	SEITE_FSP	KEY	1	CN
21	JHVGAV	SPART	TJHVBER	SPART		1	CN
22	JHVGAV	UR_BELEINH	JJTBE	BELEINH	REF	1	CN
23	JHVGAV	VKORG	TJHVBER	VKORG		1	CN
24	JHVGAV	VTWEG	TJHVBER	VTWEG		1	CN
25	JHVGAV	WAERG	TCURC	WAERS		1	CN
26	JHVGAV	ZUS_BERECH	TJH57	ISPEINHEIT	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in