NETPOSITION

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 NETPOSITION (
    COMMODITYEXPOSURECATEGORY,
    COMMODITYPRICEEXPOSURE,
    COMMODITYPRICESUBEXPOSURE,
    COMMODITYTRANSACTIONTYPE,
    COMPANYCODE,
    CONDITIONTYPE,
    EVALUATIONDATE,
    PRICEQUOTATIONDATE,
    PRICINGDOCUMENTITEM,
    PRICINGKEY,
    SUBCONDITIONTYPE,
    VERSION,
    VERSSTOCKRECORDUUID,
    ACMLESSUNPRICEDNOBASISPURQTY,
    ACMLESSUNPRICEDNOBASISSALESQTY,
    ACMLESSUNPRICEDNOPRICEQTY,
    ACMLESSUNPRICEDNOPRICESALESQTY,
    ACMNETPOSITIONRISKREPORTYEAR,
    ACMNETPOSRISKREPORTINGYEAR,
    ACMOPENSALESCONTRACTSFLATQTY,
    ACMOPENSLSCONTRACTSNOBASISQTY,
    ACMOPENSLSCONTRACTSNOFUTUREQTY,
    ACMOPENSLSCONTRACTSNOPRICEQTY,
    ADJUSTEDREPORTINGMONTH,
    ADJUSTEDREPORTINGYEAR,
    APPLICATIONDOCUMENT,
    BASISID,
    BASISPOSITIONQTY,
    BASISTYPE,
    BATCH,
    BUSINESSAREA,
    CASHFLOWDIRECTION,
    CMMDTYFORWARDINDEXTIMING,
    CNDNTERMEXCHRATEFIXATIONDATE,
    CNDNTERMEXCHRATEFIXATIONTIME,
    CNDNTERMLIMITRATEQUANTITYUNIT,
    CNDNTERMRATEFIXATIONDATE,
    CNDNTERMRATEFIXATIONTIME,
    COMMODITY,
    COMMODITYPRICEEXPOSUREQUANTITY,
    COMMODITYPRICEFIXATIONSTATUS,
    COMMODITYQUANTITYINTERMUNIT,
    COMMODITYUNIT,
    CONDITIONAPPLICATION,
    CONDITIONTERMEXTENSIONUSAGE,
    CONDITIONTERMLIMITRATECURRENCY,
    CONDITIONTERMLIMITRATEQUANTITY,
    CONDITIONTERMLIMITRATESTATUS,
    CONDITIONTERMNAME,
    CONDITIONTERMRATE,
    CONDITIONTERMRATECURRENCY,
    CONDITIONTERMRATEDNMNTR,
    CONDITIONTERMRATEFIXATION,
    CONDITIONTERMRATEISFIXED,
    CONDITIONTERMRATEISROUNDED,
    CONDITIONTERMRATEMKTCURRENCY,
    CONDITIONTERMRATENMRTR,
    CONDITIONTERMRATEQUANTITY,
    CONDITIONTERMRATEQUANTITYUNIT,
    CONDITIONTERMSTATUS,
    CONDITIONTERMVALUE,
    CONDITIONTERMVALUECURRENCY,
    CONTRPRICEEXPOSUREISEXECUTED,
    CREDITOR,
    CURRENTMONTH,
    CURRENTYEAR,
    DCSREFMONTH,
    DCSTRADPERREPORTINGMONTH,
    DELIVEREDMARKETPREXPOSUREQTY,
    DELIVERYDATE,
    DERIVATIVECONTRACT,
    DERIVATIVECONTRACTMATURITYCODE,
    DERIVATIVECONTRSPECIFICATION,
    DISPLAYVIEW,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    DOCUMENTCURRENCY,
    ENDOFDAYSNAPSHOTDATE,
    ENDOFDAYSNAPSHOTDATETIME,
    ENDOFDAYSNAPSHOTDATETIMEFROM,
    ENDOFDAYSNAPSHOTDATETIMETO,
    ENDOFDAYSNAPSHOTFROMDATE,
    ENDOFDAYSNAPSHOTTODATE,
    EXCHRATEMATURITYDATE,
    EXPECTEDPAYMENTDATE,
    EXPOSUREDUEDATE,
    FINANCIALASSETSMGMTPRODUCTTYPE,
    FINANCIALINSTRACTIVITYCATEGORY,
    FINANCIALINSTRPRODUCTCATEGORY,
    FINANCIALINSTRUMENTPRODUCTTYPE,
    FINANCIALOBJECT,
    FININSTRTRANSACTIONCATEGORY,
    FIXEDEXCHRATEDATE,
    FIXPRICEDCONTRPRICEEXPSRQTY,
    FIXPRICEDDELIVSPRICEEXPSRQTY,
    FLATPRICEDCONTRACTSQTY,
    GOODSMOVEMENT,
    IMPLICITFIXATIONISRELEVANT,
    IMPLIEDFUTURESPOSITIONQTY,
    INCOTERMSCLASSIFICATION,
    INCOTERMSTRANSFERLOCATION,
    INVENTORYANDCONTRACTSQTY,
    ISINTERCOMPANYTRANSFER,
    LOADDATACAPTUREEVENTTYPE,
    LOADDATACAPTUREOBJECTID,
    MARKETIDENTIFIERCODE,
    MATERIAL,
    MATERIALGROUP,
    MATERIALSTOCKEXPOSUREQTY,
    MATERIALSTOCKPRICEEXPOSUREUNIT,
    MATURITYKEYDATE,
    MATURITYSELECTIONTYPE,
    MAXIMUMCONDITIONTERMLIMITRATE,
    MAXIMUMVERSION,
    MINIMUMCONDITIONTERMLIMITRATE,
    MTMADJUSTMENTTYPE,
    MTMCALCGRPMARKETPRICECONDITION,
    MTMCALCULATIONGROUP,
    MTMCONDITIONGROUP,
    MTMCONDITIONGROUPCATEGORY,
    MTMDATASELECTIONTYPE,
    MTMDATASOURCETYPE,
    NETPOSITION_FLAG,
    NOBSESTABLISHEDCONTREXPSRQTY,
    NOFUTRESTABLISHEDCONTREXPSRQTY,
    NOFUTUREESTABPURCHASECONTRQTY,
    NOFUTUREESTABSALESCONTRQTY,
    NOPRCESTABLISHEDCONTREXPSRQTY,
    NUMBEROFCOMMODITYCONTRACTS,
    OPTIONPUTCALLCODE,
    OPTIONSTRIKECURRENCY,
    OPTIONSTRIKEPRICE,
    ORIGINREFERENCEDOCBUSOBJTYPE,
    ORIGINREFERENCEDOCUMENT,
    ORIGINREFERENCEDOCUMENTITEM,
    OUTRIGHTPRICEEXPOSUREQTY,
    PHYSICALCMMDTYHASNETDRYERROR,
    PHYSICALCOMMODITY,
    PHYSICALCOMMODITYERRORTEXT,
    PLANT,
    PREVIOUSVERSION,
    PRICEDCONTRACTSEXPOSUREQTY,
    PRICEDDELIVEREDCONTREXPSRQTY,
    PRICEDUNDELIVEREDCONTREXPSRQTY,
    PRICEISREALIZED,
    PRICINGSTATUS,
    PROFITCENTER,
    PURCHASINGORGANIZATION,
    QUANTITYSIGN,
    QUOTATIONDATELIST,
    QUOTATIONGROUP,
    QUOTATIONGROUPCALCULATIONRULE,
    QUOTATIONKEYTYPE,
    QUOTATIONPERIODENDDATE,
    QUOTATIONPERIODREFERENCEDATE,
    QUOTATIONPERIODSTARTDATE,
    REALIZEDMATERIALSTKPRCEXPSRQTY,
    REDUCNNOPRCESTABLISHEDEXPSRQTY,
    REFERENCEDOCBUSOBJTYPE,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTITEM,
    REPORTINGMONTH,
    REPORTINGYEAR,
    ROUNDINGDECIMALPLACES,
    SALESORGANIZATION,
    SOLDTOPARTY,
    SOURCEDOCUMENT,
    SOURCEDOCUMENTBUSOBJTYPE,
    STATISTICSCURRENCY,
    STORAGEBINHASNETDRYERROR,
    STORAGELOCATION,
    TERMENDDATE,
    TERMSTARTDATE,
    TIMETOMATURITY,
    TODAYPRICEDCONTRACTSEXPSRQTY,
    TODAYPRICEDUNDELIVEREDEXPSRQTY,
    TODAYUNPRICEDUNRLZDCTREXPSRQTY,
    TOTALPHYSICALPOSITIONQTY,
    TREASURYPOSITIONACCOUNT,
    TREASURYPOSITIONLONGSHORTCODE,
    UNDELIVEREDFIXPRCTRPREXPSRQTY,
    UNDELIVEREDMARKETPREXPOSUREQTY,
    UNPRICEDCONTRPRICEEXPOSUREQTY,
    UNPRICEDDELIVEREDCTREXPSRQTY,
    UNPRICEDUNDELIVEREDCTREXPSRQTY,
    UNPRICEDUNREALIZEDPRCEXPSRQTY,
    UNPRICEDUNRLZDGDSISSEXPSRQTY,
    UNPRICEDUNRLZDGDSRCPTEXPSRQTY,
    UNREALIZEDGOODSISSPRCEXPSRQTY,
    UNREALIZEDGOODSRCPTPRCEXPSRQTY,
    UNREALIZEDPRICEEXPOSUREQTY,
    UNRLZDMARKETPRICEEXPOSUREQTY,
    VALIDITYENDDATE,
    VALIDITYENDDATETIME,
    VALIDITYENDTIME,
    VALIDITYSTARTDATE,
    VALIDITYSTARTDATETIME,
    VALIDITYSTARTTIME,
    PRIMARY KEY (COMMODITYEXPOSURECATEGORY, COMMODITYPRICEEXPOSURE, COMMODITYPRICESUBEXPOSURE, COMMODITYTRANSACTIONTYPE, COMPANYCODE, CONDITIONTYPE, EVALUATIONDATE, PRICEQUOTATIONDATE, PRICINGDOCUMENTITEM, PRICINGKEY, SUBCONDITIONTYPE, VERSION, VERSSTOCKRECORDUUID)
);