P_GLACCOUNTBALANCE

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 with Flow-Measure
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_GLACCOUNTBALANCE (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    LEDGER,
    LEDGERGLLINEITEM,
    SOURCELEDGER,
    _ACCOUNTINGDOCUMENTCATEGORY,
    _ACCOUNTINGDOCUMENTTYPE,
    _ACCOUNTINGDOCUMENTTYPETEXT,
    _ACCRUALITEMTYPE,
    _ACCRUALOBJECT,
    _ACCRUALOBJECTTYPE,
    _ACCRUALSUBOBJECT,
    _ALTERNATIVEGLACCOUNT,
    _ASSEMBLY,
    _ASSETTRANSACTIONTYPE,
    _BALANCETRANSACTIONCURRENCY,
    _BILLABLECONTROL,
    _BILLINGDOCUMENTTYPE,
    _BILLTOPARTY,
    _BUDGETPERIOD,
    _BUDGETPERIODTEXT,
    _BUSINESSAREA,
    _BUSINESSAREATEXT,
    _BUSINESSPROCESS,
    _BUSINESSTRANSACTIONTYPE,
    _CASHLEDGERACCOUNT,
    _CASHLEDGERCOMPANYCODE,
    _CHARTOFACCOUNTS,
    _CLEARINGACCOUNTINGDOCUMENT,
    _CLEARINGJOURNALENTRY,
    _CLEARINGJRNLENTRYFISCALYEAR,
    _COMPANYCODE,
    _COMPANYCODECURRENCY,
    _COMPANYCODETEXT,
    _CONDITIONCONTRACT,
    _CONTROLLINGAREA,
    _CONTROLLINGAREATEXT,
    _CONTROLLINGDEBITCREDITCODE,
    _CONTROLLINGOBJECTCLASS,
    _COSTANALYSISRESOURCE,
    _COSTCENTER,
    _COSTCTRACTIVITYTYPE,
    _COSTORIGINGROUP,
    _COUNTRYCHARTOFACCOUNTS,
    _CURRENTCOSTCENTER,
    _CURRENTPROFITCENTER,
    _CUSTOMER,
    _CUSTOMERCOMPANY,
    _CUSTOMERGROUP,
    _CUSTOMERSUPPLIERCOUNTRY,
    _CUSTOMERTEXT,
    _DEBITCREDITCODE,
    _DISTRIBUTIONCHANNEL,
    _ELIMINATIONPROFITCENTER,
    _EMPLOYMENT,
    _EQUIPMENT,
    _FINANCIALACCOUNTTYPE,
    _FINANCIALMANAGEMENTAREA,
    _FINANCIALTRANSACTIONTYPE,
    _FISCALCALENDARDATE,
    _FISCALPERIOD,
    _FISCALPERIODFORVARIANT,
    _FISCALYEAR,
    _FISCALYEARPERIOD,
    _FISCALYEARPERIODFORVARIANT,
    _FISCALYEARVARIANT,
    _FIXEDASSET,
    _FIXEDASSETTEXT,
    _FREEDEFINEDCURRENCY1,
    _FREEDEFINEDCURRENCY2,
    _FREEDEFINEDCURRENCY3,
    _FREEDEFINEDCURRENCY4,
    _FREEDEFINEDCURRENCY5,
    _FREEDEFINEDCURRENCY6,
    _FREEDEFINEDCURRENCY7,
    _FREEDEFINEDCURRENCY8,
    _FUNCTIONALAREA,
    _FUNCTIONALLOCATION,
    _FUND,
    _FUNDEDPROGRAM,
    _FUNDSCENTER,
    _GLACCOUNTFLOWTYPE,
    _GLACCOUNTINCHARTOFACCOUNTS,
    _GLACCOUNTINCOMPANYCODE,
    _GLACCOUNTTYPE,
    _GLACCOUNTTYPEFLOWTYPE,
    _GLOBALCURRENCY,
    _GROUPFIXEDASSET,
    _GROUPFIXEDASSETTEXT,
    _GROUPMASTERFIXEDASSET,
    _GROUPMASTERFIXEDASSETTEXT,
    _HOUSEBANK,
    _HOUSEBANKACCOUNT,
    _INTERNALORDER,
    _INVENTORYSPCLSTKSALESDOCITM,
    _INVENTORYSPCLSTKSALESDOCUMENT,
    _INVENTORYSPCLSTOCKVALNTYPE,
    _INVENTORYSPECIALSTOCKSUPPLIER,
    _INVENTORYSPECIALSTOCKTYPE,
    _INVENTORYSPECIALSTOCKVALNTYPE,
    _INVENTORYVALUATIONTYPE,
    _INVTRYSPCLSTKWBSELMNTBSCDATA,
    _INVTRYSPCLSTOCKSUPPLIERTEXT,
    _JOURNALENTRY,
    _LEDGER,
    _LEDGERFISCALYEAR,
    _LEDGERFISCALYEARFORVARIANT,
    _LOGICALSYSTEM,
    _MAINTENANCEACTIVITYTYPE,
    _MAINTENANCEORDERSUBOPERATION,
    _MAINTORDPLNGDEGREECODE,
    _MASTERFIXEDASSET,
    _MASTERFIXEDASSETTEXT,
    _MOVEMENTCATEGORY,
    _OFFSETTINGACCOUNT,
    _OFFSETTINGACCOUNTTEXT,
    _OFFSETTINGACCOUNTTYPE,
    _OFFSETTINGACCOUNTWITHBP,
    _OFFSETTINGCHARTOFACCOUNTS,
    _OPERATINGCONCERN,
    _ORDER,
    _ORDERCATEGORY,
    _ORIGINCOSTCENTER,
    _ORIGINCOSTCTRACTIVITYTYPE,
    _ORIGINPROFITCENTER,
    _ORIGINSENDEROBJECT,
    _PARTNERBUDGETPERIOD,
    _PARTNERBUSINESSAREA,
    _PARTNERBUSINESSAREATEXT,
    _PARTNERBUSINESSPROCESS,
    _PARTNERCOMPANY,
    _PARTNERCOMPANYCODE,
    _PARTNERCOMPANYCODETEXT,
    _PARTNERCONTROLLINGOBJECTCLASS,
    _PARTNERCOSTCENTER,
    _PARTNERCOSTCTRACTIVITYTYPE,
    _PARTNERFUNCTIONALAREA,
    _PARTNERFUND,
    _PARTNERORDER,
    _PARTNERORDER_2,
    _PARTNERORDERCATEGORY,
    _PARTNERORDERTEXT,
    _PARTNERORDERTEXT_2,
    _PARTNERPROFITCENTER,
    _PARTNERPROJECTBASICDATA,
    _PARTNERSALESDOCUMENT,
    _PARTNERSALESDOCUMENTITEM,
    _PARTNERSEGMENT,
    _PARTNERWBSELEMENTBASICDATA,
    _PERSONWORKAGREEMENT_1,
    _PLANT,
    _PMNOTIFICATIONPRIORITY,
    _PMNOTIFICATIONPRIORITYTYPE,
    _POSTINGKEY,
    _PREDECESSORREFERENCEDOCTYPE,
    _PRODUCT,
    _PRODUCTGROUP,
    _PRODUCTGROUP_2,
    _PROFITCENTER,
    _PROJECTBASICDATA,
    _PROJECTNETWORK,
    _PUBSECBUDGETACCOUNT,
    _PUBSECBUDGETACCOUNTCOCODE,
    _PUBSECBUDGETCNSMPNAMTTYPE,
    _PUBSECBUDGETCNSMPNDATE,
    _PUBSECBUDGETCNSMPNFSCLPERIOD,
    _PUBSECBUDGETCNSMPNFSCLYEAR,
    _PUBSECBUDGETCNSMPNTYPE,
    _PURCHASINGDOCUMENT,
    _PURCHASINGDOCUMENTITEM,
    _PURREQVALUATIONAREA,
    _REFERENCEDOCUMENTTYPE,
    _SALESDISTRICT,
    _SALESDOCUMENT,
    _SALESDOCUMENTITEM,
    _SALESORDER,
    _SALESORDERITEM,
    _SALESORGANIZATION,
    _SEGMENT,
    _SERVICECONTRACT,
    _SERVICECONTRACTITEM,
    _SERVICECONTRACTTYPE,
    _SERVICEDOCUMENT,
    _SERVICEDOCUMENTITEM,
    _SERVICEDOCUMENTTYPE,
    _SHIPTOPARTY,
    _SOLDPRODUCT,
    _SOLDPRODUCTGROUP,
    _SOLDPRODUCTGROUP_2,
    _SOURCELEDGER,
    _SPECIALGLCODE,
    _SUBLEDGERACCLINEITEMTYPE,
    _SUPERIORORDER,
    _SUPPLIER,
    _SUPPLIERCOMPANY,
    _SUPPLIERTEXT,
    _TAXCODE,
    _TIMESHEETOVERTIMECAT,
    _TRANSACTIONCURRENCY,
    _USER,
    _WBSELEMENTBASICDATA,
    _WORKCENTER,
    _WORKPACKAGETEXT,
    ACCOUNTASSIGNMENT,
    ACCOUNTASSIGNMENTNUMBER,
    ACCOUNTASSIGNMENTTYPE,
    ACCOUNTINGDOCCREATEDBYUSER,
    ACCOUNTINGDOCUMENTCATEGORY,
    ACCOUNTINGDOCUMENTITEM,
    ACCOUNTINGDOCUMENTTYPE,
    ACCRUALITEMTYPE,
    ACCRUALOBJECT,
    ACCRUALOBJECTLOGICALSYSTEM,
    ACCRUALOBJECTTYPE,
    ACCRUALSUBOBJECT,
    ALTERNATIVEGLACCOUNT,
    AMOUNTINBALANCETRANSACCRCY,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINFREEDEFINEDCURRENCY1,
    AMOUNTINFREEDEFINEDCURRENCY2,
    AMOUNTINFREEDEFINEDCURRENCY3,
    AMOUNTINFREEDEFINEDCURRENCY4,
    AMOUNTINFREEDEFINEDCURRENCY6,
    AMOUNTINFREEDEFINEDCURRENCY7,
    AMOUNTINFREEDEFINEDCURRENCY8,
    AMOUNTINGLOBALCURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    ASSEMBLY,
    ASSETACCTTRANSCLASSFCTN,
    ASSETCLASS,
    ASSETDEPRECIATIONAREA,
    ASSETTRANSACTIONTYPE,
    ASSETVALUEDATE,
    ASSIGNMENTREFERENCE,
    BALANCETRANSACTIONCURRENCY,
    BILLABLECONTROL,
    BILLINGDOCUMENTTYPE,
    BILLTOPARTY,
    BUDGETPERIOD,
    BUSINESSAREA,
    BUSINESSPROCESS,
    BUSINESSTRANSACTIONTYPE,
    CALENDARMONTH,
    CALENDARQUARTER,
    CALENDARWEEK,
    CALENDARYEAR,
    CALENDARYEARMONTH,
    CALENDARYEARQUARTER,
    CALENDARYEARWEEK,
    CASHLEDGERACCOUNT,
    CASHLEDGERCOMPANYCODE,
    CHARTOFACCOUNTS,
    CLEARINGACCOUNTINGDOCUMENT,
    CLEARINGDATE,
    CLEARINGDOCFISCALYEAR,
    CLEARINGJOURNALENTRY,
    CLEARINGJOURNALENTRYFISCALYEAR,
    CONDITIONCONTRACT,
    CONTROLLINGAREA,
    CONTROLLINGDEBITCREDITCODE,
    CONTROLLINGOBJECTCLASS,
    CONTROLLINGOBJECTDEBITTYPE,
    COSTANALYSISRESOURCE,
    COSTCENTER,
    COSTCTRACTIVITYTYPE,
    COSTESTIMATE,
    COSTOBJECT,
    COSTORIGINGROUP,
    COUNTRYCHARTOFACCOUNTS,
    CREATIONDATE,
    CREATIONDATETIME,
    CREDITAMOUNTINBALANCETRANSCRCY,
    CREDITAMOUNTINCOCODECRCY,
    CREDITAMOUNTINFREEDFNDCRCY1,
    CREDITAMOUNTINFREEDFNDCRCY2,
    CREDITAMOUNTINFREEDFNDCRCY3,
    CREDITAMOUNTINFREEDFNDCRCY4,
    CREDITAMOUNTINFREEDFNDCRCY5,
    CREDITAMOUNTINFREEDFNDCRCY6,
    CREDITAMOUNTINFREEDFNDCRCY7,
    CREDITAMOUNTINFREEDFNDCRCY8,
    CREDITAMOUNTINGLOBALCRCY,
    CREDITAMOUNTINTRANSCRCY,
    CUSTOMER,
    CUSTOMERGROUP,
    CUSTOMERSERVICENOTIFICATION,
    CUSTOMERSUPPLIERCORPORATEGROUP,
    CUSTOMERSUPPLIERCOUNTRY,
    CUSTOMERSUPPLIERINDUSTRY,
    DEBITAMOUNTINBALANCETRANSCRCY,
    DEBITAMOUNTINCOCODECRCY,
    DEBITAMOUNTINFREEDFNDCRCY1,
    DEBITAMOUNTINFREEDFNDCRCY2,
    DEBITAMOUNTINFREEDFNDCRCY3,
    DEBITAMOUNTINFREEDFNDCRCY4,
    DEBITAMOUNTINFREEDFNDCRCY5,
    DEBITAMOUNTINFREEDFNDCRCY6,
    DEBITAMOUNTINFREEDFNDCRCY7,
    DEBITAMOUNTINFREEDFNDCRCY8,
    DEBITAMOUNTINGLOBALCRCY,
    DEBITAMOUNTINTRANSCRCY,
    DEBITCREDITCODE,
    DEPRECIATIONFISCALPERIOD,
    DISTRIBUTIONCHANNEL,
    DOCUMENTDATE,
    DOCUMENTITEMTEXT,
    ELIMINATIONPROFITCENTER,
    EQUIPMENT,
    FINANCIALACCOUNTTYPE,
    FINANCIALMANAGEMENTAREA,
    FINANCIALTRANSACTIONTYPE,
    FISCALPERIOD,
    FISCALYEARPERIOD,
    FISCALYEARVARIANT,
    FIXEDASSET,
    FLOWAMOUNTINBALANCETRANSCRCY,
    FLOWAMOUNTINCOCODECRCY,
    FLOWAMOUNTINFREEDFNDCRCY1,
    FLOWAMOUNTINFREEDFNDCRCY2,
    FLOWAMOUNTINFREEDFNDCRCY3,
    FLOWAMOUNTINFREEDFNDCRCY4,
    FLOWAMOUNTINFREEDFNDCRCY5,
    FLOWAMOUNTINFREEDFNDCRCY6,
    FLOWAMOUNTINFREEDFNDCRCY7,
    FLOWAMOUNTINFREEDFNDCRCY8,
    FLOWAMOUNTINGLOBALCRCY,
    FLOWAMOUNTINTRANSCRCY,
    FOLLOWONDOCUMENTTYPE,
    FREEDEFINEDCURRENCY1,
    FREEDEFINEDCURRENCY2,
    FREEDEFINEDCURRENCY3,
    FREEDEFINEDCURRENCY4,
    FREEDEFINEDCURRENCY5,
    FREEDEFINEDCURRENCY6,
    FREEDEFINEDCURRENCY7,
    FREEDEFINEDCURRENCY8,
    FUNCTIONALAREA,
    FUNCTIONALLOCATION,
    FUND,
    FUNDEDPROGRAM,
    FUNDSCENTER,
    GLACCOUNT,
    GLACCOUNTFLOWTYPE,
    GLACCOUNTTYPE,
    GLACCOUNTTYPEFLOWTYPE,
    GLOBALCURRENCY,
    GLRECORDTYPE,
    GRANTID,
    GROUPFIXEDASSET,
    GROUPMASTERFIXEDASSET,
    HOUSEBANK,
    HOUSEBANKACCOUNT,
    INVENTORYSPCLSTKSALESDOCITM,
    INVENTORYSPCLSTKSALESDOCUMENT,
    INVENTORYSPECIALSTOCKSUPPLIER,
    INVENTORYSPECIALSTOCKTYPE,
    INVENTORYSPECIALSTOCKVALNTYPE,
    INVENTORYVALUATIONTYPE,
    INVOICEITEMREFERENCE,
    INVOICEREFERENCE,
    INVOICEREFERENCEFISCALYEAR,
    INVTRYSPCLSTOCKWBSELMNTEXTID,
    INVTRYSPCLSTOCKWBSELMNTINTID,
    INVTRYSPECIALSTOCKVALNTYPE_2,
    ISBALANCESHEETACCOUNT,
    ISCOMMITMENT,
    ISOPENITEMMANAGED,
    ISREVERSAL,
    ISREVERSED,
    ISSETTLED,
    ISSETTLEMENT,
    ISSTATISTICALCOSTCENTER,
    ISSTATISTICALORDER,
    ISSTATISTICALSALESDOCUMENT,
    JOINTVENTURE,
    JOINTVENTURECOSTRECOVERYCODE,
    JOINTVENTUREEQUITYGROUP,
    JOINTVENTUREEQUITYTYPE,
    JRNLENTRYITEMOBSOLETEREASON,
    LASTCHANGEDATETIME,
    LEDGERFISCALYEAR,
    LINEITEMISCOMPLETED,
    LOGICALSYSTEM,
    MAINTENANCEACTIVITYTYPE,
    MAINTENANCEORDERISPLANNED,
    MAINTENANCEORDERPLANNINGCODE,
    MAINTPRIORITY,
    MAINTPRIORITYTYPE,
    MASTERFIXEDASSET,
    OFFSETTINGACCOUNT,
    OFFSETTINGACCOUNTTYPE,
    OFFSETTINGCHARTOFACCOUNTS,
    OPERATINGCONCERN,
    ORDERCATEGORY,
    ORDERID,
    ORDERITEM,
    ORDEROPERATION,
    ORDERSUBOPERATION,
    ORGANIZATIONDIVISION,
    ORIGINCOSTCENTER,
    ORIGINCOSTCTRACTIVITYTYPE,
    ORIGINOBJECTTYPE,
    ORIGINPROFITCENTER,
    ORIGINSENDEROBJECT,
    PARTNERACCOUNTASSIGNMENT,
    PARTNERACCOUNTASSIGNMENTTYPE,
    PARTNERBUDGETPERIOD,
    PARTNERBUSINESSAREA,
    PARTNERBUSINESSPROCESS,
    PARTNERCOMPANY,
    PARTNERCOMPANYCODE,
    PARTNERCONTROLLINGOBJECTCLASS,
    PARTNERCOSTCENTER,
    PARTNERCOSTCTRACTIVITYTYPE,
    PARTNERCOSTOBJECT,
    PARTNERFUNCTIONALAREA,
    PARTNERFUND,
    PARTNERGRANT,
    PARTNERORDER,
    PARTNERORDER_2,
    PARTNERORDERCATEGORY,
    PARTNERPROFITCENTER,
    PARTNERPROJECT,
    PARTNERPROJECTEXTERNALID,
    PARTNERPROJECTINTERNALID,
    PARTNERPROJECTNETWORK,
    PARTNERPROJECTNETWORKACTIVITY,
    PARTNERSALESDOCUMENT,
    PARTNERSALESDOCUMENTITEM,
    PARTNERSEGMENT,
    PARTNERWBSELEMENT,
    PARTNERWBSELEMENTEXTERNALID,
    PARTNERWBSELEMENTINTERNALID,
    PERSONNELNUMBER,
    PLANT,
    POSTINGDATE,
    POSTINGKEY,
    PREDECESSORREFERENCEDOCCNTXT,
    PREDECESSORREFERENCEDOCITEM,
    PREDECESSORREFERENCEDOCTYPE,
    PREDECESSORREFERENCEDOCUMENT,
    PRODUCT,
    PRODUCTGROUP,
    PROFITCENTER,
    PROJECT,
    PROJECTEXTERNALID,
    PROJECTINTERNALID,
    PROJECTNETWORK,
    PUBSECBUDGETACCOUNT,
    PUBSECBUDGETACCOUNTCOCODE,
    PUBSECBUDGETCNSMPNAMTTYPE,
    PUBSECBUDGETCNSMPNDATE,
    PUBSECBUDGETCNSMPNFSCLPERIOD,
    PUBSECBUDGETCNSMPNFSCLYEAR,
    PUBSECBUDGETCNSMPNTYPE,
    PUBSECBUDGETISRELEVANT,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    QUANTITYISINCOMPLETE,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTCONTEXT,
    REFERENCEDOCUMENTITEM,
    REFERENCEDOCUMENTITEMGROUP,
    REFERENCEDOCUMENTTYPE,
    REFERENCEPURCHASEORDERCATEGORY,
    RELATEDNETWORKACTIVITY,
    REVERSALREFERENCEDOCUMENT,
    REVERSALREFERENCEDOCUMENTCNTXT,
    SALESDISTRICT,
    SALESDOCUMENT,
    SALESDOCUMENTITEM,
    SALESORDER,
    SALESORDERITEM,
    SALESORGANIZATION,
    SEGMENT,
    SENDERACCOUNTASSIGNMENT,
    SENDERACCOUNTASSIGNMENTTYPE,
    SENDERGLACCOUNT,
    SERVICECONTRACT,
    SERVICECONTRACTITEM,
    SERVICECONTRACTTYPE,
    SERVICEDOCUMENT,
    SERVICEDOCUMENTITEM,
    SERVICEDOCUMENTTYPE,
    SERVICESRENDEREDDATE,
    SETTLEMENTREFERENCEDATE,
    SHIPTOPARTY,
    SOLDPRODUCT,
    SOLDPRODUCTGROUP,
    SOURCELOGICALSYSTEM,
    SOURCEREFERENCEDOCSUBITEM,
    SOURCEREFERENCEDOCUMENT,
    SOURCEREFERENCEDOCUMENTCNTXT,
    SOURCEREFERENCEDOCUMENTITEM,
    SOURCEREFERENCEDOCUMENTTYPE,
    SPECIALGLCODE,
    SUBLEDGERACCTLINEITEMTYPE,
    SUPERIORORDER,
    SUPPLIER,
    TAXCODE,
    TIMESHEETOVERTIMECATEGORY,
    TRANSACTIONCURRENCY,
    TRANSACTIONTYPEDETERMINATION,
    VALUATIONAREA,
    WBSELEMENT,
    WBSELEMENTEXTERNALID,
    WBSELEMENTINTERNALID,
    WBSISSTATISTICALWBSELEMENT,
    WORKCENTERINTERNALID,
    WORKITEM,
    WORKPACKAGE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, LEDGER, LEDGERGLLINEITEM, SOURCELEDGER)
);