SAP ABAP Table JHVMXK (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JHVMXK	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	VTNR	☑	MM_VTNR	MM_VTNR	CHAR	10	0	IS-M: Contract Number for Media-Mix Contract	JHTMXK
3	GPROLLE	☑	JHPARVW	JPARVW	CHAR	2	0	IS-M: Partner Role (Such As BU for Voucher Copy Recipient)	TJJ89
4	GPNR	☑	JHVGPZNR	GPNR	CHAR	10	0	IS-M/AM: Assigned Business Partner in the Contract	JGTGPNR
5	ADRNR	☑	JADRNR	JADRNR	CHAR	10	0	IS-M: Address Number
6	MXART	☐	JH_MXART	JH_MXART	CHAR	4	0	IS-M: Type of Media-Mix Contract Creation	TJJV4
7	PAKNR	☐	JH_MXPAKNR	JH_MXPAKNR	CHAR	10	0	IS-M: Number of a media-mix package	JJTMXK
8	KAUSSCHL	☐	JH_KAUSSCHL	JH_KAUSSCHL	CHAR	1	0	IS-M: Condition Exclusion Rule for Media-Mix Contract	TJJV5
9	ERFREGEL	☐	JH_ERFREGEL	JH_ERFREGEL	CHAR	1	0	IS-M: Fulfillment Rule for Media-Mix Contract	TJJV6
10	BESTIMMTER	☐	ABS_VTNR	ABS_VTNR	NUMC	6	0	IS-M: Contract Number	JHTVKO
11	MENGE1	☐	JH_ZIELMAL	JH_ZIELMAL	DEC	5	0	IS-M/AM: Target Number in the Contract
12	EINH1	☐	AB_MALEINH	MEINS	UNIT	3	0	IS-M/AM: Unit for Target Number in Contract	JJV006DL
13	MENGE2	☐	JH_ZIELMNG	ABS_MENGE	QUAN	12	3	IS-M/AM: Target Quantity in the Contract
14	EINH2	☐	AB_MNGEINH	MEINS	UNIT	3	0	IS-M/AM: Unit for Target Quantity in the Contract	JJV006
15	UMSATZ	☐	AB_ZIEL1	WERTV8	CURR	15	2	IS-M/AM: Target Quantity for Monetary Contract
16	WEINH	☐	AB_WEINH	WAERS	CUKY	5	0	IS-M: Currency Key for Contract	TCURC
17	ABRSTATUS	☐	JH_ABRSTATUS	JH_ABRSTATUS	NUMC	1	0	IS-M: Settlement Status of a Contract
18	AUFSTATUS	☐	JH_AUFSTATUS	JH_AUFSTATUS	NUMC	1	0	IS-M: Explode Status of a Media-Mix COA
19	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
20	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
21	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
22	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
23	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
24	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
25	XLOEVM	☐	LOEVM_ISP	XFELD	CHAR	1	0	Deletion Flag for Master Data in Media Sales & Distribution
26	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
27	ABSTYP	☐	ABS_TYP	ABS_TYP	CHAR	1	0	IS-M/AM: Contract Category	TJH11
28	ABSART	☐	JH_ABSART	JH_ABSART	CHAR	1	0	IS-M: Contract Type
29	RABANP	☐	RABATTANP	JH_XRABANP	CHAR	1	0	IS-M: Disc./Price Adjustment During Contract Validity Period
30	LFZBEG	☐	LFZBEG	DATUM	DATS	8	0	IS-M: Start of Validity Period
31	LFZEND	☐	LFZEND	DATUM	DATS	8	0	IS-M: End of Validity Period
32	ABRGNR	☐	ABRGNR	ABRGNR	NUMC	4	0	IS-M/AM: Contract Settlement Number
33	NAME1	☐	NAME1_ISP	NAME	CHAR	35	0	IS-M: Business Partner Name
34	NAME2	☐	NAME2_ISP	NAME	CHAR	35	0	IS-M: First Name of Business Partner

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JHVMXK	ABSTYP	TJH11	ABS_TYP	REF	C	CN
2	JHVMXK	BESTIMMTER	JHTVKO	VTNR	REF	C	CN
3	JHVMXK	EINH1	JJV006DL	MSEHI	REF	C	CN
4	JHVMXK	EINH2	JJV006	MSEHI	REF	C	CN
5	JHVMXK	ERFREGEL	TJJV6	ERFREGEL	REF	1	CN
6	JHVMXK	GPNR	JGTGPNR	GPNR	KEY	1	CN
7	JHVMXK	GPROLLE	TJJ89	PARVW	KEY	1	CN
8	JHVMXK	KAUSSCHL	TJJV5	KAUSSCHL	REF	1	CN
9	JHVMXK	MANDT	T000	MANDT	KEY	1	CN
10	JHVMXK	MXART	TJJV4	MXART	REF	1	CN
11	JHVMXK	PAKNR	JJTMXK	PAKNR	REF	C	CN
12	JHVMXK	VKORG	TVKO	VKORG	REF	C	CN
13	JHVMXK	VTNR	JHTMXK	VTNR	KEY	1	CN
14	JHVMXK	WEINH	TCURC	WAERS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in