SAP ABAP Table JHVAVMACTGA (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JHVAVMACTGA	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	GPAG	☐	GPAG	GPNR	CHAR	10	0	Business Partner: Sold-to Party	JGTGPNR
6	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TJHVBER
7	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TJHVBER
8	SPART	☐	SPART	SPART	CHAR	2	0	Division	TJHVBER
9	AUART	☐	AUART_PAM	AUART_PAM	CHAR	4	0	IS-M: Sales Document Type	TJHAK
10	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
11	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVKBZ
12	AVM_HRKNFT	☐	AVM_HRKNFT	AVM_HRKNFT	CHAR	1	0	IS-M/AM: Order Origin
13	POS_ART	☐	AVMPOS_ART	AVMPOS_ART	CHAR	2	0	IS-M: Order-Publishing-Media - Item Type	TJH17
14	PSTYV	☐	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	TJHAP
15	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
16	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
17	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
18	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
19	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
20	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
21	BELEGEINH	☐	BE_BASIS	BELEINH	CHAR	10	0	IS-M: Basic Booking Unit	JJTBE
22	UR_BELEINH	☐	UR_BELEINH	BELEINH	CHAR	10	0	IS-M: Initial Booking Unit for the OPM Item	JJTBE
23	IHKOMP	☐	INHK_PRICE	INHALTSKOM	CHAR	8	0	IS-M: Content component from price hierarchy	JJTIKO
24	INSERENT	☐	INSERENT	GPNR	CHAR	10	0	IS-M: Advertiser	JHAISZ
25	BER_TERMIN	☐	BER_TERMIN	DATUM	DATS	8	0	IS-M: Date Services were Created for Settlement Purposes
26	REGULIERER	☐	GPNR_RG	GPNR	CHAR	10	0	IS-M: Payer Business Partner	JGTGPNR
27	GF_STATUS	☐	GF_STATUS	PAM_STATUS	CHAR	2	0	IS-M: Billing Dataset Status
28	KALKS	☐	KALKS	KALKS	CHAR	1	0	Pricing procedure assigned to this customer	TVKD
29	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
30	PLTYP	☐	PLTYP	PLTYP	CHAR	2	0	Price list type	T189
31	PRSDT	☐	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
32	SEITE_FSP	☐	SEITE_FSP	SEITE_FSP	CHAR	4	0	IS-M: Page/column format	TJJ47
33	SEITE_FORM	☐	SEITE_FORM	SEITE_FORM	CHAR	2	0	IS-M: Page Format	TJJ01
34	SFSP_ABR	☐	SFSP_ABR	SEITE_FSP	CHAR	4	0	IS-M: Column Format for Settlement	TJJ47
35	AZART_AREA	☐	AZART_AREA	AZART_AREA	CHAR	4	0	IS-M/AM: Fixed Format Proposal /Ad Dimensions	TJJ13
36	AZART_GEST	☐	AZART_GEST	AZART_GEST	CHAR	4	0	IS-M: Design Ad Type	TJJ19
37	AZART_FORM	☐	AZART_FORM	AZART_FORM	CHAR	4	0	IS-M: Shape Ad Type	TJJ17
38	AZART_FARB	☐	AZART_FARB	AZART_FARB	CHAR	4	0	IS-M: Color Scheme Ad Type	TJJ11
39	AZART_SOND	☐	AZART_SOND	AZART_SOND	CHAR	2	0	IS-M: Ad Type - Special Handling Type	TJJ49
40	KALSM	☐	KALSMASD	KALSM	CHAR	6	0	Sales and Distribution: Pricing Procedure in Pricing
41	DRERZ	☐	DRERZ	DRERZ	CHAR	8	0	Publication	JDTDRER
42	PVA	☐	PVA	PVA	CHAR	8	0	Edition	JDTPVA
43	SI_TYP	☐	SITYP	SI_TYP	CHAR	2	0	IS-M: Ad Insert Type	TJH29
44	SI_GEWKL	☐	ISM_SI_GEWKL	SI_GEWKL	CHAR	4	0	IS-M: Ad inserts weight price group	TJHGEWKL
45	SI_SEKL	☐	ISM_SI_SEKL	SI_SEKL	CHAR	4	0	IS-M: Price Group for Ad Insert Pages	TJHSEKL
46	WS_TIMESLC	☐	WS_TIMESLC	WS_TIMESLC	CHAR	2	0	IS-M: Commercial Time Slice	TJJW1
47	WS_BLOCK	☐	WS_BLOCK	WS_BLOCK	CHAR	2	0	IS-M: Commercial Cluster	TJJW3
48	WS_STELLE	☐	WS_STELLE	NUMC3	NUMC	3	0	IS-M: Position (Sequence) Within a Commercial Cluster
49	FORMAT_ONL	☐	FORMAT_ONL	FORMAT_ONL	CHAR	4	0	IS-M/AM: Format Proposal (Online)
50	RRREL	☐	ISMRR_RELTYP	ISMRR_RELTYP	CHAR	1	0	IS-M/AM: Revenue Recognition Category
51	XUVVZ	☐	XUVVZ	XFELD	CHAR	1	0	IS-M: Sales Agent Assignment Incomplete
52	XSTORNIERT	☐	XSTORNIERT	XFELD	CHAR	1	0	IS-M: Canceled Order Object Indicator
53	XFAKT_EE	☐	XFAKT_EE	XFELD	CHAR	1	0	IS-M: Billed Indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JHVAVMACTGA	AUART	TJHAK	AUART	KEY	1	CN
2	JHVAVMACTGA	AZART_AREA	TJJ13	AZART_AREA		1	CN
3	JHVAVMACTGA	AZART_FARB	TJJ11	AZART_FARB	KEY	1	CN
4	JHVAVMACTGA	AZART_FORM	TJJ17	AZART_FORM	KEY	1	CN
5	JHVAVMACTGA	AZART_GEST	TJJ19	AZART_GEST	KEY	1	CN
6	JHVAVMACTGA	AZART_SOND	TJJ49	AZART_SOND	REF	1	CN
7	JHVAVMACTGA	BELEGEINH	JJTBE	BELEINH	KEY	1	CN
8	JHVAVMACTGA	DRERZ	JDTDRER	DRERZ	REF	1	CN
9	JHVAVMACTGA	GPAG	JGTGPNR	GPNR	KEY	1	CN
10	JHVAVMACTGA	IHKOMP	JJTIKO	INHALTSKOM	REF	1	CN
11	JHVAVMACTGA	INSERENT	JHAISZ	INSERENT	KEY	1	CN
12	JHVAVMACTGA	KALKS	TVKD	KALKS
13	JHVAVMACTGA	KDGRP	T151	KDGRP	REF	1	CN
14	JHVAVMACTGA	MANDT	T000	MANDT	KEY	1	CN
15	JHVAVMACTGA	PLTYP	T189	PLTYP	REF	1	CN
16	JHVAVMACTGA	POS_ART	TJH17	AVMPOS_ART	REF	1	CN
17	JHVAVMACTGA	PSTYV	TJHAP	PSTYV	REF	1	CN
18	JHVAVMACTGA	PVA	JDTPVA	PVA	REF	1	CN
19	JHVAVMACTGA	REGULIERER	JGTGPNR	GPNR	REF	1	CN
20	JHVAVMACTGA	SEITE_FORM	TJJ01	SEITE_FORM	KEY	1	CN
21	JHVAVMACTGA	SEITE_FSP	TJJ47	SEITE_FSP	KEY	1	CN
22	JHVAVMACTGA	SFSP_ABR	TJJ47	SEITE_FSP	REF	1	CN
23	JHVAVMACTGA	SI_GEWKL	TJHGEWKL	SI_GEWKL	REF	1	CN
24	JHVAVMACTGA	SI_SEKL	TJHSEKL	SI_SEKL	REF	1	CN
25	JHVAVMACTGA	SI_TYP	TJH29	SI_TYP	REF	1	CN
26	JHVAVMACTGA	SPART	TJHVBER	SPART		1	CN
27	JHVAVMACTGA	UR_BELEINH	JJTBE	BELEINH	REF	1	CN
28	JHVAVMACTGA	VKBUR	TVKBZ	VKBUR		C	CN
29	JHVAVMACTGA	VKGRP	TVBVK	VKGRP		C	CN
30	JHVAVMACTGA	VKORG	TJHVBER	VKORG		1	CN
31	JHVAVMACTGA	VTWEG	TJHVBER	VTWEG		1	CN
32	JHVAVMACTGA	WS_BLOCK	TJJW3	WS_BLOCK	REF	1	CN
33	JHVAVMACTGA	WS_TIMESLC	TJJW1	WS_TIMESLC	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in