MTMVALUE

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MTMVALUE (
    CONDITIONTYPE,
    ENDOFDAYSNAPSHOTDATE,
    PRICINGDOCUMENTITEM,
    PRICINGKEY,
    SCENARIO,
    SUBCONDITIONTYPE,
    VALUATIONDATE,
    VERSION,
    VERSSTOCKRECORDUUID,
    BASISMARKETREFADJUSTMENTSPREAD,
    BASISMARKETREFKEYDATE,
    BASISMARKETREFRATE,
    BASISMARKETREFRATECURRENCY,
    BASISTYPE,
    BATCH,
    BSMKTREFDRVTVCONTRMATURITYCODE,
    BUSINESSAREA,
    CMMDTYDOCUMENTEXTERNALNUMBER,
    CMMDTYENDOFDAYBUSINESSENTYKEY,
    CMMDTYFORWARDINDEXTIMING,
    CMMDTYPRICEEXPSRMASSUNIT,
    CMMDTYPRICEEXPSRQTYINMASSUNIT,
    CMMDTYPRICEEXPSRQTYINVOLUNIT,
    CMMDTYPRICEEXPSRVOLUMEUNIT,
    CMMDTYROOTDOCEXTERNALNUMBER,
    CNDNTERMEXCHRATEFIXATIONDATE,
    CNDNTERMEXCHRATEFIXATIONTIME,
    CNDNTERMRATEFIXATIONDATE,
    CNDNTERMRATEFIXATIONTIME,
    CNDNTOSTSTCEXCHANGERATETYPE,
    COMMODITYCONTRACTMATURITYCODE,
    COMMODITYQUANTITYINBASEUNIT,
    COMMODITYQUANTITYINTERMUNIT,
    CONDITIONAPPLICATION,
    CONDITIONTERMEXCHRATEISFIXED,
    CONDITIONTERMFACTOR,
    CONDITIONTERMRATECURRENCY,
    CONDITIONTERMRATEFIXATION,
    CONDITIONTERMRATEISFIXED,
    CONDITIONTERMRATEQUANTITY,
    CONDITIONTERMRATEQUANTITYUNIT,
    CONDITIONTERMVALUECURRENCY,
    CONDITIONTERMVALUEINDOCCRCY,
    CONDITIONTERMVALUEINSTSTCCRCY,
    CONDITIONTODOCEXCHANGERATETYPE,
    CONTRPRICEEXPOSUREISEXECUTED,
    CREDITOR,
    DATASELECTIONTYPE,
    DELIVERYDATE,
    DELIVERYMONTH,
    DELIVERYYEAR,
    DERIVATIVECONTRACTMATURITYCODE,
    DERIVATIVECONTRSPECIFICATION,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    DOCTOSTATISTICALEXCHRATE,
    DOCTOSTATISTICALEXCHRATEDATE,
    DOCTOSTSTCCRCYEXCHRATEEVALDATE,
    DOCTOSTSTCEXCHANGERATETYPE,
    DOCUMENTCURRENCY,
    ENDOFDAYBUSINESSENTITYKEY,
    ENDOFDAYSNAPSHOTDATETIMEFROM,
    ENDOFDAYSNAPSHOTDATETIMETO,
    ENDOFDAYTIMESTAMPFROM,
    ENDOFDAYTIMESTAMPTO,
    EXCHRATEEVALUATIONDATE,
    EXCHRATEMATURITYDATE,
    EXPECTEDPAYMENTDATE,
    FIXEDEXCHRATEDATE,
    FXVALUATIONDATE,
    FXVALUATIONDATEDOCTOSTSTC,
    GOODSMOVEMENTTYPE,
    HASERROR,
    INCOTERMSCLASSIFICATION,
    INCOTERMSTRANSFERLOCATION,
    ISINTERCOMPANYTRANSFER,
    MARKETCURRENCY,
    MARKETIDENTIFIERCODE,
    MARKETPRICECURRENCY,
    MARKETTODOCEXCHRATE,
    MARKETTODOCEXCHRATEDATE,
    MARKETTODOCFROZENEXCHRATE,
    MARKETTOTERMEXCHANGERATETYPE,
    MATERIAL,
    MATERIALBASEUNIT,
    MATERIALGROUP,
    MATURITYKEYDATE,
    MAXIMUMVERSION,
    MTMADJUSTMENTTYPE,
    MTMCALCGRPMARKETPRICECONDITION,
    MTMCALCULATIONGROUP,
    MTMCONDITIONGROUP,
    MTMCONDITIONGROUPCATEGORY,
    MTMDATASOURCETYPE,
    OLDESTQUOTATIONDATE,
    ORIGINREFERENCEDOCBUSOBJTYPE,
    ORIGINREFERENCEDOCUMENT,
    ORIGINREFERENCEDOCUMENTITEM,
    ORIGNREFDOCUMENTSHORTNUMBER,
    PHYSICALCOMMODITY,
    PLANT,
    PREVIOUSSUBCONDITIONTYPE,
    PREVIOUSVERSION,
    PREVIOUSVERSIONQUANTITYSIGN,
    PREVVERSCNDNTERMRATECURRENCY,
    PREVVERSIONCOMMODITYQUANTITY,
    PREVVERSIONCONDITIONTERMVALUE,
    PRICEDCONTRACTQUANTITY,
    PRICEDCONTRACTQUANTITYINMASS,
    PRICEDCONTRACTQUANTITYINVOL,
    PRICEDDAYS,
    PRICESETTINGMETHOD,
    PRICESETTINGMETHODSTATUS,
    PRICINGCONDITIONTERM,
    PRICINGPROCEDURE,
    PRICINGSTATUS,
    PROFITCENTER,
    PURCHASINGORGANIZATION,
    QUOTATIONCURRENCY,
    QUOTATIONPERIODENDDATE,
    QUOTATIONPERIODREFERENCEDATE,
    QUOTATIONPERIODSTARTDATE,
    QUOTATIONPRICETYPE,
    REFERENCEDOCBUSOBJTYPE,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTITEM,
    SALESORGANIZATION,
    SNAPSHOTDATE0,
    SNAPSHOTDATE1,
    SOLDTOPARTY,
    SOURCEDOCUMENT,
    SOURCEDOCUMENTBUSOBJTYPE,
    SOURCEDOCUMENTITEM,
    SOURCEDOCUMENTSHORTNUMBER,
    STATISTICSCURRENCY,
    STORAGELOCATION,
    SYSTEMMESSAGENUMBER,
    TODAYDAYS,
    TODAYPRICEDQUANTITY,
    TODAYPRICEDQUANTITYINMASS,
    TODAYPRICEDQUANTITYINVOL,
    UNPRICEDCONTRACTQUANTITY,
    UNPRICEDCONTRACTQUANTITYINMASS,
    UNPRICEDCONTRACTQUANTITYINVOL,
    UNPRICEDDAYS,
    VALIDITYSTARTDATE,
    VALIDITYSTARTDATETIME,
    VALIDTODATETIME,
    PRIMARY KEY (CONDITIONTYPE, ENDOFDAYSNAPSHOTDATE, PRICINGDOCUMENTITEM, PRICINGKEY, SCENARIO, SUBCONDITIONTYPE, VALUATIONDATE, VERSION, VERSSTOCKRECORDUUID)
);