R_MaintOrderOpRelationshipTP

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_MaintOrderOpRelationshipTP.
-- 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_MaintOrderOpRelationshipTP AS
SELECT
  MaintenanceOrder,
  cast( MaintenanceOrderOperation as maintenanceorderoperation preserving type ) AS MaintenanceOrderOperation,
  cast( MaintenanceOrderSubOperation as maintenanceordersuboperation preserving type ) AS MaintenanceOrderSubOperation,
  I_MaintOrdOpRelationshipID.MaintOrdOperationIsSuccessor AS MaintOrdOperationIsSuccessor,
  I_MaintOrdOpRelationshipID.RelatedMaintenanceOrder AS RelatedMaintenanceOrder,
  cast( RelatedMaintOrderOperation as maintenanceorderoperation preserving type ) AS RelatedMaintOrderOperation,
  OrderOpRelationshipIntType,
  PredecessorMaintOrderRouting,
  PredecessorOrderRoutingNode,
  SuccessorMaintOrderRouting,
  SuccessorOrderRoutingNode,
  RelatedMaintOrderRouting,
  RelatedOrderRoutingNode,
  FactoryCalendar,
  OpRelshpOffsetDuration,
  OpRelshpOffsetDurationUnit
FROM I_MaintOrdOpRelationshipID
LEFT OUTER JOIN R_MaintenanceOrderTP AS _MaintenanceOrder ON MaintenanceOrder = _MaintenanceOrder.MaintenanceOrder  -- association [1..1]
LEFT OUTER JOIN I_MaintenanceOrderOperation AS _RelatedMaintenanceOrderOp ON RelatedMaintenanceOrder = _RelatedMaintenanceOrderOp.MaintenanceOrder AND RelatedMaintOrderOperation = _RelatedMaintenanceOrderOp.MaintenanceOrderOperation  -- association [1..1]
LEFT OUTER JOIN I_MaintOrdOpRelationshipType AS _MaintOrderRelationshipType ON OrderOpRelationshipIntType = _MaintOrderRelationshipType.OrderOpRelationshipIntType  -- association [0..1]
;