I_PurHubCmmdtyFormulaUnion

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_PurHubCmmdtyFormulaUnion.
-- 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_PurHubCmmdtyFormulaUnion AS
SELECT
  new.ConditionRecord AS ConditionRecord,
  new.ConditionSequentialNumberShort AS ConditionSequentialNumberShort,
  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,
  new.PrcgCndnFmlaEvaluationDateTime AS PrcgCndnFmlaEvaluationDateTime,
  new.PrcgCndnFmlaCombinationRoutine AS PrcgCndnFmlaCombinationRoutine,
  new.PrcgCndnFmlaEvaluationModule AS PrcgCndnFmlaEvaluationModule,
  new.PrcgCndnFmlaCombnRoutineSubMdl AS PrcgCndnFmlaCombnRoutineSubMdl,
  new.OriginSystem AS OriginSystem,
  new.PrcgCndnFmlaValdtyStrtDateTime AS PrcgCndnFmlaValdtyStrtDateTime,
  new._CommodityCodeMapping AS _CommodityCodeMapping,
  new._CommodityCndnMapping AS _CommodityCndnMapping,
  new._OriginSystem AS _OriginSystem,
  new._PrcgCndnFmlaCmmdtyQtyUnit AS _PrcgCndnFmlaCmmdtyQtyUnit,
  new._PrcgCndnFormulaAmountCurrency AS _PrcgCndnFormulaAmountCurrency,
  new._PrcgCndnFormulaRateCurrency AS _PrcgCndnFormulaRateCurrency,
  new._PrcgCndnFormulaRateQtyUnit AS _PrcgCndnFormulaRateQtyUnit,
  new._PurgPrcgCndnType AS _PurgPrcgCndnType,
  new._CommodityPricingFormulaText AS _CommodityPricingFormulaText,
  old._CmmdtyPricingCombRoutineText AS _CmmdtyPricingCombRoutineText
FROM I_PurHubCommodityFormulaNew AS new
INNER JOIN I_CmmdtyPricingMigrationStatus AS tf ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_PurchaseHubCommodityFormula
;