SAP ABAP Table JHVAGVZ (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JHVAGVZ	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	JJTVV
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
8	VZUONR	☑	JH_VZUONR	JH_VZUONR	NUMC	2	0	IS-M/AM: Sales Agent Assignment Number (Corrections)
9	VERM	☐	VERMK	JJMVERM	CHAR	10	0	IS-M: Sales Agent with ID Code for Screen
10	PROSL	☐	JPROVSCHL	PRSCHL	CHAR	5	0	IS-M/AM: Commission Key for Media Sales Agent	TJH23
11	BEZKOND	☐	JBEZKOND	JBEZKOND	CHAR	2	0	IS-M: Condition Reference	TJJ83
12	STATUSK	☐	STATUSK	PAM_STATUS	CHAR	2	0	IS-M: Status
13	XUVVZ	☐	XUVVZ_GVZ	XFELD	CHAR	1	0	IS-M: Sales Agent Assignment is Incomplete
14	XZUOINACT	☐	XZUOINACT	XFELD	CHAR	1	0	IS-M: Indicator Sales Agent Assignment is Inactive
15	XDELETED	☐	PR_XDEL	XFELD	CHAR	1	0	IS-M: Sales Agent Assignment Deleted Manually Indicator
16	XPROV_EE	☐	XPROV_EE	XFELD	CHAR	1	0	IS-M: Settlement Performed (Sales Agent Payment) Indicator
17	XFAKT_EE	☐	XFAKT_EE	XFELD	CHAR	1	0	IS-M: Billed Indicator
18	REF_VBELN	☐	JJBELNR	JJBELNR	CHAR	10	0	IS-M/AM: Billing Document	JHTFK
19	REF_POSNR	☐	JJPOSNR	JJPOSNR	NUMC	6	0	IS-M/AM: Item (number) in settlement document	JHTFP
20	BELEGEINH	☐	BE_BASIS	BELEINH	CHAR	10	0	IS-M: Basic Booking Unit	JJTBE
21	UR_BELEINH	☐	UR_BELEINH	BELEINH	CHAR	10	0	IS-M: Initial Booking Unit for the OPM Item	JJTBE
22	BER_TERMIN	☐	BER_TERMIN	DATUM	DATS	8	0	IS-M: Date Services were Created for Settlement Purposes
23	FAKDATUM	☐	JHFKTER	DATUM	DATS	8	0	IS-M: Planned Billing/Settlement Date
24	PSTYV	☐	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	TJHAP
25	XAEPROV	☐	XAEPROV	XFELD	CHAR	1	0	IS-M: Agency Commission Credit Memo Indicator
26	ZW_GRABRNR	☐	ISM_TWIN_BILLING_DATASET_NO	GRUPPABR	NUMC	3	0	IS-M: Twinned Billing Dataset for Separate Agency Commission	JHAGA
27	POS_ART	☐	AVMPOS_ART	AVMPOS_ART	CHAR	2	0	IS-M: Order-Publishing-Media - Item Type	TJH17
28	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TJHVBER
29	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TJHVBER
30	SPART	☐	SPART	SPART	CHAR	2	0	Division	TJHVBER

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JHVAGVZ	AVM_NR	JHAK	AVM_NR	KEY	1	CN
2	JHVAGVZ	BEDNR	JJTVB	BEDNR	KEY	1	CN
3	JHVAGVZ	BELEGEINH	JJTBE	BELEINH	KEY	1	CN
4	JHVAGVZ	BEZKOND	TJJ83	BEZKOND	REF	1	CN
5	JHVAGVZ	GRUPPABRNR	JHAGA	GRUPPABRNR	KEY	1	CN
6	JHVAGVZ	MANDT	T000	MANDT	KEY	1	CN
7	JHVAGVZ	POS_ART	TJH17	AVMPOS_ART	REF	1	CN
8	JHVAGVZ	POS_NR	JHAP	POS_NR	KEY	1	CN
9	JHVAGVZ	PROSL	TJH23	PRSCHL	REF	1	CN
10	JHVAGVZ	PSTYV	TJHAP	PSTYV	KEY	1	CN
11	JHVAGVZ	REF_POSNR	JHTFP	POSNR	REF	1	CN
12	JHVAGVZ	REF_VBELN	JHTFK	VBELN	REF	1	CN
13	JHVAGVZ	SPART	TJHVBER	SPART		1	CN
14	JHVAGVZ	UR_BELEINH	JJTBE	BELEINH	REF	1	CN
15	JHVAGVZ	VKORG	TJHVBER	VKORG		1	CN
16	JHVAGVZ	VNR	JJTVV	VNR	KEY	1	CN
17	JHVAGVZ	VTWEG	TJHVBER	VTWEG		1	CN
18	JHVAGVZ	ZW_GRABRNR	JHAGA	GRUPPABRNR	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in