SAP Table JHTMXK
IS-M: Media-Mix Contract Header Data
JHTMXK (IS-M: Media-Mix Contract Header Data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link JHTMXK to other SAP tables.
JHTMXK table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||
| VTNR | IS-M: Contract Number for Media-Mix Contract | MM_VTNR | CHAR | 10 | 0 | |||||||||||
| MXART | IS-M: Type of Media-Mix Contract Creation | JH_MXART | TJJV4 | CHAR | 4 | 0 | ||||||||||
| PAKNR | IS-M: Number of a media-mix package | JH_MXPAKNR | JJTMXK | CHAR | 10 | 0 | ||||||||||
| KAUSSCHL | IS-M: Condition Exclusion Rule for Media-Mix Contract | JH_KAUSSCHL | TJJV5 | CHAR | 1 | 0 | ||||||||||
| ERFREGEL | IS-M: Fulfillment Rule for Media-Mix Contract | JH_ERFREGEL | TJJV6 | CHAR | 1 | 0 | ||||||||||
| BESTIMMTER | IS-M: Contract Number | ABS_VTNR | JHTVKO | NUMC | 6 | 0 | ||||||||||
| MENGE1 | IS-M/AM: Target Number in the Contract | JH_ZIELMAL | DEC | 5 | 0 | |||||||||||
| EINH1 | IS-M/AM: Unit for Target Number in Contract | AB_MALEINH | JJV006DL | UNIT | 3 | 0 | ||||||||||
| MENGE2 | IS-M/AM: Target Quantity in the Contract | JH_ZIELMNG | QUAN | 12 | 3 | |||||||||||
| EINH2 | IS-M/AM: Unit for Target Quantity in the Contract | AB_MNGEINH | JJV006 | UNIT | 3 | 0 | ||||||||||
| UMSATZ | IS-M/AM: Target Quantity for Monetary Contract | AB_ZIEL1 | CURR | 15 | 2 | |||||||||||
| WEINH | IS-M: Currency Key for Contract | AB_WEINH | TCURC | CUKY | 5 | 0 | ||||||||||
| ABRSTATUS | IS-M: Settlement Status of a Contract | JH_ABRSTATUS | NUMC | 1 | 0 |
Possible values
|
||||||||||
| AUFSTATUS | IS-M: Explode Status of a Media-Mix COA | JH_AUFSTATUS | NUMC | 1 | 0 |
Possible values
|
||||||||||
| ERFUSER | Created By | ERFUSER | CHAR | 12 | 0 | |||||||||||
| ERFDATE | Created On | ERFDATE | DATS | 8 | 0 | |||||||||||
| ERFTIME | Time Created | ERFTIME | TIMS | 6 | 0 | |||||||||||
| AENUSER | Last Changed By | AENUSER | CHAR | 12 | 0 | |||||||||||
| AENDATE | Date of Last Change | AENDATE | DATS | 8 | 0 | |||||||||||
| AENTIME | Time of Last Change | AENTIME | TIMS | 6 | 0 | |||||||||||
| XLOEVM | Deletion Flag for Master Data in Media Sales & Distribution | LOEVM_ISP | CHAR | 1 | 0 |
Possible values
|
||||||||||
| VKORG | Sales Organization | VKORG | TVKO | CHAR | 4 | 0 | ||||||||||
| ABSTYP | IS-M/AM: Contract Category | ABS_TYP | TJH11 | CHAR | 1 | 0 | ||||||||||
| ABSART | IS-M: Contract Type | JH_ABSART | CHAR | 1 | 0 |
Possible values
|
||||||||||
| RABANP | IS-M: Disc./Price Adjustment During Contract Validity Period | RABATTANP | CHAR | 1 | 0 |
Possible values
|
||||||||||
| LFZBEG | IS-M: Start of Validity Period | LFZBEG | DATS | 8 | 0 | |||||||||||
| LFZEND | IS-M: End of Validity Period | LFZEND | DATS | 8 | 0 | |||||||||||
| ABRGNR | IS-M/AM: Contract Settlement Number | ABRGNR | NUMC | 4 | 0 | |||||||||||
JHTMXK foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| JHTMXK | ABSTYP | JHTMXK | ABSTYP | TJH11 | IS-M/AM: Data Table for Contract Category | ABS_TYP |
| JHTMXK | ABSTYP | JHTMXK | MANDT | TJH11 | IS-M/AM: Data Table for Contract Category | MANDT |
| JHTMXK | BESTIMMTER | JHTMXK | MANDT | JHTVKO | IS-M/AM: Contract | MANDT |
| JHTMXK | BESTIMMTER | JHTMXK | BESTIMMTER | JHTVKO | IS-M/AM: Contract | VTNR |
| JHTMXK | EINH1 | * | JJV006DL | Generated Table for View | SPRAS | |
| JHTMXK | EINH1 | SYST | MANDT | JJV006DL | Generated Table for View | MANDT |
| JHTMXK | EINH1 | JHTMXK | EINH1 | JJV006DL | Generated Table for View | MSEHI |
| JHTMXK | EINH2 | SYST | MANDT | JJV006 | Generated Table for View | MANDT |
| JHTMXK | EINH2 | * | JJV006 | Generated Table for View | DIMID | |
| JHTMXK | EINH2 | JHTMXK | EINH2 | JJV006 | Generated Table for View | MSEHI |
| JHTMXK | EINH2 | * | JJV006 | Generated Table for View | SPRAS | |
| JHTMXK | ERFREGEL | JHTMXK | MANDT | TJJV6 | IS-M: Fulfillment Rules for Media-Mix Contracts | MANDT |
| JHTMXK | ERFREGEL | JHTMXK | ERFREGEL | TJJV6 | IS-M: Fulfillment Rules for Media-Mix Contracts | ERFREGEL |
| JHTMXK | KAUSSCHL | JHTMXK | MANDT | TJJV5 | IS-M: Condition Exclusion Rule | MANDT |
| JHTMXK | KAUSSCHL | JHTMXK | KAUSSCHL | TJJV5 | IS-M: Condition Exclusion Rule | KAUSSCHL |
| JHTMXK | MANDT | JHTMXK | MANDT | T000 | Clients | MANDT |
| JHTMXK | MXART | JHTMXK | MANDT | TJJV4 | IS-M: Type of Media-Mix COA Creation | MANDT |
| JHTMXK | MXART | JHTMXK | MXART | TJJV4 | IS-M: Type of Media-Mix COA Creation | MXART |
| JHTMXK | PAKNR | JHTMXK | MANDT | JJTMXK | IS-M: Media-Mix Package Header | MANDT |
| JHTMXK | PAKNR | JHTMXK | PAKNR | JJTMXK | IS-M: Media-Mix Package Header | PAKNR |
| JHTMXK | VKORG | JHTMXK | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
| JHTMXK | VKORG | JHTMXK | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
| JHTMXK | WEINH | SYST | MANDT | TCURC | Currency Codes | MANDT |
| JHTMXK | WEINH | JHTMXK | WEINH | TCURC | Currency Codes | WAERS |
