I_MasterRecipeHeaderTP

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_MasterRecipeHeaderTP.
-- 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: IMRCHDRTP

CREATE VIEW I_MasterRecipeHeaderTP AS
SELECT
  plko.BillOfOperationsGroup AS MasterRecipeGroup,
  plko.BillOfOperationsVariant AS MasterRecipe,
  plko.BOOInternalVersionCounter AS MasterRecipeInternalVersion,
  plkz.IsMarkedForDeletion AS IsMarkedForDeletion,
  plko.BillOfOperationsDesc AS BillOfOperationsDesc,
  plko.Plant AS Plant,
  plko.BillOfOperationsUsage AS BillOfOperationsUsage,
  plko.BillOfOperationsStatus AS BillOfOperationsStatus,
  plko.ResponsiblePlannerGroup AS ResponsiblePlannerGroup,
  plko.BillOfOperationsProfile AS BillOfOperationsProfile,
  plko.MinimumLotSizeQuantity AS MinimumLotSizeQuantity,
  plko.MaximumLotSizeQuantity AS MaximumLotSizeQuantity,
  plko.BillOfOperationsUnit AS BillOfOperationsUnit,
  plko.LongTextLanguageCode AS LongTextLanguageCode,
  plko.PlainLongText AS PlainLongText,
  plko.CreationDate AS CreationDate,
  plko.CreatedByUser AS CreatedByUser,
  plko.LastChangeDate AS LastChangeDate,
  plko.LastChangedByUser AS LastChangedByUser,
  plko.ValidityStartDate AS ValidityStartDate,
  plko.ValidityEndDate AS ValidityEndDate,
  plko.ChangeNumber AS ChangeNumber,
  _RcpTP.ChangedDateTime AS ChangedDateTime,
  plko.OperationReferenceQuantity AS OperationReferenceQuantity,
  plko.OperationUnit AS OperationUnit,
  plko.OpQtyToBaseQtyNmrtr AS OpQtyToBaseQtyNmrtr,
  plko.OpQtyToBaseQtyDnmntr AS OpQtyToBaseQtyDnmntr,
  _ChangeMaster.ChangeNumberDescription AS ChangeNumberDescription,
  _Plant.PlantName AS PlantName
FROM I_MasterRecipeHeader AS plko
INNER JOIN I_MasterRecipe AS plkz ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MasterRecipeMaterialAssgmtTP AS _MatlAssgmt ON MasterRecipeGroup = _MatlAssgmt.MasterRecipeGroup AND MasterRecipe = _MatlAssgmt.MasterRecipe AND ValidityEndDate >= _MatlAssgmt.ValidityStartDate AND ValidityStartDate <= _MatlAssgmt.ValidityEndDate  -- association [0..*]
LEFT OUTER JOIN I_MasterRecipeOperationTP AS _Operation ON MasterRecipeGroup = _Operation.MasterRecipeGroup AND MasterRecipe = _Operation.MasterRecipe AND ValidityEndDate >= _Operation.ValidityStartDate AND ValidityStartDate <= _Operation.ValidityEndDate  -- association [0..*]
LEFT OUTER JOIN I_MasterRecipeMaterialCount AS _MatlCount ON MasterRecipeGroup = _MatlCount.MasterRecipeGroup AND MasterRecipe = _MatlCount.MasterRecipe  -- association [0..1]
LEFT OUTER JOIN I_ChangeMaster AS _ChangeMaster ON ChangeNumber = _ChangeMaster.ChangeNumber  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
;