SAP ABAP Table JHTMXK (IS-M: Media-Mix Contract Header Data)

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	TRANSP	Transparent table
Transparent table	JHTMXK	Table Relationship Diagram
Short Description	IS-M: Media-Mix Contract Header Data

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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
3	MXART	☐	JH_MXART	JH_MXART	CHAR	4	0	IS-M: Type of Media-Mix Contract Creation	TJJV4
4	PAKNR	☐	JH_MXPAKNR	JH_MXPAKNR	CHAR	10	0	IS-M: Number of a media-mix package	JJTMXK
5	KAUSSCHL	☐	JH_KAUSSCHL	JH_KAUSSCHL	CHAR	1	0	IS-M: Condition Exclusion Rule for Media-Mix Contract	TJJV5
6	ERFREGEL	☐	JH_ERFREGEL	JH_ERFREGEL	CHAR	1	0	IS-M: Fulfillment Rule for Media-Mix Contract	TJJV6
7	BESTIMMTER	☐	ABS_VTNR	ABS_VTNR	NUMC	6	0	IS-M: Contract Number	JHTVKO
8	.INCLUDE	☐				0	0	IS-M: Target Agreement for Contract
9	MENGE1	☐	JH_ZIELMAL	JH_ZIELMAL	DEC	5	0	IS-M/AM: Target Number in the Contract
10	EINH1	☐	AB_MALEINH	MEINS	UNIT	3	0	IS-M/AM: Unit for Target Number in Contract	JJV006DL
11	MENGE2	☐	JH_ZIELMNG	ABS_MENGE	QUAN	12	3	IS-M/AM: Target Quantity in the Contract
12	EINH2	☐	AB_MNGEINH	MEINS	UNIT	3	0	IS-M/AM: Unit for Target Quantity in the Contract	JJV006
13	UMSATZ	☐	AB_ZIEL1	WERTV8	CURR	15	2	IS-M/AM: Target Quantity for Monetary Contract
14	WEINH	☐	AB_WEINH	WAERS	CUKY	5	0	IS-M: Currency Key for Contract	TCURC
15	ABRSTATUS	☐	JH_ABRSTATUS	JH_ABRSTATUS	NUMC	1	0	IS-M: Settlement Status of a Contract
16	AUFSTATUS	☐	JH_AUFSTATUS	JH_AUFSTATUS	NUMC	1	0	IS-M: Explode Status of a Media-Mix COA
17	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
18	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
19	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
20	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
21	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
22	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
23	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
24	XLOEVM	☐	LOEVM_ISP	XFELD	CHAR	1	0	Deletion Flag for Master Data in Media Sales & Distribution
25	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
26	ABSTYP	☐	ABS_TYP	ABS_TYP	CHAR	1	0	IS-M/AM: Contract Category	TJH11
27	ABSART	☐	JH_ABSART	JH_ABSART	CHAR	1	0	IS-M: Contract Type
28	RABANP	☐	RABATTANP	JH_XRABANP	CHAR	1	0	IS-M: Disc./Price Adjustment During Contract Validity Period
29	LFZBEG	☐	LFZBEG	DATUM	DATS	8	0	IS-M: Start of Validity Period
30	LFZEND	☐	LFZEND	DATUM	DATS	8	0	IS-M: End of Validity Period
31	ABRGNR	☐	ABRGNR	ABRGNR	NUMC	4	0	IS-M/AM: Contract Settlement Number	*

Foreign Keys

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

History

Last changed by/on	SAP	20050224
SAP Release Created in