I_PurHubCommodityExchangeRate

DDL: I_PURHUBCOMMODITYEXCHANGERATE SQL: IPURHUBCMMEXRATE Type: view BASIC
23 Fields 2 Data Sources

Purchase Hub Commodity Exchange Rate

I_PurHubCommodityExchangeRate is a Basic CDS View that provides data about "Purchase Hub Commodity Exchange Rate" in SAP S/4HANA. It reads from 2 data sources (I_CmmdtyPrcgCndnRecdMapping, I_CmmdtyPrcgTermExchangeRate) and exposes 23 fields with key fields ConditionRecord, ConditionSequentialNumberShort, PricingConditionTerm, PrcgCndnTrmExchRateDateTime.

Data Sources (2)

SourceAliasJoin Type
I_CmmdtyPrcgCndnRecdMapping CmmdtyPrcgCndnRecdMapping inner
I_CmmdtyPrcgTermExchangeRate ExchangeRate from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPURHUBCMMEXRATE view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Purchase Hub Commodity Exchange Rate view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #BASIC view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY ConditionRecord I_CmmdtyPrcgCndnRecdMapping ConditionRecord Cond.Record No.
KEY ConditionSequentialNumberShort I_CmmdtyPrcgCndnRecdMapping ConditionSequentialNumber SequNo of Cond.
KEY PricingConditionTerm I_CmmdtyPrcgTermExchangeRate PricingConditionTerm Term Number
KEY PrcgCndnTrmExchRateDateTime I_CmmdtyPrcgTermExchangeRate PrcgCndnTrmExchRateDateTime Exch Rate Time Stamp
DocItemCommodityPricingUUID I_CmmdtyPrcgCndnRecdMapping DocItemCommodityPricingUUID GUID
CndnExchRatePerdDetnResultUUID I_CmmdtyPrcgTermExchangeRate CndnExchRatePerdDetnResultUUID PerDet.Out.GUID
PrcgConditionExchangeRateType I_CmmdtyPrcgTermExchangeRate PrcgConditionExchangeRateType Exch. Rate Type
PricingConditionSourceCurrency I_CmmdtyPrcgTermExchangeRate PricingConditionSourceCurrency Curr:Conv. from
PricingConditionTargetCurrency I_CmmdtyPrcgTermExchangeRate PricingConditionTargetCurrency Curr.: Conv. to
NumberOfSourceCurrencyUnits I_CmmdtyPrcgTermExchangeRate NumberOfSourceCurrencyUnits Ratio (from)
NumberOfTargetCurrencyUnits I_CmmdtyPrcgTermExchangeRate NumberOfTargetCurrencyUnits Ratio (to)
CndnTrmExchRateSubstnDateTime I_CmmdtyPrcgTermExchangeRate CndnTrmExchRateSubstnDateTime Subst Time Stamp
CndnTrmExchRateIsNonTradingDay I_CmmdtyPrcgTermExchangeRate CndnTrmExchRateIsNonTradingDay Non-Trading Day
PrcgCndnTrmExchRateIsMissing I_CmmdtyPrcgTermExchangeRate PrcgCndnTrmExchRateIsMissing ExchangeRate Missing
CndnTrmExchRateIsSubstituted I_CmmdtyPrcgTermExchangeRate CndnTrmExchRateIsSubstituted Substitute Exr
PrcgCndnTrmExchRateIsIgnored I_CmmdtyPrcgTermExchangeRate PrcgCndnTrmExchRateIsIgnored Exchg. Rate Ignored
PrcgCndnTrmExchRateFcstStatus I_CmmdtyPrcgTermExchangeRate PrcgCndnTrmExchRateFcstStatus Forecast Status
PricingConditionExchangeRate I_CmmdtyPrcgTermExchangeRate PricingConditionExchangeRate Conv.:Ex.Rate
PrcgConditionSwapExchangeRate I_CmmdtyPrcgTermExchangeRate PrcgConditionSwapExchangeRate Swap Exchange Rate
PrcgConditionSpotExchangeRate I_CmmdtyPrcgTermExchangeRate PrcgConditionSpotExchangeRate Spot Exchange Rate
ConditionType I_CmmdtyPrcgTermExchangeRate ConditionType Condition type
_ExchRateSourceCurrency I_CmmdtyPrcgTermExchangeRate _ExchRateSourceCurrency
_ExchRateTargetCurrency I_CmmdtyPrcgTermExchangeRate _ExchRateTargetCurrency

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_PurHubCommodityExchangeRate.
-- 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: IPURHUBCMMEXRATE

CREATE VIEW I_PurHubCommodityExchangeRate AS
SELECT
  CmmdtyPrcgCndnRecdMapping.ConditionRecord AS ConditionRecord,
  CmmdtyPrcgCndnRecdMapping.ConditionSequentialNumber AS ConditionSequentialNumberShort,
  ExchangeRate.PricingConditionTerm AS PricingConditionTerm,
  ExchangeRate.PrcgCndnTrmExchRateDateTime AS PrcgCndnTrmExchRateDateTime,
  CmmdtyPrcgCndnRecdMapping.DocItemCommodityPricingUUID AS DocItemCommodityPricingUUID,
  ExchangeRate.CndnExchRatePerdDetnResultUUID AS CndnExchRatePerdDetnResultUUID,
  ExchangeRate.PrcgConditionExchangeRateType AS PrcgConditionExchangeRateType,
  ExchangeRate.PricingConditionSourceCurrency AS PricingConditionSourceCurrency,
  ExchangeRate.PricingConditionTargetCurrency AS PricingConditionTargetCurrency,
  ExchangeRate.NumberOfSourceCurrencyUnits AS NumberOfSourceCurrencyUnits,
  ExchangeRate.NumberOfTargetCurrencyUnits AS NumberOfTargetCurrencyUnits,
  ExchangeRate.CndnTrmExchRateSubstnDateTime AS CndnTrmExchRateSubstnDateTime,
  ExchangeRate.CndnTrmExchRateIsNonTradingDay AS CndnTrmExchRateIsNonTradingDay,
  ExchangeRate.PrcgCndnTrmExchRateIsMissing AS PrcgCndnTrmExchRateIsMissing,
  ExchangeRate.CndnTrmExchRateIsSubstituted AS CndnTrmExchRateIsSubstituted,
  ExchangeRate.PrcgCndnTrmExchRateIsIgnored AS PrcgCndnTrmExchRateIsIgnored,
  ExchangeRate.PrcgCndnTrmExchRateFcstStatus AS PrcgCndnTrmExchRateFcstStatus,
  ExchangeRate.PricingConditionExchangeRate AS PricingConditionExchangeRate,
  ExchangeRate.PrcgConditionSwapExchangeRate AS PrcgConditionSwapExchangeRate,
  ExchangeRate.PrcgConditionSpotExchangeRate AS PrcgConditionSpotExchangeRate,
  ExchangeRate.ConditionType AS ConditionType,
  ExchangeRate._ExchRateSourceCurrency AS _ExchRateSourceCurrency,
  ExchangeRate._ExchRateTargetCurrency AS _ExchRateTargetCurrency
FROM I_CmmdtyPrcgTermExchangeRate AS ExchangeRate
INNER JOIN I_CmmdtyPrcgCndnRecdMapping AS CmmdtyPrcgCndnRecdMapping ON /* join condition not captured in parsed metadata */
;

Learn More