I_RSHOperationAndSubOperation

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_RSHOperationAndSubOperation.
-- 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: IRSHORDOPSOPR

CREATE VIEW I_RSHOperationAndSubOperation AS
SELECT
  _Operation.OrderInternalID AS MaintOrderRoutingNumber,
  _Operation.OrderOperationInternalID AS MaintOrderOperationCounter,
  _Operation.SuperiorOperationInternalID AS SuperiorOperationInternalID,
  _Operation.ObjectInternalID AS MaintOrderOperationInternalID,
  _Operation.Operation AS MaintenanceOrderOperation,
  _Operation.OperationControlProfile AS OperationControlKey,
  _Operation.OperationText AS OperationDescription,
  _Operation.Plant AS Plant,
  _Operation.WorkCenterInternalID AS WorkCenterInternalID,
  _Operation.WorkCenterTypeCode AS WorkCenterTypeCode,
  _Operation.NumberOfCapacities AS NumberOfCapacities,
  _Operation.OperationConfirmation AS MaintOrderConfirmation,
  _Operation.OperationPersonResponsible AS OperationPersonResponsible,
  _Operation.Language AS Language,
  _Operation.MaintOperationExecStageCode AS MaintOperationExecStageCode,
  _Operation.OperationSystemCondition AS OperationSystemCondition,
  _Operation.Equipment AS OperationEquipment,
  _Operation.FunctionalLocation AS RelevantOperationFuncLocation,
  _MaintenanceOrder.MaintenanceOrder AS MaintenanceOrder,
  _MaintenanceOrder.BasicSchedulingType AS BasicSchedulingType,
  _MaintenanceOrder.OrdIsNotSchedldAutomatically AS OrdIsNotSchedldAutomatically,
  _MaintenanceOrder.MaintenanceOrderInternalID AS MaintenanceOrderInternalID,
  _MaintenanceOrder.MaintPriority AS MaintPriority,
  _MaintenanceOrder.MaintPriorityType AS MaintPriorityType,
  _MaintenanceOrder.MaintenanceOrderType AS MaintenanceOrderType,
  _MaintenanceOrder.MaintenanceActivityType AS MaintenanceActivityType,
  _MaintenanceOrder.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  _MaintenanceOrder.WBSElementInternalID AS WBSElementInternalID,
  _MaintenanceOrder.ProjectInternalID AS ProjectInternalID,
  _MaintenanceOrder.MaintenanceOrderDesc AS MaintenanceOrderDesc,
  _MaintenanceOrder.OrderHasLongText AS OrderHasLongText,
  _MaintenanceOrder.MaintOrdBasicStartDate AS MaintOrdBasicStartDate,
  _MaintenanceOrder.MaintOrdBasicStartTime AS MaintOrdBasicStartTime,
  _MaintenanceOrder.MaintOrdBasicEndDate AS MaintOrdBasicEndDate,
  _MaintenanceOrder.MaintOrdBasicEndTime AS MaintOrdBasicEndTime,
  _MaintenanceOrder.MaintenancePlannerGroup AS MaintenancePlannerGroup,
  _MaintenanceOrder.MaintenanceRevision AS MaintenanceRevision,
  _MaintenanceOrder.OperationSystemCondition AS OrderSystemCondition,
  _MaintenanceOrder.MaintenanceNotification AS MaintenanceNotification,
  _MaintenanceOrder.Equipment AS Equipment,
  _MaintenanceOrder.MaintObjectLocAcctAssgmtNmbr AS MaintObjectLocAcctAssgmtNmbr,
  _MaintenanceOrder.MaintenancePlan AS MaintenancePlan,
  _MaintenanceOrder.MaintenancePlant AS MaintenancePlant,
  _MaintenanceOrder.SchedulingIsPerformedBackward AS SchedulingIsPerformedBackward,
  _MaintenanceOrder.SchedulingType AS SchedulingType,
  _MaintenanceOrder.SuperiorProjectNetwork AS SuperiorProjectNetwork,
  _MaintenanceOrder.ControllingArea AS ControllingArea,
  _MaintenanceOrder.ResponsibleCostCenter AS ResponsibleCostCenter,
  _MaintenanceOrder.MainWorkCenter AS MainWorkCenter,
  _MaintenanceOrder.MainWorkCenterPlant AS MainWorkCenterPlant,
  _MaintenanceOrder.LatestAcceptableCompletionDate AS LatestAcceptableCompletionDate,
  _MaintenanceOrder.MaintOrderProcessingContext AS MaintOrderProcessingContext,
  _MaintenanceOrder.ServiceDocument AS ServiceDocument,
  case when _MaintenanceOrder.MaintOrderProcessingContext = 'B' then _MaintenanceOrder.ServiceDocumentItem else cast('' as abap.numc(6)) end as ServiceDocumentItem AS numc6endasServiceDocumentItem,
  _MaintenanceOrder.ServiceDocumentType AS ServiceDocumentType,
  ScheduledBasicStartDate,
  ScheduledBasicStartTime,
  ScheduledBasicEndDate,
  ScheduledBasicEndTime,
  _OperationPlanningValues.OpErlstSchedldExecStrtDte AS OpErlstSchedldExecStrtDte,
  _OperationPlanningValues.OpErlstSchedldExecStrtTme AS OpErlstSchedldExecStrtTme,
  _OperationPlanningValues.OpErlstSchedldExecEndDte AS OpErlstSchedldExecEndDte,
  _OperationPlanningValues.OpErlstSchedldExecEndTme AS OpErlstSchedldExecEndTme,
  _OperationPlanningValues.OpLtstSchedldExecStrtDte AS OpLtstSchedldExecStrtDte,
  _OperationPlanningValues.OpLtstSchedldExecStrtTme AS OpLtstSchedldExecStrtTme,
  _OperationPlanningValues.OpLtstSchedldExecEndDte AS OpLtstSchedldExecEndDte,
  _OperationPlanningValues.OpLtstSchedldExecEndTme AS OpLtstSchedldExecEndTme,
  _OperationPlanningValues.OperationPlannedWork AS OperationPlannedWork,
  _OperationPlanningValues.OperationPlannedWorkUnit AS OperationPlannedWorkUnit,
  _OperationPlanningValues.OperationDuration AS OperationDuration,
  _OperationPlanningValues.OperationDurationUnit AS OperationDurationUnit,
  _OperationPlanningValues.OpBscStartDateConstraintType AS OpBscStartDateConstraintType,
  _OperationPlanningValues.ConstraintDateForBscStartDate AS ConstraintDateForBscStartDate,
  _OperationPlanningValues.ConstraintTimeForBscStartTime AS ConstraintTimeForBscStartTime,
  _OperationPlanningValues.OpBscEndDateConstraintType AS OpBscEndDateConstraintType,
  _OperationPlanningValues.ConstraintDateForBscFinishDate AS ConstraintDateForBscFinishDate,
  _OperationPlanningValues.ConstraintTimeForBscFinishTime AS ConstraintTimeForBscFinishTime,
  MaintOrdProcessPhaseCode,
  MaintOrdProcessSubPhaseCode,
  _Operation.MaintOrdOpProcessPhaseCode AS MaintOrdOpProcessPhaseCode,
  _Operation.MaintOrdOpProcessSubPhaseCode AS MaintOrdOpProcessSubPhaseCode,
  _MaintenanceOrder._BasicSchedulingType AS _BasicSchedulingType,
  _MaintenanceOrder._Equipment AS _Equipment,
  _MaintenanceOrder._LocationAccountAssignment AS _LocationAccountAssignment,
  _MaintenanceOrder._MaintenanceActivityType AS _MaintenanceActivityType,
  _MaintenanceOrder._MaintenanceNotification AS _MaintenanceNotification,
  _MaintenanceOrder._MaintenancePriority AS _MaintenancePriority,
  _MaintenanceOrder._WBSElement AS _WBSElement,
  _MaintenanceOrder._Project AS _Project,
  _MaintenanceOrder._MaintenanceRevision AS _MaintenanceRevision
FROM I_OrderOperationBasic AS _Operation
INNER JOIN I_RSHOrder AS _MaintenanceOrder ON /* join condition not captured in parsed metadata */
INNER JOIN I_RSHAssignedWorkCenters AS _AssignedWorkCenter ON /* join condition not captured in parsed metadata */
INNER JOIN I_OperationControlProfile AS OperationControlProfile ON /* join condition not captured in parsed metadata */
INNER JOIN I_RSHOperationStatusObject AS _StatusObj ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_RSHOrderMaterialStatus AS _MaterialStatus ON _MaintenanceOrder.MaintenanceOrderInternalID = _MaterialStatus.StatusObject  -- association [1..1]
LEFT OUTER JOIN I_RSHOperationHasCrossOrderRel AS _OperationHasCrossOrderRel ON MaintOrderRoutingNumber = _OperationHasCrossOrderRel.MaintOrderRoutingNumber AND MaintOrderOperationCounter = _OperationHasCrossOrderRel.MaintOrderOperationCounter  -- association [0..1]
LEFT OUTER JOIN I_RSHOperationHasSubOperation AS _OperationHasSubOperation ON MaintOrderRoutingNumber = _OperationHasSubOperation.MaintOrderRoutingNumber AND MaintOrderOperationCounter = _OperationHasSubOperation.MaintOrderOperationCounter  -- association [0..1]
LEFT OUTER JOIN I_OrderOperationBasic AS _SuperiorOperation ON MaintOrderRoutingNumber = _SuperiorOperation.OrderInternalID AND SuperiorOperationInternalID = _SuperiorOperation.OrderOperationInternalID  -- association [0..1]
LEFT OUTER JOIN I_MaintOrderOperPlanningValues AS _OperationPlanningValues ON MaintOrderRoutingNumber = _OperationPlanningValues.MaintOrderRoutingNumber AND MaintOrderOperationCounter = _OperationPlanningValues.MaintOrderOperationCounter  -- association [1..1]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON _WorkCenter.WorkCenterInternalID = _Operation.WorkCenterInternalID AND _WorkCenter.WorkCenterTypeCode = 'A'  -- association [0..1]
LEFT OUTER JOIN I_WorkAssignment AS _PersonResponsible ON OperationPersonResponsible = _PersonResponsible.WorkAssignment  -- association [0..1]
;