P_ReportedFinancialData_RT_02

DDL: P_REPORTEDFINANCIALDATA_RT_02 SQL: PREPFINDRT_02 Type: view COMPOSITE

P_ReportedFinancialData_RT_02 is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (P_DataSubmitRequest, P_ReportedFinancialData_RT_01) and exposes 48 fields.

Data Sources (2)

SourceAliasJoin Type
P_DataSubmitRequest P_DataSubmitRequest inner
P_ReportedFinancialData_RT_01 P_ReportedFinancialData_RT_01 from

Parameters (2)

NameTypeDefault
p_timestamp_from timestamp
p_timestamp_to timestamp

Annotations (12)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName PREPFINDRT_02 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 (48)

KeyFieldSource TableSource FieldDescription
rdimen P_ReportedFinancialData_RT_01 rdimen Dimension
rldnr_fin P_ReportedFinancialData_RT_01 rldnr_fin Source Ledger
docln_fin P_ReportedFinancialData_RT_01 docln_fin Journal Entry Item
robukrs P_ReportedFinancialData_RT_01 robukrs Orig. CC
rassc P_ReportedFinancialData_RT_01 rassc Trading Partner
rvers P_ReportedFinancialData_RT_01 rvers Version: Tax rt
impvs P_ReportedFinancialData_RT_01 impvs Mapping Version
rbunit P_ReportedFinancialData_RT_01 rbunit Consolidation Unit
budat P_ReportedFinancialData_RT_01 budat Posting Date
gjahr P_ReportedFinancialData_RT_01 gjahr Settlement Year
belnr P_ReportedFinancialData_RT_01 belnr SD Document
docln P_ReportedFinancialData_RT_01 docln Matching Document Line Item
rbusa P_ReportedFinancialData_RT_01 rbusa Business Area
sbusa P_ReportedFinancialData_RT_01 sbusa Trdg Part.BA
rldnr P_ReportedFinancialData_RT_01 rldnr Ledger (Compat.)
rtcur P_ReportedFinancialData_RT_01 rtcur Currency
runit P_ReportedFinancialData_RT_01 runit Unit/Area
racct P_ReportedFinancialData_RT_01 racct GL Account From
ktopl P_ReportedFinancialData_RT_01 ktopl G/L Chart of Accounts
poper P_ReportedFinancialData_RT_01 poper Posting periods
ryear P_ReportedFinancialData_RT_01 ryear Ref. Year1
rmvct P_ReportedFinancialData_RT_01 rmvct Transact. Type
rfarea P_ReportedFinancialData_RT_01 rfarea R FuncArea
rcntr P_ReportedFinancialData_RT_01 rcntr Cost Center
prctr P_ReportedFinancialData_RT_01 prctr Profit Centers
blart P_ReportedFinancialData_RT_01 blart Rep. rec. doc. type
tsl P_ReportedFinancialData_RT_01 tsl Trans. Currency
hsl P_ReportedFinancialData_RT_01 hsl Local Crcy Amt
ksl P_ReportedFinancialData_RT_01 ksl GrpCurr
osl P_ReportedFinancialData_RT_01 osl Other Crcy Amnt
vsl P_ReportedFinancialData_RT_01 vsl Amount in Currency 2
bsl P_ReportedFinancialData_RT_01 bsl Exchange Key
csl P_ReportedFinancialData_RT_01 csl Amount in Currency 4
dsl P_ReportedFinancialData_RT_01 dsl Amount in Currency 5
esl P_ReportedFinancialData_RT_01 esl Amount in Currency 6
fsl P_ReportedFinancialData_RT_01 fsl Amount in Currency 7
gsl P_ReportedFinancialData_RT_01 gsl Amount in Currency 8
msl P_ReportedFinancialData_RT_01 msl Stat. KeyFig. Qty
activ P_ReportedFinancialData_RT_01 activ Transaction
refdocnr P_ReportedFinancialData_RT_01 refdocnr Reference
refryear P_ReportedFinancialData_RT_01 refryear Reference year
refactiv P_ReportedFinancialData_RT_01 refactiv Ref. Transactn
usnam P_ReportedFinancialData_RT_01 usnam User Name
awtyp P_ReportedFinancialData_RT_01 awtyp Reference Document Type
aworg P_ReportedFinancialData_RT_01 aworg Refer. Org.Unit
logsys P_ReportedFinancialData_RT_01 logsys Source system
gcurr P_ReportedFinancialData_RT_01 gcurr Ledger curr.
Segment P_ReportedFinancialData_RT_01 Segment Segment number

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

CREATE VIEW P_ReportedFinancialData_RT_02 AS
SELECT
  P_ReportedFinancialData_RT_01.rdimen AS rdimen,
  P_ReportedFinancialData_RT_01.rldnr_fin AS rldnr_fin,
  P_ReportedFinancialData_RT_01.docln_fin AS docln_fin,
  P_ReportedFinancialData_RT_01.robukrs AS robukrs,
  P_ReportedFinancialData_RT_01.rassc AS rassc,
  P_ReportedFinancialData_RT_01.rvers AS rvers,
  P_ReportedFinancialData_RT_01.impvs AS impvs,
  P_ReportedFinancialData_RT_01.rbunit AS rbunit,
  P_ReportedFinancialData_RT_01.budat AS budat,
  P_ReportedFinancialData_RT_01.gjahr AS gjahr,
  P_ReportedFinancialData_RT_01.belnr AS belnr,
  P_ReportedFinancialData_RT_01.docln AS docln,
  P_ReportedFinancialData_RT_01.rbusa AS rbusa,
  P_ReportedFinancialData_RT_01.sbusa AS sbusa,
  P_ReportedFinancialData_RT_01.rldnr AS rldnr,
  P_ReportedFinancialData_RT_01.rtcur AS rtcur,
  P_ReportedFinancialData_RT_01.runit AS runit,
  P_ReportedFinancialData_RT_01.racct AS racct,
  P_ReportedFinancialData_RT_01.ktopl AS ktopl,
  P_ReportedFinancialData_RT_01.poper AS poper,
  P_ReportedFinancialData_RT_01.ryear AS ryear,
  P_ReportedFinancialData_RT_01.rmvct AS rmvct,
  P_ReportedFinancialData_RT_01.rfarea AS rfarea,
  P_ReportedFinancialData_RT_01.rcntr AS rcntr,
  P_ReportedFinancialData_RT_01.prctr AS prctr,
  P_ReportedFinancialData_RT_01.blart AS blart,
  P_ReportedFinancialData_RT_01.tsl AS tsl,
  P_ReportedFinancialData_RT_01.hsl AS hsl,
  P_ReportedFinancialData_RT_01.ksl AS ksl,
  P_ReportedFinancialData_RT_01.osl AS osl,
  P_ReportedFinancialData_RT_01.vsl AS vsl,
  P_ReportedFinancialData_RT_01.bsl AS bsl,
  P_ReportedFinancialData_RT_01.csl AS csl,
  P_ReportedFinancialData_RT_01.dsl AS dsl,
  P_ReportedFinancialData_RT_01.esl AS esl,
  P_ReportedFinancialData_RT_01.fsl AS fsl,
  P_ReportedFinancialData_RT_01.gsl AS gsl,
  P_ReportedFinancialData_RT_01.msl AS msl,
  P_ReportedFinancialData_RT_01.activ AS activ,
  P_ReportedFinancialData_RT_01.refdocnr AS refdocnr,
  P_ReportedFinancialData_RT_01.refryear AS refryear,
  P_ReportedFinancialData_RT_01.refactiv AS refactiv,
  P_ReportedFinancialData_RT_01.usnam AS usnam,
  P_ReportedFinancialData_RT_01.awtyp AS awtyp,
  P_ReportedFinancialData_RT_01.aworg AS aworg,
  P_ReportedFinancialData_RT_01.logsys AS logsys,
  P_ReportedFinancialData_RT_01.gcurr AS gcurr,
  P_ReportedFinancialData_RT_01.Segment AS Segment
FROM P_ReportedFinancialData_RT_01
INNER JOIN P_DataSubmitRequest ON /* join condition not captured in parsed metadata */
;