P_GLAcctBalance1

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_GLAcctBalance1.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PFIGLACCTBAL1
-- Parameters: P_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to

CREATE VIEW P_GLAcctBalance1 AS
SELECT
  P_Glacctbalance2.rldnr AS rldnr,
  P_Glacctbalance2.rbukrs AS rbukrs,
  P_Glacctbalance2.gjahr AS gjahr,
  P_Glacctbalance2.belnr AS belnr,
  P_Glacctbalance2.docln AS docln,
  P_Glacctbalance2.rldnr_pers AS rldnr_pers,
  P_FiscalPeriodCalendarDate.FiscalYear AS ryear,
  P_Glacctbalance2.rmvct AS rmvct,
  P_Glacctbalance2.bttype AS bttype,
  P_Glacctbalance2.awtyp AS awtyp,
  P_Glacctbalance2.awsys AS awsys,
  P_Glacctbalance2.aworg AS aworg,
  P_Glacctbalance2.awref AS awref,
  P_Glacctbalance2.awitem AS awitem,
  P_Glacctbalance2.awitgrp AS awitgrp,
  P_Glacctbalance2.xreversing AS xreversing,
  P_Glacctbalance2.xreversed AS xreversed,
  P_Glacctbalance2.aworg_rev AS aworg_rev,
  P_Glacctbalance2.awref_rev AS awref_rev,
  P_Glacctbalance2.xsettling AS xsettling,
  P_Glacctbalance2.xsettled AS xsettled,
  P_Glacctbalance2.prec_awtyp AS prec_awtyp,
  P_Glacctbalance2.prec_aworg AS prec_aworg,
  P_Glacctbalance2.prec_awref AS prec_awref,
  P_Glacctbalance2.prec_awitem AS prec_awitem,
  P_Glacctbalance2.racct AS racct,
  P_Glacctbalance2.prctr AS prctr,
  P_Glacctbalance2.rfarea AS rfarea,
  P_Glacctbalance2.rbusa AS rbusa,
  P_Glacctbalance2.kokrs AS kokrs,
  P_Glacctbalance2.segment AS segment,
  P_Glacctbalance2.scntr AS scntr,
  P_Glacctbalance2.pprctr AS pprctr,
  P_Glacctbalance2.sfarea AS sfarea,
  P_Glacctbalance2.sbusa AS sbusa,
  P_Glacctbalance2.rassc AS rassc,
  P_Glacctbalance2.psegment AS psegment,
  P_Glacctbalance2.drcrk AS drcrk,
  P_Glacctbalance2.periv AS periv,
  P_FiscalPeriodCalendarDate.FiscalYearPeriod AS fiscyearper,
  P_Glacctbalance2.blart AS blart,
  P_Glacctbalance2.buzei AS buzei,
  P_Glacctbalance2.zuonr AS zuonr,
  P_Glacctbalance2.bschl AS bschl,
  P_Glacctbalance2.bstat AS bstat,
  P_Glacctbalance2.ktosl AS ktosl,
  P_Glacctbalance2.slalittype AS slalittype,
  P_Glacctbalance2.usnam AS usnam,
  P_Glacctbalance2.eprctr AS eprctr,
  P_Glacctbalance2.rhoart AS rhoart,
  P_Glacctbalance2.ktopl AS ktopl,
  P_Glacctbalance2.lokkt AS lokkt,
  P_Glacctbalance2.ktop2 AS ktop2,
  P_Glacctbalance2.CreationDateTime AS CreationDateTime,
  P_Glacctbalance2.rebzg AS rebzg,
  P_Glacctbalance2.rebzj AS rebzj,
  P_Glacctbalance2.rebzz AS rebzz,
  P_Glacctbalance2.rebzt AS rebzt,
  P_Glacctbalance2.rbest AS rbest,
  P_Glacctbalance2.ebeln AS ebeln,
  P_Glacctbalance2.ebelp AS ebelp,
  P_Glacctbalance2.zekkn AS zekkn,
  P_Glacctbalance2.sgtxt AS sgtxt,
  P_Glacctbalance2.werks AS werks,
  P_Glacctbalance2.lifnr AS lifnr,
  P_Glacctbalance2.kunnr AS kunnr,
  P_Glacctbalance2.matnr AS matnr,
  P_Glacctbalance2.matnr_copa AS matnr_copa,
  P_Glacctbalance2.matkl AS matkl,
  P_Glacctbalance2.matkl_mm AS matkl_mm,
  P_Glacctbalance2.koart AS koart,
  P_Glacctbalance2.umskz AS umskz,
  P_Glacctbalance2.mwskz AS mwskz,
  P_Glacctbalance2.hbkid AS hbkid,
  P_Glacctbalance2.hktid AS hktid,
  P_Glacctbalance2.xopvw AS xopvw,
  P_Glacctbalance2.augbl AS augbl,
  P_Glacctbalance2.auggj AS auggj,
  P_Glacctbalance2.afabe AS afabe,
  P_Glacctbalance2.anln1 AS anln1,
  P_Glacctbalance2.anln2 AS anln2,
  P_Glacctbalance2.bzdat AS bzdat,
  P_Glacctbalance2.anbwa AS anbwa,
  P_Glacctbalance2.movcat AS movcat,
  P_Glacctbalance2.depr_period AS depr_period,
  P_Glacctbalance2.anlgr AS anlgr,
  P_Glacctbalance2.anlgr2 AS anlgr2,
  P_Glacctbalance2.AssetClass AS AssetClass,
  P_Glacctbalance2.kalnr AS kalnr,
  P_Glacctbalance2.kzbws AS kzbws,
  P_Glacctbalance2.sobkz AS sobkz,
  P_Glacctbalance2.mat_kdauf AS mat_kdauf,
  P_Glacctbalance2.InvtrySpclStockWBSElmntExtID AS InvtrySpclStockWBSElmntExtID,
  P_Glacctbalance2.mat_kdpos AS mat_kdpos,
  P_Glacctbalance2.mat_pspnr AS mat_pspnr,
  P_Glacctbalance2.mat_ps_posid AS mat_ps_posid,
  P_Glacctbalance2.mat_lifnr AS mat_lifnr,
  P_Glacctbalance2.bwtar AS bwtar,
  P_Glacctbalance2.bwkey AS bwkey,
  P_Glacctbalance2.SenderCompanyCode AS SenderCompanyCode,
  P_Glacctbalance2.racct_sender AS racct_sender,
  P_Glacctbalance2.accas_sender AS accas_sender,
  P_Glacctbalance2.beltp AS beltp,
  P_Glacctbalance2.muvflg AS muvflg,
  P_Glacctbalance2.gkont AS gkont,
  P_Glacctbalance2.gkoar AS gkoar,
  P_Glacctbalance2.erlkz AS erlkz,
  P_Glacctbalance2.pernr AS pernr,
  P_Glacctbalance2.scope AS scope,
  P_Glacctbalance2.pbukrs AS pbukrs,
  P_Glacctbalance2.pscope AS pscope,
  P_Glacctbalance2.ukostl AS ukostl,
  P_Glacctbalance2.ulstar AS ulstar,
  P_Glacctbalance2.OriginProduct AS OriginProduct,
  P_Glacctbalance2.VarianceOriginGLAccount AS VarianceOriginGLAccount,
  P_Glacctbalance2.accas AS accas,
  P_Glacctbalance2.nplnr AS nplnr,
  P_Glacctbalance2.nplnr_vorgn AS nplnr_vorgn,
  P_Glacctbalance2.prznr AS prznr,
  P_Glacctbalance2.kstrg AS kstrg,
  P_Glacctbalance2.qmnum AS qmnum,
  P_Glacctbalance2.ServiceDocumentType AS ServiceDocumentType,
  P_Glacctbalance2.ServiceDocument AS ServiceDocument,
  P_Glacctbalance2.ServiceDocumentItem AS ServiceDocumentItem,
  P_Glacctbalance2.PartnerServiceDocumentType AS PartnerServiceDocumentType,
  P_Glacctbalance2.PartnerServiceDocument AS PartnerServiceDocument,
  P_Glacctbalance2.PartnerServiceDocumentItem AS PartnerServiceDocumentItem,
  P_Glacctbalance2.ServiceContract AS ServiceContract,
  P_Glacctbalance2.ServiceContractType AS ServiceContractType,
  P_Glacctbalance2.ServiceContractItem AS ServiceContractItem,
  P_Glacctbalance2.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
  P_Glacctbalance2.erkrs AS erkrs,
  P_Glacctbalance2.paccas AS paccas,
  P_Glacctbalance2.plstar AS plstar,
  P_Glacctbalance2.paufnr AS paufnr,
  P_Glacctbalance2.PartnerOrder_2 AS PartnerOrder_2,
  P_Glacctbalance2.pautyp AS pautyp,
  P_Glacctbalance2.pps_posid AS pps_posid,
  P_Glacctbalance2.pps_pspid AS pps_pspid,
  P_Glacctbalance2.ps_prj_pnr AS ps_prj_pnr,
  P_Glacctbalance2.pkdauf AS pkdauf,
  P_Glacctbalance2.pkdpos AS pkdpos,
  P_Glacctbalance2.pnplnr AS pnplnr,
  P_Glacctbalance2.pnplnr_vorgn AS pnplnr_vorgn,
  P_Glacctbalance2.pprznr AS pprznr,
  P_Glacctbalance2.pkstrg AS pkstrg,
  P_Glacctbalance2.fkart AS fkart,
  P_Glacctbalance2.vkorg AS vkorg,
  P_Glacctbalance2.vtweg AS vtweg,
  P_Glacctbalance2.spart AS spart,
  P_Glacctbalance2.kdgrp AS kdgrp,
  P_Glacctbalance2.CustomerSupplierCountry AS CustomerSupplierCountry,
  P_Glacctbalance2.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  P_Glacctbalance2.FinancialServicesProductGroup AS FinancialServicesProductGroup,
  P_Glacctbalance2.FinancialServicesBranch AS FinancialServicesBranch,
  P_Glacctbalance2.FinancialDataSource AS FinancialDataSource,
  P_Glacctbalance2.fikrs AS fikrs,
  P_Glacctbalance2.rfund AS rfund,
  P_Glacctbalance2.rgrant_nbr AS rgrant_nbr,
  P_Glacctbalance2.rbudget_pd AS rbudget_pd,
  P_Glacctbalance2.sfund AS sfund,
  P_Glacctbalance2.sgrant_nbr AS sgrant_nbr,
  P_Glacctbalance2.sbudget_pd AS sbudget_pd,
  P_Glacctbalance2.vname AS vname,
  P_Glacctbalance2.egrup AS egrup,
  P_Glacctbalance2.recid AS recid,
  P_Glacctbalance2.etype AS etype,
  P_Glacctbalance2.dabrz AS dabrz,
  P_Glacctbalance2.rcntr AS rcntr,
  P_Glacctbalance2.lstar AS lstar,
  P_Glacctbalance2.aufnr AS aufnr,
  P_Glacctbalance2.autyp AS autyp,
  P_Glacctbalance2.ps_psp_pnr AS ps_psp_pnr,
  P_Glacctbalance2.ps_posid AS ps_posid,
  P_Glacctbalance2.PartnerWBSElementInternalID AS PartnerWBSElementInternalID,
  P_Glacctbalance2.PartnerWBSElementExternalID AS PartnerWBSElementExternalID,
  P_Glacctbalance2.posid_edit AS posid_edit,
  P_Glacctbalance2.ps_pspid AS ps_pspid,
  P_Glacctbalance2.pspid_edit AS pspid_edit,
  P_Glacctbalance2.PartnerProjectInternalID AS PartnerProjectInternalID,
  P_Glacctbalance2.PartnerProjectExternalID AS PartnerProjectExternalID,
  P_Glacctbalance2.kdauf AS kdauf,
  P_Glacctbalance2.kdpos AS kdpos,
  P_FiscalPeriodCalendarDate.FiscalPeriod AS poper,
  P_Glacctbalance2.augdt AS augdt,
  P_Glacctbalance2.ConsolidationUnit AS ConsolidationUnit,
  P_Glacctbalance2.PartnerConsolidationUnit AS PartnerConsolidationUnit,
  P_Glacctbalance2.Company AS Company,
  P_Glacctbalance2.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  P_Glacctbalance2.CnsldtnFinancialStatementItem AS CnsldtnFinancialStatementItem,
  P_Glacctbalance2.CnsldtnSubitemCategory AS CnsldtnSubitemCategory,
  P_Glacctbalance2.CnsldtnSubitem AS CnsldtnSubitem,
  P_Glacctbalance2._CompanyCode AS _CompanyCode,
  P_Glacctbalance2._ControllingArea AS _ControllingArea,
  P_Glacctbalance2._BalanceTransactionCurrency AS _BalanceTransactionCurrency,
  P_Glacctbalance2._TransactionCurrency AS _TransactionCurrency,
  P_Glacctbalance2._CompanyCodeCurrency AS _CompanyCodeCurrency,
  P_Glacctbalance2._GlobalCurrency AS _GlobalCurrency,
  P_Glacctbalance2._FreeDefinedCurrency1 AS _FreeDefinedCurrency1,
  P_Glacctbalance2._FreeDefinedCurrency2 AS _FreeDefinedCurrency2,
  P_Glacctbalance2._FreeDefinedCurrency3 AS _FreeDefinedCurrency3,
  P_Glacctbalance2._FreeDefinedCurrency4 AS _FreeDefinedCurrency4,
  P_Glacctbalance2._FreeDefinedCurrency5 AS _FreeDefinedCurrency5,
  P_Glacctbalance2._FreeDefinedCurrency6 AS _FreeDefinedCurrency6,
  P_Glacctbalance2._FreeDefinedCurrency7 AS _FreeDefinedCurrency7,
  P_Glacctbalance2._FreeDefinedCurrency8 AS _FreeDefinedCurrency8,
  P_Glacctbalance2._Segment AS _Segment,
  P_Glacctbalance2._ProfitCenter AS _ProfitCenter,
  P_Glacctbalance2._BusinessArea AS _BusinessArea,
  P_Glacctbalance2._FunctionalArea AS _FunctionalArea,
  P_Glacctbalance2._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  P_Glacctbalance2._ChartOfAccounts AS _ChartOfAccounts,
  P_Glacctbalance2._AccountingDocumentType AS _AccountingDocumentType,
  P_Glacctbalance2._FinancialAccountType AS _FinancialAccountType,
  P_Glacctbalance2._DebitCreditCode AS _DebitCreditCode,
  P_Glacctbalance2._Plant AS _Plant,
  P_Glacctbalance2._Ledger AS _Ledger,
  P_Glacctbalance2._FunctionalCurrency AS _FunctionalCurrency,
  P_Glacctbalance2.rtcur AS rtcur,
  P_Glacctbalance2.rwcur AS rwcur,
  P_Glacctbalance2.rhcur AS rhcur,
  P_Glacctbalance2.rkcur AS rkcur,
  P_Glacctbalance2.FunctionalCurrency AS FunctionalCurrency,
  P_Glacctbalance2.rocur AS rocur,
  P_Glacctbalance2.rvcur AS rvcur,
  P_Glacctbalance2.rbcur AS rbcur,
  P_Glacctbalance2.rccur AS rccur,
  P_Glacctbalance2.rdcur AS rdcur,
  P_Glacctbalance2.recur AS recur,
  P_Glacctbalance2.rfcur AS rfcur,
  P_Glacctbalance2.rgcur AS rgcur,
  P_FiscalPeriodCalendarDate.FiscalPeriodDate AS FiscalPeriodDate,
  P_FiscalPeriodCalendarDate.CalendarDate AS budat,
  P_Glacctbalance2.budat AS budat2,
  P_Glacctbalance2.OffsettingChartOfAccounts AS OffsettingChartOfAccounts,
  P_Glacctbalance2.JrnlEntryItemObsoleteReason AS JrnlEntryItemObsoleteReason,
  cast( 0 as fis_dr_hsl ) AS hsl_debit,
  cast( 0 as fis_cr_hsl ) AS hsl_credit,
  cast( 0 as fis_dr_wsl ) AS wsl_debit,
  cast( 0 as fis_cr_wsl ) AS wsl_credit,
  cast( 0 as fis_dr_tsl ) AS tsl_debit,
  cast( 0 as fis_cr_tsl ) AS tsl_credit,
  cast( 0 as fis_dr_ksl ) AS ksl_debit,
  cast( 0 as fis_cr_ksl ) AS ksl_credit,
  cast( 0 as fis_dr_amt_funccrcy ) AS DebitAmountInFunctionalCrcy,
  cast( 0 as fis_cr_amt_funccrcy ) AS CreditAmountInFunctionalCrcy,
  cast( 0 as fis_dr_osl ) AS osl_debit,
  cast( 0 as fis_cr_osl ) AS osl_credit,
  cast( 0 as fis_dr_vsl ) AS vsl_debit,
  cast( 0 as fis_cr_vsl ) AS vsl_credit,
  cast( 0 as fis_dr_bsl ) AS bsl_debit,
  cast( 0 as fis_cr_bsl ) AS bsl_credit,
  cast( 0 as fis_dr_csl ) AS csl_debit,
  cast( 0 as fis_cr_csl ) AS csl_credit,
  cast( 0 as fis_dr_dsl ) AS dsl_debit,
  cast( 0 as fis_cr_dsl ) AS dsl_credit,
  cast( 0 as fis_dr_esl ) AS esl_debit,
  cast( 0 as fis_cr_esl ) AS esl_credit,
  cast( 0 as fis_dr_fsl ) AS fsl_debit,
  cast( 0 as fis_cr_fsl ) AS fsl_credit,
  cast( 0 as fis_dr_gsl ) AS gsl_debit,
  cast( 0 as fis_cr_gsl ) AS gsl_credit,
  cast( P_Glacctbalance2.hsl as fis_end_bal_hsl ) AS hsl_end_bal,
  cast( P_Glacctbalance2.wsl as fis_end_bal_wsl ) AS wsl_end_bal,
  cast( P_Glacctbalance2.tsl as fis_end_bal_tsl ) AS tsl_end_bal,
  cast( P_Glacctbalance2.ksl as fis_end_bal_ksl ) AS ksl_end_bal,
  cast( P_Glacctbalance2.AmountInFunctionalCurrency as fis_end_bal_fcsl_ui ) AS EndingBalanceAmtInFuncnlCrcy,
  cast( P_Glacctbalance2.osl as fis_end_bal_osl ) AS osl_end_bal,
  cast( P_Glacctbalance2.vsl as fis_end_bal_vsl ) AS vsl_end_bal,
  cast( P_Glacctbalance2.bsl as fis_end_bal_bsl ) AS bsl_end_bal,
  cast( P_Glacctbalance2.csl as fis_end_bal_csl ) AS csl_end_bal,
  cast( P_Glacctbalance2.dsl as fis_end_bal_dsl ) AS dsl_end_bal,
  cast( P_Glacctbalance2.esl as fis_end_bal_esl ) AS esl_end_bal,
  cast( P_Glacctbalance2.fsl as fis_end_bal_fsl ) AS fsl_end_bal,
  cast( P_Glacctbalance2.gsl as fis_end_bal_gsl ) AS gsl_end_bal,
  P_Glacctbalance2.AccrualObjectType AS AccrualObjectType,
  P_Glacctbalance2.AccrualObject AS AccrualObject,
  P_Glacctbalance2.AccrualSubobject AS AccrualSubobject,
  P_Glacctbalance2.AccrualItemType AS AccrualItemType,
  P_Glacctbalance2.AccrualObjectLogicalSystem AS AccrualObjectLogicalSystem,
  P_Glacctbalance2.AccrualReferenceObject AS AccrualReferenceObject,
  P_Glacctbalance2.AccrualValueDate AS AccrualValueDate,
  P_Glacctbalance2.CashLedgerCompanyCode AS CashLedgerCompanyCode,
  P_Glacctbalance2.CashLedgerAccount AS CashLedgerAccount,
  P_Glacctbalance2.FinancialManagementArea AS FinancialManagementArea,
  P_Glacctbalance2.FundsCenter AS FundsCenter,
  P_Glacctbalance2.FundedProgram AS FundedProgram,
  P_Glacctbalance2.Fund AS Fund,
  P_Glacctbalance2.GrantID AS GrantID,
  P_Glacctbalance2.BudgetPeriod AS BudgetPeriod,
  P_Glacctbalance2.PartnerFund AS PartnerFund,
  P_Glacctbalance2.PartnerGrant AS PartnerGrant,
  P_Glacctbalance2.PartnerBudgetPeriod AS PartnerBudgetPeriod,
  P_Glacctbalance2.PubSecBudgetAccount AS PubSecBudgetAccount,
  P_Glacctbalance2.PubSecBudgetAccountCoCode AS PubSecBudgetAccountCoCode,
  P_Glacctbalance2.PubSecBudgetCnsmpnDate AS PubSecBudgetCnsmpnDate,
  P_Glacctbalance2.PubSecBudgetCnsmpnFsclPeriod AS PubSecBudgetCnsmpnFsclPeriod,
  P_Glacctbalance2.PubSecBudgetCnsmpnFsclYear AS PubSecBudgetCnsmpnFsclYear,
  P_Glacctbalance2.PubSecBudgetIsRelevant AS PubSecBudgetIsRelevant,
  P_Glacctbalance2.PubSecBudgetCnsmpnType AS PubSecBudgetCnsmpnType,
  P_Glacctbalance2.PubSecBudgetCnsmpnAmtType AS PubSecBudgetCnsmpnAmtType,
  P_Glacctbalance2.IsStatisticalCostCenter AS IsStatisticalCostCenter,
  P_Glacctbalance2.IsStatisticalOrder AS IsStatisticalOrder,
  P_Glacctbalance2.IsStatisticalSalesDocument AS IsStatisticalSalesDocument,
  P_Glacctbalance2.WBSIsStatisticalWBSElement AS WBSIsStatisticalWBSElement,
  cast (P_Glacctbalance2.ryear as fis_ryear_flow preserving type ) AS FlowOfFundsLedgerFiscalYear,
  P_Glacctbalance2._PartnerProjectExternalID AS _PartnerProjectExternalID,
  P_Glacctbalance2._PartnerProjctExtrnalIDText AS _PartnerProjctExtrnalIDText,
  P_Glacctbalance2._PartnerWBSElementExternalID AS _PartnerWBSElementExternalID,
  P_Glacctbalance2._PartnerWBSElemntExtrnalIDText AS _PartnerWBSElemntExtrnalIDText,
  P_Glacctbalance2._PartnerProjectBasicData AS _PartnerProjectBasicData,
  P_Glacctbalance2._PartnerProjectBasicDataText AS _PartnerProjectBasicDataText,
  P_Glacctbalance2._PartnerWBSElementBasicData AS _PartnerWBSElementBasicData,
  P_Glacctbalance2._PartnerWBSElmntBasicDataText AS _PartnerWBSElmntBasicDataText,
  P_Glacctbalance2._InvtrySpclStockWBSElmntBD AS _InvtrySpclStockWBSElmntBD,
  P_Glacctbalance2._InvtrySpclStockWBSElmntExtID AS _InvtrySpclStockWBSElmntExtID,
  P_Glacctbalance2._ServiceContract AS _ServiceContract,
  P_Glacctbalance2._ServiceContractType AS _ServiceContractType,
  P_Glacctbalance2._ServiceContractItem AS _ServiceContractItem,
  P_Glacctbalance2._TimeSheetOvertimeCat AS _TimeSheetOvertimeCat,
  P_Glacctbalance2._AccrualObjectType AS _AccrualObjectType,
  P_Glacctbalance2._AccrualObject AS _AccrualObject,
  P_Glacctbalance2._AccrualSubobject AS _AccrualSubobject,
  P_Glacctbalance2._AccrualItemType AS _AccrualItemType,
  P_Glacctbalance2._CashLedgerCompanyCode AS _CashLedgerCompanyCode,
  P_Glacctbalance2._CashLedgerAccount AS _CashLedgerAccount,
  P_Glacctbalance2._FinancialManagementArea AS _FinancialManagementArea,
  P_Glacctbalance2._FundsCenter AS _FundsCenter,
  P_Glacctbalance2._FundedProgram AS _FundedProgram,
  P_Glacctbalance2._Fund AS _Fund,
  P_Glacctbalance2._BudgetPeriod AS _BudgetPeriod,
  P_Glacctbalance2._PartnerFund AS _PartnerFund,
  P_Glacctbalance2._PartnerBudgetPeriod AS _PartnerBudgetPeriod,
  P_Glacctbalance2._PubSecBudgetAccountCoCode AS _PubSecBudgetAccountCoCode,
  P_Glacctbalance2._PubSecBudgetAccount AS _PubSecBudgetAccount,
  P_Glacctbalance2._PubSecBudgetCnsmpnDate AS _PubSecBudgetCnsmpnDate,
  P_Glacctbalance2._PubSecBudgetCnsmpnFsclPeriod AS _PubSecBudgetCnsmpnFsclPeriod,
  P_Glacctbalance2._PubSecBudgetCnsmpnFsclYear AS _PubSecBudgetCnsmpnFsclYear,
  P_Glacctbalance2._PubSecBudgetCnsmpnType AS _PubSecBudgetCnsmpnType,
  P_Glacctbalance2._PubSecBudgetCnsmpnAmtType AS _PubSecBudgetCnsmpnAmtType,
  P_Glacctbalance2._ConsolidationUnit AS _ConsolidationUnit,
  P_Glacctbalance2._PartnerConsolidationUnit AS _PartnerConsolidationUnit,
  P_Glacctbalance2._Company AS _Company,
  P_Glacctbalance2._ConsolidationChartOfAccounts AS _ConsolidationChartOfAccounts,
  P_Glacctbalance2._CnsldtnFinancialStatementItem AS _CnsldtnFinancialStatementItem,
  P_Glacctbalance2._CnsldtnSubitemCategory AS _CnsldtnSubitemCategory,
  P_Glacctbalance2._CnsldtnSubitem AS _CnsldtnSubitem,
  P_Glacctbalance2._CustomerCompany AS _CustomerCompany,
  P_Glacctbalance2._SupplierCompany AS _SupplierCompany
FROM P_Glacctbalance2
INNER JOIN P_FiscalPeriodCalendarDate ON /* join condition not captured in parsed metadata */
;