I_CmmdtyPricingFormulaResult

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_CmmdtyPricingFormulaResult.
-- 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: IFORMULARESULT

CREATE VIEW I_CmmdtyPricingFormulaResult AS
SELECT
  formdoc.docitem_guid AS DocItemCommodityPricingUUID,
  formdoc.cond_type AS ConditionType,
  formdoc.formid AS PricingConditionFormulaKey,
  formdoc.forminput_guid AS PrcgConditionFormulaInputUUID,
  formdoc_rates.PricingConditionFormulaAmount AS PricingConditionFormulaAmount,
  formdoc_rates.PrcgCndnFmlaAmtInDocCurrency AS PrcgCndnFmlaAmtInDocCurrency,
  formdoc_rates.PrcgCndnFormulaAmountCurrency AS PrcgCndnFormulaAmountCurrency,
  formdoc_rates.PricingConditionFormulaRate AS PricingConditionFormulaRate,
  formdoc_rates.PrcgCndnFormulaRateCurrency AS PrcgCndnFormulaRateCurrency,
  formdoc_rates.PrcgCndnFormulaRateQuantity AS PrcgCndnFormulaRateQuantity,
  formdoc_rates.PrcgCndnFormulaRateQtyUnit AS PrcgCndnFormulaRateQtyUnit,
  formdoc.formcommquan AS PrcgCndnFmlaCommodityQuantity,
  formdoc.formcommuom AS PrcgCndnFmlaCmmdtyQuantityUnit,
  formdoc.logsys AS OriginSystem,
  cast( formdoc.eval_timestamp as cpet_eval_timestamp_cds preserving type ) AS PrcgCndnFmlaEvaluationDateTime
FROM cped_formdoc AS formdoc
INNER JOIN P_CmmdtyPricingFormulaResult ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CmmdtyPrcgCndnRecdMapping AS _CmmdtyPrcgCndnRecdMapping ON DocItemCommodityPricingUUID = _CmmdtyPrcgCndnRecdMapping.DocItemCommodityPricingUUID  -- association [0..*]
LEFT OUTER JOIN I_CmmdtyPrcgFormulaInputData AS _CmmdtyPrcgFormulaInputData ON PrcgConditionFormulaInputUUID = _CmmdtyPrcgFormulaInputData.PrcgConditionFormulaInputUUID  -- association [0..1]
LEFT OUTER JOIN I_CommodityPricingTermResult AS _CommodityPricingTermResult ON DocItemCommodityPricingUUID = _CommodityPricingTermResult.DocItemCommodityPricingUUID AND ConditionType = _CommodityPricingTermResult.ConditionType  -- association [0..*]
LEFT OUTER JOIN I_CmmdtyPrcgTrmChangedResult AS _CmmdtyPrcgTrmChangedResult ON PrcgConditionFormulaInputUUID = _CmmdtyPrcgTrmChangedResult.PrcgConditionFormulaInputUUID  -- association [0..*]
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]
;