I_PurchaseHubCommodityFormula

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_PurchaseHubCommodityFormula.
-- 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: IPURHUBFORMULA

CREATE VIEW I_PurchaseHubCommodityFormula AS
SELECT
  CmmdtyPrcgCndnRecdMapping.ConditionRecord AS ConditionRecord,
  CmmdtyPrcgCndnRecdMapping.ConditionSequentialNumber AS ConditionSequentialNumberShort,
  CmmdtyPricingFormulaResult.DocItemCommodityPricingUUID AS DocItemCommodityPricingUUID,
  CmmdtyPricingFormulaResult.ConditionType AS ConditionType,
  CmmdtyPricingFormulaResult.PricingConditionFormulaKey AS PricingConditionFormulaKey,
  CmmdtyPricingFormulaResult.PrcgConditionFormulaInputUUID AS PrcgConditionFormulaInputUUID,
  CmmdtyPricingFormulaResult.PrcgCndnFmlaAmtInDocCurrency AS PrcgCndnFmlaAmtInDocCurrency,
  CmmdtyPricingFormulaResult.PrcgCndnFormulaAmountCurrency AS PrcgCndnFormulaAmountCurrency,
  CmmdtyPricingFormulaResult.PricingConditionFormulaRate AS PricingConditionFormulaRate,
  CmmdtyPricingFormulaResult.PrcgCndnFormulaRateCurrency AS PrcgCndnFormulaRateCurrency,
  CmmdtyPricingFormulaResult.PrcgCndnFormulaRateQuantity AS PrcgCndnFormulaRateQuantity,
  CmmdtyPricingFormulaResult.PrcgCndnFormulaRateQtyUnit AS PrcgCndnFormulaRateQtyUnit,
  CmmdtyPricingFormulaResult.PrcgCndnFmlaCommodityQuantity AS PrcgCndnFmlaCommodityQuantity,
  CmmdtyPricingFormulaResult.PrcgCndnFmlaCmmdtyQuantityUnit AS PrcgCndnFmlaCmmdtyQuantityUnit,
  CmmdtyPricingFormulaResult.PrcgCndnFmlaEvaluationDateTime AS PrcgCndnFmlaEvaluationDateTime,
  cast ('FE' as cpet_module preserving type ) AS PrcgCndnFmlaEvaluationModule,
  cast ('04' as cpet_log_submodule) AS PrcgCndnFmlaCombnRoutineSubMdl,
  CmmdtyPricingFormulaResult.OriginSystem AS OriginSystem,
  CommodityPricingFormulaCustKey.PrcgCndnFmlaValdtyStrtDateTime AS PrcgCndnFmlaValdtyStrtDateTime,
  CmmdtyPricingFormulaResult._CmmdtyPrcgFormulaInputData AS _CmmdtyPrcgFormulaInputData,
  CmmdtyPricingFormulaResult._OriginSystem AS _OriginSystem,
  CmmdtyPricingFormulaResult._PrcgCndnFormulaAmountCurrency AS _PrcgCndnFormulaAmountCurrency,
  CmmdtyPricingFormulaResult._PrcgCndnFormulaRateCurrency AS _PrcgCndnFormulaRateCurrency,
  CmmdtyPricingFormulaResult._PrcgCndnFormulaRateQtyUnit AS _PrcgCndnFormulaRateQtyUnit,
  CmmdtyPricingFormulaResult._PrcgCndnFmlaCmmdtyQtyUnit AS _PrcgCndnFmlaCmmdtyQtyUnit
FROM I_CmmdtyPricingFormulaResult AS CmmdtyPricingFormulaResult
INNER JOIN I_CmmdtyPrcgCndnRecdMapping AS CmmdtyPrcgCndnRecdMapping ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CommodityPricingFormula AS _CommodityPricingFormula ON _CommodityPricingFormula.OriginSystem = OriginSystem AND _CommodityPricingFormula.PricingConditionFormulaKey = PricingConditionFormulaKey AND _CommodityPricingFormula.ConditionType = ConditionType AND _CommodityPricingFormula.PrcgCndnFmlaValdtyStrtDateTime = PrcgCndnFmlaValdtyStrtDateTime  -- association [1..1]
LEFT OUTER JOIN I_CommodityPricingRoutine AS _CommodityPricingCombRoutine ON _CommodityPricingCombRoutine.OriginSystem = OriginSystem AND _CommodityPricingCombRoutine.PricingConditionModule = PrcgCndnFmlaEvaluationModule AND _CommodityPricingCombRoutine.PricingConditionSubModule = PrcgCndnFmlaCombnRoutineSubMdl AND _CommodityPricingCombRoutine.PricingConditionRoutine = PrcgCndnFmlaCombinationRoutine  -- association [1..1]
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..*]
;