P_ReportedFinancialData_RT_07

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

CREATE VIEW P_ReportedFinancialData_RT_07 AS
SELECT
  P_ReportedFinancialData_RT_06.rdimen AS rdimen,
  P_ReportedFinancialData_RT_06.rldnr_fin AS rldnr_fin,
  P_ReportedFinancialData_RT_06.docln_fin AS docln_fin,
  P_ReportedFinancialData_RT_06.ritclg AS ritclg,
  P_ReportedFinancialData_RT_06.robukrs AS robukrs,
  P_ReportedFinancialData_RT_06.rbuptr AS rbuptr,
  P_ReportedFinancialData_RT_06.rvers AS rvers,
  P_ReportedFinancialData_RT_06.rbunit AS rbunit,
  P_ReportedFinancialData_RT_06.budat AS budat,
  P_ReportedFinancialData_RT_06.belnr AS belnr,
  P_ReportedFinancialData_RT_06.docln AS docln,
  P_ReportedFinancialData_RT_06.rldnr AS rldnr,
  P_ReportedFinancialData_RT_06.runit AS runit,
  P_ReportedFinancialData_RT_06.poper AS poper,
  P_ReportedFinancialData_RT_06.ryear AS ryear,
  P_ReportedFinancialData_RT_06.ritem AS ritem,
  P_ReportedFinancialData_RT_06.sityp AS sityp,
  P_ReportedFinancialData_RT_06.subit AS subit,
  rmvct,
  rfarea,
  rbusa,
  rcntr,
  racct,
  prctr,
  segment,
  P_ReportedFinancialData_RT_06.docty AS docty,
  case when tf103a_rtcur.BreakdownType = '' or tf103a_rtcur.BreakdownType is null then case I_CnsldtnUnit.DocumentEntryIsInGroupCurrency when '' then P_ReportedFinancialData_RT_06.hsl when 'X' then P_ReportedFinancialData_RT_06.ksl end when tf103a_rtcur.BreakdownType = '2' then P_ReportedFinancialData_RT_06.tsl end as tsl AS tslendastsl,
  P_ReportedFinancialData_RT_06.hsl AS hsl,
  P_ReportedFinancialData_RT_06.ksl AS ksl,
  P_ReportedFinancialData_RT_06.msl AS msl,
  P_ReportedFinancialData_RT_06.rlcurr AS rlcurr,
  P_ReportedFinancialData_RT_06.rgcurr AS rgcurr,
  P_ReportedFinancialData_RT_06.activ AS activ,
  P_ReportedFinancialData_RT_06.refdocnr AS refdocnr,
  P_ReportedFinancialData_RT_06.refryear AS refryear,
  P_ReportedFinancialData_RT_06.refactiv AS refactiv,
  P_ReportedFinancialData_RT_06.usnam AS usnam,
  P_ReportedFinancialData_RT_06.awtyp AS awtyp,
  P_ReportedFinancialData_RT_06.aworg AS aworg,
  P_ReportedFinancialData_RT_06.logsys AS logsys
FROM P_ReportedFinancialData_RT_06
LEFT OUTER JOIN acdoca AS _acdoca ON P_ReportedFinancialData_RT_06.rldnr_fin = _acdoca.rldnr AND P_ReportedFinancialData_RT_06.robukrs = _acdoca.rbukrs AND P_ReportedFinancialData_RT_06.refryear = _acdoca.gjahr AND P_ReportedFinancialData_RT_06.belnr = _acdoca.belnr AND P_ReportedFinancialData_RT_06.docln_fin = _acdoca.docln  -- association [1..1]
;