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 | Possible values | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||||
|
||||||||||||||||
|
AUFSTATUS
IS-M: Explode Status of a Media-Mix COA
|
JH_AUFSTATUS |
NUMC
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
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 | ||||||||||||
|
||||||||||||||||
|
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 | ||||||||||||
|
||||||||||||||||
|
RABANP
IS-M: Disc./Price Adjustment During Contract Validity Period
|
RABATTANP |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
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 | MANDT |
TJH11
IS-M/AM: Data Table for Contract Category
|
MANDT |
| JHTMXK | ABSTYP | JHTMXK | ABSTYP |
TJH11
IS-M/AM: Data Table for Contract Category
|
ABS_TYP |
| JHTMXK | BESTIMMTER | JHTMXK | MANDT |
JHTVKO
IS-M/AM: Contract
|
MANDT |
| JHTMXK | BESTIMMTER | JHTMXK | BESTIMMTER |
JHTVKO
IS-M/AM: Contract
|
VTNR |
| JHTMXK | EINH1 | SYST | MANDT |
JJV006DL
Generated Table for View
|
MANDT |
| JHTMXK | EINH1 | JHTMXK | EINH1 |
JJV006DL
Generated Table for View
|
MSEHI |
| JHTMXK | EINH1 | * |
JJV006DL
Generated Table for View
|
SPRAS | |
| JHTMXK | EINH2 | JHTMXK | EINH2 |
JJV006
Generated Table for View
|
MSEHI |
| JHTMXK | EINH2 | * |
JJV006
Generated Table for View
|
SPRAS | |
| JHTMXK | EINH2 | SYST | MANDT |
JJV006
Generated Table for View
|
MANDT |
| JHTMXK | EINH2 | * |
JJV006
Generated Table for View
|
DIMID | |
| 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 |