I_COExchangeRateEffectiveDate

DDL: I_COEXCHANGERATEEFFECTIVEDATE SQL: IEXCHRATEEFFDATE Type: view COMPOSITE Package: ODATA_PRODUCTION_COST_ANALYSIS
4 Fields 1 Data Sources

CO Exchange Rate Effective Date

I_COExchangeRateEffectiveDate is a Composite CDS View that provides data about "CO Exchange Rate Effective Date" in SAP S/4HANA. It reads from 1 data source (I_ExchangeRate) and exposes 4 fields with key fields ExchangeRateType, SourceCurrency, TargetCurrency. Part of development package ODATA_PRODUCTION_COST_ANALYSIS.

Data Sources (1)

SourceAliasJoin Type
I_ExchangeRate I_ExchangeRate from

Parameters (1)

NameTypeDefault
P_ExchangeRateDate vdm_v_exchange_rate_date

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IEXCHRATEEFFDATE view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CO Exchange Rate Effective Date view
VDM.viewType #COMPOSITE view
AbapCatalog.buffering.type #NONE view
AbapCatalog.buffering.numberOfKeyFields 0 view
AbapCatalog.buffering.status #NOT_ALLOWED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #D view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY ExchangeRateType ExchangeRateType Exch. Rate Type
KEY SourceCurrency SourceCurrency From currency
KEY TargetCurrency TargetCurrency Trans. Currency
ExchangeRateEffectiveDate

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 I_COExchangeRateEffectiveDate.
-- 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: IEXCHRATEEFFDATE
-- Parameters: P_ExchangeRateDate : vdm_v_exchange_rate_date

CREATE VIEW I_COExchangeRateEffectiveDate AS
SELECT
  ExchangeRateType,
  SourceCurrency,
  TargetCurrency,
  max( ExchangeRateEffectiveDate ) AS ExchangeRateEffectiveDate
FROM I_ExchangeRate
;

Learn More