P_ReportedFinancialData_RT_06

DDL: P_REPORTEDFINANCIALDATA_RT_06 SQL: PREPFINDRT_06 Type: view COMPOSITE
35 Fields 1 Data Sources

P_ReportedFinancialData_RT_06 is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_ReportedFinancialData_RT_05) and exposes 35 fields.

Data Sources (1)

SourceAliasJoin Type
P_ReportedFinancialData_RT_05 P_ReportedFinancialData_RT_05 from

Parameters (2)

NameTypeDefault
p_timestamp_from timestamp
p_timestamp_to timestamp

Annotations (12)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName PREPFINDRT_06 view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view

Fields (35)

KeyFieldSource TableSource FieldDescription
rdimen P_ReportedFinancialData_RT_05 rdimen Dimension
rldnr_fin P_ReportedFinancialData_RT_05 rldnr_fin
docln_fin P_ReportedFinancialData_RT_05 docln_fin
ritclg P_ReportedFinancialData_RT_05 ritclg Consolidation COA
robukrs P_ReportedFinancialData_RT_05 robukrs Orig. CC
rbuptr P_ReportedFinancialData_RT_05 rbuptr Partner Unit
rvers P_ReportedFinancialData_RT_05 rvers Version: Tax rt
rbunit P_ReportedFinancialData_RT_05 rbunit Consolidation Unit
budat P_ReportedFinancialData_RT_05 budat Posting Date
gjahr P_ReportedFinancialData_RT_05 gjahr Settlement Year
belnr P_ReportedFinancialData_RT_05 belnr SD Document
docln P_ReportedFinancialData_RT_05 docln Matching Document Line Item
rldnr P_ReportedFinancialData_RT_05 rldnr Ledger (Compat.)
rtcur P_ReportedFinancialData_RT_05 rtcur Currency
runit P_ReportedFinancialData_RT_05 runit Unit/Area
poper P_ReportedFinancialData_RT_05 poper Posting periods
ryear P_ReportedFinancialData_RT_05 ryear Ref. Year1
ritem P_ReportedFinancialData_RT_05 ritem Reporting Item
sityp P_ReportedFinancialData_RT_05 sityp Trip Schedule Type
subit P_ReportedFinancialData_RT_05 subit Subitem
docty P_ReportedFinancialData_RT_05 docty Document Type
gslendashsl
rlcurr P_ReportedFinancialData_RT_05 rlcurr
rgcurr P_ReportedFinancialData_RT_05 rgcurr
tsl P_ReportedFinancialData_RT_05 tsl Trans. Currency
msl P_ReportedFinancialData_RT_05 msl Stat. KeyFig. Qty
itgrp P_ReportedFinancialData_RT_05 itgrp Breakdown Cat.
activ P_ReportedFinancialData_RT_05 activ Transaction
refdocnr P_ReportedFinancialData_RT_05 refdocnr Reference
refryear P_ReportedFinancialData_RT_05 refryear Reference year
refactiv P_ReportedFinancialData_RT_05 refactiv Ref. Transactn
usnam P_ReportedFinancialData_RT_05 usnam User Name
awtyp P_ReportedFinancialData_RT_05 awtyp Reference Document Type
aworg P_ReportedFinancialData_RT_05 aworg Refer. Org.Unit
logsys P_ReportedFinancialData_RT_05 logsys Source system

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

CREATE VIEW P_ReportedFinancialData_RT_06 AS
SELECT
  P_ReportedFinancialData_RT_05.rdimen AS rdimen,
  P_ReportedFinancialData_RT_05.rldnr_fin AS rldnr_fin,
  P_ReportedFinancialData_RT_05.docln_fin AS docln_fin,
  P_ReportedFinancialData_RT_05.ritclg AS ritclg,
  P_ReportedFinancialData_RT_05.robukrs AS robukrs,
  P_ReportedFinancialData_RT_05.rbuptr AS rbuptr,
  P_ReportedFinancialData_RT_05.rvers AS rvers,
  P_ReportedFinancialData_RT_05.rbunit AS rbunit,
  P_ReportedFinancialData_RT_05.budat AS budat,
  P_ReportedFinancialData_RT_05.gjahr AS gjahr,
  P_ReportedFinancialData_RT_05.belnr AS belnr,
  P_ReportedFinancialData_RT_05.docln AS docln,
  P_ReportedFinancialData_RT_05.rldnr AS rldnr,
  P_ReportedFinancialData_RT_05.rtcur AS rtcur,
  P_ReportedFinancialData_RT_05.runit AS runit,
  P_ReportedFinancialData_RT_05.poper AS poper,
  P_ReportedFinancialData_RT_05.ryear AS ryear,
  P_ReportedFinancialData_RT_05.ritem AS ritem,
  P_ReportedFinancialData_RT_05.sityp AS sityp,
  P_ReportedFinancialData_RT_05.subit AS subit,
  P_ReportedFinancialData_RT_05.docty AS docty,
  case P_ReportedFinancialData_RT_05.curr_local_send when 'H' then P_ReportedFinancialData_RT_05.hsl when 'K' then P_ReportedFinancialData_RT_05.ksl when 'O' then P_ReportedFinancialData_RT_05.osl when 'V' then P_ReportedFinancialData_RT_05.vsl when 'B' then P_ReportedFinancialData_RT_05.bsl when 'C' then P_ReportedFinancialData_RT_05.csl when 'D' then P_ReportedFinancialData_RT_05.dsl when 'E' then P_ReportedFinancialData_RT_05.esl when 'F' then P_ReportedFinancialData_RT_05.fsl when 'G' then P_ReportedFinancialData_RT_05.gsl end as hsl AS gslendashsl,
  P_ReportedFinancialData_RT_05.rlcurr AS rlcurr,
  P_ReportedFinancialData_RT_05.rgcurr AS rgcurr,
  P_ReportedFinancialData_RT_05.tsl AS tsl,
  P_ReportedFinancialData_RT_05.msl AS msl,
  P_ReportedFinancialData_RT_05.itgrp AS itgrp,
  P_ReportedFinancialData_RT_05.activ AS activ,
  P_ReportedFinancialData_RT_05.refdocnr AS refdocnr,
  P_ReportedFinancialData_RT_05.refryear AS refryear,
  P_ReportedFinancialData_RT_05.refactiv AS refactiv,
  P_ReportedFinancialData_RT_05.usnam AS usnam,
  P_ReportedFinancialData_RT_05.awtyp AS awtyp,
  P_ReportedFinancialData_RT_05.aworg AS aworg,
  P_ReportedFinancialData_RT_05.logsys AS logsys
FROM P_ReportedFinancialData_RT_05
;

Learn More