SAP Table JJTMXK
IS-M: Media-Mix Package Header
JJTMXK (IS-M: Media-Mix Package Header) 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 JJTMXK to other SAP tables.
JJTMXK table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values |
|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |
|
PAKNR
IS-M: Number of a media-mix package
|
JH_MXPAKNR |
CHAR
|
10 | 0 | ||
|
KURZTEXT
IS-M: Short Text
|
BEZEICHN15 |
CHAR
|
15 | 0 | ||
|
LANGTEXT
IS-M: Long Text
|
BEZEICHN50 |
CHAR
|
50 | 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 | |
|
MMIXPRUEF
IS-M: Check during use of a media-mix package
|
JH_MMIXPRUEF | TJJV8 |
CHAR
|
2 | 0 | |
|
VKORG
Sales Organization
|
VKORG | TVKO |
CHAR
|
4 | 0 | |
|
LFZBEG
IS-M: Start of Validity Period for a Media-Mix Package
|
JH_LFZBEG_MIN |
DATS
|
8 | 0 | ||
|
LFZEND
IS-M: End of Validity Period for a Media-Mix COA
|
JH_LFZEND_MAX |
DATS
|
8 | 0 | ||
|
MXART
IS-M: Type of Media-Mix Contract Creation
|
JH_MXART | TJJV4 |
CHAR
|
4 | 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 |
JJTMXK foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| JJTMXK | EINH1 | * |
JJV006DL
Generated Table for View
|
SPRAS | |
| JJTMXK | EINH1 | SYST | MANDT |
JJV006DL
Generated Table for View
|
MANDT |
| JJTMXK | EINH1 | JJTMXK | EINH1 |
JJV006DL
Generated Table for View
|
MSEHI |
| JJTMXK | EINH2 | SYST | MANDT |
JJV006
Generated Table for View
|
MANDT |
| JJTMXK | EINH2 | * |
JJV006
Generated Table for View
|
DIMID | |
| JJTMXK | EINH2 | JJTMXK | EINH2 |
JJV006
Generated Table for View
|
MSEHI |
| JJTMXK | EINH2 | * |
JJV006
Generated Table for View
|
SPRAS | |
| JJTMXK | ERFREGEL | JJTMXK | MANDT |
TJJV6
IS-M: Fulfillment Rules for Media-Mix Contracts
|
MANDT |
| JJTMXK | ERFREGEL | JJTMXK | ERFREGEL |
TJJV6
IS-M: Fulfillment Rules for Media-Mix Contracts
|
ERFREGEL |
| JJTMXK | KAUSSCHL | JJTMXK | MANDT |
TJJV5
IS-M: Condition Exclusion Rule
|
MANDT |
| JJTMXK | KAUSSCHL | JJTMXK | KAUSSCHL |
TJJV5
IS-M: Condition Exclusion Rule
|
KAUSSCHL |
| JJTMXK | MANDT | JJTMXK | MANDT |
T000
Clients
|
MANDT |
| JJTMXK | MMIXPRUEF | JJTMXK | MANDT |
TJJV8
IS-M: Checks for the Use of Media-Mix Packages
|
MANDT |
| JJTMXK | MMIXPRUEF | JJTMXK | MMIXPRUEF |
TJJV8
IS-M: Checks for the Use of Media-Mix Packages
|
MMIXPRUEF |
| JJTMXK | MXART | JJTMXK | MXART |
TJJV4
IS-M: Type of Media-Mix COA Creation
|
MXART |
| JJTMXK | MXART | JJTMXK | MANDT |
TJJV4
IS-M: Type of Media-Mix COA Creation
|
MANDT |
| JJTMXK | VKORG | JJTMXK | MANDT |
TVKO
Organizational Unit: Sales Organizations
|
MANDT |
| JJTMXK | VKORG | JJTMXK | VKORG |
TVKO
Organizational Unit: Sales Organizations
|
VKORG |
| JJTMXK | WEINH | SYST | MANDT |
TCURC
Currency Codes
|
MANDT |
| JJTMXK | WEINH | JJTMXK | WEINH |
TCURC
Currency Codes
|
WAERS |