SAP ABAP Table MCJHAGVZB (IS-PAM: Reference structure from MCJAGVZB for LIS func.group)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JAS (Package) Application development R/3 Publishing Advertising System***

Basic Data

Table Category	INTTAB	Structure
Structure	MCJHAGVZB	Table Relationship Diagram
Short Description	IS-PAM: Reference structure from MCJAGVZB for LIS func.group

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	.INCLUDE	☐				0	0	Update Indicator for Statistics Updating
2	SUPKZ	☐	SUPKZ	SUPKZ	CHAR	1	0	Statistics update indicator (post in/post out)
3	.INCLUDE	☐				0	0	IS-PAM: LIS communication structure for agent assignment
4	.INCLUDE	☐				0	0	IS-M/AM: Order Sales Agent Assignment
5	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
6	AVM_NR	☐	AVM_NR	AVM_NR	CHAR	10	0	IS-M/AM: Sales Document Number	JHAK
7	POS_NR	☐	POS_NR	AVM_PNR	NUMC	3	0	IS-M: Order Item Number	JHAP
8	GRUPPABRNR	☐	GRUPPABRNR	GRUPPABR	NUMC	3	0	IS-M/AM: Billing Dataset	JHAGA
9	VNR	☐	JVMVVNR	JVMVVNR	CHAR	10	0	IS-M: Media Sales Agent Contract Number	JJTVV
10	BEDNR	☐	VM_BEDNR	VM_BEDNR	NUMC	6	0	IS-M: Number of Media Sales Agent Contract Requirement	JJTVB
11	PROVTYP	☐	PROVTYP	PROVTYP	CHAR	1	0	IS-M/AM: Commission Category
12	VZUONR	☐	JH_VZUONR	JH_VZUONR	NUMC	2	0	IS-M/AM: Sales Agent Assignment Number (Corrections)	*
13	VERM	☐	VERMK	JJMVERM	CHAR	10	0	IS-M: Sales Agent with ID Code for Screen	*
14	XAUTO	☐	JAUTOZUGPR	XFELD	CHAR	1	0	IS-M: Assigned automatically Indicator
15	XFOUND	☐	PR_XFOUND	XFELD	CHAR	1	0	Suitable Sales Agent Contract Requirement Found Indicator
16	XMANU	☐	PR_XMANU	XFELD	CHAR	1	0	IS-M: Sales Agent Assigned Manually Indicator
17	XKOPF_ZUO	☐	PRKOPF_ZUO	XFELD	CHAR	1	0	IS-M: "Sales Agent Copied from Order Header" Indicator
18	XPOS_ZUO	☐	PRPOS_ZUO	XFELD	CHAR	1	0	IS-M: Sales Agent Copied from Order Item
19	.INCLUDE	☐				0	0	Values that can be Modified Manually for Sales Agent Assign.
20	PR_BASIS	☐	VPROVBAS	DECV4_3	DEC	7	3	IS-M: Sales Agent Share of Calculation Base (in %)
21	PR_BETRAG	☐	VPROZP	DEC4_3	DEC	7	3	IS-M: Sales Agent Share of Commission (in %)
22	PRA_XMANU	☐	JHPRAXMANU	XFELD	CHAR	1	0	IS-M: Sales Agent Share was Changed Manually Indicator
23	PROSL	☐	JPROVSCHL	PRSCHL	CHAR	5	0	IS-M/AM: Commission Key for Media Sales Agent	TJH23
24	PROV_SATZ	☐	PROV_SATZ	DECV4_3	DEC	7	3	IS-M: Commission Rate (Percent)
25	PROVM_SATZ	☐	PROV_SATZM	WERTV8	CURR	15	2	IS-M: Commission Amount for mm Commission
26	PROVM_WAER	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
27	PROV_PEIN	☐	PAMPEIN	KPEIN	DEC	5	0	IS-M: Price Unit (Surcharge Discount, Basic Price)
28	PROV_MEIN	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
29	BEZKOND	☐	JBEZKOND	JBEZKOND	CHAR	2	0	IS-M: Condition Reference	TJJ83
30	VZMANUAEND	☐	VZMANUAEND	XFELD	CHAR	1	0	IS-M: Sales Agent Assignment was Changed Indicator
31	BEDGR	☐	BEDGR	BEDGR	CHAR	2	0	IS-M: Media Sales Agent Requirement Group	TJJ77
32	JVERMART	☐	JVERMART	JVERMART	CHAR	2	0	IS-M: Media Sales Agent Type: General/City/Special Agent	TJJ09
33	VANR	☐	JVANR	JVANR	CHAR	5	0	IS-M: Extra commission/exclusion
34	REF_VZUONR	☐	JH_REF_VZUONR	JH_VZUONR	NUMC	2	0	IS-M/AM: Reference Number of the Preceding Agent Assignmt	JHAGVZ
35	SUC_VZUONR	☐	JH_SUC_VZUONR	JH_VZUONR	NUMC	2	0	IS-M: Reference No.of Successor Sales Agent Assignment	JHAGVZ
36	CORRCAUSE	☐	JHVZCC	JHVZCC	CHAR	2	0	IS-M/AM: Reason for Correction to Sales Agent Assignment	TJHVZCC
37	CANCELCC	☐	JHCANCELCC	JHVZCC	CHAR	2	0	IS-M: Reversal Correction Reason for Sales Agent Assignment	TJHVZCC
38	.INCLUDE	☐				0	0	IS-PAM: Agent assignment grouping status fields
39	STATUSK	☐	STATUSK	PAM_STATUS	CHAR	2	0	IS-M: Status
40	XPROV_EE	☐	XPROV_EE	XFELD	CHAR	1	0	IS-M: Settlement Performed (Sales Agent Payment) Indicator
41	XUVVZ	☐	XUVVZ_GVZ	XFELD	CHAR	1	0	IS-M: Sales Agent Assignment is Incomplete
42	XZUOINACT	☐	XZUOINACT	XFELD	CHAR	1	0	IS-M: Indicator Sales Agent Assignment is Inactive
43	XDELETED	☐	PR_XDEL	XFELD	CHAR	1	0	IS-M: Sales Agent Assignment Deleted Manually Indicator
44	.INCLUDE	☐				0	0	IS-PAM: Characteristics for individual use (Ad.sched.line)
45	MERKMAL0	☐	MERK0_VZ	XFELD	CHAR	1	0	IS-M: Characteristic 0 for Ind.Use (Sales Agent Assignment)
46	MERKMAL1	☐	MERK1_VZ	XFELD	CHAR	1	0	IS-M: Characteristic 1 for Ind.Use (Sales Agent Assignment)
47	MERKMAL2	☐	MERK2_VZ	XFELD	CHAR	1	0	IS-M: Characteristic 2 for Ind.Use (Sales Agent Assignment)
48	MERKMAL3	☐	MERK3_VZ	XFELD	CHAR	1	0	IS-M: Characteristic 3 for Ind.Use (Sales Agent Assignment)
49	MERKMAL4	☐	MERK4_VZ	XFELD	CHAR	1	0	IS-M: Characteristic 4 for Ind.Use (Sales Agent Assignment)
50	MERKMAL5	☐	MERK5_VZ	XFELD	CHAR	1	0	IS-M: Characteristic 5 for Ind.Use (Sales Agent Assignment)
51	MERKMAL6	☐	MERK6_VZ	XFELD	CHAR	1	0	IS-M: Characteristic 6 for Ind.Use (Sales Agent Assignment)
52	MERKMAL7	☐	MERK7_VZ	XFELD	CHAR	1	0	IS-M: Characteristic 7 for Ind.Use (Sales Agent Assignment)
53	MERKMAL8	☐	MERK8_VZ	XFELD	CHAR	1	0	IS-M: Characteristic 8 for Ind.Use (Sales Agent Assignment)
54	MERKMAL9	☐	MERK9_VZ	XFELD	CHAR	1	0	CIS-M: Characteristic 9 for Ind.Use (Sales Agent Assignment)
55	.INCLUDE	☐				0	0	IS-M: LIS communication structure, agent data item extra
56	VZ_UMBRT	☐	VZ_UMBRT	WERTV10	CURR	19	2	IS-M/AM: LIS order SA total gross sales volume
57	VZ_UMNET	☐	VZ_UMNET	WERTV10	CURR	19	2	IS-M/AM: LIS order SA total net sales volume
58	VZ_KZWI1	☐	VZ_KZWI1	WERTV9	CURR	17	2	IS-M/AM: LIS Order SA SVOL ST1 Total
59	VZ_KZWI2	☐	VZ_KZWI2	WERTV9	CURR	17	2	IS-M/AM: LIS Order SA SVol ST2 Total
60	VZ_KZWI3	☐	VZ_KZWI3	WERTV9	CURR	17	2	IS-M/AM: LIS Order SA SVol. ST3 Total
61	VZ_KZWI4	☐	VZ_KZWI4	WERTV9	CURR	17	2	IS-M/AM: LIS Order SA SVol ST4 Total
62	VZ_KZWI5	☐	VZ_KZWI5	WERTV9	CURR	17	2	IS-M/AM: LIS Order SA SVol ST5 Total
63	VZ_KZWI6	☐	VZ_KZWI6	WERTV9	CURR	17	2	IS-M/AM: LIS Order SA SVol. ST6 Total
64	VZ_GUBRT	☐	VZ_GUBRT	WERTV10	CURR	19	2	IS-M/AM: LIS Order SA SVol Gross Total Credit Memo
65	VZ_GUNET	☐	VZ_GUNET	WERTV10	CURR	19	2	IS-M/AM: LIS Order SA SVol Net Total Credit Memo
66	VZ_KZWI1G	☐	VZ_KZWI1G	WERTV9	CURR	17	2	IS-M/AM: LIS Order SA SVol ST1 Total Credit Memo
67	VZ_KZWI2G	☐	VZ_KZWI2G	WERTV9	CURR	17	2	IS-M/AM: LIS Order SA SVol. ST2 Total Credit Memo
68	VZ_KZWI3G	☐	VZ_KZWI3G	WERTV9	CURR	17	2	IS-M/AM: LIS Order SA SVol ST3.Total Credit Memo
69	VZ_KZWI4G	☐	VZ_KZWI4G	WERTV9	CURR	17	2	IS-M/AM: LIS Order SA SVol ST4 Total Credit Memo
70	VZ_KZWI5G	☐	VZ_KZWI5G	WERTV9	CURR	17	2	IS-M/AM: LIS Order SA SVol. ST5 Total Credit Memo
71	VZ_KZWI6G	☐	VZ_KZWI6G	WERTV9	CURR	17	2	IS-M/AM: LIS Order SA SVol. ST6 Total Credit Memo
72	VZA_UMBRT	☐	VZA_UMBRT	WERTV10	CURR	19	2	IS-M/AM: LIS Order SAShare SVol Gross Total
73	VZA_UMNET	☐	VZA_UMNET	WERTV10	CURR	19	2	IS-M/AM: LIS Order SA Share SVol Net Total
74	VZA_KZWI1	☐	VZA_KZWI1	WERTV9	CURR	17	2	IS-M: LIS order SAShare SVol ST1 Total
75	VZA_KZWI2	☐	VZA_KZWI2	WERTV9	CURR	17	2	IS-M: LIS order SAShare SVOl. ST2 Total
76	VZA_KZWI3	☐	VZA_KZWI3	WERTV9	CURR	17	2	IS-M: LIS order SAShare SVol ST3 Total
77	VZA_KZWI4	☐	VZA_KZWI4	WERTV9	CURR	17	2	IS-M: LIS order SAShare SVol ST4 Total
78	VZA_KZWI5	☐	VZA_KZWI5	WERTV9	CURR	17	2	IS-M: LIS order SAShare SVolume ST5 Total
79	VZA_KZWI6	☐	VZA_KZWI6	WERTV9	CURR	17	2	IS-M: LIS order SAShare SVolume ST6 Total
80	VZA_GUBRT	☐	VZA_GUBRT	WERTV10	CURR	19	2	IS-M/AM: LIS Order SAShare SVol Gross Total Credit Memo
81	VZA_GUNET	☐	VZA_GUNET	WERTV10	CURR	19	2	IS-M/AM: LIS Order SAShare SVol Net Total Credit Memo
82	VZA_KZWI1G	☐	VZA_KZWI1G	WERTV9	CURR	17	2	IS-M: LIS order SAShare SVol ST1 Tital Credit Memo
83	VZA_KZWI2G	☐	VZA_KZWI2G	WERTV9	CURR	17	2	IS-M: LIS order SAShare SVol. ST2 Total Credit Memo
84	VZA_KZWI3G	☐	VZA_KZWI3G	WERTV9	CURR	17	2	IS-M: LIS order SAShare SVol ST3 Total Credit Memo
85	VZA_KZWI4G	☐	VZA_KZWI4G	WERTV9	CURR	17	2	IS-M: LIS order SAgtAssShare SVol ST4 Total credit memo
86	VZA_KZWI5G	☐	VZA_KZWI5G	WERTV9	CURR	17	2	IS-M: LIS order SAShare SVol ST5 Total Credit Memo
87	VZA_KZWI6G	☐	VZA_KZWI6G	WERTV9	CURR	17	2	IS-M: LIS order SAShare SVol ST6 Total Credit Memo
88	J_FAKDAT	☐	J_FAKDAT	DATUM	DATS	8	0	IS-M: LIS auxiliary field for billing date in the order
89	J_KUNAG	☐	GPAG	GPNR	CHAR	10	0	Business Partner: Sold-to Party	*
90	J_KUNRG	☐	REGULIERER	GPNR	CHAR	10	0	IS-M: Payer	*
91	J_INSERENT	☐	INSERENT	GPNR	CHAR	10	0	IS-M: Advertiser	*
92	J_VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
93	J_VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
94	J_SPART	☐	SPART	SPART	CHAR	2	0	Division	*
95	J_BEINH	☐	BELEGEINH	BELEINH	CHAR	10	0	IS-M/AM: Booking Unit	*
96	J_BEINH_BA	☐	BE_BASIS	BELEINH	CHAR	10	0	IS-M: Basic Booking Unit	*
97	.INCLUDE	☐				0	0	IS-M: LIS communication structure, billing agent data
98	VF_UMBRT	☐	VF_UMBRT	WERTV10	CURR	19	2	IS-M/AM: LIS billing SA total gross sales volume
99	VF_UMNET	☐	VF_UMNET	WERTV10	CURR	19	2	IS-M/AM: LIS billing SA total net sales volume
100	VF_KZWI1	☐	VF_KZWI1	WERTV9	CURR	17	2	IS-M: LIS billing SA SVol ST1 total
101	VF_KZWI2	☐	VF_KZWI2	WERTV9	CURR	17	2	IS-M: LIS billing SA SVol ST2 total
102	VF_KZWI3	☐	VF_KZWI3	WERTV9	CURR	17	2	IS-M: LIS billing SA SVol ST3 total
103	VF_KZWI4	☐	VF_KZWI4	WERTV9	CURR	17	2	IS-M: LIS billing SA SVol ST4 total
104	VF_KZWI5	☐	VF_KZWI5	WERTV9	CURR	17	2	IS-M: LIS billing SA SVol ST5 total
105	VF_KZWI6	☐	VF_KZWI6	WERTV9	CURR	17	2	IS-M: LIS billing SA SVol.ST6 total
106	VF_GUBRT	☐	VF_GUBRT	WERTV10	CURR	19	2	IS-M/AM: LIS billing AA gross sales volume total credit memo
107	VF_GUNET	☐	VF_GUNET	WERTV10	CURR	19	2	IS-M/AM: LIS billing SA SVol net total credit memo
108	VF_KZWI1G	☐	VF_KZWI1G	WERTV9	CURR	17	2	IS-M: LIS billing SA SVol ST1 total credit memo
109	VF_KZWI2G	☐	VF_KZWI2G	WERTV9	CURR	17	2	IS-M: LIS billing SA SVol ST2 total credit memo
110	VF_KZWI3G	☐	VF_KZWI3G	WERTV9	CURR	17	2	IS-M: LIS billing SA SVol ST3 total credit memo
111	VF_KZWI4G	☐	VF_KZWI4G	WERTV9	CURR	17	2	IS-M: LIS billing SA SVol ST4 total credit memo
112	VF_KZWI5G	☐	VF_KZWI5G	WERTV9	CURR	17	2	IS-M: LIS billing SA SVol ST5 total credit memo
113	VF_KZWI6G	☐	VF_KZWI6G	WERTV9	CURR	17	2	IS-M: LIS billing SA SVol ST6 total credit memo
114	VFA_UMBRT	☐	VFA_UMBRT	WERTV10	CURR	19	2	IS-M/AM: LIS billing SAShare total gross sales volume
115	VFA_UMNET	☐	VFA_UMNET	WERTV10	CURR	19	2	IS-M/AM: LIS billing SA share total net sales volume
116	VFA_KZWI1	☐	VFA_KZWI1	WERTV9	CURR	17	2	IS-M: LIS billing SAShare SVol ST1 total
117	VFA_KZWI2	☐	VFA_KZWI2	WERTV9	CURR	17	2	IS-M: LIS billing SAShare SVol ST2 total
118	VFA_KZWI3	☐	VFA_KZWI3	WERTV9	CURR	17	2	IS-M: LIS billing SAShare SVol ST3 total
119	VFA_KZWI4	☐	VFA_KZWI4	WERTV9	CURR	17	2	IS-M: LIS billing SAShare SVol ST4 total
120	VFA_KZWI5	☐	VFA_KZWI5	WERTV9	CURR	17	2	IS-M: LIS billing SAShare SVol ST5 total
121	VFA_KZWI6	☐	VFA_KZWI6	WERTV9	CURR	17	2	IS-M: LIS billing SAShare Sales vol.ST6 total
122	VFA_GUBRT	☐	VFA_GUBRT	WERTV10	CURR	19	2	IS-M/AM: LIS billing SAAShare gross SVol.total credit memo
123	VFA_GUNET	☐	VFA_GUNET	WERTV10	CURR	19	2	IS-M/AM: LIS billing SAAShare net SVol total credit memo
124	VFA_KZWI1G	☐	VFA_KZWI1G	WERTV9	CURR	17	2	IS-M: LIS billing SAShare SVol ST1 total credit memo
125	VFA_KZWI2G	☐	VFA_KZWI2G	WERTV9	CURR	17	2	IS-M: LIS billing SAShare SVol ST2 total credit memo
126	VFA_KZWI3G	☐	VFA_KZWI3G	WERTV9	CURR	17	2	IS-M: LIS billing SAShare SVol ST3 total credit memo
127	VFA_KZWI4G	☐	VFA_KZWI4G	WERTV9	CURR	17	2	IS-M: LIS billing SAShare SVol ST4 total credit memo
128	VFA_KZWI5G	☐	VFA_KZWI5G	WERTV9	CURR	17	2	IS-M: LIS billing SAShare SVol. ST5 total credit memo
129	VFA_KZWI6G	☐	VFA_KZWI6G	WERTV9	CURR	17	2	IS-M: LIS billing SAShare SVol ST6 total credit memo

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MCJHAGVZB	AVM_NR	JHAK	AVM_NR	KEY	1	CN
2	MCJHAGVZB	BEDGR	TJJ77	BEDGR	KEY	1	CN
3	MCJHAGVZB	BEDNR	JJTVB	BEDNR	KEY	1	CN
4	MCJHAGVZB	BEZKOND	TJJ83	BEZKOND	REF	1	CN
5	MCJHAGVZB	CANCELCC	TJHVZCC	CORRCAUSE	REF	1	CN
6	MCJHAGVZB	CORRCAUSE	TJHVZCC	CORRCAUSE	REF	1	CN
7	MCJHAGVZB	GRUPPABRNR	JHAGA	GRUPPABRNR	KEY	1	CN
8	MCJHAGVZB	JVERMART	TJJ09	JVERMART	KEY	1	CN
9	MCJHAGVZB	MANDT	T000	MANDT	KEY	1	CN
10	MCJHAGVZB	POS_NR	JHAP	POS_NR	KEY	1	CN
11	MCJHAGVZB	PROSL	TJH23	PRSCHL	REF	1	CN
12	MCJHAGVZB	PROVM_WAER	TCURC	WAERS	REF	1	CN
13	MCJHAGVZB	PROV_MEIN	T006	MSEHI	REF	1	CN
14	MCJHAGVZB	REF_VZUONR	JHAGVZ	VZUONR	REF	1	CN
15	MCJHAGVZB	SUC_VZUONR	JHAGVZ	VZUONR	REF	1	C
16	MCJHAGVZB	VNR	JJTVV	VNR	KEY	1	CN

History

Last changed by/on	SAP	20060208
SAP Release Created in