I_ControlRecipe

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_ControlRecipe.
-- 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_ControlRecipe AS
SELECT
  cast(coch.crid as pph_crid preserving type) AS ControlRecipe,
  coch.werk AS Plant,
  cast(coch.phseq as vdm_phseq preserving type) AS ControlRecipeDestination,
  coch.cotyp AS ControlRecipeDestinationType,
  coch.adres AS ControlRecipeDestAddressName,
  cast(coch.crstat as vdm_crstat preserving type) AS ControlRecipeStatus,
  coch.tstkz AS ControlRecipeIsForTesting,
  coch.ktxt AS ControlRecipeText,
  cast(coch.matnr as productnumber preserving type) AS Product,
  cast(coch.matxt as productdescription preserving type) AS ProductName,
  coch.charg AS Batch,
  coch.prueflos AS InspectionLot,
  coch.andat AS CreationDate,
  coch.anuzt AS CreationTime,
  coch.aedat AS LastChangeDate,
  cast(coch.fsavd as pph_fsavd preserving type) AS ScheduledEarliestStartDate,
  cast(coch.fsavz as pph_fsavz preserving type) AS ScheduledEarliestStartTime
FROM coch
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_ManufacturingOrder AS _ProcessOrder ON ProcessOrder = _ProcessOrder.ManufacturingOrder  -- association [1..1]
LEFT OUTER JOIN I_ControlRecipeDestination AS _ControlRecipeDestination ON Plant = _ControlRecipeDestination.Plant AND ControlRecipeDestination = _ControlRecipeDestination.ControlRecipeDestination  -- association [1..1]
LEFT OUTER JOIN I_ControlRecipeDestinationType AS _ControlRecipeDestinationType ON ControlRecipeDestinationType = _ControlRecipeDestinationType.ControlRecipeDestinationType  -- association [1..1]
LEFT OUTER JOIN I_ControlRecipeStatus AS _ControlRecipeStatus ON ControlRecipeStatus = _ControlRecipeStatus.ControlRecipeStatus  -- association [1..1]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_Batch AS _Batch ON Plant = _Batch.Plant AND Product = _Batch.Material AND Batch = _Batch.Batch  -- association [0..1]
LEFT OUTER JOIN I_InspectionLot AS _InspectionLot ON InspectionLot = _InspectionLot.InspectionLot  -- association [0..1]
;