I_RecipeFormulaItem

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_RecipeFormulaItem.
-- 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: IRCPFRMITM

CREATE VIEW I_RecipeFormulaItem AS
SELECT
  rfo_item_guid AS RcpFmlaItemUUID,
  rfo_guid AS RcpFmlaUUID,
  item_guid AS RcpFmlaItemSourceFmlaItemUUID,
  cast( posnr as /plmb/rfo_frml_posnr_vdm preserving type ) AS RcpFmlaItemPosition,
  cast( poscount as /plmb/rfo_frml_poscount_vdm preserving type ) AS RcpFmlaItemAlternativeItemPos,
  item_type AS RcpFmlaItemType,
  subrecn AS SpecificationInternalID,
  Material,
  stream_id AS RcpFmlaStreamUUID,
  comp_type AS RcpFmlaItemComponentType,
  quant_low AS RcpFmlaItemLowerLimit,
  quant_high AS RcpFmlaItemUpperLimit,
  quant AS RcpFmlaItemQuantity,
  uom AS RcpFmlaItemUnit,
  exception_value AS RcpFmlaItemExceptionCode,
  scrap AS RcpFmlaItemScrapInPercent,
  overrun AS RcpFmlaItemOverrunInPercent,
  alt_item_guid AS RcpFmlaItemAlternativeItemUUID,
  massabsfloat AS RcpFmlaItemQuantityInKilogram,
  zero_sign AS RcpFmlaItemZeroSign,
  calculated AS RcpFmlaItemIsSelectedForCalc,
  expl_rcp_guid AS RcpFmlaItemExplosionRecipeUUID,
  calc_type AS RcpFmlaCalculationType,
  is_balancing_item AS RcpFmlaItemIsBalancingItem,
  _Recipe.RecipeUUID AS RecipeUUID
FROM /plmb/rfo_frmitm
LEFT OUTER JOIN I_SpecComponentType AS _ComponentType ON RcpFmlaItemComponentType = _ComponentType.SpecificationComponentType  -- association [0..1]
LEFT OUTER JOIN I_RecipeProcessElementAssgmt AS _RecipeProcessElementAssgmt ON RcpFmlaItemSourceFmlaItemUUID = _RecipeProcessElementAssgmt.RcpFmlaItemSourceFmlaItemUUID AND recipeuuid = _RecipeProcessElementAssgmt.RecipeUUID  -- association [1..1]
LEFT OUTER JOIN I_Recipe AS _Recipe ON RcpFmlaUUID = _Recipe.RcpFmlaUUID  -- association [1..1]
LEFT OUTER JOIN I_Product AS _Product ON Material = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_RecipeStreamQuantity AS _RecipeStreamQuantity ON RcpFmlaItemUUID = _RecipeStreamQuantity.RcpFmlaItemUUID  -- association [1..*]
;