P_RSHScheduleOperations

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 P_RSHScheduleOperations.
-- 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: PRSHSCHEDOPS

CREATE VIEW P_RSHScheduleOperations AS
SELECT
  SimulatedOperations.MaintOrderRoutingNumber AS MaintOrderRoutingNumber,
  SimulatedOperations.MaintOrderOperationCounter AS MaintOrderOperationCounter,
  SimulatedOperations.MaintOrderConfirmation AS MaintOrderConfirmation,
  MaintSchedSimlnOperationUUID,
  SimulatedOperations._MaintenanceOrder.MaintenanceOrder AS MaintenanceOrder,
  cast( SimulatedOperations._Operation.Operation as rsh_operation_id preserving type ) AS MaintenanceOrderOperation,
  case when SimulatedOperations._Operation.SuperiorOperationInternalID = '00000000' then '' else SimulatedOperations._Operation.Operation end AS MaintenanceOrderSubOperation,
  MaintSchedSimlnUUID,
  SimulatedOperations.MaintOrderOperationInternalID AS MaintOrderOperationInternalID,
  cast ( SimulatedOperations._MaintenanceOrder.MaintenanceOrderDesc as rsh_order_description preserving type ) AS MaintenanceOrderDesc,
  SimulatedOperations._MaintenanceOrder.MaintenanceOrderType AS MaintenanceOrderType,
  SimulatedOperations._MaintenanceOrder.MaintenanceActivityType AS MaintenanceActivityType,
  cast( SimulatedOperations._MaintenanceOrder._MaintenanceActivityType._Text[ 1: Language = $session.system_language ].MaintenanceActivityTypeName as eam_maint_activity_type_name ) AS MaintenanceActivityTypeName,
  SimulatedOperations._MaintenanceOrder.MaintOrdBasicStartDate AS MaintOrdBasicStartDate,
  SimulatedOperations._MaintenanceOrder.MaintOrdBasicEndDate AS MaintOrdBasicEndDate,
  cast( SimulatedOperations._MaintenanceOrder.MaintPriority as rsh_eam_priority_key ) AS MaintPriority,
  SimulatedOperations._MaintenanceOrder.MaintPriorityType AS MaintPriorityType,
  cast( SimulatedOperations._MaintenanceOrder._MaintenancePriority._Text[ 1: Language = $session.system_language ].MaintPriorityDesc as rsh_eam_priority_text preserving type ) AS MaintPriorityDesc,
  SimulatedOperations.OperationHasLongText AS OperationHasLongText,
  _HasLongTextVH.OperationHasLongTextDesc AS OperationHasLongTextDesc,
  SimulatedOperations._MaintenanceOrder.MaintenanceNotification AS MaintenanceNotification,
  cast( SimulatedOperations._MaintenanceOrder._MaintenanceNotification.NotificationText as rsh_eam_notification_text preserving type ) AS NotificationText,
  cast(SimulatedOperations._MaintenanceOrder.Equipment as rsh_eams_equipment preserving type ) AS Equipment,
  cast( SimulatedOperations._MaintenanceOrder._Equipment._EquipmentText[ 1: Language = $session.system_language ].EquipmentName as rsh_eam_equipment_name preserving type ) AS EquipmentName,
  cast( SimulatedOperations.FunctionalLocation as rsh_eams_ord_func_location) AS FunctionalLocation,
  cast( FunctionalLocationName as rsh_eam_func_location_name preserving type ) AS FunctionalLocationName,
  SimulatedOperations.TechObjIsEquipOrFuncnlLoc AS TechObjIsEquipOrFuncnlLoc,
  _TechObjIsEquipOrFuncnlLoc._Text[1:Language=$session.system_language].TechObjIsEquipOrFuncnlLocDesc AS TechObjIsEquipOrFuncnlLocDesc,
  cast ( SimulatedOperations._MaintenanceOrder.OperationSystemCondition as rsh_eams_system_cond preserving type ) AS OrderSystemCondition,
  SimulatedOperations._MaintenanceOrder._OperationSystemCondition._Text[1:Language = $session.system_language].OperationSystemConditionText AS OrderSystemConditionText,
  cast ( SimulatedOperations.Equipment as rsh_eams_op_equipment preserving type) AS OperationEquipment,
  _OpEquipmentText[ 1: Language = $session.system_language ].EquipmentName AS OperationEquipmentName,
  RelevantOperationFuncLocation,
  cast(_OperationFuncLocationLabel.FunctionalLocationLabelName as rsh_eams_oper_func_loc preserving type ) AS OperationFunctionalLocation,
  _OperationFunctionalLocation._FunctionalLocationText[ 1: Language = $session.system_language ].FunctionalLocationName AS OpFunctionalLocationName,
  SimulatedOperations.OperationTechnicalObject AS OperationTechnicalObject,
  SimulatedOperations.OpTechObjEquipOrFuncnlLoc AS OpTechObjEquipOrFuncnlLoc,
  _TechnicalObjectText[1:Language = $session.system_language].TechnicalObjectDescription AS OperationTechnicalObjectDesc,
  _OperationTechObjIsEquip._Text[1:Language=$session.system_language].TechObjIsEquipOrFuncnlLocDesc AS OpTechObjEquipOrFuncnlLocDesc,
  cast( SimulatedOperations.OperationSystemCondition as rsh_eams_op_system_cond preserving type ) AS OperationSystemCondition,
  cast ( _OperationSystemConditionVH.OperationSystemConditionText as rsh_eam_op_system_cond_text) AS OperationSystemConditionText,
  cast( SimulatedOperations._MaintenanceOrder.MaintenancePlannerGroup as rsh_eam_planner_group ) AS MaintenancePlannerGroup,
  SimulatedOperations._MaintenanceOrder.MaintenanceRevision AS MaintenanceRevision,
  SimulatedOperations._MaintenanceOrder._LocationAccountAssignment.AssetRoom AS AssetRoom,
  SimulatedOperations._MaintenanceOrder._LocationAccountAssignment.AssetLocation AS AssetLocation,
  SimulatedOperations._MaintenanceOrder._LocationAccountAssignment.PlantSection AS PlantSection,
  SimulatedOperations._MaintenanceOrder.MaintenancePlan AS MaintenancePlan,
  SimulatedOperations._MaintenanceOrder.SuperiorProjectNetwork AS SuperiorProjectNetwork,
  cast( SimulatedOperations._MaintenanceOrder.MainWorkCenter as rsh_eam_main_workcenter ) AS MainWorkCenter,
  cast( SimulatedOperations._MaintenanceOrder.MainWorkCenterPlant as rsh_eam_main_workcenter_plant) AS MainWorkCenterPlant,
  cast( SimulatedOperations._Operation._WorkCenterByInternalID.WorkCenter as rsh_eam_work_center preserving type ) AS OriginalWorkCenter,
  cast ( SimulatedOperations._Operation.WorkCenterInternalID as rsh_eam_work_center_object_id preserving type) AS OriginalWorkcenterInternalID,
  cast( SimulatedOperations._Operation._WorkCenterByInternalID.WorkCenterTypeCode as rsh_eam_work_center_object_typ preserving type ) AS OriginalWorkCenterTypeCode,
  SimulatedOperations._Operation._WorkCenterByInternalID.Plant AS OriginalWorkCenterPlant,
  SimulatedOperations._Operation.OperationControlProfile AS OperationControlKey,
  cast ( SimulatedOperations._Operation.OperationText as rsh_eam_maintenance_operation) AS OperationDescription,
  SimulatedOperations.OperationPersonResponsible AS OperationPersonResponsible,
  _PersonResponsible.PersonFullName AS OperationPersonRespName,
  cast( coalesce( SimulatedWorkCenter, _WorkCenter.WorkCenter) as rsh_eam_work_center preserving type ) AS WorkCenter,
  cast ( SimulatedOperations.WorkCenterInternalID as rsh_eam_work_center_object_id preserving type) AS WorkCenterInternalID,
  cast( SimulatedOperations.WorkCenterTypeCode as rsh_eam_work_center_object_typ preserving type ) AS WorkCenterTypeCode,
  cast( coalesce( SimulatedOperations._SimWorkCenter.Plant, SimulatedOperations._Operation.Plant ) as rsh_eam_work_center_plant preserving type) AS Plant,
  _OperationPlanningValues.OperationPlannedWork AS OperationPlannedWork,
  _OperationPlanningValues.OperationPlannedWorkUnit AS OperationPlannedWorkUnit,
  _OperationPlanningValues.OperationDuration AS OperationDuration,
  _OperationPlanningValues.OperationDurationUnit AS OperationDurationUnit,
  _OperationPlanningValues.OpErlstSchedldExecStrtDte AS OpErlstSchedldExecStrtDte,
  _OperationPlanningValues.OpErlstSchedldExecEndDte AS OpErlstSchedldExecEndDte,
  _OperationPlanningValues.OpLtstSchedldExecStrtDte AS OpLtstSchedldExecStrtDte,
  _OperationPlanningValues.OpLtstSchedldExecEndDte AS OpLtstSchedldExecEndDte,
  _OperationPlanningValues.OpErlstSchedldExecStrtTme AS OpErlstSchedldExecStrtTme,
  _OperationPlanningValues.OpErlstSchedldExecEndTme AS OpErlstSchedldExecEndTme,
  _OperationPlanningValues.OpLtstSchedldExecStrtTme AS OpLtstSchedldExecStrtTme,
  _OperationPlanningValues.OpLtstSchedldExecEndTme AS OpLtstSchedldExecEndTme,
  SimulatedOperations._MaintenanceOrder.SchedulingIsPerformedBackward AS SchedulingIsPerformedBackward,
  SimulatedOperations._MaintenanceOrder.SchedulingType AS SchedulingType,
  SimulatedOperations._MaintenanceOrder._BasicSchedulingType._Text[ 1: Language = $session.system_language ].SchedulingTypeName AS SchedulingTypeName,
  cast( SimulatedOperations._Operation.NumberOfCapacities as rsh_eam_number_of_capacities preserving type) AS NumberOfCapacities,
  cast( SimulatedOperations.ProcessingStatus as rsh_eam_processing_status_int preserving type ) AS ProcessingStatus,
  _MaintSchedStatusVH.ProcessingStatusText AS ProcessingStatusText,
  ForceSchedulingSimulation,
  MaintOrdOpHasToScheduleAutom,
  MaintOrdOpHasToRespectSetStart,
  MaintSchedSetStartIsTimeBased,
  SimulatedOperations.MaterialStatus AS MaterialStatus,
  cast( _MaterialStatusVH.MaterialStatusText as rsh_eam_material_status_text ) AS MaterialStatusText,
  SimulatedOperations._MaintenanceOrder._Equipment.AuthorizationGroup AS AuthorizationGroup,
  SimulatedOperations._MaintenanceOrder._LocationAccountAssignment._FunctionalLocation.AuthorizationGroup AS FlocAuthorizationGroup,
  SimulatedOperations._MaintenanceOrder._LocationAccountAssignment.MaintenancePlant AS MaintenancePlant,
  SimulatedOperations._MaintenanceOrder.ControllingArea AS ControllingArea,
  SimulatedOperations._MaintenanceOrder._LocationAccountAssignment.CostCenter AS CostCenter,
  cast(SimulatedOperations._MaintenanceOrder.ResponsibleCostCenter as rsh_eam_resp_cost_center) AS ResponsibleCostCenter,
  SimulatedWorkCenterInternalID,
  SimulatedWorkCenterTypeCode,
  _SimulatedWorkCenter.WorkCenter AS SimulatedWorkCenter,
  _SimulatedWorkCenter.Plant AS SimulatedWorkCenterPlant,
  MaintOrdOpSimulationStatus,
  _OperationSimulationStatus.MaintOrdOpSimulationStatusText AS MaintOrdOpSimulationStatusText,
  MaintOrdOpSimulatedStartDate,
  MaintOrdOpSimulatedStartTime,
  MaintOrdOpSimulatedEndDate,
  MaintOrdOpSimulatedEndTime,
  SimulatedOperations._MaintenanceOrder.MaintObjectLocAcctAssgmtNmbr AS MaintObjectLocAcctAssgmtNmbr,
  SimulatedOperations._MaintenanceOrder.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  LastChangedByUser,
  SimulationSessionState,
  SimulatedOperations._MaintenanceOrder.LatestAcceptableCompletionDate AS LatestAcceptableCompletionDate,
  SimulatedOperations.MaintOperationExecStageCode AS MaintOperationExecStageCode,
  _MaintOpExecStageCodeText[1:LanguageCode = $session.system_language].MaintOpExecutionStageName AS MaintOpExecutionStageName,
  _MaintOpExecStageCodeText[1:LanguageCode = $session.system_language].MaintOpExecStageShortText AS MaintOpExecStageShortText,
  cast ( SimulatedOperations._MaintenanceOrder.MaintOrdProcessPhaseCode as eam_maint_ord_proc_phase_code preserving type) AS MaintOrdProcessPhaseCode,
  cast( SimulatedOperations._MaintenanceOrder._EAMProcessPhase._EAMProcessPhaseText[1:Language = $session.system_language].EAMProcessPhaseCodeDesc as eam_maint_ord_proc_phase ) AS MaintOrdProcessPhaseDesc,
  cast ( SimulatedOperations._MaintenanceOrder.MaintOrdProcessSubPhaseCode as eam_maint_ord_proc_sph_code preserving type) AS MaintOrdProcessSubPhaseCode,
  cast( SimulatedOperations._MaintenanceOrder._EAMProcessSubPhase._EAMProcessSubPhaseText[1:Language = $session.system_language].EAMProcessSubPhaseCodeDesc as eam_maint_ord_proc_subphase ) AS MaintOrdProcessSubPhaseDesc,
  cast (_OperationDetails._MaintenanceOrderOperation.MaintOrdOpProcessPhaseCode as eam_maint_ordop_proc_phas_code preserving type) AS MaintOrdOpProcessPhaseCode,
  cast(_OperationDetails._MaintenanceOrderOperation._EAMProcessPhase._EAMProcessPhaseText[1:Language = $session.system_language].EAMProcessPhaseCodeDesc as eam_maint_ordop_proc_phase ) AS MaintOrdOpProcessPhaseDesc,
  cast (_OperationDetails._MaintenanceOrderOperation.MaintOrdOpProcessSubPhaseCode as eam_maint_ordop_proc_sph_code preserving type) AS MaintOrdOpProcessSubPhaseCode,
  cast(_OperationDetails._MaintenanceOrderOperation._EAMProcessSubPhase._EAMProcessSubPhaseText[1:Language = $session.system_language].EAMProcessSubPhaseCodeDesc as eam_maint_ordop_proc_subphase) AS MaintOrdOpProcessSubPhaseDesc,
  MaintenanceOrderInternalID,
  SimulatedOperations._MaintenanceOrder._Project.Project AS Project,
  SimulatedOperations._MaintenanceOrder._Project.ProjectDescription AS ProjectDescription,
  cast( SimulatedOperations._MaintenanceOrder._WBSElement.WBSElement as rsh_eam_wbs_element preserving type ) AS WBSElement,
  cast( SimulatedOperations._MaintenanceOrder._WBSElement.WBSDescription as rsh_eam_wbs_element_desc preserving type ) AS WBSDescription,
  cast( unit_conversion( QUANTITY => _OperationPlanningValues.OperationDuration, SOURCE_UNIT => _OperationPlanningValues.OperationDurationUnit, TARGET_UNIT => cast( 'S' as abap.unit(3) ), ERROR_HANDLING => 'SET_TO_NULL' ) as abap.dec(24,0) ) as OperationDurationInSec AS dec240asOperationDurationInSec,
  cast( unit_conversion( QUANTITY => _OperationPlanningValues.OperationPlannedWork, SOURCE_UNIT => _OperationPlanningValues.OperationPlannedWorkUnit, TARGET_UNIT => cast( 'S' as abap.unit(3) ), ERROR_HANDLING => 'SET_TO_NULL' ) as abap.dec(24,0) ) as OperationPlannedWorkInSec AS dec240asOperationPlannedWorkInSec,
  SimulatedOperations.WorkCenterInternalID AS WorkCenterCalendarID,
  UserIsAssignedToOpSimWrkCtr,
  UserIsAssignedToOpWrkCtr,
  MaintSchedCollaboratorType,
  OperationIsDue,
  _PersonResponsible._BusinessPartner.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _PersonResponsible.AuthorizationGroup AS PResAuthorizationGroup,
  SimulatedOperations._MaintenanceOrder._LocationAccountAssignment AS _LocationAccountAssignment,
  SimulatedOperations._MaintenanceOrder._Equipment AS _Equipment,
  MaterialStatusCode,
  _MaintSchedSimulation.LastChangeDateTime AS LastChangeDateTime
FROM I_RSHMaintSchedSmltdOpTP AS SimulatedOperations
LEFT OUTER JOIN C_RSHMaintSchedSimulation AS _MaintSchedSimulation ON _MaintSchedSimulation.MaintSchedSimlnUUID = MaintSchedSimlnUUID  -- association [1..1]
LEFT OUTER JOIN C_RSHOperationSimlnStatusVH AS _OperationSimulationStatus ON MaintOrdOpSimulationStatus = _OperationSimulationStatus.MaintOrdOpSimulationStatus  -- association [1..1]
LEFT OUTER JOIN C_RSHMaintSchedStatusVH AS _MaintSchedStatusVH ON ProcessingStatus = _MaintSchedStatusVH.ProcessingStatus  -- association [1..1]
LEFT OUTER JOIN C_RSHOrderMaterialStatusVH AS _MaterialStatusVH ON MaterialStatus = _MaterialStatusVH.MaterialStatus  -- association [0..1]
LEFT OUTER JOIN C_RSHOperationActivityTypeVH AS _ActivityTypeVH ON maintenanceactivitytype = _ActivityTypeVH.MaintenanceActivityType  -- association [0..1]
LEFT OUTER JOIN C_RSHOrderHasLongTextVH AS _HasLongTextVH ON OperationHasLongText = _HasLongTextVH.OperationHasLongText  -- association [0..1]
LEFT OUTER JOIN C_MaintOrderTypeVH AS _MaintOrderTypeVH ON maintenanceordertype = _MaintOrderTypeVH.MaintenanceOrderType  -- association [0..1]
LEFT OUTER JOIN C_RSHEAMUserVariant AS _MyWorkCenterVH ON WorkCenterInternalID = _MyWorkCenterVH.WorkCenterInternalID AND WorkCenterTypeCode = _MyWorkCenterVH.WorkCenterTypeCode AND Plant = _MyWorkCenterVH.Plant  -- association [0..1]
LEFT OUTER JOIN C_RSHOperationActiveUserStatus AS _OperationActiveStatus ON _OperationActiveStatus.StatusObject = MaintOrderOperationInternalID  -- association [0..*]
LEFT OUTER JOIN C_RSHOperationDetails AS _OperationDetails ON MaintOrderRoutingNumber = _OperationDetails.MaintOrderRoutingNumber AND MaintOrderOperationCounter = _OperationDetails.MaintOrderOperationCounter  -- association [0..1]
LEFT OUTER JOIN C_RSHOrderPriorityVH AS _PriorityVH ON MaintPriority = _PriorityVH.MaintPriority AND maintprioritytype = _PriorityVH.MaintPriorityType  -- association [0..1]
LEFT OUTER JOIN I_OperationControlProfile AS _ControlKeyVH ON OperationControlKey = _ControlKeyVH.OperationControlProfile  -- association [0..1]
LEFT OUTER JOIN C_RSHSchedulingTypeVH AS _SchedulingTypeVH ON schedulingtype = _SchedulingTypeVH.SchedulingType  -- association [0..1]
LEFT OUTER JOIN I_WorkAssignment AS _PersonResponsible ON OperationPersonResponsible = _PersonResponsible.WorkAssignment  -- association [0..1]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON _WorkCenter.WorkCenterInternalID = SimulatedOperations.WorkCenterInternalID AND _WorkCenter.WorkCenterTypeCode = SimulatedOperations.WorkCenterTypeCode  -- association [0..1]
LEFT OUTER JOIN I_WorkCenter AS _SimulatedWorkCenter ON _SimulatedWorkCenter.WorkCenterInternalID = SimulatedOperations.SimulatedWorkCenterInternalID  -- association [0..1]
LEFT OUTER JOIN I_MaintOpExecStageCodeText AS _MaintOpExecStageCodeText ON _MaintOpExecStageCodeText.MaintOperationExecStageCode = MaintOperationExecStageCode  -- association [0..*]
LEFT OUTER JOIN I_EquipmentText AS _OpEquipmentText ON _OpEquipmentText.Equipment = OperationEquipment  -- association [0..*]
LEFT OUTER JOIN I_FunctionalLocation AS _OperationFunctionalLocation ON _OperationFunctionalLocation.FunctionalLocation = RelevantOperationFuncLocation  -- association [0..*]
LEFT OUTER JOIN I_FunctionalLocationLabel AS _OperationFuncLocationLabel ON RelevantOperationFuncLocation = _OperationFuncLocationLabel.FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_TechObjIsEquipOrFuncnlLoc AS _TechObjIsEquipOrFuncnlLoc ON _TechObjIsEquipOrFuncnlLoc.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN I_TechObjIsEquipOrFuncnlLoc AS _OperationTechObjIsEquip ON _OperationTechObjIsEquip.TechObjIsEquipOrFuncnlLoc = OpTechObjEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN C_RSHOpSystemConditionVH AS _OperationSystemConditionVH ON OperationSystemCondition = _OperationSystemConditionVH.OperationSystemCondition  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocationLabel AS _FunctionalLocationLabel ON SimulatedOperations.FunctionalLocation = _FunctionalLocationLabel.FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocationLabel AS _OperFunctionalLocationLabel ON _OperFunctionalLocationLabel.FunctionalLocation = OperationTechnicalObject  -- association [0..1]
LEFT OUTER JOIN I_TechnicalObjectText AS _TechnicalObjectText ON _TechnicalObjectText.TechnicalObject = OperationTechnicalObject AND _TechnicalObjectText.TechObjIsEquipOrFuncnlLoc = OpTechObjEquipOrFuncnlLoc  -- association [0..*]
LEFT OUTER JOIN I_EAMProcessPhase AS _EAMProcessPhase ON MaintOrdProcessPhaseCode = _EAMProcessPhase.EAMProcessPhaseCode  -- association [0..1]
LEFT OUTER JOIN I_EAMProcessSubPhase AS _EAMProcessSubPhase ON MaintOrdProcessSubPhaseCode = _EAMProcessSubPhase.EAMProcessSubPhaseCode  -- association [0..1]
-- UNION ALL with additional select branch(es): I_RSHMaintSchedExistingOp
;