SAP ABAP View JHVAGVZ (IS-M/AM: Sales Agent Assignments for JHAGVX Maintenance)

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	JHVAGVZ
Short Description	IS-M/AM: Sales Agent Assignments for JHAGVX Maintenance
Root table	JHAGVZ	IS-M/AM: Order Sales Agent Assignment

Table

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

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	JHAGA	MANDT	JL	EQ				0	0
2	JHAGVZ	MANDT	JR	EQ			AND	0	0
3	JHAGA	AVM_NR	JL	EQ				0	0
4	JHAGVZ	AVM_NR	JR	EQ			AND	0	0
5	JHAGA	POS_NR	JL	EQ				0	0
6	JHAGVZ	POS_NR	JR	EQ			AND	0	0
7	JHAGA	GRUPPABRNR	JL	EQ				0	0
8	JHAGVZ	GRUPPABRNR	JR	EQ			AND	0	0
9	JHAP	MANDT	JL	EQ				0	0
10	JHAGVZ	MANDT	JR	EQ			AND	0	0
11	JHAP	AVM_NR	JL	EQ				0	0
12	JHAGVZ	AVM_NR	JR	EQ			AND	0	0
13	JHAP	POS_NR	JL	EQ				0	0
14	JHAGVZ	POS_NR	JR	EQ			AND	0	0
15	JHAK	MANDT	JL	EQ				0	0
16	JHAGVZ	MANDT	JR	EQ			AND	0	0
17	JHAK	AVM_NR	JL	EQ				0	0
18	JHAGVZ	AVM_NR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	JHAGVZ	MANDT		☐	MANDT	☐	Client
2	AVM_NR	JHAGVZ	AVM_NR		☐	AVM_NR	☐	IS-M/AM: Sales Document Number
3	POS_NR	JHAGVZ	POS_NR		☐	POS_NR	☐	IS-M: Order Item Number
4	GRUPPABRNR	JHAGVZ	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	VERM	JHAGVZ	VERM		☐	VERMK	☐	IS-M: Sales Agent with ID Code for Screen
10	PROSL	JHAGVZ	PROSL		☐	JPROVSCHL	☐	IS-M/AM: Commission Key for Media Sales Agent
11	BEZKOND	JHAGVZ	BEZKOND		☐	JBEZKOND	☐	IS-M: Condition Reference
12	STATUSK	JHAGVZ	STATUSK		☐	STATUSK	☐	IS-M: Status
13	XUVVZ	JHAGVZ	XUVVZ		☐	XUVVZ_GVZ	☐	IS-M: Sales Agent Assignment is Incomplete
14	XZUOINACT	JHAGVZ	XZUOINACT		☐	XZUOINACT	☐	IS-M: Indicator Sales Agent Assignment is Inactive
15	XDELETED	JHAGVZ	XDELETED		☐	PR_XDEL	☐	IS-M: Sales Agent Assignment Deleted Manually Indicator
16	XPROV_EE	JHAGVZ	XPROV_EE		☐	XPROV_EE	☐	IS-M: Settlement Performed (Sales Agent Payment) Indicator
17	XFAKT_EE	JHAGA	XFAKT_EE		☐	XFAKT_EE	☐	IS-M: Billed Indicator
18	REF_VBELN	JHAGA	REF_VBELN		☐	JJBELNR	☐	IS-M/AM: Billing Document
19	REF_POSNR	JHAGA	REF_POSNR		☐	JJPOSNR	☐	IS-M/AM: Item (number) in settlement document
20	BELEGEINH	JHAGA	BELEGEINH		☐	BE_BASIS	☐	IS-M: Basic Booking Unit
21	UR_BELEINH	JHAGA	UR_BELEINH		☐	UR_BELEINH	☐	IS-M: Initial Booking Unit for the OPM Item
22	BER_TERMIN	JHAGA	BER_TERMIN		☐	BER_TERMIN	☐	IS-M: Date Services were Created for Settlement Purposes
23	FAKDATUM	JHAGA	FAKDATUM		☐	JHFKTER	☐	IS-M: Planned Billing/Settlement Date
24	PSTYV	JHAGA	PSTYV		☐	PSTYV_PAM	☐	IS-M: Item Category for Sales Document
25	XAEPROV	JHAGA	XAEPROV		☐	XAEPROV	☐	IS-M: Agency Commission Credit Memo Indicator
26	ZW_GRABRNR	JHAGA	ZW_GRABRNR		☐	ISM_TWIN_BILLING_DATASET_NO	☐	IS-M: Twinned Billing Dataset for Separate Agency Commission
27	POS_ART	JHAP	POS_ART		☐	AVMPOS_ART	☐	IS-M: Order-Publishing-Media - Item Type
28	VKORG	JHAK	VKORG		☐	VKORG	☐	Sales Organization
29	VTWEG	JHAK	VTWEG		☐	VTWEG	☐	Distribution Channel
30	SPART	JHAK	SPART		☐	SPART	☐	Division

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