A_CurrencyExchangeRate

DDL: A_CURRENCYEXCHANGERATE Type: view_entity CONSUMPTION Package: ODATA_CRCY_EXCHANGE_RATES_V2
14 Fields 1 Data Sources 2 OData Services

Currency Exchange Rate

A_CurrencyExchangeRate is a Consumption CDS View that provides data about "Currency Exchange Rate" in SAP S/4HANA. It reads from 1 data source (R_CurrencyExchangeRateTP) and exposes 14 fields with key fields ExchangeRateType, SourceCurrency, TargetCurrency, ExchangeRateEffectiveDate. It is exposed through 2 OData services (API_CURRENCYEXCHANGERATE, ASQL_F9048). Part of development package ODATA_CRCY_EXCHANGE_RATES_V2.

Data Sources (1)

SourceAliasJoin Type
R_CurrencyExchangeRateTP R_CurrencyExchangeRateTP projection

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Currency Exchange Rate view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.sapObjectNodeType.name ExchangeRate view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
OData.entityType.name CurrencyExchangeRate_Type view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

OData Services (2)

ServiceBindingVersionContractRelease
API_CURRENCYEXCHANGERATE API_CURRENCYEXCHANGERATE V4 C2 C1
ASQL_F9048 ASQL_F9048 C2 NOT_RELEASED

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY ExchangeRateType ExchangeRateType Exch. Rate Type
KEY SourceCurrency SourceCurrency
KEY TargetCurrency TargetCurrency
KEY ExchangeRateEffectiveDate ExchangeRateEffectiveDate
ExchangeRate ExchangeRate Exchange rate
AlternativeExchangeRateType AlternativeExchangeRateType
NumberOfSourceCurrencyUnits NumberOfSourceCurrencyUnits Ratio (from)
NumberOfTargetCurrencyUnits NumberOfTargetCurrencyUnits Ratio (to)
ExchangeRateQuotation ExchangeRateQuotation
AbsoluteExchangeRate AbsoluteExchangeRate Absolute Exchange Rate
DirectQuotedEffectiveExchRate DirectQuotedEffectiveExchRate
IndirectQuotedEffctvExchRate IndirectQuotedEffctvExchRate
CurrencyPair CurrencyPair
CurrencyPairText CurrencyPairText

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 A_CurrencyExchangeRate.
-- 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.

CREATE VIEW A_CurrencyExchangeRate AS
SELECT
  ExchangeRateType,
  SourceCurrency,
  TargetCurrency,
  ExchangeRateEffectiveDate,
  ExchangeRate,
  AlternativeExchangeRateType,
  NumberOfSourceCurrencyUnits,
  NumberOfTargetCurrencyUnits,
  ExchangeRateQuotation,
  AbsoluteExchangeRate,
  DirectQuotedEffectiveExchRate,
  IndirectQuotedEffctvExchRate,
  CurrencyPair,
  CurrencyPairText
FROM R_CurrencyExchangeRateTP
;

Learn More