C_CurrencyRateCalculation

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 C_CurrencyRateCalculation.
-- 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: CRCYRATECALC
-- Parameters: P_Date : sydatum, P_SAPClient : symandt, P_SourceCurrency : vdm_v_display_currency, P_TargetCurrency : vdm_v_display_currency, P_AmountInSourceCurrency : fis_revenue_hsl_p

CREATE VIEW C_CurrencyRateCalculation AS
SELECT
  :P_TargetCurrency AS TargetCurrency,
  currency_conversion( client => :P_SAPClient, amount => :P_AmountInSourceCurrency, source_currency => :P_SourceCurrency, target_currency => :P_TargetCurrency, exchange_rate_date => :P_Date, exchange_rate_type => 'M', round => #CDSBoolean.true, decimal_shift => #CDSBoolean.true, decimal_shift_back => #CDSBoolean.true ) as RecalculatedAmountInTargetCrcy AS trueasRecalculatedAmountInTargetCrcy
FROM I_Language
;