SAP ABAP Table JHVAGVX (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JHVAGVX	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

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

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	AVM_NR	☑	AVM_NR	AVM_NR	CHAR	10	0	IS-M/AM: Sales Document Number	JHAK
3	POS_NR	☑	POS_NR	AVM_PNR	NUMC	3	0	IS-M: Order Item Number	JHAP
4	GRUPPABRNR	☑	GRUPPABRNR	GRUPPABR	NUMC	3	0	IS-M/AM: Billing Dataset	JHAGA
5	VNR	☑	JVMVVNR	JVMVVNR	CHAR	10	0	IS-M: Media Sales Agent Contract Number
6	BEDNR	☑	VM_BEDNR	VM_BEDNR	NUMC	6	0	IS-M: Number of Media Sales Agent Contract Requirement	JJTVB
7	PROVTYP	☑	PROVTYP	PROVTYP	CHAR	1	0	IS-M/AM: Commission Category	JHAGVZ
8	VZUONR	☑	JH_VZUONR	JH_VZUONR	NUMC	2	0	IS-M/AM: Sales Agent Assignment Number (Corrections)	JHAGVZ
9	FKBEL	☑	JJBELNR	JJBELNR	CHAR	10	0	IS-M/AM: Billing Document	JHTFK
10	FKPOS	☑	JJPOSNR	JJPOSNR	NUMC	6	0	IS-M/AM: Item (number) in settlement document	JHTFP
11	VTYP	☐	JVERMVTYP	JVERMVTYP	CHAR	1	0	IS-M: Contract Category for Media Sales Agent Contract
12	POOLNR	☐	POOLNR	POOLNR	CHAR	6	0	IS-M: Media Sales Agent Pool	JJTPO
13	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
14	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
15	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
16	VGRUP	☐	JVGRUP	JVGRUP	CHAR	6	0	IS-M: Media Sales Agent Contract Grouping	TJJV1
17	PERNR	☐	JJPERNR	JPERNR	CHAR	20	0	IS-M: Personnel Number
18	UEBERLART	☐	UEBERLZIEL	UEBERLZIEL	CHAR	1	0	IS-M: Transfer Destination
19	XLOESCHVM	☐	LOEVM_ISP	XFELD	CHAR	1	0	Deletion Flag for Master Data in Media Sales & Distribution
20	XLOESCHKZ	☐	LOEKZ_ISP	XFELD	CHAR	1	0	Deletion Indicator for Master Data in Media Sales & Dist.
21	SETTLESTAT	☐	JHSETLSTAT	JHSETLSTAT	CHAR	1	0	IS-M/AM: Settlement Status
22	FKDAT	☐	JHFKTER	DATUM	DATS	8	0	IS-M: Planned Billing/Settlement Date
23	FAKSP	☐	PAM_FAKSP	FAKSP	CHAR	2	0	IS-M: Billing Block
24	VERM	☐	VERMK	JJMVERM	CHAR	10	0	IS-M: Sales Agent with ID Code for Screen
25	PROSL	☐	JPROVSCHL	PRSCHL	CHAR	5	0	IS-M/AM: Commission Key for Media Sales Agent	TJH23
26	BEDGR	☐	BEDGR	BEDGR	CHAR	2	0	IS-M: Media Sales Agent Requirement Group	TJJ77
27	JVERMART	☐	JVERMART	JVERMART	CHAR	2	0	IS-M: Media Sales Agent Type: General/City/Special Agent	TJJ09
28	REF_VBELN	☐	JJBELNR	JJBELNR	CHAR	10	0	IS-M/AM: Billing Document	JHTFK
29	REF_POSNR	☐	JJPOSNR	JJPOSNR	NUMC	6	0	IS-M/AM: Item (number) in settlement document	JHTFP

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JHVAGVX	AVM_NR	JHAK	AVM_NR	KEY	1	CN
2	JHVAGVX	BEDGR	TJJ77	BEDGR	KEY	1	CN
3	JHVAGVX	BEDNR	JJTVB	BEDNR	KEY	1	CN
4	JHVAGVX	EKORG	T024E	EKORG	REF	1	CN
5	JHVAGVX	FKBEL	JHTFK	VBELN	KEY	C	CN
6	JHVAGVX	FKPOS	JHTFP	POSNR	KEY	C	CN
7	JHVAGVX	GRUPPABRNR	JHAGA	GRUPPABRNR	KEY	1	CN
8	JHVAGVX	JVERMART	TJJ09	JVERMART	KEY	1	CN
9	JHVAGVX	MANDT	T000	MANDT	KEY	1	CN
10	JHVAGVX	POOLNR	JJTPO	POOLNR	REF	C	CN
11	JHVAGVX	POS_NR	JHAP	POS_NR	KEY	1	CN
12	JHVAGVX	PROSL	TJH23	PRSCHL	REF	1	CN
13	JHVAGVX	PROVTYP	JHAGVZ	PROVTYP	KEY	1	CN
14	JHVAGVX	REF_POSNR	JHTFP	POSNR	REF	C	CN
15	JHVAGVX	REF_VBELN	JHTFK	VBELN	REF	C	CN
16	JHVAGVX	VGRUP	TJJV1	VGRUP	REF	1	CN
17	JHVAGVX	VKBUR	TVBUR	VKBUR	REF	C	CN
18	JHVAGVX	VKGRP	TVBVK	VKGRP	REF	1	CN
19	JHVAGVX	VZUONR	JHAGVZ	VZUONR	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in