C_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 C_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.

CREATE VIEW C_MasterRecipe AS
SELECT
  MasterRecipeGroup,
  MasterRecipe,
  MasterRecipeInternalVersion,
  BillOfOperationsDesc,
  Plant,
  BillOfOperationsStatus,
  BillOfOperationsUsage,
  _UsageText.BillOfOperationsUsageDesc AS BillOfOperationsUsageDesc,
  _StatusText.BillOfOperationsStatusDesc AS BillOfOperationsStatusDesc,
  ValidityStartDate,
  ValidityEndDate,
  CreationDate,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser,
  ChangeNumber,
  ChangedDateTime,
  MinimumLotSizeQuantity,
  MaximumLotSizeQuantity,
  BillOfOperationsUnit,
  _ChangeMaster.ChangeNumberDescription AS ChangeNumberDescription,
  _Plant.PlantName AS PlantName,
  _MatlCount.NumberOfProducts AS NumberOfProducts,
  virtual KeyDate : abap.dats(8) AS dats8
FROM I_MasterRecipeHeaderTP
LEFT OUTER JOIN C_MasterRecipeMaterialAssgmt AS _MatlAssgmt ON MasterRecipeGroup = _MatlAssgmt.MasterRecipeGroup AND MasterRecipe = _MatlAssgmt.MasterRecipe AND ValidityEndDate >= _MatlAssgmt.ValidityStartDate AND ValidityStartDate <= _MatlAssgmt.ValidityEndDate  -- association [0..*]
;