MTMPHY

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 MTMPHY (
    COMPANYCODE,
    CONDITIONTYPE,
    ENDOFDAYSNAPSHOTDATE,
    PRICINGDOCUMENTITEM,
    PRICINGKEY,
    SUBCONDITIONTYPE,
    VERSION,
    VERSSTOCKRECORDUUID,
    BASISID,
    BASISMARKETREFADJUSTMENTSPREAD,
    BASISMARKETREFKEYDATE,
    BASISMARKETREFRATE,
    BASISMARKETREFRATECURRENCY,
    BASISTYPE,
    BATCH,
    BSMKTREFDRVTVCONTRMATURITYCODE,
    BUSINESSAREA,
    CNDNTERMEXCHRATEFIXATIONDATE,
    CNDNTERMEXCHRATEFIXATIONTIME,
    CNDNTERMRATEFIXATIONDATE,
    CNDNTERMRATEFIXATIONTIME,
    COMMODITYQUANTITYINTERMUNIT,
    CONDITIONAPPLICATION,
    CONDITIONTERMEXCHRATEISFIXED,
    CONDITIONTERMFACTOR,
    CONDITIONTERMRATE,
    CONDITIONTERMRATECURRENCY,
    CONDITIONTERMRATEFIXATION,
    CONDITIONTERMRATEISFIXED,
    CONDITIONTERMRATEQUANTITY,
    CONDITIONTERMRATEQUANTITYUNIT,
    CONDITIONTERMVALUECURRENCY,
    CONDITIONTERMVALUEINDOCCRCY,
    CONDITIONTERMVALUEINSTSTCCRCY,
    CREDITOR,
    DELIVERYDATE,
    DELIVERYMONTH,
    DELIVERYYEAR,
    DERIVATIVECONTRACTMATURITYCODE,
    DERIVATIVECONTRSPECIFICATION,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    DOCTOSTATISTICALEXCHRATE,
    DOCTOSTSTCCRCYEXCHRATEEVALDATE,
    DOCUMENTCURRENCY,
    ENDOFDAYSNAPSHOTDATETIMEFROM,
    ENDOFDAYSNAPSHOTDATETIMETO,
    EXCHRATEEVALUATIONDATE,
    EXCHRATEMATURITYDATE,
    EXPECTEDPAYMENTDATE,
    GOODSMOVEMENTTYPE,
    HASERROR,
    INCOTERMSCLASSIFICATION,
    INCOTERMSTRANSFERLOCATION,
    ISINTERCOMPANYTRANSFER,
    MARKETIDENTIFIERCODE,
    MARKETPRICECURRENCY,
    MARKETTODOCEXCHRATE,
    MARKETTODOCFROZENEXCHRATE,
    MATERIAL,
    MATERIALGROUP,
    MATURITYKEYDATE,
    MTMADJUSTMENTTYPE,
    MTMCALCGRPMARKETPRICECONDITION,
    MTMCALCULATIONGROUP,
    MTMCONDITIONGROUP,
    MTMCONDITIONGROUPCATEGORY,
    MTMDATASOURCETYPE,
    OLDESTQUOTATIONDATE,
    ORIGINREFERENCEDOCBUSOBJTYPE,
    ORIGINREFERENCEDOCUMENT,
    ORIGINREFERENCEDOCUMENTITEM,
    ORIGNREFDOCUMENTSHORTNUMBER,
    PHYSICALCOMMODITY,
    PLANT,
    PRICINGSTATUS,
    PROFITCENTER,
    PURCHASINGORGANIZATION,
    QUOTATIONPERIODREFERENCEDATE,
    QUOTATIONPRICETYPE,
    REFERENCEDOCBUSOBJTYPE,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTITEM,
    SALESORGANIZATION,
    SOLDTOPARTY,
    SOURCEDOCUMENT,
    SOURCEDOCUMENTBUSOBJTYPE,
    SOURCEDOCUMENTITEM,
    SOURCEDOCUMENTSHORTNUMBER,
    STATISTICSCURRENCY,
    STORAGELOCATION,
    SYSTEMMESSAGENUMBER,
    VALIDITYSTARTDATE,
    PRIMARY KEY (COMPANYCODE, CONDITIONTYPE, ENDOFDAYSNAPSHOTDATE, PRICINGDOCUMENTITEM, PRICINGKEY, SUBCONDITIONTYPE, VERSION, VERSSTOCKRECORDUUID)
);