P_RU_DSGLAcctBalWithCompPeriod

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_RU_DSGLAcctBalWithCompPeriod.
-- 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: PRUDSGLACCTBALPR
-- Parameters: P_Ledger : fis_rldnr, P_StartPostingDate : fis_budat, P_EndPostingDate : fis_budat, P_ComprnFromPostingDate : fis_budat, P_ComprnToPostingDate : fis_budat, P_ComparisonFromPostingDate2 : fis_budat, P_ComparisonToPostingDate2 : fis_budat, P_CurrencyRole : fis_curtp, P_AlternativeGLAccountIsUsed : char1

CREATE VIEW P_RU_DSGLAcctBalWithCompPeriod AS
SELECT
  GLbalance.Ledger AS Ledger,
  GLbalance.CompanyCode AS CompanyCode,
  GLbalance.AccountingDocument AS AccountingDocument,
  GLbalance.LedgerGLLineItem AS LedgerGLLineItem,
  GLbalance.FiscalYear AS FiscalYear,
  GLbalance.PostingDate AS PostingDate,
  cast( GLbalance.ChartOfAccounts as ktopl preserving type ) AS ChartOfAccounts,
  GLbalance.GLAccount AS GLAccount,
  GLbalance.AlternativeGLAccount AS AlternativeGLAccount,
  GLbalance.Currency AS Currency,
  cast( coalesce( GLbalance.PeriodBalAmtInDspCrcy, 0 ) as fis_cr_gsl ) AS PeriodBalAmt,
  cast( coalesce( GLbalance.YearOpeningBalAmtInDspCrcy, 0 ) as fis_cr_gsl ) AS YearOpeningBalAmt,
  cast( coalesce( GLbalance.OpeningPeriodBalAmtInDspCrcy, 0 ) as fis_cr_gsl ) AS OpeningPeriodBalAmt,
  cast( coalesce( GLbalance.EndingPeriodBalAmtInDspCrcy, 0 ) as fis_cr_gsl ) AS EndingPeriodBalAmt,
  cast( coalesce( GLbalance.CreditPeriodBalAmtInDspCrcy, 0 ) as fis_cr_gsl ) AS CreditPeriodBalAmt,
  cast( coalesce( GLbalance.DebitPeriodBalAmtInDspCrcy, 0 ) as fis_cr_gsl ) AS DebitPeriodBalAmt
FROM P_GLAcctBalWithComprnPeriod
;