SAP ABAP View JHVGVZ (View of Assigned Sales Agent Requirements in 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	JHVGVZ
Short Description	View of Assigned Sales Agent Requirements in Billing Dataset
Root table	JHAGVZ	IS-M/AM: Order Sales Agent Assignment

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JHAGVZ	JHAGVZ
2	JJTVB
3	JJTVERMKU
4	TJJ77

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	JJTVB	MANDT	JL	EQ				0	0
2	JHAGVZ	MANDT	JR	EQ			AND	0	0
3	JJTVB	VNR	JL	EQ				0	0
4	JHAGVZ	VNR	JR	EQ			AND	0	0
5	JJTVB	BEDNR	JL	EQ				0	0
6	JHAGVZ	BEDNR	JR	EQ			AND	0	0
7	JJTVERMKU	MANDT	JL	EQ				0	0
8	JHAGVZ	MANDT	JR	EQ			AND	0	0
9	JJTVERMKU	VERMGPNR	JL	EQ				0	0
10	JHAGVZ	VERM	JR	EQ			AND	0	0
11	TJJ77	MANDT	JL	EQ				0	0
12	JHAGVZ	MANDT	JR	EQ			AND	0	0
13	TJJ77	BEDGR	JL	EQ				0	0
14	JJTVB	BEDGR	JR	EQ			AND	0	0
15	JHAGVZ	XDELETED		EQ	' '		AND	0	0
16	JHAGVZ	XZUOINACT		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	VERMKURZ	JJTVERMKU	VERMKURZ		☐	JVERMKURZ	☐	IS-M: Media Sales Agent Identification Code for Fast Input
10	BEDART	JJTVB	BEDART		☐	VMBEDART	☐	IS-M/AM: Requirement Type in Media Sales Agent Contract
11	XVBAG	TJJ77	XVBAG		☐	XVBAG	☐	IS-M: Sales Agent For Agency Indicator
12	XVBIS	TJJ77	XVBIS		☐	XVBIS	☐	IS-M: Advertiser Sales Agent Indicator
13	KURZTEXT	JJTVB	KURZTEXT		☐	BEZEICHN15	☐	IS-M: Short Text
14	VERM	JHAGVZ	VERM		☐	VERMK	☐	IS-M: Sales Agent with ID Code for Screen
15	XDELETED	JHAGVZ	XDELETED		☐	PR_XDEL	☐	IS-M: Sales Agent Assignment Deleted Manually Indicator
16	XZUOINACT	JHAGVZ	XZUOINACT		☐	XZUOINACT	☐	IS-M: Indicator Sales Agent Assignment is Inactive

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