SOURCE

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 SOURCE (
    CONDITIONTYPE,
    CONSOLIDATIONRECORDNUMBER,
    FILTER,
    GL_SIRID,
    LOGISTICSDOCUMENTVERSION,
    PRICINGDOCUMENTITEM,
    PRICINGKEY,
    PROGNAME,
    R3STATE,
    SOURCE_OTC,
    SOURCE_SYSTEM,
    SOURCEDOCUMENTITEM,
    SUBCONDITIONTYPE,
    VERSION,
    _BASISID,
    _CMMDTYMTMMESSAGE,
    _COMMODITY,
    _COMMODITYUNIT,
    _COMPANYCODE,
    _COMPARATIVEMARKETDCS,
    _COMPARMKTMARKETIDENTIFIERCODE,
    _CONDITIONTERMRATECURRENCY,
    _CONDITIONTERMRATEQUANTITYUNIT,
    _CONTRACTDCS,
    _CONTRACTMARKETIDENTIFIERCODE,
    _CONTRCNDNTERMRATECURRENCY,
    _CONTROLLINGAREA,
    _CREDITOR,
    _DATAAGING,
    _DOCUMENTCURRENCY,
    _INCOTERMSCLASSIFICATION,
    _MARKETDCS,
    _MATERIAL,
    _MKTCNDNTERMRATEQUANTITYUNIT,
    _MKTMARKETIDENTIFIERCODE,
    _MTMADJUSTMENTTYPE,
    _MTMCALCULATIONGROUP,
    _MTMCONDITIONGROUP,
    _MTMCONDITIONGROUPCATEGORY,
    _MTMDATASOURCETYPE,
    _ORIGINREFERENCEDOCBUSOBJTYPE,
    _PLANT,
    _PNLELEMENTARYEVENTTYPE,
    _PNLEVENTCATEGORY,
    _PNLEVENTGROUP,
    _PNLEVENTTYPE,
    _PRICINGSTATUS,
    _PROFITCENTER,
    _REFERENCEDOCBUSOBJTYPE,
    _SOLDTOPARTY,
    _SOURCEDOCUMENTBUSOBJTYPE,
    _SPREADCURRENCY,
    _STATISTICSCURRENCY,
    _STORAGELOCATION,
    ACCOUNTINGDOCUMENT,
    ACTIV,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINGLOBALCURRENCY,
    AMOUNTINGROUPCURRENCY,
    AMOUNTINLOCALCURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    ASSIGNMENTREFERENCE,
    AUFNR,
    AUTOM,
    AWORG,
    AWREF,
    AWTYP,
    BALANCETRANSACTIONCURRENCY,
    BASEUNIT,
    BATCH,
    BELNR,
    BILLINGDOCUMENTTYPE,
    BILLTOPARTY,
    BLART,
    BREAKDOWNCATEGORY,
    BRSCH,
    BSL,
    BUDAT,
    BUSINESSAREA,
    BVORG,
    BZIRK,
    CALCRELCOMPARCONTRCNDNTERMRATE,
    CALCRELCONTRCONDITIONTERMRATE,
    CALCRLVTCOMPARCNDNTRMRATECRCY,
    CALCRLVTCONTRCNDNTRMRATECRCY,
    CASHLEDGERACCOUNT,
    CHARTOFACCOUNTS,
    CMMDTYDOCUMENTEXTERNALNUMBER,
    CMMDTYENDOFDAYBUSINESSENTYKEY,
    CMMDTYPRICEEXPSRMASSUNIT,
    CMMDTYPRICEEXPSRQTYINMASSUNIT,
    CMMDTYPRICEEXPSRQTYINVOLUNIT,
    CMMDTYPRICEEXPSRVOLUMEUNIT,
    CMMDTYROOTDOCEXTERNALNUMBER,
    CNDNTERMEXCHRATEFIXATIONDATE,
    CNDNTERMEXCHRATEFIXATIONTIME,
    CNDNTERMRATEFIXATIONDATE,
    CNDNTERMRATEFIXATIONTIME,
    CNDNTOSTSTCEXCHANGERATETYPE,
    CNSLDTNCASHLEDGERCHARTOFACCTS,
    CNSLDTNSUBITEMSOURCE,
    CNSLDTNUNITGROUPCRCYSOURCE,
    CNSLDTNUNITLOCALCRCYSOURCE,
    COIAC,
    COICU,
    COINR,
    COMMODITY,
    COMMODITYQUANTITY,
    COMMODITYQUANTITYINTERMUNIT,
    COMMODITYUNIT,
    COMPANY,
    COMPANYCODE,
    COMPANYCODECURRENCY,
    COMPARATIVECNDNTRMRATEISFIXED,
    COMPARATIVEEVALUATIONDATE,
    COMPARATIVEMARKETDCS,
    COMPARATIVEPRICINGSTATUS,
    COMPARCMMDTYQUANTITYINTERMUNIT,
    COMPARCNDNTRMEXCHRATEISFXD,
    COMPARCONDITIONTERMFACTOR,
    COMPARCONTRCMMDTYQTYINTRMUNIT,
    COMPARCONTRCNDNTERMRATE,
    COMPARCONTRCNDNTRMRATECURRENCY,
    COMPARCONTRDOCTOSTSTCEXCHRATE,
    COMPARCONTRMKTTODOCEXCHRATE,
    COMPARCONTRSPREADCNDNTERMRATE,
    COMPARIMPLICITFIXATION,
    COMPARIMPLICITFIXATIONISRLVT,
    COMPARMARKETBASISID,
    COMPARMARKETBASISTYPE,
    COMPARMKTADJMTVALCNDNTERMVALUE,
    COMPARMKTCONDITIONTERMRATE,
    COMPARMKTDOCTOSTSTCEXCHRATE,
    COMPARMKTDRVTVCONTRCODE,
    COMPARMKTMARKETIDENTIFIERCODE,
    COMPARMKTMARKETTODOCEXCHRATE,
    COMPARMKTMARKETTOSTSTCEXCHRATE,
    COMPARMKTMATURITYKEYDATE,
    COMPARMKTQUOTATIONPRICETYPE,
    COMPARQTANPERIODREFERENCEDATE,
    CONDITIONAPPLICATION,
    CONDITIONCALCULATIONTYPE,
    CONDITIONCALCULATIONTYPESHORT,
    CONDITIONCURRENCY,
    CONDITIONQUANTITY,
    CONDITIONQUANTITYUNIT,
    CONDITIONRATE,
    CONDITIONRATEAMOUNT,
    CONDITIONTERMEXCHRATEISFIXED,
    CONDITIONTERMEXTENSIONUSAGE,
    CONDITIONTERMFACTOR,
    CONDITIONTERMNAME,
    CONDITIONTERMRATE,
    CONDITIONTERMRATECURRENCY,
    CONDITIONTERMRATEDNMNTR,
    CONDITIONTERMRATEFIXATION,
    CONDITIONTERMRATEISFIXED,
    CONDITIONTERMRATEISROUNDED,
    CONDITIONTERMRATENMRTR,
    CONDITIONTERMRATEQUANTITY,
    CONDITIONTERMRATEQUANTITYUNIT,
    CONDITIONTERMSTATUS,
    CONDITIONTERMVALUE,
    CONDITIONTERMVALUECURRENCY,
    CONDITIONTODOCEXCHANGERATETYPE,
    CONSOLIDATIONCHARTOFACCOUNTS,
    CONSOLIDATIONDIMENSION,
    CONSOLIDATIONLEDGER,
    CONSOLIDATIONUNIT,
    CONSOLIDATIONUNITLOCALCURRENCY,
    CONSOLIDATIONVERSION,
    CONTRACTBASISID,
    CONTRACTBASISTYPE,
    CONTRACTCONDITIONTERMRATE,
    CONTRACTCONDITIONTYPE,
    CONTRACTDCS,
    CONTRACTMARKETIDENTIFIERCODE,
    CONTRACTMARKETTODOCEXCHRATE,
    CONTRACTMATURITYKEYDATE,
    CONTRACTMKTTODOCEXCHRATE,
    CONTRACTQUOTATIONPRICETYPE,
    CONTRCMMDTYQTYINTERMUNIT,
    CONTRCNDNTRMRATEISFXD,
    CONTRCONDITIONTERMRATECURRENCY,
    CONTRDOCTOSTSTCEXCHRATE,
    CONTRDRVTVCONTRMATURITYCODE,
    CONTRMARKETTOSTSTCEXCHRATE,
    CONTROLLINGAREA,
    CONTRSPREADCNDNTERMRATE,
    CONTRTRMEXCHRATEISFXD,
    COSTCENTER,
    CPUDT,
    CPUTM,
    CREATIONDATETIME,
    CREDITOR,
    CSL,
    CTRCONDITIONTERMRATEISFIXED,
    CTRCONDTERMEXCHRATEISFIXED,
    CUSTOMER,
    CUSTOMERGROUP,
    CUSTOMERSUPPLIERCORPORATEGROUP,
    CUSTOMERSUPPLIERCOUNTRY,
    CUSTOMERSUPPLIERINDUSTRY,
    DATAPAKID,
    DELIVERYDATE,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    DOCCT,
    DOCLN,
    DOCNR,
    DOCTOSTSTCEXCHANGERATETYPE,
    DOCTOSTSTCFXPNLVALUE,
    DOCTY,
    DOCUMENTCURRENCY,
    DOCUMENTENTRYISINGROUPCURRENCY,
    DOCUMENTTOSTSTCFXCHANGEVALUE,
    DOCUMENTTOSTSTCFXREMOVEVALUE,
    DOCUMENTTOSTSTCFXSETVALUE,
    DRCRK,
    DSL,
    ENDOFDAYBUSINESSENTITYKEY,
    ESL,
    EVALUATIONDATE,
    EXCHRATEMATURITYDATE,
    EXPECTEDPAYMENTDATE,
    FINANCIALDATASOURCE,
    FINANCIALMANAGEMENTAREA,
    FINANCIALPLANNINGDATAPACKET,
    FINANCIALPLANNINGENTRYITEM,
    FINANCIALPLANNINGREQTRANSSQNC,
    FINANCIALSERVICESBRANCH,
    FINANCIALSERVICESPRODUCTGROUP,
    FINANCIALSTATEMENTITEM,
    FINANCIALTRANSACTIONTYPE,
    FISCAL_YEAR_PERIOD,
    FISCALPERIOD,
    FISCALYEAR,
    FISCALYEARPERIOD,
    FISCYEARPER,
    FIXEDEXCHRATEDATE,
    FIXEDMKTSPREADCNDNTERMRATE,
    FKART,
    FLOATINGMKTSPREADCNDNTERMRATE,
    FSITEMMAPPINGVERSION,
    FSL,
    FUNCTIONALAREA,
    FUND,
    FXCHANGEMKTADJMTVALUE,
    FXREMOVEMKTADJMTVALUE,
    FXSETMKTADJMTVALUE,
    GJAHR,
    GLACCOUNT,
    GLOBALCURRENCY,
    GRANTID,
    GROUPCURRENCY,
    GSL,
    HASERROR,
    HSL,
    IMPLICITFIXATION,
    IMPLICITFIXATIONISRELEVANT,
    INCOTERMSCLASSIFICATION,
    INCOTERMSTRANSFERLOCATION,
    ISINTERCOMPANYTRANSFER,
    KDGRP,
    KOKRS,
    KONZS,
    KSL,
    KTOPL,
    KUNNR,
    KUNRE,
    KUNWE,
    LAND1,
    LEDGER,
    LEDGERGLLINEITEM,
    LIFNR,
    LOCALCURRENCY,
    LOGSYS,
    M2DAVGBAL_B,
    M2DAVGBAL_C,
    M2DAVGBAL_D,
    M2DAVGBAL_E,
    M2DAVGBAL_F,
    M2DAVGBAL_FC,
    M2DAVGBAL_G,
    M2DAVGBAL_H,
    M2DAVGBAL_K,
    M2DAVGBAL_O,
    M2DAVGBAL_T,
    M2DAVGBAL_V,
    MARKETADJUSTMENTVALUECURRENCY,
    MARKETADJUSTMENTVALUERATE,
    MARKETBASISID,
    MARKETBASISTYPE,
    MARKETCONDITIONTERMRATE,
    MARKETDCS,
    MARKETPRICEQUANTITYUNIT,
    MARKETTOSTSTCFXCHANGEVALUE,
    MARKETTOSTSTCFXREMOVEVALUE,
    MARKETTOSTSTCFXSETVALUE,
    MARKETTOTERMEXCHANGERATETYPE,
    MATERIAL,
    MATERIALGROUP,
    MATKL,
    MATKL_MM,
    MATNR,
    MATNR_COPA,
    MATURITYSELECTIONTYPE,
    MAVDOCTOSTSTCEXCHRATE,
    MAXIMUMVERSION,
    MKTADJMTVALDOCTOSTSTCEXCHRATE,
    MKTADJMTVALUECNDNTERMVALUE,
    MKTDOCTOSTSTCEXCHRATE,
    MKTDRVTVCONTRMATURITYCODE,
    MKTMARKETIDENTIFIERCODE,
    MKTMARKETTODOCEXCHRATE,
    MKTMARKETTOSTSTCEXCHRATE,
    MKTMATURITYKEYDATE,
    MKTPRICEPNLVALUE,
    MKTQUOTATIONPRICETYPE,
    MKTTOSTSTCFXPNLVALUE,
    MKTVALADJMTFXBROUGHTFWDVAL,
    MSL,
    MTDAVGDAILYBALINBALTRANSCRCY,
    MTDAVGDAILYBALINCCCRCY,
    MTDAVGDAILYBALINGLOBCRCY,
    MTMADJUSTMENTTYPE,
    MTMCALCGRPMARKETPRICECONDITION,
    MTMCALCULATIONGROUP,
    MTMCONDITIONGROUP,
    MTMCONDITIONGROUPCATEGORY,
    MTMDATASOURCEGROUP,
    MTMDATASOURCETYPE,
    OLDQTYDOCTOSTSTCFXREMOVEVALUE,
    OLDQTYDOCTOSTSTCFXSETVALUE,
    OLDQTYFXREMOVEMKTADJMTVALUE,
    OLDQTYFXSETMKTADJMTVALUE,
    OLDQTYMKTTOSTSTCFXREMOVEVALUE,
    OLDQTYMKTTOSTSTCFXSETVALUE,
    OLDQTYPRICEREMOVEMKTADJMTVALUE,
    OLDQTYPRICESETMKTADJMTVALUE,
    OLDQUANTITYPRICEREMOVEVALUE,
    OLDQUANTITYPRICESETVALUE,
    ORDERID,
    ORGANIZATIONDIVISION,
    ORIGINREFERENCEDOCBUSOBJTYPE,
    ORIGINREFERENCEDOCUMENT,
    ORIGINREFERENCEDOCUMENTITEM,
    ORIGNREFDOCUMENTSHORTNUMBER,
    ORNDOCNR,
    OSL,
    PARTNERBUSINESSAREA,
    PARTNERCOMPANY,
    PARTNERCONSOLIDATIONUNIT,
    PARTNERCOSTCENTER,
    PARTNERFUNCTIONALAREA,
    PARTNERFUND,
    PARTNERPROFITCENTER,
    PARTNERSEGMENT,
    PHYSICALCOMMODITY,
    PLANT,
    PLEVL,
    PNLCALCRELEVANTMARKETQUANTITY,
    PNLCALCULATIONRELEVANTQUANTITY,
    PNLCALCULATIONRELEVANTVALUE,
    PNLELEMENTARYEVENTTYPE,
    PNLEVENTCATEGORY,
    PNLEVENTGROUP,
    PNLEVENTTYPE,
    PNLVALUE,
    POPER,
    PPRCTR,
    PRACQ,
    PRCTR,
    PREVIOUSVERSION,
    PREVVERSIONSUBCONDITIONTYPE,
    PRICECHANGEMKTADJMTVALUE,
    PRICECHANGEVALUE,
    PRICEISREALIZED,
    PRICEREMOVEDOCUMENTSPREADVALUE,
    PRICEREMOVEMARKETSPREADVALUE,
    PRICEREMOVEMKTADJMTVALUE,
    PRICEREMOVEVALUE,
    PRICESETDOCUMENTSPREADVALUE,
    PRICESETMARKETSPREADVALUE,
    PRICESETMKTADJMTVALUE,
    PRICESETTINGMETHOD,
    PRICESETTINGMETHODSTATUS,
    PRICESETVALUE,
    PRICINGCONDITIONTERM,
    PRICINGPROCEDURE,
    PRICINGSTATUS,
    PRODUCTGROUP,
    PROFITCENTER,
    PROJECT,
    PS_POSID,
    PS_PSP_PNR,
    PS_PSPID,
    PSEGMENT,
    PURCHASINGORGANIZATION,
    Q2DAVGBAL_B,
    Q2DAVGBAL_C,
    Q2DAVGBAL_D,
    Q2DAVGBAL_E,
    Q2DAVGBAL_F,
    Q2DAVGBAL_FC,
    Q2DAVGBAL_G,
    Q2DAVGBAL_H,
    Q2DAVGBAL_K,
    Q2DAVGBAL_O,
    Q2DAVGBAL_T,
    Q2DAVGBAL_V,
    QTDAVGDAILYBALINBALTRANSCRCY,
    QTDAVGDAILYBALINCCCRCY,
    QTDAVGDAILYBALINGLOBCRCY,
    QUANTITYINBASEUNIT,
    QUANTITYSIGN,
    QUOTATIONDATELIST,
    QUOTATIONGROUP,
    QUOTATIONGROUPCALCULATIONRULE,
    QUOTATIONKEYTYPE,
    QUOTATIONPERIODENDDATE,
    QUOTATIONPERIODREFERENCEDATE,
    QUOTATIONPERIODSTARTDATE,
    QUOTATIONPRICETYPE,
    RACCT,
    RASSC,
    RBUKRS,
    RBUNIT,
    RBUPTR,
    RBUSA,
    RCNTR,
    RCOMP,
    RCONGR,
    RDIMEN,
    RECORD,
    REFACTIV,
    REFDOCCT,
    REFDOCLN,
    REFDOCNR,
    REFERENCEDOCBUSOBJTYPE,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTITEM,
    REFERENCEDOCUMENTLONGNUMBER,
    REFERENCEFISCALYEAR,
    REFRYEAR,
    REQTSN,
    REVYEAR,
    RFAREA,
    RFCCUR,
    RHCUR,
    RITCLG,
    RITEM,
    RKCUR,
    RLDNR,
    RLDNR_FIN,
    RMVCT,
    ROBUKRS,
    ROUNDINGDECIMALPLACES,
    RPFLG,
    RRCTY,
    RTCUR,
    RTFLG,
    RUNIT,
    RVERS,
    RVSDOCNR,
    RYEAR,
    SALESDISTRICT,
    SALESORGANIZATION,
    SBUSA,
    SCNTR,
    SEGMENT,
    SFAREA,
    SGTXT,
    SHIPTOPARTY,
    SITYP,
    SOLDPRODUCT,
    SOLDPRODUCTGROUP,
    SOLDTOPARTY,
    SOURCEDOCUMENT,
    SOURCEDOCUMENTBUSOBJTYPE,
    SOURCEDOCUMENTSHORTNUMBER,
    SOURCELEDGER,
    SOURCETRANSACEVENTENDDATETIME,
    SOURCETRANSACTIONEVENTDATETIME,
    SPART,
    SPREADCURRENCY,
    SPREADMARKETTODOCEXCHRATE,
    SPREADMARKETTOSTSTCEXCHRATE,
    SPREADPNLVALUE,
    STATISTICSCURRENCY,
    STORAGELOCATION,
    SUBIT,
    SUBITEM,
    SUBITEMCATEGORY,
    SUPPLIER,
    SYSTEMMESSAGENUMBER,
    TIMESTAMP,
    TRANSACTIONCURRENCY,
    TSL,
    UPDHP,
    UPPCU,
    USNAM,
    VALIDITYENDDATE,
    VALIDITYENDDATETIME,
    VALIDITYSTARTDATE,
    VALIDITYSTARTDATETIME,
    VALIDITYSTARTTIME,
    VALIDTODATETIME,
    VERSSTOCKRECORDUUID,
    VKORG,
    VSL,
    VTWEG,
    WBSELEMENT,
    WBSELEMENTEXTERNALID,
    WBSELEMENTINTERNALID,
    WERKS,
    WSDAT,
    XBLNR,
    Y2DAVGBAL_B,
    Y2DAVGBAL_C,
    Y2DAVGBAL_D,
    Y2DAVGBAL_E,
    Y2DAVGBAL_F,
    Y2DAVGBAL_FC,
    Y2DAVGBAL_G,
    Y2DAVGBAL_H,
    Y2DAVGBAL_K,
    Y2DAVGBAL_O,
    Y2DAVGBAL_T,
    Y2DAVGBAL_V,
    YRACQ,
    YTDAVGDAILYBALINBALTRANSCRCY,
    YTDAVGDAILYBALINCCCRCY,
    YTDAVGDAILYBALINGLOBCRCY,
    ZUONR,
    PRIMARY KEY (CONDITIONTYPE, CONSOLIDATIONRECORDNUMBER, FILTER, GL_SIRID, LOGISTICSDOCUMENTVERSION, PRICINGDOCUMENTITEM, PRICINGKEY, PROGNAME, R3STATE, SOURCE_OTC, SOURCE_SYSTEM, SOURCEDOCUMENTITEM, SUBCONDITIONTYPE, VERSION)
);