I_MasterRecipeRelationship

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_MasterRecipeRelationship.
-- 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: IMSTRRCPRELSHP

CREATE VIEW I_MasterRecipeRelationship AS
SELECT
  BillOfOperationsType,
  PrdcssrBOOGroup,
  PrdcssrBOOVariant,
  PrdcssrBOOOpInternalID,
  SuccssrBOOGroup,
  SuccssrBOOVariant,
  SuccssrBOOOpInternalID,
  MasterRecipeRelationshipType,
  MaxTimeIntvlIsUsedForSchedg,
  BOOInternalVersionCounter,
  BOORelationshipType,
  _RelshpType.NetworkActivityRelationType AS NetworkActivityRelationType,
  cast( ValidityStartDate as vdm_datuv ) AS ValidityStartDate,
  cast( ValidityEndDate as vdm_datub ) AS ValidityEndDate,
  cast( CreationDate as vdm_andat ) AS CreationDate,
  cast( CreatedByUser as vdm_annam ) AS CreatedByUser,
  cast( LastChangeDate as vdm_aedat ) AS LastChangeDate,
  cast( LastChangedByUser as vdm_aenam ) AS LastChangedByUser,
  ChangeNumber,
  cast( TimeIntvlBtwnRelshp as vdm_aobdauer ) AS TimeIntvlBtwnRelshp,
  cast( MaxTimeIntvlBtwnRelshp as vdm_aobdauerm ) AS MaxTimeIntvlBtwnRelshp,
  TimeIntvlBtwnRelshpUnit,
  OperationIsSuccessor,
  OperationIsPredecessor,
  FactoryCalendar,
  IsDeleted,
  IsImplicitlyDeleted,
  WorkCenterInternalID,
  _WorkCenter.WorkCenter AS WorkCenter,
  Plant
FROM I_BillOfOperationsRelationship AS plab
LEFT OUTER JOIN I_BOORelshpTypeText AS _RelshpType ON _RelshpType.Language = $session.system_language AND BOORelationshipType = _RelshpType.NetworkActivityRelationTypeKey  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperationsType AS _BillOfOperationsType ON BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperationsGroup AS _PrdcssrBOOGroup ON BillOfOperationsType = _PrdcssrBOOGroup.BillOfOperationsType AND PrdcssrBOOGroup = _PrdcssrBOOGroup.BillOfOperationsGroup  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperations AS _PrdcssrBOO ON BillOfOperationsType = _PrdcssrBOO.BillOfOperationsType AND PrdcssrBOOGroup = _PrdcssrBOO.BillOfOperationsGroup AND PrdcssrBOOVariant = _PrdcssrBOO.BillOfOperationsVariant  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperationsGroup AS _SuccssrBOOGroup ON BillOfOperationsType = _SuccssrBOOGroup.BillOfOperationsType AND SuccssrBOOGroup = _SuccssrBOOGroup.BillOfOperationsGroup  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperations AS _SuccssrBOO ON BillOfOperationsType = _SuccssrBOO.BillOfOperationsType AND SuccssrBOOGroup = _SuccssrBOO.BillOfOperationsGroup AND SuccssrBOOVariant = _SuccssrBOO.BillOfOperationsVariant  -- association [1..1]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON WorkCenterInternalID = _WorkCenter.WorkCenterInternalID AND _WorkCenter.WorkCenterTypeCode = 'A '  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TimeIntvlUnit ON TimeIntvlBtwnRelshpUnit = _TimeIntvlUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_MasterRecipePhase AS _PrdcssrPhse ON BillOfOperationsType = _PrdcssrPhse.BillOfOperationsType AND PrdcssrBOOGroup = _PrdcssrPhse.BillOfOperationsGroup AND PrdcssrBOOVariant = _PrdcssrPhse.BillOfOperationsVariant AND PrdcssrBOOOpInternalID = _PrdcssrPhse.BOOOperationInternalID AND ValidityStartDate <= _PrdcssrPhse.ValidityEndDate AND ValidityEndDate >= _PrdcssrPhse.ValidityStartDate AND _PrdcssrPhse.IsDeleted <> 'X' AND _PrdcssrPhse.IsImplicitlyDeleted <> 'X'  -- association [1..*]
LEFT OUTER JOIN I_MasterRecipePhase AS _SuccssrPhse ON BillOfOperationsType = _SuccssrPhse.BillOfOperationsType AND SuccssrBOOGroup = _SuccssrPhse.BillOfOperationsGroup AND SuccssrBOOVariant = _SuccssrPhse.BillOfOperationsVariant AND SuccssrBOOOpInternalID = _SuccssrPhse.BOOOperationInternalID AND ValidityStartDate <= _SuccssrPhse.ValidityEndDate AND ValidityEndDate >= _SuccssrPhse.ValidityStartDate AND _SuccssrPhse.IsDeleted <> 'X' AND _SuccssrPhse.IsImplicitlyDeleted <> 'X'  -- association [1..*]
;