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 | |||
|---|---|---|---|---|---|---|---|---|
| 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 | SYST | MANDT | JJV006DL | Generated Table for View | MANDT |
| JJTMXK | EINH1 | JJTMXK | EINH1 | JJV006DL | Generated Table for View | MSEHI |
| JJTMXK | EINH1 | * | JJV006DL | Generated Table for View | SPRAS | |
| JJTMXK | EINH2 | * | JJV006 | Generated Table for View | SPRAS | |
| 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 | 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 | MANDT | TJJV4 | IS-M: Type of Media-Mix COA Creation | MANDT |
| JJTMXK | MXART | JJTMXK | MXART | TJJV4 | IS-M: Type of Media-Mix COA Creation | MXART |
| JJTMXK | VKORG | JJTMXK | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
| JJTMXK | VKORG | JJTMXK | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
| JJTMXK | WEINH | SYST | MANDT | TCURC | Currency Codes | MANDT |
| JJTMXK | WEINH | JJTMXK | WEINH | TCURC | Currency Codes | WAERS |
