C_CmmdtyFXRatesDEX

DDL: C_CMMDTYFXRATESDEX Type: view_entity CONSUMPTION
10 Fields 1 Data Sources

Dex for Generic Mkt Data Exchange Rates

C_CmmdtyFXRatesDEX is a Consumption CDS View (Fact) that provides data about "Dex for Generic Mkt Data Exchange Rates" in SAP S/4HANA. It reads from 1 data source (I_GmdaFx) and exposes 10 fields with key fields MarketDataScenario, SourceCurrency, TargetCurrency, ExchangeRateType, MaturityDate.

Data Sources (1)

SourceAliasJoin Type
I_GmdaFx I_GmdaFx from

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Dex for Generic Mkt Data Exchange Rates view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #NONE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
Analytics.dataCategory #FACT view
ObjectModel.modelingPattern #ANALYTICAL_FACT view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY MarketDataScenario MarketDataScenario VAT Scenario
KEY SourceCurrency SourceCurrency Source Currency
KEY TargetCurrency TargetCurrency Target Currency
KEY ExchangeRateType ExchangeRateType Exch. Rate Type
KEY MaturityDate MaturityDate Maturity Date
KEY ExchangeRateValidFrom ExchangeRateValidFrom Start Date
ExchangeRateValidTo
ForwardExchangeRate ForwardExchangeRate Exchange Rate
NumberOfSourceCurrencyUnits NumberOfSourceCurrencyUnits Ratio (from)
NumberOfTargetCurrencyUnits NumberOfTargetCurrencyUnits Ratio (to)

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_CmmdtyFXRatesDEX.
-- 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 C_CmmdtyFXRatesDEX AS
SELECT
  MarketDataScenario,
  SourceCurrency,
  TargetCurrency,
  ExchangeRateType,
  MaturityDate,
  ExchangeRateValidFrom,
  dats_to_datn( ExchangeRateValidTo , 'INITIAL' , 'INITIAL' ) AS ExchangeRateValidTo,
  ForwardExchangeRate,
  NumberOfSourceCurrencyUnits,
  NumberOfTargetCurrencyUnits
FROM I_GmdaFx
;

Learn More