I_CndnRmndrFltgTrmExchangeRate

DDL: I_CNDNRMNDRFLTGTRMEXCHANGERATE Type: view_entity COMPOSITE
18 Fields 3 Data Sources

I_CndnRmndrFltgTrmExchangeRate is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_CmmdtyPrcgCndnRmndrFltgTerm, I_CmmdtyPrcgCndnTrmExchRate, I_CndnRmndrFltgTrmCnvrsnResult) and exposes 18 fields with key fields DocItmCmmdtyPrcgCndnUUID, PricingConditionTerm, PrcgConditionConversionPlace, PrcgCndnTrmExchRateDateTime.

Data Sources (3)

SourceAliasJoin Type
I_CmmdtyPrcgCndnRmndrFltgTerm _CmmdtyPrcgCndnRmndrFltgTerm inner
I_CmmdtyPrcgCndnTrmExchRate _CmmdtyPrcgCndnTrmExchRate from
I_CndnRmndrFltgTrmCnvrsnResult _CndnRmndrFltgTrmCnvrsnResult inner

Annotations (5)

NameValueLevelField
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #COMPOSITE view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY DocItmCmmdtyPrcgCndnUUID I_CmmdtyPrcgCndnTrmExchRate DocItmCmmdtyPrcgCndnUUID Doc. Cond. Item GUID
KEY PricingConditionTerm I_CmmdtyPrcgCndnTrmExchRate PricingConditionTerm Term Number
KEY PrcgConditionConversionPlace I_CmmdtyPrcgCndnTrmExchRate PrcgConditionConversionPlace Conv. Place
KEY PrcgCndnTrmExchRateDateTime I_CmmdtyPrcgCndnTrmExchRate PrcgCndnTrmExchRateDateTime Exch Rate Time Stamp
PrcgConditionExchangeRateType I_CmmdtyPrcgCndnTrmExchRate PrcgConditionExchangeRateType Exch. Rate Type
PricingConditionSourceCurrency I_CmmdtyPrcgCndnTrmExchRate PricingConditionSourceCurrency Curr:Conv. from
PricingConditionTargetCurrency I_CmmdtyPrcgCndnTrmExchRate PricingConditionTargetCurrency Curr.: Conv. to
PricingConditionExchangeRate I_CmmdtyPrcgCndnTrmExchRate PricingConditionExchangeRate Conv.:Ex.Rate
NumberOfSourceCurrencyUnits I_CmmdtyPrcgCndnTrmExchRate NumberOfSourceCurrencyUnits Ratio (from)
NumberOfTargetCurrencyUnits I_CmmdtyPrcgCndnTrmExchRate NumberOfTargetCurrencyUnits Ratio (to)
CndnTrmExchRateSubstnDateTime I_CmmdtyPrcgCndnTrmExchRate CndnTrmExchRateSubstnDateTime Subst Time Stamp
CndnTrmExchRateIsNonTradingDay I_CmmdtyPrcgCndnTrmExchRate CndnTrmExchRateIsNonTradingDay Non-Trading Day
PrcgCndnTrmExchRateIsMissing I_CmmdtyPrcgCndnTrmExchRate PrcgCndnTrmExchRateIsMissing ExchangeRate Missing
CndnTrmExchRateIsSubstituted I_CmmdtyPrcgCndnTrmExchRate CndnTrmExchRateIsSubstituted Substitute Exr
PrcgCndnTrmExchRateIsIgnored I_CmmdtyPrcgCndnTrmExchRate PrcgCndnTrmExchRateIsIgnored Exchg. Rate Ignored
PrcgCndnTrmExchRateFcstStatus I_CmmdtyPrcgCndnTrmExchRate PrcgCndnTrmExchRateFcstStatus Forecast Status
PrcgConditionSwapExchangeRate I_CmmdtyPrcgCndnTrmExchRate PrcgConditionSwapExchangeRate Swap Exchange Rate
PrcgConditionSpotExchangeRate I_CmmdtyPrcgCndnTrmExchRate PrcgConditionSpotExchangeRate Spot Exchange Rate

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_CndnRmndrFltgTrmExchangeRate.
-- 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 I_CndnRmndrFltgTrmExchangeRate AS
SELECT
  _CmmdtyPrcgCndnTrmExchRate.DocItmCmmdtyPrcgCndnUUID AS DocItmCmmdtyPrcgCndnUUID,
  _CmmdtyPrcgCndnTrmExchRate.PricingConditionTerm AS PricingConditionTerm,
  _CmmdtyPrcgCndnTrmExchRate.PrcgConditionConversionPlace AS PrcgConditionConversionPlace,
  _CmmdtyPrcgCndnTrmExchRate.PrcgCndnTrmExchRateDateTime AS PrcgCndnTrmExchRateDateTime,
  _CmmdtyPrcgCndnTrmExchRate.PrcgConditionExchangeRateType AS PrcgConditionExchangeRateType,
  _CmmdtyPrcgCndnTrmExchRate.PricingConditionSourceCurrency AS PricingConditionSourceCurrency,
  _CmmdtyPrcgCndnTrmExchRate.PricingConditionTargetCurrency AS PricingConditionTargetCurrency,
  _CmmdtyPrcgCndnTrmExchRate.PricingConditionExchangeRate AS PricingConditionExchangeRate,
  _CmmdtyPrcgCndnTrmExchRate.NumberOfSourceCurrencyUnits AS NumberOfSourceCurrencyUnits,
  _CmmdtyPrcgCndnTrmExchRate.NumberOfTargetCurrencyUnits AS NumberOfTargetCurrencyUnits,
  _CmmdtyPrcgCndnTrmExchRate.CndnTrmExchRateSubstnDateTime AS CndnTrmExchRateSubstnDateTime,
  _CmmdtyPrcgCndnTrmExchRate.CndnTrmExchRateIsNonTradingDay AS CndnTrmExchRateIsNonTradingDay,
  _CmmdtyPrcgCndnTrmExchRate.PrcgCndnTrmExchRateIsMissing AS PrcgCndnTrmExchRateIsMissing,
  _CmmdtyPrcgCndnTrmExchRate.CndnTrmExchRateIsSubstituted AS CndnTrmExchRateIsSubstituted,
  _CmmdtyPrcgCndnTrmExchRate.PrcgCndnTrmExchRateIsIgnored AS PrcgCndnTrmExchRateIsIgnored,
  _CmmdtyPrcgCndnTrmExchRate.PrcgCndnTrmExchRateFcstStatus AS PrcgCndnTrmExchRateFcstStatus,
  _CmmdtyPrcgCndnTrmExchRate.PrcgConditionSwapExchangeRate AS PrcgConditionSwapExchangeRate,
  _CmmdtyPrcgCndnTrmExchRate.PrcgConditionSpotExchangeRate AS PrcgConditionSpotExchangeRate
FROM I_CmmdtyPrcgCndnTrmExchRate AS _CmmdtyPrcgCndnTrmExchRate
INNER JOIN I_CmmdtyPrcgCndnRmndrFltgTerm AS _CmmdtyPrcgCndnRmndrFltgTerm ON /* join condition not captured in parsed metadata */
INNER JOIN I_CndnRmndrFltgTrmCnvrsnResult AS _CndnRmndrFltgTrmCnvrsnResult ON /* join condition not captured in parsed metadata */
;

Learn More