P_ReportedFinancialData_RT_02
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)
| Source | Alias | Join Type |
|---|---|---|
| P_DataSubmitRequest | P_DataSubmitRequest | inner |
| P_ReportedFinancialData_RT_01 | P_ReportedFinancialData_RT_01 | from |
Parameters (2)
| Name | Type | Default |
|---|---|---|
| p_timestamp_from | timestamp | |
| p_timestamp_to | timestamp |
Annotations (12)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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 */
;
Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA