I_PurHubCommodityFormulaNew

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_PurHubCommodityFormulaNew.
-- 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_PurHubCommodityFormulaNew AS
SELECT
  CmmdtyPrcgCndnRecdMapping.ConditionRecord AS ConditionRecord,
  CmmdtyPrcgCndnRecdMapping.ConditionSequentialNumber AS ConditionSequentialNumberShort,
  formula.DocItemCommodityPricingUUID AS DocItemCommodityPricingUUID,
  formula.ConditionType AS ConditionType,
  formula.PricingConditionFormulaKey AS PricingConditionFormulaKey,
  formula.PrcgConditionFormulaInputUUID AS PrcgConditionFormulaInputUUID,
  formula.PrcgCndnFmlaAmtInDocCurrency AS PrcgCndnFmlaAmtInDocCurrency,
  formula.PrcgCndnFormulaAmountCurrency AS PrcgCndnFormulaAmountCurrency,
  formula.PricingConditionFormulaRate AS PricingConditionFormulaRate,
  formula.PrcgCndnFormulaRateCurrency AS PrcgCndnFormulaRateCurrency,
  formula.PrcgCndnFormulaRateQuantity AS PrcgCndnFormulaRateQuantity,
  formula.PrcgCndnFormulaRateQtyUnit AS PrcgCndnFormulaRateQtyUnit,
  formula.PrcgCndnFmlaCommodityQuantity AS PrcgCndnFmlaCommodityQuantity,
  formula.PrcgCndnFmlaCmmdtyQuantityUnit AS PrcgCndnFmlaCmmdtyQuantityUnit,
  formula.PrcgCndnFmlaEvaluationDateTime AS PrcgCndnFmlaEvaluationDateTime,
  formula.PrcgCndnFmlaCombinationRoutine AS PrcgCndnFmlaCombinationRoutine,
  cast ('FE' as cpet_module preserving type ) AS PrcgCndnFmlaEvaluationModule,
  cast ('04' as cpet_log_submodule) AS PrcgCndnFmlaCombnRoutineSubMdl,
  cast ('' as cpet_formlogsys) AS OriginSystem,
  formula.PrcgCndnFmlaEvaluationDateTime AS PrcgCndnFmlaValdtyStrtDateTime
FROM I_CmmdtyPrcgConditionFormula AS formula
INNER JOIN I_CmmdtyPrcgCndnRecdMapping AS CmmdtyPrcgCndnRecdMapping ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurgPrcgCndnType AS _PurgPrcgCndnType ON _PurgPrcgCndnType.ConditionApplication = 'M' AND _PurgPrcgCndnType.ConditionType = ConditionType  -- association [1..1]
LEFT OUTER JOIN I_CommodityCodeCndnMapping AS _CommodityCodeMapping ON _CommodityCodeMapping.ConditionType = ConditionType  -- association [0..*]
LEFT OUTER JOIN I_PurCommodityConditionMapping AS _CommodityCndnMapping ON _CommodityCndnMapping.ConditionType = ConditionType  -- association [0..1]
LEFT OUTER JOIN I_CommodityPricingFormulaText AS _CommodityPricingFormulaText ON _CommodityPricingFormulaText.OriginSystem = OriginSystem AND _CommodityPricingFormulaText.PricingConditionFormulaKey = PricingConditionFormulaKey AND _CommodityPricingFormulaText.ConditionType = ConditionType  -- association [1..*]
LEFT OUTER JOIN I_CommodityPricingRoutineText AS _CmmdtyPricingCombRoutineText ON _CmmdtyPricingCombRoutineText.OriginSystem = OriginSystem AND _CmmdtyPricingCombRoutineText.PricingConditionModule = PrcgCndnFmlaEvaluationModule AND _CmmdtyPricingCombRoutineText.PricingConditionSubModule = PrcgCndnFmlaCombnRoutineSubMdl AND _CmmdtyPricingCombRoutineText.PricingConditionRoutine = PrcgCndnFmlaCombinationRoutine  -- association [1..*]
LEFT OUTER JOIN I_Currency AS _PrcgCndnFormulaAmountCurrency ON PrcgCndnFormulaAmountCurrency = _PrcgCndnFormulaAmountCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _PrcgCndnFormulaRateCurrency ON PrcgCndnFormulaRateCurrency = _PrcgCndnFormulaRateCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _PrcgCndnFormulaRateQtyUnit ON PrcgCndnFormulaRateQtyUnit = _PrcgCndnFormulaRateQtyUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _PrcgCndnFmlaCmmdtyQtyUnit ON PrcgCndnFmlaCmmdtyQuantityUnit = _PrcgCndnFmlaCmmdtyQtyUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_LogicalSystem AS _OriginSystem ON OriginSystem = _OriginSystem.LogicalSystem  -- association [0..1]
;