CUBE

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 CUBE (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTCLASS,
    BUSINESSPLACE,
    COMPANYCODE,
    CONDITIONTYPE,
    DEBITCREDITCODE,
    FISCALYEAR,
    JP_VALUEADDTAXRETURNFORM,
    JP_VALUEADDTAXRETURNFORMITEM,
    JP_VALUEADDTAXRETURNSUBITEM,
    JP_VATRETURNRULE,
    LEDGER,
    LEDGERGLLINEITEM,
    PRICINGDOCUMENTITEM,
    PRICINGKEY,
    SOURCELEDGER,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    SUBCONDITIONTYPE,
    SUPPLIERTAXID2,
    TAXCODE,
    TAXGROUP,
    TAXNUMBER1,
    VERSION,
    _BASISID,
    _CMMDTYMTMMESSAGE,
    _COMMODITY,
    _COMMODITYUNIT,
    _COMPANYCODE,
    _COMPARATIVEMARKETDCS,
    _COMPARMKTMARKETIDENTIFIERCODE,
    _CONDITIONTERMRATECURRENCY,
    _CONDITIONTERMRATEQUANTITYUNIT,
    _CREDITOR,
    _DOCUMENTCURRENCY,
    _INCOTERMSCLASSIFICATION,
    _MARKETDCS,
    _MATERIAL,
    _MKTMARKETIDENTIFIERCODE,
    _MTMADJUSTMENTTYPE,
    _MTMCALCULATIONGROUP,
    _MTMCONDITIONGROUP,
    _MTMCONDITIONGROUPCATEGORY,
    _MTMDATASOURCETYPE,
    _ORIGINREFERENCEDOCBUSOBJTYPE,
    _PLANT,
    _PNLEVENTCATEGORY,
    _PNLEVENTGROUP,
    _PNLEVENTTYPE,
    _PRICINGSTATUS,
    _REFERENCEDOCBUSOBJTYPE,
    _SOLDTOPARTY,
    _SOURCEDOCUMENTBUSOBJTYPE,
    _SPREADCURRENCY,
    _STATISTICSCURRENCY,
    _STORAGELOCATION,
    ACCOUNTINGDOCCREATEDBYUSER,
    ACCOUNTINGDOCUMENTCATEGORY,
    ACCOUNTINGDOCUMENTTYPE,
    ACMPRICINGVERSION,
    ALTERNATIVEGLACCOUNT,
    ASSIGNMENTREFERENCE,
    BASEAMTFORSTDTAXRATEINCCCRCY,
    BASEAMTFORSTDTAXRATEINCCCRCY1,
    BASEAMTFORSTDTAXRATEINCCCRCY2,
    BASEAMTFORSTDTAXRATEINCCCRCY3,
    BASEAMTFORSTDTAXRATEINCCCRCY4,
    BASEAMTFORSTDTAXRATEINCCCRCY5,
    BASEAMTFORSTDTAXRATEINCCCRCY6,
    BATCH,
    BUSINESSAREA,
    BUSINESSPARTNER,
    CALCRELCOMPARCONTRCNDNTERMRATE,
    CALCRLVTCOMPARCNDNTRMRATECRCY,
    CALCRLVTCONTRCNDNTRMRATECRCY,
    CHARTOFACCOUNTS,
    CMMDTYPRICEEXPSRMASSUNIT,
    CMMDTYPRICEEXPSRQTYINMASSUNIT,
    CMMDTYPRICEEXPSRQTYINVOLUNIT,
    CMMDTYPRICEEXPSRVOLUMEUNIT,
    CNDNTERMEXCHRATEFIXATIONDATE,
    CNDNTERMEXCHRATEFIXATIONTIME,
    CNDNTERMRATEFIXATIONDATE,
    CNDNTERMRATEFIXATIONTIME,
    CNDNTOSTSTCEXCHANGERATETYPE,
    COMMODITY,
    COMMODITYQUANTITYINTERMUNIT,
    COMMODITYUNIT,
    COMPANYCODECURRENCY,
    COMPARATIVEEVALUATIONDATE,
    COMPARATIVEMARKETDCS,
    COMPARCMMDTYQUANTITYINTERMUNIT,
    COMPARCONDITIONTERMFACTOR,
    COMPARCONTRCNDNTERMRATE,
    COMPARCONTRCNDNTRMRATECURRENCY,
    COMPARCONTRDOCTOSTSTCEXCHRATE,
    COMPARCONTRMKTTODOCEXCHRATE,
    COMPARCONTRNETQTYINTERMUNIT,
    COMPARCONTRSPREADCNDNTERMRATE,
    COMPARMARKETBASISID,
    COMPARMARKETBASISTYPE,
    COMPARMKTCONDITIONTERMRATE,
    COMPARMKTDOCTOSTSTCEXCHRATE,
    COMPARMKTDRVTVCONTRCODE,
    COMPARMKTMARKETIDENTIFIERCODE,
    COMPARMKTMARKETTODOCEXCHRATE,
    COMPARMKTMARKETTOSTSTCEXCHRATE,
    COMPARMKTMATURITYKEYDATE,
    COMPARMKTQUOTATIONPRICETYPE,
    COMPARQTANPERIODREFERENCEDATE,
    CONDITIONAPPLICATION,
    CONDITIONTERMFACTOR,
    CONDITIONTERMRATECURRENCY,
    CONDITIONTERMRATEFIXATION,
    CONDITIONTERMRATEQUANTITYUNIT,
    CONDITIONTODOCEXCHANGERATETYPE,
    CONTRACTBASISID,
    CONTRACTBASISTYPE,
    CONTRACTCONDITIONTERMRATE,
    CONTRACTCONDITIONTYPE,
    CONTRACTDCS,
    CONTRACTMARKETIDENTIFIERCODE,
    CONTRACTMATURITYKEYDATE,
    CONTRACTMKTTODOCEXCHRATE,
    CONTRACTQUOTATIONPRICETYPE,
    CONTRCONDITIONTERMRATECURRENCY,
    CONTRDOCTOSTSTCEXCHRATE,
    CONTRDRVTVCONTRMATURITYCODE,
    CONTRNETQUANTITYINTERMUNIT,
    CONTROLLINGOBJECTTYPE,
    CONTRSPREADCNDNTERMRATE,
    COSTCENTER,
    COUNTRYCHARTOFACCOUNTS,
    CREDITOR,
    CUSTOMER,
    CUSTOMERCOUNTRY,
    DEDUCTIONTYPE,
    DELIVERYDATE,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    DOCTOSTSTCEXCHANGERATETYPE,
    DOCTOSTSTCFXPNLVALUE,
    DOCUMENTCURRENCY,
    DOCUMENTDATE,
    DOCUMENTITEMTEXT,
    DOCUMENTREFERENCEID,
    EVALUATIONDATE,
    EXCHRATEMATURITYDATE,
    EXPECTEDPAYMENTDATE,
    FINANCIALACCOUNTTYPE,
    FISCALPERIOD,
    FIXEDEXCHRATEDATE,
    FIXEDMKTSPREADCNDNTERMRATE,
    FLOATINGMKTSPREADCNDNTERMRATE,
    FUNCTIONALAREA,
    GLACCOUNT,
    GLACCOUNTINPURCHASEORG,
    GLACCOUNTLONGNAME,
    GOODSARECLEARED,
    GROSSTAXAMOUNT,
    HASERROR,
    INCOTERMSCLASSIFICATION,
    INCOTERMSTRANSFERLOCATION,
    INDUSTRIALTAXRATECATEGORY,
    ISINTERCOMPANYTRANSFER,
    JP_VATRETURNFORMITEMNAME,
    JP_VATRETURNRULENAME,
    JP_VATRETURNRULETAXRATEDESC,
    JRNLENTRYCNTRYSPECIFICREF1,
    JRNLENTRYCNTRYSPECIFICREF2,
    JRNLENTRYCNTRYSPECIFICREF3,
    MARKETBASISID,
    MARKETBASISTYPE,
    MARKETCONDITIONTERMRATE,
    MARKETDCS,
    MARKETPRICEQUANTITYUNIT,
    MARKETTOTERMEXCHANGERATETYPE,
    MATERIAL,
    MATERIALGROUP,
    MKTADJMTVALDOCTOSTSTCEXCHRATE,
    MKTADJMTVALUECNDNTERMVALUE,
    MKTDOCTOSTSTCEXCHRATE,
    MKTDRVTVCONTRMATURITYCODE,
    MKTMARKETIDENTIFIERCODE,
    MKTMARKETTODOCEXCHRATE,
    MKTMARKETTOSTSTCEXCHRATE,
    MKTMATURITYKEYDATE,
    MKTPRICEPNLVALUE,
    MKTQUOTATIONPRICETYPE,
    MKTTOSTSTCFXPNLVALUE,
    MKTVALADJMTFXBROUGHTFWDVAL,
    MTMADJUSTMENTTYPE,
    MTMCALCGRPMARKETPRICECONDITION,
    MTMCALCULATIONGROUP,
    MTMCONDITIONGROUP,
    MTMCONDITIONGROUPCATEGORY,
    MTMCONDITIONGROUPCATEGORYNAME,
    MTMDATASOURCETYPE,
    ORIGINREFERENCEDOCBUSOBJTYPE,
    ORIGINREFERENCEDOCUMENT,
    ORIGINREFERENCEDOCUMENTITEM,
    PHYSICALCOMMODITY,
    PLANT,
    PNLCALCRELEVANTMARKETQUANTITY,
    PNLCALCULATIONRELEVANTQUANTITY,
    PNLCALCULATIONRELEVANTVALUE,
    PNLCALRELEVANTNETQUANTITY,
    PNLELEMENTARYEVENTTYPE,
    PNLEVENTCATEGORY,
    PNLEVENTGROUP,
    PNLEVENTTYPE,
    PNLVALUE,
    POSTINGDATE,
    POSTINGKEY,
    PRICEISREALIZED,
    PRICESETTINGMETHOD,
    PRICESETTINGMETHODSTATUS,
    PRICINGCONDITIONTERM,
    PRICINGPROCEDURE,
    PRICINGSTATUS,
    PROFITCENTER,
    PURCHASINGORGANIZATION,
    QUOTATIONGROUP,
    QUOTATIONGROUPCALCULATIONRULE,
    QUOTATIONPERIODENDDATE,
    QUOTATIONPERIODREFERENCEDATE,
    QUOTATIONPERIODSTARTDATE,
    REFERENCEDOCBUSOBJTYPE,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTITEM,
    REFERENCEDOCUMENTLONGNUMBER,
    REPORTINGDATE,
    REVERSEDOCUMENT,
    REVERSEDOCUMENTFISCALYEAR,
    SALESORGANIZATION,
    SOLDTOPARTY,
    SOURCEDOCUMENT,
    SOURCEDOCUMENTBUSOBJTYPE,
    SOURCEDOCUMENTITEM,
    SOURCEDOCUMENTSHORTNUMBER,
    SPECIALGLCODE,
    SPREADCURRENCY,
    SPREADPNLVALUE,
    STATISTICSCURRENCY,
    STORAGELOCATION,
    SUPPLIER,
    SUPPLIERCOUNTRY,
    SYSTEMMESSAGENUMBER,
    TAXAMOUNTDIFFERENCEINCCCRCY,
    TAXCATEGORY,
    TAXRATE,
    TAXRATEVALIDITYSTARTDATE,
    TAXREPORTINGDATE,
    TAXTYPE,
    TOTALINVOICEBASEAMOUNTINCCCRCY,
    TOTALTAXAMOUNTINCOCODECRCY,
    TW_EDOCGVMNTUNIFORMINVCNUMBER,
    VALIDITYSTARTDATE,
    VALIDITYSTARTDATETIME,
    VALIDITYSTARTTIME,
    VALIDTODATETIME,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTCLASS, BUSINESSPLACE, COMPANYCODE, CONDITIONTYPE, DEBITCREDITCODE, FISCALYEAR, JP_VALUEADDTAXRETURNFORM, JP_VALUEADDTAXRETURNFORMITEM, JP_VALUEADDTAXRETURNSUBITEM, JP_VATRETURNRULE, LEDGER, LEDGERGLLINEITEM, PRICINGDOCUMENTITEM, PRICINGKEY, SOURCELEDGER, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID, SUBCONDITIONTYPE, SUPPLIERTAXID2, TAXCODE, TAXGROUP, TAXNUMBER1, VERSION)
);