P_ExchangeRate1

DDL: P_EXCHANGERATE1 SQL: P_GENVIEW3108 Type: view BASIC
6 Fields 2 Data Sources

P_ExchangeRate1 is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (tcurf, tcurr) and exposes 6 fields with key fields kurst, fcurr, tcurr, GDATU_R.

Data Sources (2)

SourceAliasJoin Type
tcurf tcurf from
tcurr tcurr inner

Annotations (7)

NameValueLevelField
VDM.viewType #BASIC view
AbapCatalog.sqlViewName P_GENVIEW3108 view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY kurst tcurf kurst Fix.rate type (EMU)
KEY fcurr tcurf fcurr From currency
KEY tcurr tcurf tcurr Trans. Currency
KEY GDATU_R
ExchRateIsIndirectQuotation
GDATU_TCURF

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_ExchangeRate1.
-- 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: P_GENVIEW3108

CREATE VIEW P_ExchangeRate1 AS
SELECT
  tcurf.kurst AS kurst,
  tcurf.fcurr AS fcurr,
  tcurf.tcurr AS tcurr,
  cast( tcurr.gdatu as abap.char(8)) AS GDATU_R,
  cast( '' as fis_indirect_quotation) AS ExchRateIsIndirectQuotation,
  min(tcurf.gdatu) AS GDATU_TCURF
FROM tcurf
INNER JOIN tcurr ON /* join condition not captured in parsed metadata */
;

Learn More