I_PurchaseHubCommodityTerm

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_PurchaseHubCommodityTerm.
-- 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: IPURHUBTERM

CREATE VIEW I_PurchaseHubCommodityTerm AS
SELECT
  CmmdtyPrcgCndnRecdMapping.ConditionRecord AS ConditionRecord,
  CmmdtyPrcgCndnRecdMapping.ConditionSequentialNumber AS ConditionSequentialNumberShort,
  CommodityPricingTermCustKeys.PricingConditionTerm AS PricingConditionTerm,
  CmmdtyPricingFormulaResult.DocItemCommodityPricingUUID AS DocItemCommodityPricingUUID,
  CmmdtyPricingFormulaResult.ConditionType AS ConditionType,
  CmmdtyPricingFormulaResult.PricingConditionFormulaKey AS PricingConditionFormulaKey,
  CmmdtyPricingFormulaResult.PrcgConditionFormulaInputUUID AS PrcgConditionFormulaInputUUID,
  CmmdtyPricingFormulaResult.OriginSystem AS OriginSystem,
  CmmdtyPricingFormulaResult.PrcgCndnFmlaCommodityQuantity AS PrcgCndnFmlaCommodityQuantity,
  CmmdtyPricingFormulaResult.PrcgCndnFmlaCmmdtyQuantityUnit AS PrcgCndnFmlaCmmdtyQuantityUnit,
  CmmdtyPricingFormulaResult.PrcgCndnFmlaEvaluationDateTime AS PrcgCndnFmlaEvaluationDateTime,
  CommodityPricingTermCustKeys.CndnExchRatePerdDetnResultUUID AS CndnExchRatePerdDetnResultUUID,
  CommodityPricingTermCustKeys.PrcgCndnTrmConversionInputUUID AS PrcgCndnTrmConversionInputUUID,
  CommodityPricingTermCustKeys.PrcgCndnTermConversionRsltUUID AS PrcgCndnTermConversionRsltUUID,
  CommodityPricingTermCustKeys.PricingConditionSourceCurrency AS PricingConditionSourceCurrency,
  CommodityPricingTermCustKeys.PricingConditionTargetCurrency AS PricingConditionTargetCurrency,
  CommodityPricingTermCustKeys.PrcgCndnSourceQuantityUnit AS PrcgCndnSourceQuantityUnit,
  CommodityPricingTermCustKeys.PrcgCndnTargetQuantityUnit AS PrcgCndnTargetQuantityUnit,
  CommodityPricingTermCustKeys.PricingConditionConversionRule AS PricingConditionConversionRule,
  CommodityPricingTermCustKeys.PrcgConditionFixedExchangeRate AS PrcgConditionFixedExchangeRate,
  CommodityPricingTermCustKeys.CndnCnvrsnRuleValdtyStrtDteTme AS CndnCnvrsnRuleValdtyStrtDteTme,
  CommodityPricingTermCustKeys.CndnTrmCnvrsnValdtyStrtDteTme AS CndnTrmCnvrsnValdtyStrtDteTme,
  CommodityPricingTermCustKeys.PrcgConditionConversionPlace AS PrcgConditionConversionPlace,
  CommodityPricingTermCustKeys.PrcgCndnGrpTrmValdtyStrtDteTme AS PrcgCndnGrpTrmValdtyStrtDteTme,
  CommodityPricingTermCustKeys.PricingConditionTermKey AS PricingConditionTermKey,
  CommodityPricingTermCustKeys.PrcgCndnTrmValdtyStartDateTime AS PrcgCndnTrmValdtyStartDateTime,
  cast ('FE' as cpet_module preserving type ) AS PrcgCndnFmlaEvaluationModule,
  cast ('05' as cpet_log_submodule) AS CndnTrmCalcTypeRoutineSubMdl,
  CommodityPricingTermCustKeys.PricingConditionTermRule AS PricingConditionTermRule,
  CommodityPricingTermCustKeys.CndnTrmRuleValdtyStartDateTime AS CndnTrmRuleValdtyStartDateTime,
  CommodityPricingTermCustKeys.PrcgCndnTermCalculationRule AS PrcgCndnTermCalculationRule,
  CommodityPricingTermCustKeys.CndnCalcRuleValdtyStrtDateTime AS CndnCalcRuleValdtyStrtDateTime,
  CommodityPricingTermCustKeys.PrcgCndnTermQuotationRule AS PrcgCndnTermQuotationRule,
  CommodityPricingTermCustKeys.CndnQtanRuleValdtyStrtDateTime AS CndnQtanRuleValdtyStrtDateTime,
  CndnTrmQtanPerdDetnResult.PrcgCndnTrmPeriodStartDateTime AS PrcgCndnTrmQtanPerdStrtDteTime,
  CndnTrmQtanPerdDetnResult.PrcgCndnTermPeriodEndDateTime AS PrcgCndnTrmQtanPerdEndDateTime,
  CndnTrmQtanPerdDetnResult.PrcgConditionTermReferenceDate AS PrcgCndnTrmQtanPerdRefDate,
  CndnTrmQtanPerdDetnResult.PrcgConditionTermBaseDateTime AS PrcgCndnTrmQtanPerdBaseDteTime,
  CndnExchRatePerdDetnResult.PrcgCndnTrmPeriodStartDateTime AS CndnTrmExchRatePerdStrtDteTime,
  CndnExchRatePerdDetnResult.PrcgCndnTermPeriodEndDateTime AS CndnTrmExchRatePerdEndDateTime,
  CndnExchRatePerdDetnResult.PrcgConditionTermReferenceDate AS PrcgCndnTrmExchRatePerdRefDate,
  CndnExchRatePerdDetnResult.PrcgConditionTermBaseDateTime AS CndnTrmExchRatePerdBaseDteTime,
  case when CmmdtyPricingTermInputData.TimeToMaturity is not initial then CmmdtyPricingTermInputData.TimeToMaturity else _CmmdtyPricingQuotationRule.TimeToMaturity end as TimeToMaturity AS TimeToMaturityendasTimeToMaturity,
  CmmdtyPricingFormulaResult._CmmdtyPrcgFormulaInputData AS _CmmdtyPrcgFormulaInputData,
  CmmdtyPricingFormulaResult._OriginSystem AS _OriginSystem
FROM I_CmmdtyPricingFormulaResult AS CmmdtyPricingFormulaResult
INNER JOIN I_CmmdtyPrcgCndnRecdMapping AS CmmdtyPrcgCndnRecdMapping ON /* join condition not captured in parsed metadata */
INNER JOIN I_CmmdtyPrcgCustomizingTerm AS CommodityPricingTermCustKeys ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CmmdtyPricingTermGrouping AS _CmmdtyPricingTermGrouping ON _CmmdtyPricingTermGrouping.OriginSystem = OriginSystem AND _CmmdtyPricingTermGrouping.PricingConditionFormulaKey = PricingConditionFormulaKey AND _CmmdtyPricingTermGrouping.ConditionType = ConditionType AND _CmmdtyPricingTermGrouping.PricingConditionTerm = PricingConditionTerm AND _CmmdtyPricingTermGrouping.PrcgCndnGrpTrmValdtyStrtDteTme = PrcgCndnGrpTrmValdtyStrtDteTme  -- association [1..1]
LEFT OUTER JOIN I_CommodityPricingTerm AS _CommodityPricingTerm ON _CommodityPricingTerm.OriginSystem = OriginSystem AND _CommodityPricingTerm.PricingConditionTermKey = PricingConditionTermKey AND _CommodityPricingTerm.ConditionType = ConditionType AND _CommodityPricingTerm.PrcgCndnTrmValdtyStartDateTime = PrcgCndnTrmValdtyStartDateTime  -- association [1..1]
LEFT OUTER JOIN I_CmmdtyPricingQuotationRule AS _CmmdtyPricingQuotationRule ON _CmmdtyPricingQuotationRule.OriginSystem = OriginSystem AND _CmmdtyPricingQuotationRule.PrcgCndnTermQuotationRule = PrcgCndnTermQuotationRule AND _CmmdtyPricingQuotationRule.CndnQtanRuleValdtyStrtDateTime = CndnQtanRuleValdtyStrtDateTime  -- association [1..1]
LEFT OUTER JOIN I_CmmdtyPricingTermRule AS _CmmdtyPricingTermRule ON _CmmdtyPricingTermRule.OriginSystem = OriginSystem AND _CmmdtyPricingTermRule.PricingConditionTermRule = PricingConditionTermRule AND _CmmdtyPricingTermRule.CndnTrmRuleValdtyStartDateTime = CndnTrmRuleValdtyStartDateTime  -- association [1..1]
LEFT OUTER JOIN I_CmmdtyPricingCalculationRule AS _CmmdtyPricingCalculationRule ON _CmmdtyPricingCalculationRule.OriginSystem = OriginSystem AND _CmmdtyPricingCalculationRule.PrcgCndnTermCalculationRule = PrcgCndnTermCalculationRule AND _CmmdtyPricingCalculationRule.CndnCalcRuleValdtyStrtDateTime = CndnCalcRuleValdtyStrtDateTime  -- association [1..1]
LEFT OUTER JOIN I_CommodityPricingTermText AS _CommodityPricingTermText ON _CommodityPricingTermText.OriginSystem = OriginSystem AND _CommodityPricingTermText.PricingConditionTermKey = PricingConditionTermKey AND _CommodityPricingTermText.ConditionType = ConditionType  -- association [1..*]
LEFT OUTER JOIN I_CmmdtyPrcgQuotationRuleText AS _CmmdtyPrcgQuotationRuleText ON _CmmdtyPrcgQuotationRuleText.OriginSystem = OriginSystem AND _CmmdtyPrcgQuotationRuleText.PrcgCndnTermQuotationRule = PrcgCndnTermQuotationRule  -- association [1..*]
LEFT OUTER JOIN I_CmmdtyPricingTermRuleText AS _CmmdtyPricingTermRuleText ON _CmmdtyPricingTermRuleText.OriginSystem = OriginSystem AND _CmmdtyPricingTermRuleText.PricingConditionTermRule = PricingConditionTermRule  -- association [1..*]
LEFT OUTER JOIN I_CmmdtyPrcgCalcRuleText AS _CmmdtyPrcgCalcRuleText ON _CmmdtyPrcgCalcRuleText.OriginSystem = OriginSystem AND _CmmdtyPrcgCalcRuleText.PrcgCndnTermCalculationRule = PrcgCndnTermCalculationRule  -- association [1..*]
LEFT OUTER JOIN I_CommodityPricingRoutineText AS _CmmdtyPrcgTermCalcTypeText ON _CmmdtyPrcgTermCalcTypeText.OriginSystem = OriginSystem AND _CmmdtyPrcgTermCalcTypeText.PricingConditionModule = PrcgCndnFmlaEvaluationModule AND _CmmdtyPrcgTermCalcTypeText.PricingConditionSubModule = CndnTrmCalcTypeRoutineSubMdl AND _CmmdtyPrcgTermCalcTypeText.PricingConditionRoutine = PrcgCndnTermCalculationType  -- association [1..*]
LEFT OUTER JOIN I_CommodityPricingRoutine AS _CmmdtyPricingTermCalcType ON _CmmdtyPricingTermCalcType.OriginSystem = OriginSystem AND _CmmdtyPricingTermCalcType.PricingConditionModule = PrcgCndnFmlaEvaluationModule AND _CmmdtyPricingTermCalcType.PricingConditionSubModule = CndnTrmCalcTypeRoutineSubMdl AND _CmmdtyPricingTermCalcType.PricingConditionRoutine = PrcgCndnTermCalculationType  -- association [1..1]
LEFT OUTER JOIN I_CmmdtyPricingConversionRule AS _CmmdtyPricingConversionRule ON _CmmdtyPricingConversionRule.OriginSystem = OriginSystem AND _CmmdtyPricingConversionRule.PricingConditionConversionRule = PricingConditionConversionRule AND _CmmdtyPricingConversionRule.CndnCnvrsnRuleValdtyStrtDteTme = CndnCnvrsnRuleValdtyStrtDteTme  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyPricingTermConversion AS _CmmdtyPricingTermConversion ON _CmmdtyPricingTermConversion.OriginSystem = OriginSystem AND _CmmdtyPricingTermConversion.PricingConditionTermKey = PricingConditionTermKey AND _CmmdtyPricingTermConversion.ConditionType = ConditionType AND _CmmdtyPricingTermConversion.CndnTrmCnvrsnValdtyStrtDteTme = CndnTrmCnvrsnValdtyStrtDteTme AND _CmmdtyPricingTermConversion.PrcgConditionConversionPlace = PrcgConditionConversionPlace AND _CmmdtyPricingTermConversion.PricingConditionSourceCurrency = PricingConditionSourceCurrency AND _CmmdtyPricingTermConversion.PrcgCndnSourceQuantityUnit = PrcgCndnSourceQuantityUnit AND _CmmdtyPricingTermConversion.PricingConditionTargetCurrency = PricingConditionTargetCurrency AND _CmmdtyPricingTermConversion.PrcgCndnTargetQuantityUnit = PrcgCndnTargetQuantityUnit  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _PrcgConditionSourceCurrency ON PricingConditionSourceCurrency = _PrcgConditionSourceCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _PrcgConditionTargetCurrency ON PricingConditionTargetCurrency = _PrcgConditionTargetCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _PrcgCndnSourceQuantityUnit ON PrcgCndnSourceQuantityUnit = _PrcgCndnSourceQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _PrcgCndnTargetQuantityUnit ON PrcgCndnTargetQuantityUnit = _PrcgCndnTargetQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _PrcgCndnFmlaCmmdtyQtyUnit ON PrcgCndnFmlaCmmdtyQuantityUnit = _PrcgCndnFmlaCmmdtyQtyUnit.UnitOfMeasure  -- association [0..1]
;