I_MasterRecipe

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_MasterRecipe.
-- 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: IMSTRRCP

CREATE VIEW I_MasterRecipe AS
SELECT
  plkz.plnty AS BillOfOperationsType,
  plkz.plnnr AS BillOfOperationsGroup,
  plkz.plnal AS BillOfOperationsVariant,
  plkz.subtype AS BillOfOperationsVersionType,
  plkz.subtype AS BillOfOperationsSubtype,
  plkz.abdat AS LastUsageDate,
  plkz.abanz AS NumberOfUsages,
  plkz.flg_ecm AS HasChangeNumber,
  plkz.flg_ecm_par AS HasParameterEffectivity,
  plkz.aeuzeit AS LastChangeTime,
  cast(plkz.aenam as vdm_lastchangedbyuserid preserving type) AS LastChangedByUser,
  plkz.delkz AS IsMarkedForDeletion,
  plkz.rework AS RoutingIsReworkRouting,
  plkz.relaxed AS ProdnProcgIsFlexible
FROM plkz
LEFT OUTER JOIN I_BillOfOperationsType AS _BillOfOperationsType ON BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperationsVersionType AS _BillOfOperationsVersionType ON BillOfOperationsVersionType = _BillOfOperationsVersionType.BillOfOperationsVersionType  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperationsGroup AS _BillOfOperationsGroup ON BillOfOperationsType = _BillOfOperationsGroup.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperationsGroup.BillOfOperationsGroup  -- association [1..1]
;