P_RU_DataSelFinSTMNT

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_DataSelFinSTMNT.
-- 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: PRUDTSELFINSTMNT
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id, P_FinancialStatementHierarchy : hryid, P_FinancialStatementHierarchy3 : hryid, P_Ledger : fis_rldnr, P_FromPostingDate : fis_budat, P_ToPostingDate : 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, P_Language : sylangu

CREATE VIEW P_RU_DataSelFinSTMNT AS
SELECT
  GLbalance.CompanyCode AS CompanyCode,
  GLbalance.FiscalYear AS FiscalYear,
  GLbalance.AccountingDocument AS AccountingDocument,
  GLbalance.LedgerGLLineItem AS LedgerGLLineItem,
  cast( GLbalance.PeriodBalAmtInDspCrcy as fis_cr_gsl ) AS PeriodBalAmt,
  cast( GLbalance.YearOpeningBalAmtInDspCrcy as fis_cr_gsl ) AS YearOpeningBalAmt,
  cast( GLbalance.OpeningPeriodBalAmtInDspCrcy as fis_cr_gsl ) AS OpeningPeriodBalAmt,
  cast( GLbalance.EndingPeriodBalAmtInDspCrcy as fis_cr_gsl ) AS EndingPeriodBalAmt,
  cast( GLbalance.CreditPeriodBalAmtInDspCrcy as fis_cr_gsl ) AS CreditPeriodBalAmt,
  cast( GLbalance.DebitPeriodBalAmtInDspCrcy as fis_cr_gsl ) AS DebitPeriodBalAmt,
  GLbalance.Currency AS Currency,
  left(Hierarchy.FinancialStatementHierarchy,4) AS FormCode,
  $parameters.P_StatryRptgEntity AS StatryRptgEntity,
  $parameters.P_StatryRptCategory AS StatryRptCategory,
  $parameters.P_StatryRptRunID AS StatryRptRunID,
  Hierarchy.FinancialStatementHierarchy AS FinancialStatementHierarchy,
  Hierarchy.GLAccountInfo AS GLAccountInfo,
  Hierarchy.FinancialStatementLeafItem AS FinancialStatementLeafItem,
  cast( '' as belnr_d ) AS InvoiceNumber,
  cast( '0000' as gjahr ) AS InvoiceYear,
  cast( '' as docln ) AS InvoiceItem,
  cast( '' as docln ) AS OffsettingItem,
  P_StartPostingDate: :P_FromPostingDate AS P_StartPostingDateP_FromPostingDate,
  P_EndPostingDate: :P_ToPostingDate AS P_EndPostingDateP_ToPostingDate
FROM I_FinStmntExpandedHierNode AS Hierarchy
LEFT OUTER JOIN P_RU_GLAcctBalWithComprnPeriod ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_FinStmntExpandedHierNode
;