SAP ABAP Table JHVAEG1 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JHVAEG1	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	AVM_HRKNFT	☑	AVM_HRKNFT	AVM_HRKNFT	CHAR	1	0	IS-M/AM: Order Origin
4	POS_NR	☑	POS_NR	AVM_PNR	NUMC	3	0	IS-M: Order Item Number	JHAP
5	INSERENT	☑	INSERENT	GPNR	CHAR	10	0	IS-M: Advertiser	JJVDB_MK_FK
6	BELEGEINH	☑	BELEGEINH	BELEINH	CHAR	10	0	IS-M/AM: Booking Unit	JJTBE
7	TERMINSPEZ	☑	TERMINSPEZ	TERMINSPEZ	CHAR	6	0	IS-M/AM: Specify Dates for Date Combinations	JJTBEZK
8	GPAG	☐	GPAG	GPNR	CHAR	10	0	Business Partner: Sold-to Party	JGTGPNR
9	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TJHVBER
10	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TJHVBER
11	SPART	☐	SPART	SPART	CHAR	2	0	Division	TJHVBER
12	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
13	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVKBZ
14	AUART	☐	AUART_PAM	AUART_PAM	CHAR	4	0	IS-M: Sales Document Type	TJHAK
15	POS_ART	☐	AVMPOS_ART	AVMPOS_ART	CHAR	2	0	IS-M: Order-Publishing-Media - Item Type	TJH17
16	PSTYV	☐	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	TJHAP
17	XAGENAUFTR	☐	XAGENAUFTR	XFELD	CHAR	1	0	IS-M: Agency order indicator
18	BRAN_PAM	☐	BRAN_POS	BRACO	CHAR	10	0	IS-M/AM: Current Industry Sector Associated With Order Item	TBRC
19	STATUS_P	☐	STATUSK	PAM_STATUS	CHAR	2	0	IS-M: Status
20	SELDAT_VON	☐	SELDAT_VON	DATUM	DATS	8	0	IS-M: Start Date for Item
21	SELDAT_BIS	☐	SELDAT_BIS	DATUM	DATS	8	0	IS-M: End Date for Items
22	INHK_TECH1	☐	INHK_TECH1	INHALTSKOM	CHAR	8	0	IS-M: Technical Content Component (Positioning View)	JJTIKO
23	INHK_TECH2	☐	INHK_SOVER	INHALTSKOM	CHAR	8	0	IS-M: Special Publication Content Component	JJTIKO
24	INHK_KFM	☐	INHK_KFM	INHALTSKOM	CHAR	8	0	IS-M: Business Content Component	JJTIKO
25	TEC_AVM_NR	☐	TEC_AVM_NR	CHAR10	CHAR	10	0	IS-M: Order number in technical system
26	ANFANG_PER	☐	ANFANG_PER	PAM_PERIOD	CHAR	14	0	IS-M: Start of Copy/Publication Date Period
27	ENDE_PER	☐	ENDE_PER	PAM_PERIOD	CHAR	14	0	IS-M: End of Period - Issue/Publication Date
28	TERMINART	☐	TERMINART	TERMINART	CHAR	1	0	IS-M/AM: Type of Publication Date
29	TERM_TYP	☐	TERMINTYP	TERMINTYP	CHAR	1	0	IS-M/AM: Date Category Copy Number/Publication Date	TJH55
30	TERM_ZYKL	☐	ANZ_ZYKLUS	ANZ_ZYKLUS	CHAR	4	0	IS-M: Frequency for Ad Publication	TJJ57
31	WUNSCH_T	☐	WUNSCH_T	DATUM	DATS	8	0	IS-M/AM: Date Required
32	X_MONTAG	☐	JHT_MONTAG	XFELD	CHAR	1	0	IS-M: Date Field Indicator - Monday
33	X_DIENSTAG	☐	JHT_DIENSTAG	XFELD	CHAR	1	0	IS-M: Date Field Indicator - Tuesday
34	X_MITTWOCH	☐	JHT_MITTWOCH	XFELD	CHAR	1	0	IS-M: Date Field Indicator - Wednesday
35	X_DONNERST	☐	JHT_DONNERST	XFELD	CHAR	1	0	IS-M: Date Field Indicator - Thursday
36	X_FREITAG	☐	JHT_FREITAG	XFELD	CHAR	1	0	IS-M: Date Field Indicator - Friday
37	X_SAMSTAG	☐	JHT_SAMSTAG	XFELD	CHAR	1	0	IS-M: Date Field Indicator - Saturday
38	X_SONNTAG	☐	JHT_SONNTAG	XFELD	CHAR	1	0	IS-M: Date Field Indicator - Sunday

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JHVAEG1	AUART	TJHAK	AUART	KEY	1	CN
2	JHVAEG1	AVM_NR	JHAK	AVM_NR	KEY	1	CN
3	JHVAEG1	BELEGEINH	JJTBE	BELEINH	KEY	1	CN
4	JHVAEG1	BRAN_PAM	TBRC	BRACO	REF	1	CN
5	JHVAEG1	GPAG	JGTGPNR	GPNR	KEY	1	CN
6	JHVAEG1	INHK_KFM	JJTIKO	INHALTSKOM	REF	1	CN
7	JHVAEG1	INHK_TECH1	JJTIKO	INHALTSKOM	REF	1	CN
8	JHVAEG1	INHK_TECH2	JJTIKO	INHALTSKOM	REF	1	CN
9	JHVAEG1	INSERENT	JJVDB_MK_FK	GPNR	KEY	1	CN
10	JHVAEG1	MANDT	T000	MANDT	KEY	1	CN
11	JHVAEG1	POS_ART	TJH17	AVMPOS_ART	REF	1	CN
12	JHVAEG1	POS_NR	JHAP	POS_NR	KEY	1	CN
13	JHVAEG1	PSTYV	TJHAP	PSTYV	REF	1	CN
14	JHVAEG1	SPART	TJHVBER	SPART		1	CN
15	JHVAEG1	TERMINSPEZ	JJTBEZK	TERMINSPEZ	KEY	1	CN
16	JHVAEG1	TERM_TYP	TJH55	TERM_TYP	REF	1	CN
17	JHVAEG1	TERM_ZYKL	TJJ57	RHYTHMUS
18	JHVAEG1	VKBUR	TVKBZ	VKBUR		C	CN
19	JHVAEG1	VKGRP	TVBVK	VKGRP		C	CN
20	JHVAEG1	VKORG	TJHVBER	VKORG		1	CN
21	JHVAEG1	VTWEG	TJHVBER	VTWEG		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in