R_SrcgProjQtnItmCmmdtyExchRate

DDL: R_SRCGPROJQTNITMCMMDTYEXCHRATE Type: view COMPOSITE
41 Fields 2 Data Sources 2 Associations

Srcg Project Qtn Itm Cmmdty Exc Rate

R_SrcgProjQtnItmCmmdtyExchRate is a Composite CDS View that provides data about "Srcg Project Qtn Itm Cmmdty Exc Rate" in SAP S/4HANA. It reads from 2 data sources (I_PurHubSmrtCmmdtyExchangeRate, R_SrcgProjQtnItemCondition) and exposes 41 fields with key fields ConditionRecord, ConditionSequentialNumberShort, PricingConditionTerm, PrcgCndnTrmExchRateDateTime. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_PurHubSmrtCmmdtyExchangeRate ExchangeRate from
R_SrcgProjQtnItemCondition SrcgProjQtnItemCondition inner

Associations (2)

CardinalityTargetAliasCondition
[0..1] R_SourcingProjectQuotation _SourcingProjectQuotation $projection.SourcingProjectQuotationUUID = _SourcingProjectQuotation.SourcingProjectQuotationUUID
[1..1] R_SrcgProjQtnItmCommodityTerm _SrcgProjQtnItmCommodityTerm $projection.ConditionRecord = _SrcgProjQtnItmCommodityTerm.ConditionRecord and $projection.ConditionSequentialNumberShort = _SrcgProjQtnItmCommodityTerm.ConditionSequentialNumberShort and $projection.PricingConditionTerm = _SrcgProjQtnItmCommodityTerm.PricingConditionTerm and $projection.SourcingProjectQuotation = _SrcgProjQtnItmCommodityTerm.SourcingProjectQuotation

Annotations (13)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName RSPQTNCMDTEXRATE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.representativeKey ConditionSequentialNumberShort view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Srcg Project Qtn Itm Cmmdty Exc Rate view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY ConditionRecord R_SrcgProjQtnItemCondition ConditionRecord Cond.Record No.
KEY ConditionSequentialNumberShort R_SrcgProjQtnItemCondition ConditionSequentialNumberShort Sequent. No. of Cond
KEY PricingConditionTerm I_PurHubSmrtCmmdtyExchangeRate PricingConditionTerm Term Number
KEY PrcgCndnTrmExchRateDateTime I_PurHubSmrtCmmdtyExchangeRate PrcgCndnTrmExchRateDateTime Exch Rate Time Stamp
SrcgProjQtnItemUUID R_SrcgProjQtnItemCondition SrcgProjQtnItemUUID Supplier Quotation Item UUID
SourcingProjectQuotationUUID R_SrcgProjQtnItemCondition SourcingProjectQuotationUUID Supplier Quotation UUID
SourcingProjectQuotation R_SrcgProjQtnItemCondition SourcingProjectQuotation Supplier Quotation
SourcingProjectQuotationItem R_SrcgProjQtnItemCondition SourcingProjectQuotationItem Item
SrcgProjQuotationVersion R_SrcgProjQtnItemCondition SrcgProjQuotationVersion Version
ConditionValidityEndDate R_SrcgProjQtnItemCondition ConditionValidityEndDate Valid To
ConditionValidityStartDate R_SrcgProjQtnItemCondition ConditionValidityStartDate Valid From
ProcmtHubPlantUniqueID R_SrcgProjQtnItemCondition ProcmtHubPlantUniqueID Plant Unique ID
ConditionType R_SrcgProjQtnItemCondition ConditionType Condition type
Currency R_SrcgProjQtnItemCondition Currency Valuation Crcy
ConditionRateValue R_SrcgProjQtnItemCondition ConditionRateValue Condition Rate Value
ConditionRateValueUnit R_SrcgProjQtnItemCondition ConditionRateValueUnit Unit of Condition Rate Value
ConditionCalculationTypeShort R_SrcgProjQtnItemCondition ConditionCalculationTypeShort Calculat.Type
ConditionQuantity R_SrcgProjQtnItemCondition ConditionQuantity Pricing Unit
ConditionQuantityUnit R_SrcgProjQtnItemCondition ConditionQuantityUnit Unit of Measure
ConditionApplication R_SrcgProjQtnItemCondition ConditionApplication Application
ConditionIsDeleted R_SrcgProjQtnItemCondition ConditionIsDeleted Deletion Indic.
DocItemCommodityPricingUUID I_PurHubSmrtCmmdtyExchangeRate DocItemCommodityPricingUUID GUID
CndnExchRatePerdDetnResultUUID I_PurHubSmrtCmmdtyExchangeRate CndnExchRatePerdDetnResultUUID PerDet.Out.GUID
PrcgConditionExchangeRateType I_PurHubSmrtCmmdtyExchangeRate PrcgConditionExchangeRateType Exch. Rate Type
PricingConditionSourceCurrency I_PurHubSmrtCmmdtyExchangeRate PricingConditionSourceCurrency Curr:Conv. from
PricingConditionTargetCurrency I_PurHubSmrtCmmdtyExchangeRate PricingConditionTargetCurrency Curr.: Conv. to
NumberOfSourceCurrencyUnits I_PurHubSmrtCmmdtyExchangeRate NumberOfSourceCurrencyUnits Ratio (from)
NumberOfTargetCurrencyUnits I_PurHubSmrtCmmdtyExchangeRate NumberOfTargetCurrencyUnits Ratio (to)
CndnTrmExchRateSubstnDateTime I_PurHubSmrtCmmdtyExchangeRate CndnTrmExchRateSubstnDateTime Subst Time Stamp
CndnTrmExchRateIsNonTradingDay I_PurHubSmrtCmmdtyExchangeRate CndnTrmExchRateIsNonTradingDay Non-Trading Day
PrcgCndnTrmExchRateIsMissing I_PurHubSmrtCmmdtyExchangeRate PrcgCndnTrmExchRateIsMissing ExchangeRate Missing
CndnTrmExchRateIsSubstituted I_PurHubSmrtCmmdtyExchangeRate CndnTrmExchRateIsSubstituted Substitute Exr
PrcgCndnTrmExchRateIsIgnored I_PurHubSmrtCmmdtyExchangeRate PrcgCndnTrmExchRateIsIgnored Exchg. Rate Ignored
PrcgCndnTrmExchRateFcstStatus I_PurHubSmrtCmmdtyExchangeRate PrcgCndnTrmExchRateFcstStatus Forecast Status
PricingConditionExchangeRate I_PurHubSmrtCmmdtyExchangeRate PricingConditionExchangeRate Conv.:Ex.Rate
PrcgConditionSwapExchangeRate I_PurHubSmrtCmmdtyExchangeRate PrcgConditionSwapExchangeRate Swap Exchange Rate
PrcgConditionSpotExchangeRate I_PurHubSmrtCmmdtyExchangeRate PrcgConditionSpotExchangeRate Spot Exchange Rate
_ExchRateSourceCurrency I_PurHubSmrtCmmdtyExchangeRate _ExchRateSourceCurrency
_ExchRateTargetCurrency I_PurHubSmrtCmmdtyExchangeRate _ExchRateTargetCurrency
_SourcingProjectQuotation _SourcingProjectQuotation
_SrcgProjQtnItmCommodityTerm _SrcgProjQtnItmCommodityTerm

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 R_SrcgProjQtnItmCmmdtyExchRate.
-- 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 R_SrcgProjQtnItmCmmdtyExchRate AS
SELECT
  SrcgProjQtnItemCondition.ConditionRecord AS ConditionRecord,
  SrcgProjQtnItemCondition.ConditionSequentialNumberShort AS ConditionSequentialNumberShort,
  ExchangeRate.PricingConditionTerm AS PricingConditionTerm,
  ExchangeRate.PrcgCndnTrmExchRateDateTime AS PrcgCndnTrmExchRateDateTime,
  SrcgProjQtnItemCondition.SrcgProjQtnItemUUID AS SrcgProjQtnItemUUID,
  SrcgProjQtnItemCondition.SourcingProjectQuotationUUID AS SourcingProjectQuotationUUID,
  SrcgProjQtnItemCondition.SourcingProjectQuotation AS SourcingProjectQuotation,
  SrcgProjQtnItemCondition.SourcingProjectQuotationItem AS SourcingProjectQuotationItem,
  SrcgProjQtnItemCondition.SrcgProjQuotationVersion AS SrcgProjQuotationVersion,
  SrcgProjQtnItemCondition.ConditionValidityEndDate AS ConditionValidityEndDate,
  SrcgProjQtnItemCondition.ConditionValidityStartDate AS ConditionValidityStartDate,
  SrcgProjQtnItemCondition.ProcmtHubPlantUniqueID AS ProcmtHubPlantUniqueID,
  SrcgProjQtnItemCondition.ConditionType AS ConditionType,
  SrcgProjQtnItemCondition.Currency AS Currency,
  SrcgProjQtnItemCondition.ConditionRateValue AS ConditionRateValue,
  SrcgProjQtnItemCondition.ConditionRateValueUnit AS ConditionRateValueUnit,
  SrcgProjQtnItemCondition.ConditionCalculationTypeShort AS ConditionCalculationTypeShort,
  SrcgProjQtnItemCondition.ConditionQuantity AS ConditionQuantity,
  SrcgProjQtnItemCondition.ConditionQuantityUnit AS ConditionQuantityUnit,
  SrcgProjQtnItemCondition.ConditionApplication AS ConditionApplication,
  SrcgProjQtnItemCondition.ConditionIsDeleted AS ConditionIsDeleted,
  ExchangeRate.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._ExchRateSourceCurrency AS _ExchRateSourceCurrency,
  ExchangeRate._ExchRateTargetCurrency AS _ExchRateTargetCurrency
FROM I_PurHubSmrtCmmdtyExchangeRate AS ExchangeRate
INNER JOIN R_SrcgProjQtnItemCondition AS SrcgProjQtnItemCondition ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_SourcingProjectQuotation AS _SourcingProjectQuotation ON SourcingProjectQuotationUUID = _SourcingProjectQuotation.SourcingProjectQuotationUUID  -- association [0..1]
LEFT OUTER JOIN R_SrcgProjQtnItmCommodityTerm AS _SrcgProjQtnItmCommodityTerm ON ConditionRecord = _SrcgProjQtnItmCommodityTerm.ConditionRecord AND ConditionSequentialNumberShort = _SrcgProjQtnItmCommodityTerm.ConditionSequentialNumberShort AND PricingConditionTerm = _SrcgProjQtnItmCommodityTerm.PricingConditionTerm AND SourcingProjectQuotation = _SrcgProjQtnItmCommodityTerm.SourcingProjectQuotation  -- association [1..1]
;

Learn More