I_GLACCTBALANCECUBE

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.

-- G/L Account Balance - Cube
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_GLACCTBALANCECUBE (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALPERIODDATE,
    FISCALYEAR,
    GLACCOUNTFLOWTYPE,
    LEDGERGLLINEITEM,
    SOURCELEDGER,
    _COMPANYCODE,
    ACCOUNTASSIGNMENT,
    ACCOUNTASSIGNMENTNUMBER,
    ACCOUNTASSIGNMENTTYPE,
    ACCOUNTINGDOCCREATEDBYUSER,
    ACCOUNTINGDOCUMENTCATEGORY,
    ACCOUNTINGDOCUMENTTYPE,
    ALTERNATIVEGLACCOUNT,
    ASSETDEPRECIATIONAREA,
    ASSETTRANSACTIONTYPE,
    ASSETVALUEDATE,
    ASSIGNMENTREFERENCE,
    BALANCETRANSACTIONCURRENCY,
    BILLINGDOCUMENTTYPE,
    BUDGETPERIOD,
    BUSINESSAREA,
    BUSINESSPROCESS,
    BUSINESSTRANSACTIONTYPE,
    CALENDARMONTH,
    CALENDARQUARTER,
    CALENDARWEEK,
    CALENDARYEAR,
    CALENDARYEARMONTH,
    CALENDARYEARQUARTER,
    CALENDARYEARWEEK,
    CHARTOFACCOUNTS,
    CLEARINGACCOUNTINGDOCUMENT,
    CLEARINGDATE,
    CLEARINGDOCFISCALYEAR,
    CLEARINGJOURNALENTRY,
    CLEARINGJOURNALENTRYFISCALYEAR,
    COMPANYCODECURRENCY,
    CONTROLLINGAREA,
    CONTROLLINGOBJECTCLASS,
    CONTROLLINGOBJECTDEBITTYPE,
    CORPORATEGROUPACCOUNT,
    CORPORATEGROUPCHARTOFACCOUNTS,
    COSTCENTER,
    COSTCTRACTIVITYTYPE,
    COSTOBJECT,
    COUNTRYCHARTOFACCOUNTS,
    CREDITAMOUNTINBALANCETRANSCRCY,
    CREDITAMOUNTINCOCODECRCY,
    CREDITAMOUNTINFREEDEFINEDCRCY1,
    CREDITAMOUNTINFREEDEFINEDCRCY2,
    CREDITAMOUNTINFREEDEFINEDCRCY3,
    CREDITAMOUNTINFREEDEFINEDCRCY4,
    CREDITAMOUNTINFREEDEFINEDCRCY5,
    CREDITAMOUNTINFREEDEFINEDCRCY6,
    CREDITAMOUNTINFREEDEFINEDCRCY7,
    CREDITAMOUNTINFREEDEFINEDCRCY8,
    CREDITAMOUNTINFUNCTIONALCRCY,
    CREDITAMOUNTINGLOBALCRCY,
    CREDITAMOUNTINTRANSCRCY,
    CUSTOMER,
    CUSTOMERGROUP,
    CUSTOMERSERVICENOTIFICATION,
    DEBITAMOUNTINBALANCETRANSCRCY,
    DEBITAMOUNTINCOCODECRCY,
    DEBITAMOUNTINFREEDEFINEDCRCY1,
    DEBITAMOUNTINFREEDEFINEDCRCY2,
    DEBITAMOUNTINFREEDEFINEDCRCY3,
    DEBITAMOUNTINFREEDEFINEDCRCY4,
    DEBITAMOUNTINFREEDEFINEDCRCY5,
    DEBITAMOUNTINFREEDEFINEDCRCY6,
    DEBITAMOUNTINFREEDEFINEDCRCY7,
    DEBITAMOUNTINFREEDEFINEDCRCY8,
    DEBITAMOUNTINFUNCTIONALCRCY,
    DEBITAMOUNTINGLOBALCRCY,
    DEBITAMOUNTINTRANSCRCY,
    DEBITCREDITCODE,
    DISTRIBUTIONCHANNEL,
    ELIMINATIONPROFITCENTER,
    ENDINGBALAMTINFREEDFNDCRCY1,
    ENDINGBALAMTINFREEDFNDCRCY2,
    ENDINGBALAMTINFREEDFNDCRCY3,
    ENDINGBALAMTINFREEDFNDCRCY4,
    ENDINGBALAMTINFREEDFNDCRCY5,
    ENDINGBALAMTINFREEDFNDCRCY6,
    ENDINGBALAMTINFREEDFNDCRCY7,
    ENDINGBALAMTINFREEDFNDCRCY8,
    ENDINGBALANCEAMTINBALTRANSCRCY,
    ENDINGBALANCEAMTINCOCODECRCY,
    ENDINGBALANCEAMTINFUNCNLCRCY,
    ENDINGBALANCEAMTINGLOBALCRCY,
    ENDINGBALANCEAMTINTRANSCRCY,
    FINANCIALACCOUNTTYPE,
    FINANCIALMANAGEMENTAREA,
    FINANCIALTRANSACTIONTYPE,
    FISCALPERIOD,
    FISCALPERIODENDDATE,
    FISCALPERIODSTARTDATE,
    FISCALQUARTER,
    FISCALWEEK,
    FISCALYEARPERIOD,
    FISCALYEARQUARTER,
    FISCALYEARVARIANT,
    FISCALYEARWEEK,
    FIXEDASSET,
    FREEDEFINEDCURRENCY1,
    FREEDEFINEDCURRENCY2,
    FREEDEFINEDCURRENCY3,
    FREEDEFINEDCURRENCY4,
    FREEDEFINEDCURRENCY5,
    FREEDEFINEDCURRENCY6,
    FREEDEFINEDCURRENCY7,
    FREEDEFINEDCURRENCY8,
    FUNCTIONALAREA,
    FUNCTIONALCURRENCY,
    FUND,
    GLACCOUNT,
    GLACCOUNTTYPE,
    GLOBALCURRENCY,
    GRANTID,
    GROUPFIXEDASSET,
    GROUPMASTERFIXEDASSET,
    HOUSEBANK,
    HOUSEBANKACCOUNT,
    INVENTORYSPCLSTKSALESDOCITM,
    INVENTORYSPCLSTKSALESDOCUMENT,
    INVENTORYSPCLSTOCKWBSELEMENT,
    INVENTORYSPECIALSTOCKSUPPLIER,
    INVENTORYSPECIALSTOCKTYPE,
    INVENTORYSPECIALSTOCKVALNTYPE,
    INVENTORYVALUATIONTYPE,
    INVTRYSPCLSTOCKWBSELMNTEXTID,
    INVTRYSPCLSTOCKWBSELMNTINTID,
    INVTRYSPECIALSTOCKVALNTYPE_2,
    ISBALANCESHEETACCOUNT,
    ISOPENITEMMANAGED,
    ISREVERSAL,
    ISREVERSED,
    ISSETTLED,
    ISSETTLEMENT,
    JOINTVENTURE,
    JOINTVENTURECOSTRECOVERYCODE,
    JOINTVENTUREEQUITYGROUP,
    JOINTVENTUREEQUITYTYPE,
    LEDGERFISCALYEAR,
    LINEITEMISCOMPLETED,
    LOGICALSYSTEM,
    MASTERFIXEDASSET,
    MATERIAL,
    MATERIALGROUP,
    OFFSETTINGACCOUNT,
    OFFSETTINGACCOUNTTYPE,
    OPERATINGCONCERN,
    ORDERCATEGORY,
    ORDERID,
    ORGANIZATIONDIVISION,
    ORIGINCOSTCENTER,
    ORIGINCOSTCTRACTIVITYTYPE,
    ORIGINOBJECTTYPE,
    PARTNERACCOUNTASSIGNMENT,
    PARTNERACCOUNTASSIGNMENTTYPE,
    PARTNERBUDGETPERIOD,
    PARTNERBUSINESSAREA,
    PARTNERBUSINESSPROCESS,
    PARTNERCOMPANY,
    PARTNERCOMPANYCODE,
    PARTNERCONTROLLINGOBJECTCLASS,
    PARTNERCOSTCENTER,
    PARTNERCOSTCTRACTIVITYTYPE,
    PARTNERCOSTOBJECT,
    PARTNERFUNCTIONALAREA,
    PARTNERFUND,
    PARTNERGRANT,
    PARTNERORDER,
    PARTNERORDERCATEGORY,
    PARTNERPROFITCENTER,
    PARTNERPROJECT,
    PARTNERPROJECTEXTERNALID,
    PARTNERPROJECTINTERNALID,
    PARTNERPROJECTNETWORK,
    PARTNERPROJECTNETWORKACTIVITY,
    PARTNERSALESDOCUMENT,
    PARTNERSALESDOCUMENTITEM,
    PARTNERSEGMENT,
    PARTNERWBSELEMENT,
    PERSONNELNUMBER,
    PLANT,
    POSTINGKEY,
    PREDECESSORREFERENCEDOCTYPE,
    PRODUCT,
    PRODUCTGROUP,
    PROFITCENTER,
    PROJECT,
    PROJECTEXTERNALID,
    PROJECTINTERNALID,
    PROJECTNETWORK,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    QUANTITYISINCOMPLETE,
    REFERENCEDOCUMENTITEMGROUP,
    REFERENCEDOCUMENTTYPE,
    RELATEDNETWORKACTIVITY,
    SALESDOCUMENT,
    SALESDOCUMENTITEM,
    SALESORDER,
    SALESORDERITEM,
    SALESORGANIZATION,
    SEGMENT,
    SENDERACCOUNTASSIGNMENT,
    SENDERACCOUNTASSIGNMENTTYPE,
    SENDERGLACCOUNT,
    SETTLEMENTREFERENCEDATE,
    SOLDMATERIAL,
    SOLDPRODUCT,
    SOLDPRODUCTGROUP,
    SPECIALGLCODE,
    SUPPLIER,
    TAXCODE,
    TRANSACTIONCURRENCY,
    TRANSACTIONTYPEDETERMINATION,
    VALUATIONAREA,
    WBSELEMENT,
    WBSELEMENTEXTERNALID,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALPERIODDATE, FISCALYEAR, GLACCOUNTFLOWTYPE, LEDGERGLLINEITEM, SOURCELEDGER)
);