P_ReportedFinancialData_RT_03

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_ReportedFinancialData_RT_03.
-- 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: PREPFINDRT_03
-- Parameters: p_timestamp_from : timestamp, p_timestamp_to : timestamp

CREATE VIEW P_ReportedFinancialData_RT_03 AS
SELECT
  I_FSItemMappingAssgmtWithVers.FinancialStatementItem AS ritem,
  I_FSItemMappingAssgmtWithVers.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  coalesce(tfin010.bunit,'') AS rbuptr,
  P_ReportedFinancialData_RT_02.gcurr AS rgcurr,
  P_ConsolidationUnitCurrency.curr AS rlcurr,
  P_ReportedFinancialData_RT_02.rdimen AS rdimen,
  P_ReportedFinancialData_RT_02.rldnr_fin AS rldnr_fin,
  P_ReportedFinancialData_RT_02.docln_fin AS docln_fin,
  P_ReportedFinancialData_RT_02.robukrs AS robukrs,
  P_ReportedFinancialData_RT_02.rassc AS rassc,
  P_ReportedFinancialData_RT_02.rvers AS rvers,
  P_ReportedFinancialData_RT_02.rbunit AS rbunit,
  P_ReportedFinancialData_RT_02.budat AS budat,
  P_ReportedFinancialData_RT_02.belnr AS belnr,
  P_ReportedFinancialData_RT_02.docln AS docln,
  P_ReportedFinancialData_RT_02.sbusa AS sbusa,
  P_ReportedFinancialData_RT_02.rldnr AS rldnr,
  P_ReportedFinancialData_RT_02.rtcur AS rtcur,
  P_ReportedFinancialData_RT_02.runit AS runit,
  P_ReportedFinancialData_RT_02.poper AS poper,
  P_ReportedFinancialData_RT_02.ryear AS ryear,
  P_ReportedFinancialData_RT_02.rmvct AS rmvct,
  P_ReportedFinancialData_RT_02.rfarea AS rfarea,
  P_ReportedFinancialData_RT_02.rcntr AS rcntr,
  P_ReportedFinancialData_RT_02.prctr AS prctr,
  P_ReportedFinancialData_RT_02.rbusa AS rbusa,
  P_ReportedFinancialData_RT_02.blart AS blart,
  P_ReportedFinancialData_RT_02.gjahr AS gjahr,
  P_ReportedFinancialData_RT_02.racct AS racct,
  P_ReportedFinancialData_RT_02.tsl AS tsl,
  P_ReportedFinancialData_RT_02.hsl AS hsl,
  P_ReportedFinancialData_RT_02.ksl AS ksl,
  P_ReportedFinancialData_RT_02.osl AS osl,
  P_ReportedFinancialData_RT_02.vsl AS vsl,
  P_ReportedFinancialData_RT_02.bsl AS bsl,
  P_ReportedFinancialData_RT_02.csl AS csl,
  P_ReportedFinancialData_RT_02.dsl AS dsl,
  P_ReportedFinancialData_RT_02.esl AS esl,
  P_ReportedFinancialData_RT_02.fsl AS fsl,
  P_ReportedFinancialData_RT_02.gsl AS gsl,
  P_ReportedFinancialData_RT_02.msl AS msl,
  P_ReportedFinancialData_RT_02.activ AS activ,
  P_ReportedFinancialData_RT_02.refdocnr AS refdocnr,
  P_ReportedFinancialData_RT_02.refryear AS refryear,
  P_ReportedFinancialData_RT_02.refactiv AS refactiv,
  P_ReportedFinancialData_RT_02.usnam AS usnam,
  P_ReportedFinancialData_RT_02.awtyp AS awtyp,
  P_ReportedFinancialData_RT_02.aworg AS aworg,
  P_ReportedFinancialData_RT_02.logsys AS logsys,
  P_ReportedFinancialData_RT_02.gcurr AS gcurr,
  P_ReportedFinancialData_RT_02.Segment AS Segment
FROM P_ReportedFinancialData_RT_02
LEFT OUTER JOIN I_FSItemMappingAssgmtWithVers ON /* join condition not captured in parsed metadata */
;