1. Home
  2. Resources
  3. SAP Tables
  4. JJTMXB - IS-M: Media-Mix Package Element

SAP Table JJTMXB

IS-M: Media-Mix Package Element

JJTMXB (IS-M: Media-Mix Package Element) 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 JJTMXB to other SAP tables.

JJTMXB 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 JJTMXK CHAR 10 0
BESNR IS-M: Media-Mix Package Element Number JH_MXBESNR NUMC 3 0
VKORG Sales Organization VKORG TVTA CHAR 4 0
VTWEG Distribution Channel VTWEG TVTA CHAR 2 0
SPART Division SPART TVTA CHAR 2 0
VKBUR Sales Office VKBUR TVKBZ CHAR 4 0
VKGRP Sales Group VKGRP TVBVK CHAR 3 0
ABSTYP IS-M/AM: Contract Category ABS_TYP JJVV4_ABSTYP CHAR 1 0
ABSART IS-M: Contract Type JH_ABSART CHAR 1 0
0 Discount/Bonus Contract
1 Fixed Quantity Price Contract
2 Customer Bonus Contract
3 Scale Basis Contract
XRABAEN IS-M/AM: Discount Changed Manually XRABAEN CHAR 1 0
X Yes
NULL No
RABANP IS-M: Disc./Price Adjustment During Contract Validity Period RABATTANP CHAR 1 0
0 No adjustment
1 For each order
2 During interim settlement
3 No adjustment, no overfulfillment
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
RABATT IS-M: Agreed Discount VRABATT DEC 5 2
BONUS IS-M: Agreed Bonus VBONUS DEC 5 2
FMPREIS IS-M: Agreed Price from Contract AB_VPREIS CURR 15 2
FMP_KPEIN Condition pricing unit KPEIN DEC 5 0
FMP_KMEIN Condition unit KMEIN T006 UNIT 3 0

JJTMXB foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
JJTMXB ABSTYP JJTMXB MANDT JJVV4_ABSTYP Generated Table for View MANDT
JJTMXB ABSTYP JJTMXK ERFREGEL JJVV4_ABSTYP Generated Table for View ERFREGEL
JJTMXB ABSTYP JJTMXB ABSTYP JJVV4_ABSTYP Generated Table for View ABSTYP
JJTMXB ABSTYP * JJVV4_ABSTYP Generated Table for View SPRAS
JJTMXB EINH1 * JJV006DL Generated Table for View SPRAS
JJTMXB EINH1 SYST MANDT JJV006DL Generated Table for View MANDT
JJTMXB EINH1 JJTMXB EINH1 JJV006DL Generated Table for View MSEHI
JJTMXB EINH2 * JJV006 Generated Table for View DIMID
JJTMXB EINH2 JJTMXB EINH2 JJV006 Generated Table for View MSEHI
JJTMXB EINH2 * JJV006 Generated Table for View SPRAS
JJTMXB EINH2 SYST MANDT JJV006 Generated Table for View MANDT
JJTMXB FMP_KMEIN SYST MANDT T006 Units of Measurement MANDT
JJTMXB FMP_KMEIN JJTMXB FMP_KMEIN T006 Units of Measurement MSEHI
JJTMXB MANDT JJTMXB MANDT T000 Clients MANDT
JJTMXB PAKNR JJTMXB MANDT JJTMXK IS-M: Media-Mix Package Header MANDT
JJTMXB PAKNR JJTMXB PAKNR JJTMXK IS-M: Media-Mix Package Header PAKNR
JJTMXB SPART SYST MANDT TVTA Organizational Unit: Sales Area(s) MANDT
JJTMXB SPART JJTMXB VKORG TVTA Organizational Unit: Sales Area(s) VKORG
JJTMXB SPART JJTMXB VTWEG TVTA Organizational Unit: Sales Area(s) VTWEG
JJTMXB SPART JJTMXB SPART TVTA Organizational Unit: Sales Area(s) SPART
JJTMXB VKBUR JJTMXB SPART TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit SPART
JJTMXB VKBUR JJTMXB VKBUR TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit VKBUR
JJTMXB VKBUR SYST MANDT TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit MANDT
JJTMXB VKBUR JJTMXB VKORG TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit VKORG
JJTMXB VKBUR JJTMXB VTWEG TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit VTWEG
JJTMXB VKGRP JJTMXB VKBUR TVBVK Organizational Unit: Sales Groups per Sales Office VKBUR
JJTMXB VKGRP JJTMXB VKGRP TVBVK Organizational Unit: Sales Groups per Sales Office VKGRP
JJTMXB VKGRP SYST MANDT TVBVK Organizational Unit: Sales Groups per Sales Office MANDT
JJTMXB VKORG SYST MANDT TVTA Organizational Unit: Sales Area(s) MANDT
JJTMXB VKORG JJTMXB VKORG TVTA Organizational Unit: Sales Area(s) VKORG
JJTMXB VKORG JJTMXB VTWEG TVTA Organizational Unit: Sales Area(s) VTWEG
JJTMXB VKORG JJTMXB SPART TVTA Organizational Unit: Sales Area(s) SPART
JJTMXB VTWEG JJTMXB VKORG TVTA Organizational Unit: Sales Area(s) VKORG
JJTMXB VTWEG JJTMXB VTWEG TVTA Organizational Unit: Sales Area(s) VTWEG
JJTMXB VTWEG JJTMXB SPART TVTA Organizational Unit: Sales Area(s) SPART
JJTMXB VTWEG SYST MANDT TVTA Organizational Unit: Sales Area(s) MANDT
JJTMXB WEINH SYST MANDT TCURC Currency Codes MANDT
JJTMXB WEINH JJTMXB WEINH TCURC Currency Codes WAERS