VFIND

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 VFIND (
    COMMODITYEXPOSURECATEGORY,
    COMMODITYPRICEEXPOSURE,
    COMMODITYPRICEEXPOSUREVERSION,
    COMMODITYPRICESUBEXPOSURE,
    COMPANYCODE,
    _COMPANYCODE,
    _DERIVATIVECONTRSPECIFICATION,
    _FINASSETSMGMTPRODUCTTYPE,
    _MARKETIDENTIFIERCODE,
    _PHYSICALCOMMODITY,
    _UNITOFMEASURE,
    CASHFLOWDIRECTION,
    CMMDTYFORWARDINDEXTIMING,
    CMMDTYHDGPLANEXPOSUREHEDGEBOOK,
    CMMDTYPRICEEXPSRMASSUNIT,
    CMMDTYPRICEEXPSRQTYINMASSUNIT,
    CMMDTYPRICEEXPSRQTYINVOLUNIT,
    CMMDTYPRICEEXPSRVOLUMEUNIT,
    COMMODITY,
    COMMODITYHEDGEPLANEXPOSUREID,
    COMMODITYPRICEEXPOSUREBASEQTY,
    COMMODITYPRICEEXPOSUREBASEUNIT,
    COMMODITYPRICEEXPOSUREQUANTITY,
    COMMODITYPRICEEXPOSUREUNIT,
    COMMODITYPRICEFIXATIONSTATUS,
    CONSUMPTIONTYPE,
    DELIVERYDATE,
    DERIVATIVECONTRACT,
    DERIVATIVECONTRACTMATURITYCODE,
    DERIVATIVECONTRSPECIFICATION,
    DISPLAYVIEW,
    ENDOFDAYBUSINESSENTITYKEY,
    ENDOFDAYSNAPSHOTDATE,
    ENDOFDAYSNAPSHOTDATETIME,
    EVALUATIONDATE,
    EXPOSUREDUEDATE,
    FINANCIALASSETSMGMTPRODUCTTYPE,
    FINANCIALINSTRACTIVITYCATEGORY,
    FINANCIALINSTRPRODUCTCATEGORY,
    FINANCIALINSTRUMENTPRODUCTTYPE,
    FINANCIALOBJECT,
    FINANCIALTRANSACTIONPORTFOLIO,
    FININSTREXTERNALREFERENCE,
    FININSTRTRANSACTIONCATEGORY,
    HASERROR,
    ISNOTRELEVANTFORMTMRISK,
    MARKETIDENTIFIERCODE,
    MATURITYKEYDATE,
    MAXIMUMVERSION,
    NUMBEROFCOMMODITYCONTRACTS,
    OPTIONEXERCISETYPE,
    OPTIONPUTCALLCODE,
    OPTIONSTRIKECURRENCY,
    OPTIONSTRIKEPRICE,
    PARDRVTVCONTRACTSPECIFICATION,
    PAYMENTCURRENCY,
    PNLEVENTTYPE,
    QUOTATIONCURRENCY,
    QUOTATIONPRICETYPE,
    REPORTINGDATE,
    REPORTINGMONTH,
    REPORTINGYEAR,
    RISKANALYZERVERSIONUUID,
    RISKVIEWISNOTRELEVANT,
    TERMENDDATE,
    TERMSTARTDATE,
    TIMETOMATURITY,
    TRADEDDRVTVCONTRSPECIFICATION,
    TREASURYPOSITIONACCOUNT,
    TREASURYPOSITIONLONGSHORTCODE,
    VALIDITYENDCHARTIMESTAMP,
    VALIDITYENDDATE,
    VALIDITYENDDATETIME,
    VALIDITYENDTIME,
    VALIDITYSTARTCHARTIMESTAMP,
    VALIDITYSTARTDATE,
    VALIDITYSTARTDATETIME,
    VALIDITYSTARTTIME,
    PRIMARY KEY (COMMODITYEXPOSURECATEGORY, COMMODITYPRICEEXPOSURE, COMMODITYPRICEEXPOSUREVERSION, COMMODITYPRICESUBEXPOSURE, COMPANYCODE)
);