R_ProcessOrderRelationshipTP

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 R_ProcessOrderRelationshipTP.
-- 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 R_ProcessOrderRelationshipTP AS
SELECT
  PredecessorOrderInternalID,
  PredecessorOperationInternalID AS PredecessorPhaseInternalID,
  SuccessorOrderInternalID,
  SuccessorOperationInternalID AS SuccessorPhaseInternalID,
  OrderOpRelationshipIntType AS OrderPhaseRelationshipIntType,
  MaxTimeIntvlIsUsedForSchedg,
  PredecessorOrder,
  PredecessorOrderOperation AS PredecessorOrderPhase,
  SuccessorOrder,
  SuccessorOrderOperation AS SuccessorOrderPhase,
  ManufacturingOrderCategory,
  OpRelationshipTimeIntervalUnit AS PhaseRelshpTimeIntervalUnit,
  OpRelationshipTimeIntervalDurn AS PhaseRelshpTimeIntervalDurn,
  MaxTimeIntvlBtwnRelshp AS PhaseRelshpTimeIntervalDurnMax,
  TimeIntvlBtwnRelshpInPct,
  TimeInterval,
  ObjectInternalID,
  ObjectIsDeleted,
  FactoryCalendar,
  Plant,
  WorkCenterInternalID AS ProductionResourceInternalID,
  cast(_WorkCenter.WorkCenter as cr_resourc preserving type) AS ProductionResource
FROM I_MfgOrderOpRelationship AS Relationship
LEFT OUTER JOIN R_ProcessOrderTP AS _SuccessorOrder ON _SuccessorOrder.ProcessOrder = SuccessorOrder  -- association [1..1]
LEFT OUTER JOIN R_ProcessOrderPhaseTP AS _PredecessorPhase ON _PredecessorPhase.OrderInternalID = PredecessorOrderInternalID AND _PredecessorPhase.OrderPhaseInternalID = PredecessorPhaseInternalID  -- association [1..1]
LEFT OUTER JOIN R_ProcessOrderTP AS _PredecessorOrder ON _PredecessorOrder.ProcessOrder = PredecessorOrder  -- association [1..1]
;