I_CntrlPurContrCmmdtyFmlaUnion

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_CntrlPurContrCmmdtyFmlaUnion.
-- 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_CntrlPurContrCmmdtyFmlaUnion AS
SELECT
  new.ConditionRecord AS ConditionRecord,
  new.ConditionSequentialNumber AS ConditionSequentialNumber,
  new.CentralPurchaseContract AS CentralPurchaseContract,
  new.CentralPurchaseContractItem AS CentralPurchaseContractItem,
  new.ConditionValidityEndDate AS ConditionValidityEndDate,
  new.DocItemCommodityPricingUUID AS DocItemCommodityPricingUUID,
  new.ConditionType AS ConditionType,
  new.PricingConditionFormulaKey AS PricingConditionFormulaKey,
  new.PrcgConditionFormulaInputUUID AS PrcgConditionFormulaInputUUID,
  cast ( cast (new.PrcgCndnFmlaAmtInDocCurrency as abap.decfloat34) as cpet_formval_doccurr_cds) AS PrcgCndnFmlaAmtInDocCurrency,
  new.PrcgCndnFormulaAmountCurrency AS PrcgCndnFormulaAmountCurrency,
  cast ( cast (new.PricingConditionFormulaRate as abap.decfloat34) as cpet_formrate_cds) AS PricingConditionFormulaRate,
  new.PrcgCndnFormulaRateCurrency AS PrcgCndnFormulaRateCurrency,
  new.PrcgCndnFormulaRateQuantity AS PrcgCndnFormulaRateQuantity,
  new.PrcgCndnFormulaRateQtyUnit AS PrcgCndnFormulaRateQtyUnit,
  new.PrcgCndnFmlaCommodityQuantity AS PrcgCndnFmlaCommodityQuantity,
  new.PrcgCndnFmlaCmmdtyQuantityUnit AS PrcgCndnFmlaCmmdtyQuantityUnit,
  cast (new.PrcgCndnFmlaEvaluationDateTime as cpet_eval_timestamp_cds) AS PrcgCndnFmlaEvaluationDateTime,
  new.PrcgCndnFmlaCombinationRoutine AS PrcgCndnFmlaCombinationRoutine,
  new.OriginSystem AS OriginSystem,
  new.PrcgCndnFmlaValdtyStrtDateTime AS PrcgCndnFmlaValdtyStrtDateTime,
  new.PrcgCndnFmlaEvaluationModule AS PrcgCndnFmlaEvaluationModule,
  new.PrcgCndnFmlaCombnRoutineSubMdl AS PrcgCndnFmlaCombnRoutineSubMdl,
  new._CommodityPricingFormulaText AS _CommodityPricingFormulaText,
  new._CmmdtyPricingCombRoutineText AS _CmmdtyPricingCombRoutineText,
  new._PurgPrcgCndnType AS _PurgPrcgCndnType,
  new._CommodityCodeMapping AS _CommodityCodeMapping,
  new._CommodityCndnMapping AS _CommodityCndnMapping,
  new._OriginSystem AS _OriginSystem,
  new._PrcgCndnFormulaAmountCurrency AS _PrcgCndnFormulaAmountCurrency,
  new._PrcgCndnFormulaRateCurrency AS _PrcgCndnFormulaRateCurrency,
  new._PrcgCndnFormulaRateQtyUnit AS _PrcgCndnFormulaRateQtyUnit,
  old._PrcgCndnFmlaCmmdtyQtyUnit AS _PrcgCndnFmlaCmmdtyQtyUnit
FROM I_CntrlPurContrCmmdtyFmlaNew AS new
INNER JOIN I_CmmdtyPricingMigrationStatus AS tf ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_CntrlPurContrCmmdtyFormula
;