SAP ABAP View JHVMXK (IS-M: Selection View for Media-Mix Contracts)

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	JHVMXK
Short Description	IS-M: Selection View for Media-Mix Contracts
Root table	JHTMGPZ	IS-M: Media-Mix Contract: Business Partner

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JHTMGPZ	JHTMGPZ
2	JHTMXK
3	JGTSADR

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	JHTMXK	MANDT	JL	EQ				0	0
2	JHTMGPZ	MANDT	JR	EQ			AND	0	0
3	JHTMXK	VTNR	JL	EQ				0	0
4	JHTMGPZ	VTNR	JR	EQ			AND	0	0
5	JGTSADR	MANDT	JL	EQ				0	0
6	JHTMGPZ	MANDT	JR	EQ			AND	0	0
7	JGTSADR	GP_REF	JL	EQ				0	0
8	JHTMGPZ	GPNR	JR	EQ			AND	0	0
9	JHTMXK	AUFSTATUS		NE	'2'		AND	0	0
10	JGTSADR	HERK		EQ	'1'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	JHTMGPZ	MANDT		☐	MANDT	☐	Client
2	VTNR	JHTMGPZ	VTNR		☐	MM_VTNR	☐	IS-M: Contract Number for Media-Mix Contract
3	GPROLLE	JHTMGPZ	GPROLLE		☐	JHPARVW	☐	IS-M: Partner Role (Such As BU for Voucher Copy Recipient)
4	GPNR	JHTMGPZ	GPNR		☐	JHVGPZNR	☐	IS-M/AM: Assigned Business Partner in the Contract
5	ADRNR	JGTSADR	ADRNR		☐	JADRNR	☐	IS-M: Address Number
6	*	JHTMXK	*		☐		☐
7	-	JHTMXK	MANDT		☐	MANDT	☐	Client
8	-	JHTMXK	VTNR		☐	MM_VTNR	☐	IS-M: Contract Number for Media-Mix Contract
9	MXART	JHTMXK	MXART		☐	JH_MXART	☐	IS-M: Type of Media-Mix Contract Creation
10	PAKNR	JHTMXK	PAKNR		☐	JH_MXPAKNR	☐	IS-M: Number of a media-mix package
11	KAUSSCHL	JHTMXK	KAUSSCHL		☐	JH_KAUSSCHL	☐	IS-M: Condition Exclusion Rule for Media-Mix Contract
12	ERFREGEL	JHTMXK	ERFREGEL		☐	JH_ERFREGEL	☐	IS-M: Fulfillment Rule for Media-Mix Contract
13	BESTIMMTER	JHTMXK	BESTIMMTER		☐	ABS_VTNR	☐	IS-M: Contract Number
14	MENGE1	JHTMXK	MENGE1		☐	JH_ZIELMAL	☐	IS-M/AM: Target Number in the Contract
15	EINH1	JHTMXK	EINH1		☐	AB_MALEINH	☐	IS-M/AM: Unit for Target Number in Contract
16	MENGE2	JHTMXK	MENGE2		☐	JH_ZIELMNG	☐	IS-M/AM: Target Quantity in the Contract
17	EINH2	JHTMXK	EINH2		☐	AB_MNGEINH	☐	IS-M/AM: Unit for Target Quantity in the Contract
18	UMSATZ	JHTMXK	UMSATZ		☐	AB_ZIEL1	☐	IS-M/AM: Target Quantity for Monetary Contract
19	WEINH	JHTMXK	WEINH		☐	AB_WEINH	☐	IS-M: Currency Key for Contract
20	ABRSTATUS	JHTMXK	ABRSTATUS		☐	JH_ABRSTATUS	☐	IS-M: Settlement Status of a Contract
21	AUFSTATUS	JHTMXK	AUFSTATUS		☐	JH_AUFSTATUS	☐	IS-M: Explode Status of a Media-Mix COA
22	ERFUSER	JHTMXK	ERFUSER		☐	ERFUSER	☐	Created By
23	ERFDATE	JHTMXK	ERFDATE		☐	ERFDATE	☐	Created On
24	ERFTIME	JHTMXK	ERFTIME		☐	ERFTIME	☐	Time Created
25	AENUSER	JHTMXK	AENUSER		☐	AENUSER	☐	Last Changed By
26	AENDATE	JHTMXK	AENDATE		☐	AENDATE	☐	Date of Last Change
27	AENTIME	JHTMXK	AENTIME		☐	AENTIME	☐	Time of Last Change
28	XLOEVM	JHTMXK	XLOEVM		☐	LOEVM_ISP	☐	Deletion Flag for Master Data in Media Sales & Distribution
29	VKORG	JHTMXK	VKORG		☐	VKORG	☐	Sales Organization
30	ABSTYP	JHTMXK	ABSTYP		☐	ABS_TYP	☐	IS-M/AM: Contract Category
31	ABSART	JHTMXK	ABSART		☐	JH_ABSART	☐	IS-M: Contract Type
32	RABANP	JHTMXK	RABANP		☐	RABATTANP	☐	IS-M: Disc./Price Adjustment During Contract Validity Period
33	LFZBEG	JHTMXK	LFZBEG		☐	LFZBEG	☐	IS-M: Start of Validity Period
34	LFZEND	JHTMXK	LFZEND		☐	LFZEND	☐	IS-M: End of Validity Period
35	ABRGNR	JHTMXK	ABRGNR		☐	ABRGNR	☐	IS-M/AM: Contract Settlement Number
36	NAME1	JGTSADR	NAME1		☐	NAME1_ISP	☐	IS-M: Business Partner Name
37	NAME2	JGTSADR	NAME2		☐	NAME2_ISP	☐	IS-M: First Name of Business Partner

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