SAP ABAP View JHVAGVX (IS-M/AM: Sales Agent Settlement Index (for Settlement))

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	JHVAGVX
Short Description	IS-M/AM: Sales Agent Settlement Index (for Settlement)
Root table	JJTVV	IS-M/AM: Media Sales Agent Contract

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JJTVV	JJTVV
2	JHAGVX
3	JHAGVZ

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	JJTVV	MANDT	JL	EQ				0	0
2	JHAGVX	MANDT	JR	EQ			AND	0	0
3	JJTVV	VNR	JL	EQ				0	0
4	JHAGVX	VNR	JR	EQ			AND	0	0
5	JHAGVZ	MANDT	JL	EQ				0	0
6	JHAGVX	MANDT	JR	EQ			AND	0	0
7	JHAGVZ	AVM_NR	JL	EQ				0	0
8	JHAGVX	AVM_NR	JR	EQ			AND	0	0
9	JHAGVZ	POS_NR	JL	EQ				0	0
10	JHAGVX	POS_NR	JR	EQ			AND	0	0
11	JHAGVZ	GRUPPABRNR	JL	EQ				0	0
12	JHAGVX	GRUPPABRNR	JR	EQ			AND	0	0
13	JHAGVZ	VNR	JL	EQ				0	0
14	JHAGVX	VNR	JR	EQ			AND	0	0
15	JHAGVZ	BEDNR	JL	EQ				0	0
16	JHAGVX	BEDNR	JR	EQ			AND	0	0
17	JHAGVZ	PROVTYP	JL	EQ				0	0
18	JHAGVX	PROVTYP	JR	EQ			AND	0	0
19	JHAGVZ	VZUONR	JL	EQ				0	0
20	JHAGVX	VZUONR	JR	EQ			AND	0	0
21	JJTVV	XLOESCHKZ		EQ	' '		AND	0	0
22	JJTVV	XLOESCHVM		EQ	' '			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	JJTVV	MANDT		☐	MANDT	☐	Client
2	AVM_NR	JHAGVX	AVM_NR		☐	AVM_NR	☐	IS-M/AM: Sales Document Number
3	POS_NR	JHAGVX	POS_NR		☐	POS_NR	☐	IS-M: Order Item Number
4	GRUPPABRNR	JHAGVX	GRUPPABRNR		☐	GRUPPABRNR	☐	IS-M/AM: Billing Dataset
5	VNR	JJTVV	VNR		☐	JVMVVNR	☐	IS-M: Media Sales Agent Contract Number
6	BEDNR	JHAGVX	BEDNR		☐	VM_BEDNR	☐	IS-M: Number of Media Sales Agent Contract Requirement
7	PROVTYP	JHAGVX	PROVTYP		☐	PROVTYP	☐	IS-M/AM: Commission Category
8	VZUONR	JHAGVX	VZUONR		☐	JH_VZUONR	☐	IS-M/AM: Sales Agent Assignment Number (Corrections)
9	FKBEL	JHAGVX	FKBEL		☐	JJBELNR	☐	IS-M/AM: Billing Document
10	FKPOS	JHAGVX	FKPOS		☐	JJPOSNR	☐	IS-M/AM: Item (number) in settlement document
11	VTYP	JJTVV	VTYP		☐	JVERMVTYP	☐	IS-M: Contract Category for Media Sales Agent Contract
12	POOLNR	JJTVV	POOLNR		☐	POOLNR	☐	IS-M: Media Sales Agent Pool
13	EKORG	JJTVV	EKORG		☐	EKORG	☐	Purchasing organization
14	VKBUR	JJTVV	VKBUR		☐	VKBUR	☐	Sales office
15	VKGRP	JJTVV	VKGRP		☐	VKGRP	☐	Sales group
16	VGRUP	JJTVV	VGRUP		☐	JVGRUP	☐	IS-M: Media Sales Agent Contract Grouping
17	PERNR	JJTVV	PERNR		☐	JJPERNR	☐	IS-M: Personnel Number
18	UEBERLART	JJTVV	UEBERLART		☐	UEBERLZIEL	☐	IS-M: Transfer Destination
19	XLOESCHVM	JJTVV	XLOESCHVM		☐	LOEVM_ISP	☐	Deletion Flag for Master Data in Media Sales & Distribution
20	XLOESCHKZ	JJTVV	XLOESCHKZ		☐	LOEKZ_ISP	☐	Deletion Indicator for Master Data in Media Sales & Dist.
21	SETTLESTAT	JHAGVX	SETTLESTAT		☐	JHSETLSTAT	☐	IS-M/AM: Settlement Status
22	FKDAT	JHAGVX	FKDAT		☐	JHFKTER	☐	IS-M: Planned Billing/Settlement Date
23	FAKSP	JHAGVX	FAKSP		☐	PAM_FAKSP	☐	IS-M: Billing Block
24	VERM	JHAGVZ	VERM		☐	VERMK	☐	IS-M: Sales Agent with ID Code for Screen
25	PROSL	JHAGVZ	PROSL		☐	JPROVSCHL	☐	IS-M/AM: Commission Key for Media Sales Agent
26	BEDGR	JHAGVZ	BEDGR		☐	BEDGR	☐	IS-M: Media Sales Agent Requirement Group
27	JVERMART	JHAGVZ	JVERMART		☐	JVERMART	☐	IS-M: Media Sales Agent Type: General/City/Special Agent
28	REF_VBELN	JHAGVX	REF_VBELN		☐	JJBELNR	☐	IS-M/AM: Billing Document
29	REF_POSNR	JHAGVX	REF_POSNR		☐	JJPOSNR	☐	IS-M/AM: Item (number) in settlement document

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