SAP ABAP View JHVAVMACTGA (IS-M/AM: Order Update, Selection to Billing Dataset)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JAS (Package) Application development R/3 Publishing Advertising System***

Basic Data

View Type	D	Database View
Database View	JHVAVMACTGA
Short Description	IS-M/AM: Order Update, Selection to Billing Dataset
Root table	JHAK	IS-M/AM: Order-Publishing-Media (Header Data)

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JHAK	JHAK
2	JHAP
3	JHAGA

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	JHAK	MANDT	JL	EQ				0	0
2	JHAP	MANDT	JR	EQ			AND	0	0
3	JHAK	AVM_NR	JL	EQ				0	0
4	JHAP	AVM_NR	JR	EQ			AND	0	0
5	JHAP	MANDT	JL	EQ				0	0
6	JHAGA	MANDT	JR	EQ			AND	0	0
7	JHAP	AVM_NR	JL	EQ				0	0
8	JHAGA	AVM_NR	JR	EQ			AND	0	0
9	JHAP	POS_NR	JL	EQ				0	0
10	JHAGA	POS_NR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	JHAK	MANDT		☐	MANDT	☐	Client
2	AVM_NR	JHAK	AVM_NR		☐	AVM_NR	☐	IS-M/AM: Sales Document Number
3	POS_NR	JHAP	POS_NR		☐	POS_NR	☐	IS-M: Order Item Number
4	GRUPPABRNR	JHAGA	GRUPPABRNR		☐	GRUPPABRNR	☐	IS-M/AM: Billing Dataset
5	GPAG	JHAK	GPAG		☐	GPAG	☐	Business Partner: Sold-to Party
6	VKORG	JHAK	VKORG		☐	VKORG	☐	Sales Organization
7	VTWEG	JHAK	VTWEG		☐	VTWEG	☐	Distribution Channel
8	SPART	JHAK	SPART		☐	SPART	☐	Division
9	AUART	JHAK	AUART		☐	AUART_PAM	☐	IS-M: Sales Document Type
10	VKGRP	JHAK	VKGRP		☐	VKGRP	☐	Sales group
11	VKBUR	JHAK	VKBUR		☐	VKBUR	☐	Sales office
12	AVM_HRKNFT	JHAK	AVM_HRKNFT		☐	AVM_HRKNFT	☐	IS-M/AM: Order Origin
13	POS_ART	JHAP	POS_ART		☐	AVMPOS_ART	☐	IS-M: Order-Publishing-Media - Item Type
14	PSTYV	JHAP	PSTYV		☐	PSTYV_PAM	☐	IS-M: Item Category for Sales Document
15	ERFUSER	JHAP	ERFUSER		☐	ERFUSER	☐	Created By
16	ERFDATE	JHAP	ERFDATE		☐	ERFDATE	☐	Created On
17	ERFTIME	JHAP	ERFTIME		☐	ERFTIME	☐	Time Created
18	AENUSER	JHAP	AENUSER		☐	AENUSER	☐	Last Changed By
19	AENDATE	JHAP	AENDATE		☐	AENDATE	☐	Date of Last Change
20	AENTIME	JHAP	AENTIME		☐	AENTIME	☐	Time of Last Change
21	BELEGEINH	JHAGA	BELEGEINH		☐	BE_BASIS	☐	IS-M: Basic Booking Unit
22	UR_BELEINH	JHAGA	UR_BELEINH		☐	UR_BELEINH	☐	IS-M: Initial Booking Unit for the OPM Item
23	IHKOMP	JHAGA	IHKOMP		☐	INHK_PRICE	☐	IS-M: Content component from price hierarchy
24	INSERENT	JHAGA	INSERENT		☐	INSERENT	☐	IS-M: Advertiser
25	BER_TERMIN	JHAGA	BER_TERMIN		☐	BER_TERMIN	☐	IS-M: Date Services were Created for Settlement Purposes
26	REGULIERER	JHAGA	REGULIERER		☐	GPNR_RG	☐	IS-M: Payer Business Partner
27	GF_STATUS	JHAGA	GF_STATUS		☐	GF_STATUS	☐	IS-M: Billing Dataset Status
28	KALKS	JHAGA	KALKS		☐	KALKS	☐	Pricing procedure assigned to this customer
29	KDGRP	JHAGA	KDGRP		☐	KDGRP	☐	Customer group
30	PLTYP	JHAGA	PLTYP		☐	PLTYP	☐	Price list type
31	PRSDT	JHAGA	PRSDT		☐	PRSDT	☐	Date for pricing and exchange rate
32	SEITE_FSP	JHAGA	SEITE_FSP		☐	SEITE_FSP	☐	IS-M: Page/column format
33	SEITE_FORM	JHAGA	SEITE_FORM		☐	SEITE_FORM	☐	IS-M: Page Format
34	SFSP_ABR	JHAGA	SFSP_ABR		☐	SFSP_ABR	☐	IS-M: Column Format for Settlement
35	AZART_AREA	JHAGA	AZART_AREA		☐	AZART_AREA	☐	IS-M/AM: Fixed Format Proposal /Ad Dimensions
36	AZART_GEST	JHAGA	AZART_GEST		☐	AZART_GEST	☐	IS-M: Design Ad Type
37	AZART_FORM	JHAGA	AZART_FORM		☐	AZART_FORM	☐	IS-M: Shape Ad Type
38	AZART_FARB	JHAGA	AZART_FARB		☐	AZART_FARB	☐	IS-M: Color Scheme Ad Type
39	AZART_SOND	JHAGA	AZART_SOND		☐	AZART_SOND	☐	IS-M: Ad Type - Special Handling Type
40	KALSM	JHAGA	KALSM		☐	KALSMASD	☐	Sales and Distribution: Pricing Procedure in Pricing
41	DRERZ	JHAGA	DRERZ		☐	DRERZ	☐	Publication
42	PVA	JHAGA	PVA		☐	PVA	☐	Edition
43	SI_TYP	JHAGA	SI_TYP		☐	SITYP	☐	IS-M: Ad Insert Type
44	SI_GEWKL	JHAGA	SI_GEWKL		☐	ISM_SI_GEWKL	☐	IS-M: Ad inserts weight price group
45	SI_SEKL	JHAGA	SI_SEKL		☐	ISM_SI_SEKL	☐	IS-M: Price Group for Ad Insert Pages
46	WS_TIMESLC	JHAGA	WS_TIMESLC		☐	WS_TIMESLC	☐	IS-M: Commercial Time Slice
47	WS_BLOCK	JHAGA	WS_BLOCK		☐	WS_BLOCK	☐	IS-M: Commercial Cluster
48	WS_STELLE	JHAGA	WS_STELLE		☐	WS_STELLE	☐	IS-M: Position (Sequence) Within a Commercial Cluster
49	FORMAT_ONL	JHAGA	FORMAT_ONL		☐	FORMAT_ONL	☐	IS-M/AM: Format Proposal (Online)
50	RRREL	JHAGA	RRREL		☐	ISMRR_RELTYP	☐	IS-M/AM: Revenue Recognition Category
51	XUVVZ	JHAGA	XUVVZ		☐	XUVVZ	☐	IS-M: Sales Agent Assignment Incomplete
52	XSTORNIERT	JHAGA	XSTORNIERT		☐	XSTORNIERT	☐	IS-M: Canceled Order Object Indicator
53	XFAKT_EE	JHAGA	XFAKT_EE		☐	XFAKT_EE	☐	IS-M: Billed Indicator

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

Last changed by/on	SAP	20130529
SAP Release Created in	462