VLOGP

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 VLOGP (
    CONDITIONTYPE,
    EVALUATIONDATE,
    FXVALUATIONDATE,
    FXVALUATIONDATEDOCTOSTSTC,
    LOGISTICSDOCUMENTVERSION,
    PRICEQUOTATIONDATE,
    PRICINGDOCUMENTITEM,
    PRICINGKEY,
    QUOTATIONPERIODDATE,
    SNAPSHOTDATE0,
    SNAPSHOTDATE1,
    SUBCONDITIONTYPE,
    VALUATIONDATE,
    VALUATIONDATE1,
    VERSION,
    VERSSTOCKRECORDUUID,
    _MATERIAL,
    ACMGOODSMOVEMENTYEAR,
    ACMREPORTINGMONTH,
    ACMREPORTINGYEAR,
    ADJUSTEDQUANTITYPERDAY,
    ADJUSTEDREPORTINGDATE,
    ADJUSTEDREPORTINGMONTH,
    ADJUSTEDREPORTINGYEAR,
    APPLICATIONDOCUMENT,
    BASIS_ID,
    BASIS_TYPE,
    BASISID,
    BASISTYPE,
    BATCH,
    BINHASERROR,
    BUKRS,
    BUSINESSAREA,
    BUSINESSPARTNER,
    CMMDTYDOCUMENTEXTERNALNUMBER,
    CMMDTYFORWARDINDEXTIMING,
    CMMDTYFORWARDINDEXTIMINGTEXT,
    CMMDTYLTSTEVALUATIONKEYDATE,
    CMMDTYPRICEEXPSRMASSUNIT,
    CMMDTYPRICEEXPSRQTYINMASSUNIT,
    CMMDTYPRICEEXPSRQTYINVOLUNIT,
    CMMDTYPRICEEXPSRVOLUMEUNIT,
    CMMDTYPRICEFIXATIONSTATUSSHORT,
    CMMDTYROOTDOCEXTERNALNUMBER,
    CNDNTERMEXCHRATEFIXATIONDATE,
    CNDNTERMEXCHRATEFIXATIONTIME,
    CNDNTERMLIMITRATEQUANTITYUNIT,
    CNDNTERMRATEFIXATIONDATE,
    CNDNTERMRATEFIXATIONTIME,
    CNDNTOSTSTCEXCHANGERATETYPE,
    COMMODITY,
    COMMODITYCONTRACTMATURITYCODE,
    COMMODITYCURVE,
    COMMODITYEXPOSUREQUANTITY,
    COMMODITYEXPOSUREUNIT,
    COMMODITYPRICEFIXATIONSTATUS,
    COMMODITYQUANTITY,
    COMMODITYQUANTITYINTERMUNIT,
    COMMODITYREPORTINGYEAR,
    COMMODITYUNIT,
    COMPANYCODE,
    COMPARCNDNTERMFACTORNUMERATOR,
    COMPARCNDNTRMFCTRDENOMINATOR,
    COMPARIMPLICITFIXATIONISRLVT,
    COMPARMAXCNDNTERMLIMITRATE,
    COMPARMINCNDNTERMLIMITRATE,
    CONDITIONAPPLICATION,
    CONDITIONCALCULATIONTYPE,
    CONDITIONCURRENCY,
    CONDITIONQUANTITY,
    CONDITIONQUANTITYUNIT,
    CONDITIONRATE,
    CONDITIONTERMEXCHRATEISFIXED,
    CONDITIONTERMEXTENSIONUSAGE,
    CONDITIONTERMFACTORDENOMINATOR,
    CONDITIONTERMFACTORNUMERATOR,
    CONDITIONTERMLIMITRATECURRENCY,
    CONDITIONTERMLIMITRATEQUANTITY,
    CONDITIONTERMLIMITRATESTATUS,
    CONDITIONTERMNAME,
    CONDITIONTERMRATE,
    CONDITIONTERMRATECURRENCY,
    CONDITIONTERMRATEDNMNTR,
    CONDITIONTERMRATEFIXATION,
    CONDITIONTERMRATEISFIXED,
    CONDITIONTERMRATEISROUNDED,
    CONDITIONTERMRATEMKTCURRENCY,
    CONDITIONTERMRATENMRTR,
    CONDITIONTERMRATEQUANTITY,
    CONDITIONTERMRATEQUANTITYUNIT,
    CONDITIONTERMSTATUS,
    CONDITIONTERMVALUE,
    CONDITIONTERMVALUECURRENCY,
    CONDITIONTODOCEXCHANGERATETYPE,
    CONSUMPTIONTYPE,
    CONTRPRICEEXPOSUREISEXECUTED,
    CREDITOR,
    CURVE,
    DATASELECTIONTYPE,
    DCS_PERIOD_TYPE,
    DCS_SELECTION_TYPE,
    DCSID,
    DCSPERIODTYPE,
    DCSREPORTINGDATE,
    DELIVERYDATE,
    DELIVERYPERIODENDDATE,
    DELIVERYPERIODSTARTDATE,
    DERIVATIVECONTRACTMATURITYCODE,
    DERIVATIVECONTRSPECIFICATION,
    DISPLAYUNITOFMEASURE,
    DISPLAYVIEW,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    DOCTOSTSTCEXCHANGERATETYPE,
    DOCUMENTCURRENCY,
    ENDOFDAYBUSINESSENTITYKEY,
    ENDOFDAYSNAPSHOTDATE,
    ENDOFDAYSNAPSHOTDATETIMEFROM,
    ENDOFDAYSNAPSHOTDATETIMETO,
    ENDOFDAYSNAPSHOTFROMDATE,
    ENDOFDAYSNAPSHOTTODATE,
    ENDOFDAYTIMESTAMPFROM,
    ENDOFDAYTIMESTAMPTO,
    EXCHANGERATETYPE,
    EXCHRATEMATURITYDATE,
    EXCLUDEBASEDATE,
    EXPECTEDPAYMENTDATE,
    EXPOSUREDUEDATE,
    EXTERNALKEYFIGUREVALUE,
    FINANCIALASSETSMGMTPRODUCTTYPE,
    FINANCIALINSTRTRANSACTIONTYPE,
    FINANCIALINSTRUMENTPRODUCTTYPE,
    FININSTREXTERNALREFERENCE,
    FININSTRTRANSACTIONCATEGORY,
    FIRSTQUOTATIONPERIODDATE,
    FIXATIONINBRIDGETABLE,
    FIXEDCALCULATIONTYPE,
    FIXEDEXCHRATEDATE,
    FIXEDFACTORFROM,
    FIXEDFACTORTO,
    GOODSMOVEMENT,
    HASERROR,
    IMPLICITFIXATIONISRELEVANT,
    INCOTERMSCLASSIFICATION,
    INCOTERMSTRANSFERLOCATION,
    INSTRUMENT,
    ISINTERCOMPANYTRANSFER,
    KEYDATE_SELECTION_ROUT,
    LASTQUOTATIONPERIODDATE,
    LOADDATACAPTUREEVENTTYPE,
    LOADDATACAPTUREOBJECTID,
    MARKETIDENTIFIERCODE,
    MARKETTOTERMEXCHANGERATETYPE,
    MATERIAL,
    MATERIALBASEUNIT,
    MATERIALGROUP,
    MATNR,
    MATURITYKEYDATE,
    MATURITYSELECTIONROUTINE,
    MATURITYSELECTIONTYPE,
    MAXIMUMCONDITIONTERMLIMITRATE,
    MAXIMUMVERSION,
    MIC,
    MINIMUMCONDITIONTERMLIMITRATE,
    MTMADJUSTMENTTYPE,
    MTMCALCGRPMARKETPRICECONDITION,
    MTMCALCULATIONGROUP,
    MTMCONDITIONGROUP,
    MTMCONDITIONGROUPCATEGORY,
    MTMDATASELECTIONTYPE,
    MTMDATASOURCETYPE,
    NUMBEROFCOMMODITYCONTRACTS,
    NUMBEROFDAYSINQUOTATIONPERIOD,
    OLDCONDITIONTERMRATE,
    OLDCONDITIONTERMVALUE,
    OPTIONDELTAFACTOR,
    OPTIONPUTCALLCODE,
    OPTIONSTRIKEAMOUNT,
    OPTIONSTRIKECURRENCY,
    OPTIONSTRIKECURRENCYUNIT,
    OPTIONSTRIKEPRICE,
    ORIGINREFERENCEDOCBUSOBJTYPE,
    ORIGINREFERENCEDOCUMENT,
    ORIGINREFERENCEDOCUMENTITEM,
    ORIGNREFDOCUMENTSHORTNUMBER,
    PHYSICALCOMMODITY,
    PHYSICALCOMMODITYERRORTEXT,
    PHYSICALCOMMODITYHASERROR,
    PHYSICALCOMMODITYUNIT,
    PLANT,
    PNLEVALUATIONPERIOD,
    PNLEVENTTYPE,
    PREVIOUSSUBCONDITIONTYPE,
    PREVIOUSVERSION,
    PREVIOUSVERSIONQUANTITYSIGN,
    PREVVERSCNDNTERMRATECURRENCY,
    PREVVERSCNDNTERMRATEISFIXED,
    PREVVERSCNDNTRMEXCHRATEISFIXED,
    PREVVERSDOCSTSTCSRCECNVRSNFCTR,
    PREVVERSDOCSTSTCTGTCNVRSNFCTR,
    PREVVERSIONCOMMODITYQUANTITY,
    PREVVERSIONCONDITIONTERMRATE,
    PREVVERSIONCONDITIONTERMVALUE,
    PREVVERSIONDOCUMENTCURRENCY,
    PREVVERSIONSUBCONDITIONTYPE,
    PREVVERSMKTDOCTGTCNVRSNFCTR,
    PREVVERSMKTTODOCSRCECNVRSNFCTR,
    PRICEDDAYS,
    PRICEISREALIZED,
    PRICESETTINGMETHOD,
    PRICESETTINGMETHODSTATUS,
    PRICETYPE,
    PRICINGCONDITIONTERM,
    PRICINGPROCEDURE,
    PRICINGSTATUS,
    PROFITCENTER,
    PURCHASINGORGANIZATION,
    QUANTITYPERDAY,
    QUANTITYSIGN,
    QUOTATIONCURRENCY,
    QUOTATIONDATELIST,
    QUOTATIONGROUP,
    QUOTATIONGROUPCALCULATIONRULE,
    QUOTATIONKEYTYPE,
    QUOTATIONPERIODENDDATE,
    QUOTATIONPERIODREFERENCEDATE,
    QUOTATIONPERIODSTARTDATE,
    QUOTATIONPRICETYPE,
    QUOTATIONUNITOFMEASURE,
    QUOTGROUP,
    QUOTPERIOD_BEGIN,
    QUOTPERIOD_END,
    RECORD_TYPE,
    REFERENCEDOCBUSOBJTYPE,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTITEM,
    REFERENCEDOCUMENTLONGNUMBER,
    REFERENCEEVALUATIONKEYDATE,
    REPORTINGDATE,
    REPORTINGMONTH,
    REPORTINGYEAR,
    ROUNDINGDECIMALPLACES,
    SALESORGANIZATION,
    SECURITYCLASS,
    SKIPREPORTINGINDICATORISSET,
    SOLDTOPARTY,
    SOURCECONVERSIONFACTOR,
    SOURCEDOCUMENT,
    SOURCEDOCUMENTBUSOBJTYPE,
    SOURCEDOCUMENTITEM,
    SOURCEDOCUMENTSHORTNUMBER,
    SOURCETRANSACEVENTENDDATETIME,
    SOURCETRANSACTIONEVENTDATETIME,
    SOURCEUOM,
    STATISTICSCURRENCY,
    STORAGELOCATION,
    SUBSTITUTEPRICEQUOTATIONDATE,
    TARGETCONVERSIONFACTOR,
    TARGETUOM,
    TERMTODOCFIXEDFACTORFROM,
    TERMTODOCFIXEDFACTORTO,
    TIMETOMATURITY,
    TODAYDAYS,
    TOTALQUOTATIONPERIODDAYS,
    TREASURYCONTRACTTYPE,
    TREASURYPOSITIONACCOUNT,
    TREASURYPOSITIONLONGSHORTCODE,
    UNPRICEDDAYS,
    VALIDITYENDDATE,
    VALIDITYENDDATETIME,
    VALIDITYENDTIME,
    VALIDITYSTARTDATE,
    VALIDITYSTARTDATETIME,
    VALIDITYSTARTTIME,
    VALIDTODATETIME,
    WERKS,
    PRIMARY KEY (CONDITIONTYPE, EVALUATIONDATE, FXVALUATIONDATE, FXVALUATIONDATEDOCTOSTSTC, LOGISTICSDOCUMENTVERSION, PRICEQUOTATIONDATE, PRICINGDOCUMENTITEM, PRICINGKEY, QUOTATIONPERIODDATE, SNAPSHOTDATE0, SNAPSHOTDATE1, SUBCONDITIONTYPE, VALUATIONDATE, VALUATIONDATE1, VERSION, VERSSTOCKRECORDUUID)
);