I_CntrlPurContrCmmdtyFormula

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_CntrlPurContrCmmdtyFormula.
-- 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: ICCNTRFORMULA

CREATE VIEW I_CntrlPurContrCmmdtyFormula AS
SELECT
  CmmdtyPrcgCndnRecdMapping.ConditionRecord AS ConditionRecord,
  CmmdtyPrcgCndnRecdMapping.ConditionSequentialNumber AS ConditionSequentialNumber,
  CntrlPurContrItmCndnValdty.CentralPurchaseContract AS CentralPurchaseContract,
  CntrlPurContrItmCndnValdty.CentralPurchaseContractItem AS CentralPurchaseContractItem,
  cast( CntrlPurContrItmCndnValdty.ConditionValidityEndDate as kodatbi preserving type ) AS ConditionValidityEndDate,
  CmmdtyPricingFormulaResult.DocItemCommodityPricingUUID AS DocItemCommodityPricingUUID,
  CmmdtyPricingFormulaResult.ConditionType AS ConditionType,
  CmmdtyPricingFormulaResult.PricingConditionFormulaKey AS PricingConditionFormulaKey,
  CmmdtyPricingFormulaResult.PrcgConditionFormulaInputUUID AS PrcgConditionFormulaInputUUID,
  PrcgCndnFmlaAmtInDocCurrency,
  PrcgCndnFormulaAmountCurrency,
  PricingConditionFormulaRate,
  CmmdtyPricingFormulaResult.PrcgCndnFormulaRateCurrency AS PrcgCndnFormulaRateCurrency,
  CmmdtyPricingFormulaResult.PrcgCndnFormulaRateQuantity AS PrcgCndnFormulaRateQuantity,
  CmmdtyPricingFormulaResult.PrcgCndnFormulaRateQtyUnit AS PrcgCndnFormulaRateQtyUnit,
  PrcgCndnFmlaCommodityQuantity,
  CmmdtyPricingFormulaResult.PrcgCndnFmlaCmmdtyQuantityUnit AS PrcgCndnFmlaCmmdtyQuantityUnit,
  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
FROM I_CmmdtyPricingFormulaResult AS CmmdtyPricingFormulaResult
INNER JOIN I_CmmdtyPrcgCndnRecdMapping AS CmmdtyPrcgCndnRecdMapping ON /* join condition not captured in parsed metadata */
INNER JOIN I_CntrlPurContrItmCndnValdty AS CntrlPurContrItmCndnValdty ON /* join condition not captured in parsed metadata */
INNER JOIN I_CntrlPurContrItmCndnAmount AS CntrlPurContrItmCndnAmount 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_CentralPurchaseContract AS _CentralPurchaseContract ON _CentralPurchaseContract.CentralPurchaseContract = CentralPurchaseContract  -- association [1..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_CommodityCodeCndnMapping AS _CommodityCodeMapping ON _CommodityCodeMapping.ConditionType = ConditionType  -- association [0..*]
LEFT OUTER JOIN I_PurCommodityConditionMapping AS _CommodityCndnMapping ON _CommodityCndnMapping.ConditionType = ConditionType  -- association [0..1]
;