I_RSHMaintSchedExistingOp

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_RSHMaintSchedExistingOp.
-- 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: IRSHMNTSCHEXOPS

CREATE VIEW I_RSHMaintSchedExistingOp AS
SELECT
  MaintSchedSimlnUUID,
  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,
  _WorkCenter.WorkCenter AS WorkCenter,
  Operation.WorkCenterInternalID AS WorkCenterInternalID,
  Operation.WorkCenterTypeCode AS WorkCenterTypeCode,
  Operation.NumberOfCapacities AS NumberOfCapacities,
  Operation.OperationConfirmation AS MaintOrderConfirmation,
  Operation.OperationPersonResponsible AS OperationPersonResponsible,
  Operation.Language AS Language,
  cast(case when Language = '' then '' else 'X' end as rsh_eam_long_text_available preserving type ) AS OperationHasLongText,
  Operation.MaintOperationExecStageCode AS MaintOperationExecStageCode,
  Operation.Equipment AS OperationEquipment,
  Operation.FunctionalLocation AS RelevantOperationFuncLocation,
  cast(_OperationFuncLocationLabel.FunctionalLocationLabelName as rsh_eams_oper_func_loc preserving type ) AS OperationFunctionalLocation,
  Operation.OperationSystemCondition AS OperationSystemCondition,
  MaintenanceOrder.MaintenanceOrder AS MaintenanceOrder,
  MaintenanceOrder.BasicSchedulingType AS BasicSchedulingType,
  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.MaintenanceOrderDesc AS MaintenanceOrderDesc,
  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._OperationSystemCondition._Text[1:Language = $session.system_language].OperationSystemConditionText AS OrderSystemConditionText,
  MaintenanceOrder.MaintenanceNotification AS MaintenanceNotification,
  MaintenanceOrder.Equipment AS Equipment,
  MaintenanceOrder._LocationAccountAssignment.FunctionalLocation AS FunctionalLocation,
  cast( MaintenanceOrder._LocationAccountAssignment._FunctionalLocation._FunctionalLocationText[ 1: Language = $session.system_language ].FunctionalLocationName as ps_s4_pltxt preserving type ) AS FunctionalLocationName,
  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,
  cast( coalesce( _MaterialStatus.MaterialStatus , 30 ) as rsh_eam_material_status_int preserving type ) AS MaterialStatus,
  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.OpActualExecutionStartDate AS OpActualExecutionStartDate,
  OperationPlanningValues.OpActualExecutionStartTime AS OpActualExecutionStartTime,
  OperationPlanningValues.OpActualExecutionEndDate AS OpActualExecutionEndDate,
  OperationPlanningValues.OpActualExecutionEndTime AS OpActualExecutionEndTime,
  OperationPlanningValues.OperationPlannedWork AS OperationPlannedWork,
  OperationPlanningValues.OperationPlannedWorkUnit AS OperationPlannedWorkUnit,
  OperationPlanningValues.OperationDuration AS OperationDuration,
  OperationPlanningValues.OperationDurationUnit AS OperationDurationUnit,
  _ProcStatus.ProcessingStatus AS ProcessingStatus,
  MaintenanceOrder.MaintOrdProcessPhaseCode AS MaintOrdProcessPhaseCode,
  MaintenanceOrder.MaintOrdProcessSubPhaseCode AS MaintOrdProcessSubPhaseCode,
  MaintOrdOpProcessPhaseCode,
  MaintOrdOpProcessSubPhaseCode,
  MaintenanceOrder.WBSElementInternalID AS WBSElementInternalID,
  cast( MaintenanceOrder.ProjectInternalID as rsh_eam_project_int_id preserving type ) AS ProjectInternalID,
  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
INNER JOIN I_RSHOrder AS MaintenanceOrder ON /* join condition not captured in parsed metadata */
INNER JOIN I_RSHMaintSchedSmltdWrkCtr AS SimulatedWrkCtr 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_MaintOrderOperPlanningValues AS OperationPlanningValues ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_StatusObjectStatusBasic AS ExclStatusObj ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_StatusObjectStatusBasic AS InclStatusObj ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_RSHMaintSchedSimulationTP AS _MaintSchedSimulation ON _MaintSchedSimulation.MaintSchedSimlnUUID = MaintSchedSimlnUUID  -- association [1..1]
LEFT OUTER JOIN I_RSHOperationProcessingStatus AS _ProcStatus ON _ProcStatus.StatusObject = Operation.ObjectInternalID  -- association [1..1]
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_OrderOperationBasic AS _SuperiorOperation ON MaintOrderRoutingNumber = _SuperiorOperation.OrderInternalID AND SuperiorOperationInternalID = _SuperiorOperation.OrderOperationInternalID  -- association [0..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]
LEFT OUTER JOIN C_RSHOrderMaterialStatusVH AS _MaterialStatusVH ON MaterialStatus = _MaterialStatusVH.MaterialStatus  -- association [0..1]
LEFT OUTER JOIN I_MaintOrderOperObjectListLink AS _MaintOrderOpObjectListLink ON MaintOrderOperationCounter = _MaintOrderOpObjectListLink.MaintOrderOperationCounter AND MaintOrderRoutingNumber = _MaintOrderOpObjectListLink.MaintOrderRoutingNumber  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocationLabel AS _OperationFuncLocationLabel ON RelevantOperationFuncLocation = _OperationFuncLocationLabel.FunctionalLocation  -- association [0..1]
;