ITEMQUOT

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 ITEMQUOT (
    CONDITIONTYPE,
    FXVALUATIONDATE,
    FXVALUATIONDATEDOCTOSTSTC,
    PRICINGDOCUMENTITEM,
    QUOTATIONGROUPITEM,
    SCENARIO,
    SUBCONDITIONTYPE,
    VALUATIONDATE,
    VERSION,
    BASISID,
    BASISMARKETREFADJUSTMENTSPREAD,
    BASISMARKETREFKEYDATE,
    BASISMARKETREFRATE,
    BASISMARKETREFRATECURRENCY,
    BASISTYPE,
    BATCH,
    BSMKTREFDRVTVCONTRMATURITYCODE,
    BUSINESSAREA,
    CMMDTYFORWARDINDEXTIMING,
    CNDNTERMEXCHRATEFIXATIONDATE,
    CNDNTERMEXCHRATEFIXATIONTIME,
    CNDNTERMRATEFIXATIONDATE,
    CNDNTERMRATEFIXATIONTIME,
    COMMODITYCONTRACTMATURITYCODE,
    COMMODITYQUANTITYINTERMUNIT,
    COMMODITYUNIT,
    CONDITIONAPPLICATION,
    CONDITIONTERMEXCHRATEISFIXED,
    CONDITIONTERMEXTENSIONUSAGE,
    CONDITIONTERMNAME,
    CONDITIONTERMRATECURRENCY,
    CONDITIONTERMRATEDNMNTR,
    CONDITIONTERMRATEFIXATION,
    CONDITIONTERMRATEISFIXED,
    CONDITIONTERMRATEISROUNDED,
    CONDITIONTERMRATENMRTR,
    CONDITIONTERMRATEQUANTITY,
    CONDITIONTERMRATEQUANTITYUNIT,
    CONDITIONTERMSTATUS,
    CONDITIONTERMVALUE,
    CONDITIONTERMVALUECURRENCY,
    CREDITOR,
    DATASELECTIONTYPE,
    DELIVERYDATE,
    DERIVATIVECONTRSPECIFICATION,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    DOCUMENTCURRENCY,
    ENDOFDAYBUSINESSENTITYKEY,
    ENDOFDAYSNAPSHOTDATE,
    ENDOFDAYTIMESTAMPFROM,
    ENDOFDAYTIMESTAMPTO,
    EXCHRATEMATURITYDATE,
    EXPECTEDPAYMENTDATE,
    FIXEDEXCHRATEDATE,
    INCOTERMSCLASSIFICATION,
    INCOTERMSTRANSFERLOCATION,
    ISINTERCOMPANYTRANSFER,
    MARKETIDENTIFIERCODE,
    MATERIAL,
    MATERIALGROUP,
    MATURITYKEYDATE,
    MAXIMUMVERSION,
    MTMADJUSTMENTTYPE,
    MTMCALCGRPMARKETPRICECONDITION,
    MTMCALCULATIONGROUP,
    MTMCONDITIONGROUP,
    MTMCONDITIONGROUPCATEGORY,
    MTMDATASOURCETYPE,
    OLDCONDITIONTERMRATE,
    OLDCONDITIONTERMVALUE,
    ORIGINREFERENCEDOCBUSOBJTYPE,
    ORIGINREFERENCEDOCUMENT,
    ORIGINREFERENCEDOCUMENTITEM,
    PHYSICALCOMMODITY,
    PLANT,
    PREVIOUSSUBCONDITIONTYPE,
    PREVIOUSVERSION,
    PREVIOUSVERSIONQUANTITYSIGN,
    PREVVERSCNDNTERMRATECURRENCY,
    PREVVERSIONCOMMODITYQUANTITY,
    PREVVERSIONCONDITIONTERMVALUE,
    PRICINGSTATUS,
    PROFITCENTER,
    PURCHASINGORGANIZATION,
    QUOTATIONCPEUOM,
    QUOTATIONCURRENCY,
    QUOTATIONGROUPCALCULATIONRULE,
    QUOTATIONGROUPITEMSIGN,
    QUOTATIONPERIODENDDATE,
    QUOTATIONPERIODREFERENCEDATE,
    QUOTATIONPERIODSTARTDATE,
    QUOTATIONPRICE,
    QUOTATIONPRICETYPE,
    REFERENCEDOCBUSOBJTYPE,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTITEM,
    ROUNDINGDECIMALPLACES,
    SALESORGANIZATION,
    SNAPSHOTDATE0,
    SNAPSHOTDATE1,
    SOLDTOPARTY,
    SOURCEDOCUMENT,
    SOURCEDOCUMENTBUSOBJTYPE,
    SOURCETRANSACEVENTENDDATETIME,
    SOURCETRANSACTIONEVENTDATETIME,
    STATISTICSCURRENCY,
    STORAGELOCATION,
    SYSTEMMESSAGENUMBER,
    TIMETOMATURITY,
    VALIDITYENDDATE,
    VALIDITYENDDATETIME,
    VALIDITYSTARTDATE,
    VALIDITYSTARTDATETIME,
    PRIMARY KEY (CONDITIONTYPE, FXVALUATIONDATE, FXVALUATIONDATEDOCTOSTSTC, PRICINGDOCUMENTITEM, QUOTATIONGROUPITEM, SCENARIO, SUBCONDITIONTYPE, VALUATIONDATE, VERSION)
);