SAP ABAP View JHVAVMACTGVZ (IS-M/AM: Order Update, Selection to Sales Agent Assignment)

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	JHVAVMACTGVZ
Short Description	IS-M/AM: Order Update, Selection to Sales Agent Assignment
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
4	JHAGVZ
5	JJTVV

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			AND	0	0
11	JHAGA	MANDT	JL	EQ				0	0
12	JHAGVZ	MANDT	JR	EQ			AND	0	0
13	JHAGA	AVM_NR	JL	EQ				0	0
14	JHAGVZ	AVM_NR	JR	EQ			AND	0	0
15	JHAGA	POS_NR	JL	EQ				0	0
16	JHAGVZ	POS_NR	JR	EQ			AND	0	0
17	JHAGA	GRUPPABRNR	JL	EQ				0	0
18	JHAGVZ	GRUPPABRNR	JR	EQ			AND	0	0
19	JJTVV	MANDT	JL	EQ				0	0
20	JHAGVZ	MANDT	JR	EQ			AND	0	0
21	JJTVV	VNR	JL	EQ				0	0
22	JHAGVZ	VNR	JR	EQ			AND	0	0
23	JHAGA	XSTORNIERT		EQ	''		AND	0	0
24	JHAGVZ	VZUONR		EQ	'01'			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	VNR	JHAGVZ	VNR		☐	JVMVVNR	☐	IS-M: Media Sales Agent Contract Number
6	BEDNR	JHAGVZ	BEDNR		☐	VM_BEDNR	☐	IS-M: Number of Media Sales Agent Contract Requirement
7	PROVTYP	JHAGVZ	PROVTYP		☐	PROVTYP	☐	IS-M/AM: Commission Category
8	VZUONR	JHAGVZ	VZUONR		☐	JH_VZUONR	☐	IS-M/AM: Sales Agent Assignment Number (Corrections)
9	GPAG	JHAK	GPAG		☐	GPAG	☐	Business Partner: Sold-to Party
10	VKORG	JHAK	VKORG		☐	VKORG	☐	Sales Organization
11	VTWEG	JHAK	VTWEG		☐	VTWEG	☐	Distribution Channel
12	SPART	JHAK	SPART		☐	SPART	☐	Division
13	AUART	JHAK	AUART		☐	AUART_PAM	☐	IS-M: Sales Document Type
14	VKGRP	JHAK	VKGRP		☐	VKGRP	☐	Sales group
15	VKBUR	JHAK	VKBUR		☐	VKBUR	☐	Sales office
16	AVM_HRKNFT	JHAK	AVM_HRKNFT		☐	AVM_HRKNFT	☐	IS-M/AM: Order Origin
17	POS_ART	JHAP	POS_ART		☐	AVMPOS_ART	☐	IS-M: Order-Publishing-Media - Item Type
18	PSTYV	JHAP	PSTYV		☐	PSTYV_PAM	☐	IS-M: Item Category for Sales Document
19	ERFUSER	JHAP	ERFUSER		☐	ERFUSER	☐	Created By
20	ERFDATE	JHAP	ERFDATE		☐	ERFDATE	☐	Created On
21	ERFTIME	JHAP	ERFTIME		☐	ERFTIME	☐	Time Created
22	AENUSER	JHAP	AENUSER		☐	AENUSER	☐	Last Changed By
23	AENDATE	JHAP	AENDATE		☐	AENDATE	☐	Date of Last Change
24	AENTIME	JHAP	AENTIME		☐	AENTIME	☐	Time of Last Change
25	BELEGEINH	JHAGA	BELEGEINH		☐	BE_BASIS	☐	IS-M: Basic Booking Unit
26	UR_BELEINH	JHAGA	UR_BELEINH		☐	UR_BELEINH	☐	IS-M: Initial Booking Unit for the OPM Item
27	IHKOMP	JHAGA	IHKOMP		☐	INHK_PRICE	☐	IS-M: Content component from price hierarchy
28	INSERENT	JHAGA	INSERENT		☐	INSERENT	☐	IS-M: Advertiser
29	BER_TERMIN	JHAGA	BER_TERMIN		☐	BER_TERMIN	☐	IS-M: Date Services were Created for Settlement Purposes
30	REGULIERER	JHAGA	REGULIERER		☐	GPNR_RG	☐	IS-M: Payer Business Partner
31	GF_STATUS	JHAGA	GF_STATUS		☐	GF_STATUS	☐	IS-M: Billing Dataset Status
32	KALKS	JHAGA	KALKS		☐	KALKS	☐	Pricing procedure assigned to this customer
33	KDGRP	JHAGA	KDGRP		☐	KDGRP	☐	Customer group
34	PLTYP	JHAGA	PLTYP		☐	PLTYP	☐	Price list type
35	PRSDT	JHAGA	PRSDT		☐	PRSDT	☐	Date for pricing and exchange rate
36	SEITE_FSP	JHAGA	SEITE_FSP		☐	SEITE_FSP	☐	IS-M: Page/column format
37	SEITE_FORM	JHAGA	SEITE_FORM		☐	SEITE_FORM	☐	IS-M: Page Format
38	SFSP_ABR	JHAGA	SFSP_ABR		☐	SFSP_ABR	☐	IS-M: Column Format for Settlement
39	AZART_AREA	JHAGA	AZART_AREA		☐	AZART_AREA	☐	IS-M/AM: Fixed Format Proposal /Ad Dimensions
40	AZART_GEST	JHAGA	AZART_GEST		☐	AZART_GEST	☐	IS-M: Design Ad Type
41	AZART_FORM	JHAGA	AZART_FORM		☐	AZART_FORM	☐	IS-M: Shape Ad Type
42	AZART_FARB	JHAGA	AZART_FARB		☐	AZART_FARB	☐	IS-M: Color Scheme Ad Type
43	AZART_SOND	JHAGA	AZART_SOND		☐	AZART_SOND	☐	IS-M: Ad Type - Special Handling Type
44	KALSM	JHAGA	KALSM		☐	KALSMASD	☐	Sales and Distribution: Pricing Procedure in Pricing
45	DRERZ	JHAGA	DRERZ		☐	DRERZ	☐	Publication
46	PVA	JHAGA	PVA		☐	PVA	☐	Edition
47	SI_TYP	JHAGA	SI_TYP		☐	SITYP	☐	IS-M: Ad Insert Type
48	SI_GEWKL	JHAGA	SI_GEWKL		☐	ISM_SI_GEWKL	☐	IS-M: Ad inserts weight price group
49	SI_SEKL	JHAGA	SI_SEKL		☐	ISM_SI_SEKL	☐	IS-M: Price Group for Ad Insert Pages
50	WS_TIMESLC	JHAGA	WS_TIMESLC		☐	WS_TIMESLC	☐	IS-M: Commercial Time Slice
51	WS_BLOCK	JHAGA	WS_BLOCK		☐	WS_BLOCK	☐	IS-M: Commercial Cluster
52	WS_STELLE	JHAGA	WS_STELLE		☐	WS_STELLE	☐	IS-M: Position (Sequence) Within a Commercial Cluster
53	FORMAT_ONL	JHAGA	FORMAT_ONL		☐	FORMAT_ONL	☐	IS-M/AM: Format Proposal (Online)
54	RRREL	JHAGA	RRREL		☐	ISMRR_RELTYP	☐	IS-M/AM: Revenue Recognition Category
55	XUVVZ	JHAGA	XUVVZ		☐	XUVVZ	☐	IS-M: Sales Agent Assignment Incomplete
56	XSTORNIERT	JHAGA	XSTORNIERT		☐	XSTORNIERT	☐	IS-M: Canceled Order Object Indicator
57	XFAKT_EE	JHAGA	XFAKT_EE		☐	XFAKT_EE	☐	IS-M: Billed Indicator
58	EKORG	JJTVV	EKORG		☐	EKORG	☐	Purchasing organization
59	VGRUP	JJTVV	VGRUP		☐	JVGRUP	☐	IS-M: Media Sales Agent Contract Grouping
60	VERM	JHAGVZ	VERM		☐	VERMK	☐	IS-M: Sales Agent with ID Code for Screen
61	PROSL	JHAGVZ	PROSL		☐	JPROVSCHL	☐	IS-M/AM: Commission Key for Media Sales Agent

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