P_ReportedFinancialData_RT_04

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

CREATE VIEW P_ReportedFinancialData_RT_04 AS
SELECT
  I_CnsldtnFinStmntItem.BreakdownCategory AS itgrp,
  case when I_BreakdownCategoryField.BreakdownType = '0' or I_BreakdownCategoryField.BreakdownType is null then '' when I_BreakdownCategoryField.BreakdownType = '3' then I_BreakdownCategoryField.BreakdownCategoryFixedValue end as sityp AS BreakdownCategoryFixedValueendassityp,
  case tf110.sitem_send when '01' then P_ReportedFinancialData_RT_03.rmvct when '02' then P_ReportedFinancialData_RT_03.rfarea when '03' then P_ReportedFinancialData_RT_03.rbusa when '05' then P_ReportedFinancialData_RT_03.rcntr when '06' then P_ReportedFinancialData_RT_03.racct when '07' then P_ReportedFinancialData_RT_03.prctr when '08' then P_ReportedFinancialData_RT_03.Segment end as subit AS Segmentendassubit,
  tf110.sitem_send AS sitem_send,
  rmvct,
  rfarea,
  rbusa,
  rcntr,
  racct,
  prctr,
  Segment,
  P_ReportedFinancialData_RT_03.rdimen AS rdimen,
  P_ReportedFinancialData_RT_03.rldnr_fin AS rldnr_fin,
  P_ReportedFinancialData_RT_03.docln_fin AS docln_fin,
  P_ReportedFinancialData_RT_03.ConsolidationChartOfAccounts AS ritclg,
  P_ReportedFinancialData_RT_03.robukrs AS robukrs,
  P_ReportedFinancialData_RT_03.rbuptr AS rbuptr,
  P_ReportedFinancialData_RT_03.rvers AS rvers,
  P_ReportedFinancialData_RT_03.rbunit AS rbunit,
  P_ReportedFinancialData_RT_03.budat AS budat,
  P_ReportedFinancialData_RT_03.gjahr AS gjahr,
  P_ReportedFinancialData_RT_03.belnr AS belnr,
  P_ReportedFinancialData_RT_03.docln AS docln,
  P_ReportedFinancialData_RT_03.rldnr AS rldnr,
  P_ReportedFinancialData_RT_03.rtcur AS rtcur,
  P_ReportedFinancialData_RT_03.runit AS runit,
  P_ReportedFinancialData_RT_03.poper AS poper,
  P_ReportedFinancialData_RT_03.ryear AS ryear,
  P_ReportedFinancialData_RT_03.ritem AS ritem,
  P_ReportedFinancialData_RT_03.blart AS blart,
  P_ReportedFinancialData_RT_03.tsl AS tsl,
  P_ReportedFinancialData_RT_03.hsl AS hsl,
  P_ReportedFinancialData_RT_03.ksl AS ksl,
  P_ReportedFinancialData_RT_03.osl AS osl,
  P_ReportedFinancialData_RT_03.vsl AS vsl,
  P_ReportedFinancialData_RT_03.bsl AS bsl,
  P_ReportedFinancialData_RT_03.csl AS csl,
  P_ReportedFinancialData_RT_03.dsl AS dsl,
  P_ReportedFinancialData_RT_03.esl AS esl,
  P_ReportedFinancialData_RT_03.fsl AS fsl,
  P_ReportedFinancialData_RT_03.gsl AS gsl,
  P_ReportedFinancialData_RT_03.msl AS msl,
  P_ReportedFinancialData_RT_03.gcurr AS gcurr,
  P_ReportedFinancialData_RT_03.activ AS activ,
  P_ReportedFinancialData_RT_03.refdocnr AS refdocnr,
  P_ReportedFinancialData_RT_03.refryear AS refryear,
  P_ReportedFinancialData_RT_03.refactiv AS refactiv,
  P_ReportedFinancialData_RT_03.usnam AS usnam,
  P_ReportedFinancialData_RT_03.awtyp AS awtyp,
  P_ReportedFinancialData_RT_03.aworg AS aworg,
  P_ReportedFinancialData_RT_03.logsys AS logsys,
  P_ReportedFinancialData_RT_03.rgcurr AS rgcurr,
  P_ReportedFinancialData_RT_03.rlcurr AS rlcurr
FROM P_ReportedFinancialData_RT_03
;