I_PrcgCndnExerTermExchangeRate

DDL: I_PRCGCNDNEXERTERMEXCHANGERATE Type: view_entity COMPOSITE
19 Fields 2 Data Sources

I_PrcgCndnExerTermExchangeRate is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_CmmdtyPrcgCndnTrmExchRate, I_PrcgCndnExerTrmCnvrsnResult) and exposes 19 fields with key fields DocItmCmmdtyPrcgCndnUUID, PricingConditionTerm, PrcgConditionConversionPlace, PrcgCndnTrmExchRateDateTime.

Data Sources (2)

SourceAliasJoin Type
I_CmmdtyPrcgCndnTrmExchRate _CmmdtyPrcgCndnTrmExchRate from
I_PrcgCndnExerTrmCnvrsnResult _PrcgCndnExerTrmCnvrsnResult inner

Annotations (6)

NameValueLevelField
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #COMPOSITE view
ObjectModel.sapObjectNodeType.name CmmdtyPrcgCndnExerTermExchRate view

Fields (19)

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
ConditionType I_CmmdtyPrcgCndnTrmExchRate ConditionType Condition type

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_PrcgCndnExerTermExchangeRate.
-- 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_PrcgCndnExerTermExchangeRate 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,
  _CmmdtyPrcgCndnTrmExchRate.ConditionType AS ConditionType
FROM I_CmmdtyPrcgCndnTrmExchRate AS _CmmdtyPrcgCndnTrmExchRate
INNER JOIN I_PrcgCndnExerTrmCnvrsnResult AS _PrcgCndnExerTrmCnvrsnResult ON /* join condition not captured in parsed metadata */
;

Learn More