I_RSHMaintOperationAssgmtTP

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_RSHMaintOperationAssgmtTP.
-- 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: IRSHMNTOPASGTP

CREATE VIEW I_RSHMaintOperationAssgmtTP AS
SELECT
  iop.OrderInternalID AS MaintOrderRoutingNumber,
  iop.OrderOperationInternalID AS MaintOrderOperationCounter,
  iop.OperationConfirmation AS MaintOrderConfirmation,
  iop.OperationPersonResponsible AS OperationPersonResponsibleID,
  cast ( 10 as rsh_eam_asg_tech_status_int ) AS MaintOperationAssignTechStatus
FROM I_OrderOperationBasic AS iop
INNER JOIN I_RSHOrder AS MaintenanceOrder ON /* join condition not captured in parsed metadata */
INNER JOIN I_RSHAssignedWorkCenters AS AssignedWorkcenters ON /* join condition not captured in parsed metadata */
INNER JOIN I_OperationControlProfile AS OperationControlProfile ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN E_MaintenanceOrder AS _MaintenanceOrderExtension ON MaintenanceOrder.MaintenanceOrder = _MaintenanceOrderExtension.MaintenanceOrder  -- association [0..1]
LEFT OUTER JOIN E_MaintenanceOrderOperation AS _MaintOrderOperExtension ON MaintOrderRoutingNumber = _MaintOrderOperExtension.MaintOrderRoutingNumber AND MaintOrderOperationCounter = _MaintOrderOperExtension.MaintOrderOperationCounter  -- association [0..1]
;