P_ExchangeRate3

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_ExchangeRate3.
-- 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_GENVIEW3110

CREATE VIEW P_ExchangeRate3 AS
SELECT
  Join_3.kurst AS kurst,
  Join_3.fcurr AS fcurr,
  Join_3.tcurr AS tcurr,
  cast(Join_3.gdatu as abap.numc(8)) AS gdatu,
  cast(Join_3.ukurs as fis_exchange_rate) AS ukurs,
  Join_4.ffact AS ffact,
  Join_4.tfact AS tfact,
  Join_4.abwct AS abwct,
  Join_4.abwga AS abwga,
  cast(ExchRateIsIndirectQuotation as fis_indirect_quotation) AS ExchRateIsIndirectQuotation,
  cast(Join_3.ukurs as fis_absolute_exchangerate) AS AbsoluteExchangeRate,
  cast(division(Join_3.ukurs, Join_4.ffact, 5) * Join_4.tfact as fis_effective_exchangerate) AS EffectiveExchangeRate,
  cast(Join_3.ukurs as fis_direct_exchange_rate) AS DirectQuotedEffectiveExchRate,
  cast(Join_5.ukurs as fis_indirect_exchange_rate) AS IndirectQuotedEffctvExchRate
FROM tcurr AS Join_3
INNER JOIN P_ExchangeRate1 AS Aggregation_1 ON /* join condition not captured in parsed metadata */
INNER JOIN tcurf AS Join_4 ON /* join condition not captured in parsed metadata */
INNER JOIN P_ExchangeRate2 AS Aggregation_2 ON /* join condition not captured in parsed metadata */
INNER JOIN tcurf AS Join_6 ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): tcurr
;