P_ReportedFinancialData_RT_05

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

CREATE VIEW P_ReportedFinancialData_RT_05 AS
SELECT
  P_ReportedFinancialData_RT_04.rdimen AS rdimen,
  P_ReportedFinancialData_RT_04.rldnr_fin AS rldnr_fin,
  P_ReportedFinancialData_RT_04.docln_fin AS docln_fin,
  P_ReportedFinancialData_RT_04.ritclg AS ritclg,
  P_ReportedFinancialData_RT_04.robukrs AS robukrs,
  P_ReportedFinancialData_RT_04.rvers AS rvers,
  P_ReportedFinancialData_RT_04.rbunit AS rbunit,
  P_ReportedFinancialData_RT_04.budat AS budat,
  P_ReportedFinancialData_RT_04.gjahr AS gjahr,
  P_ReportedFinancialData_RT_04.belnr AS belnr,
  P_ReportedFinancialData_RT_04.docln AS docln,
  P_ReportedFinancialData_RT_04.rldnr AS rldnr,
  P_ReportedFinancialData_RT_04.rtcur AS rtcur,
  P_ReportedFinancialData_RT_04.poper AS poper,
  P_ReportedFinancialData_RT_04.ryear AS ryear,
  P_ReportedFinancialData_RT_04.ritem AS ritem,
  P_ReportedFinancialData_RT_04.itgrp AS itgrp,
  P_ReportedFinancialData_RT_04.sityp AS sityp,
  sitem_send,
  rmvct,
  rfarea,
  rbusa,
  rcntr,
  racct,
  prctr,
  Segment,
  P_ReportedFinancialData_RT_04.tsl AS tsl,
  P_ReportedFinancialData_RT_04.hsl AS hsl,
  P_ReportedFinancialData_RT_04.ksl AS ksl,
  P_ReportedFinancialData_RT_04.osl AS osl,
  P_ReportedFinancialData_RT_04.vsl AS vsl,
  P_ReportedFinancialData_RT_04.bsl AS bsl,
  P_ReportedFinancialData_RT_04.csl AS csl,
  P_ReportedFinancialData_RT_04.dsl AS dsl,
  P_ReportedFinancialData_RT_04.esl AS esl,
  P_ReportedFinancialData_RT_04.fsl AS fsl,
  P_ReportedFinancialData_RT_04.gsl AS gsl,
  P_ReportedFinancialData_RT_04.gcurr AS gcurr,
  P_ReportedFinancialData_RT_04.activ AS activ,
  P_ReportedFinancialData_RT_04.refdocnr AS refdocnr,
  P_ReportedFinancialData_RT_04.refryear AS refryear,
  P_ReportedFinancialData_RT_04.refactiv AS refactiv,
  P_ReportedFinancialData_RT_04.usnam AS usnam,
  P_ReportedFinancialData_RT_04.awtyp AS awtyp,
  P_ReportedFinancialData_RT_04.aworg AS aworg,
  P_ReportedFinancialData_RT_04.logsys AS logsys,
  case when tf103a_runit.BreakdownType = '0' or tf103a_runit.BreakdownType is null then 0 when tf103a_runit.BreakdownType = '3' then P_ReportedFinancialData_RT_04.msl end as msl AS mslendasmsl,
  I_CnsldtnDocumentType.ConsolidationDocumentType AS docty,
  P_ReportedFinancialData_RT_04.rgcurr AS rgcurr,
  P_ReportedFinancialData_RT_04.rlcurr AS rlcurr
FROM P_ReportedFinancialData_RT_04
;