C_RSHOperations

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 C_RSHOperations.
-- 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: CRSHOPERATIONS

CREATE VIEW C_RSHOperations AS
SELECT
  iop.MaintenanceOrder AS MaintenanceOrder,
  iop.MaintenanceOrderOperation AS MaintenanceOrderOperation,
  cast( iop.MaintenanceOrderSubOperation as uvorn preserving type ) AS MaintenanceOrderSubOperation,
  iop.MaintOrderRoutingNumber AS MaintOrderRoutingNumber,
  iop.MaintOrderOperationCounter AS MaintOrderOperationCounter,
  iop.MaintOrderOperationInternalID AS MaintOrderOperationInternalID,
  iop.MaintOrderConfirmation AS MaintOrderConfirmation,
  iop.MaintenanceOrderDesc AS MaintenanceOrderDesc,
  iop.MaintenanceOrderType AS OrderType,
  iop.MaintenanceActivityType AS MaintenanceActivityType,
  iop._MaintenanceActivityType._Text[ 1: Language = $session.system_language ].MaintenanceActivityTypeName AS MaintenanceActivityTypeName,
  iop.MaintPriority AS MaintPriority,
  iop.MaintPriorityType AS MaintPriorityType,
  iop._MaintenancePriority._Text[ 1: Language = $session.system_language ].MaintPriorityDesc AS MaintPriorityDesc,
  iop.OperationHasLongText AS OperationHasLongText,
  _HasLongTextVH.OperationHasLongTextDesc AS OperationHasLongTextDesc,
  '' AS OperationHasSubOperations,
  iop.MaintenanceNotification AS MaintenanceNotification,
  iop._MaintenanceNotification.NotificationText AS NotificationText,
  iop.Equipment AS Equipment,
  iop.EquipmentName AS EquipmentName,
  FunctionalLocationName,
  FunctionalLocation,
  OperationTechnicalObject,
  OpTechObjEquipOrFuncnlLoc,
  cast( OperationTechnicalObject as rsh_eams_op_tech_obj_conv ) AS OperationTechnicalObjectLabel,
  OperationEquipment,
  iop.OperationEquipmentName AS OperationEquipmentName,
  OperationFunctionalLocation,
  iop.OpFunctionalLocationName AS OpFunctionalLocationName,
  'X' AS FuncnlLocLabelIsPrimaryLabel,
  'X' AS FunctionalLocLabelIsActive,
  MaintenancePlanningPlant,
  MaintenancePlannerGroup,
  MaintenanceRevision,
  _MaintenanceRevision.MaintenanceRevisionDesc AS MaintenanceRevisionDesc,
  OperationSystemCondition,
  _OperationSystemConditionVH.OperationSystemConditionText AS OperationSystemConditionText,
  OrderSystemCondition,
  _OrderSystemConditionVH.OperationSystemConditionText AS OrderSystemConditionText,
  AssetRoom,
  AssetLocation,
  PlantSection,
  MaintenancePlan,
  ABCIndicator,
  ABCIndicatorDesc,
  cast( Project as rsh_eam_project preserving type ) AS Project,
  ProjectDescription,
  cast( WBSElement as rsh_eam_wbs_element preserving type ) AS WBSElement,
  WBSDescription,
  iop.SuperiorProjectNetwork AS SuperiorProjectNetwork,
  iop.MainWorkCenter AS MainWorkCenter,
  MainWorkCenterPlant,
  OperationControlKey,
  case when SuperiorOperationInternalID = '00000000' then '' else OperationDescription end AS SubOperationText,
  case when SuperiorOperationInternalID = '00000000' then OperationDescription else _SuperiorOperation.OperationText end as OperationDescription AS OperationTextendasOperationDescription,
  OperationPersonResponsible,
  PersonFullName AS OperationPersonRespName,
  WorkCenter,
  iop.WorkCenterInternalID AS WorkCenterInternalID,
  cast( iop.WorkCenterTypeCode as rsh_eam_work_center_object_typ ) AS WorkCenterTypeCode,
  iop.Plant AS Plant,
  iop.OperationPlannedWork AS OperationPlannedWork,
  iop.OperationPlannedWorkUnit AS OperationPlannedWorkUnit,
  iop.OperationDuration AS OperationDuration,
  iop.OperationDurationUnit AS OperationDurationUnit,
  iop.OpErlstSchedldExecStrtDte AS OpErlstSchedldExecStrtDte,
  iop.OpErlstSchedldExecStrtTme AS OpErlstSchedldExecStrtTme,
  iop.OpErlstSchedldExecEndDte AS OpErlstSchedldExecEndDte,
  iop.OpErlstSchedldExecEndTme AS OpErlstSchedldExecEndTme,
  iop.OpLtstSchedldExecStrtDte AS OpLtstSchedldExecStrtDte,
  iop.OpLtstSchedldExecStrtTme AS OpLtstSchedldExecStrtTme,
  iop.OpLtstSchedldExecEndDte AS OpLtstSchedldExecEndDte,
  iop.OpLtstSchedldExecEndTme AS OpLtstSchedldExecEndTme,
  ScheduledBasicStartDate,
  ScheduledBasicStartTime,
  ScheduledBasicEndDate,
  ScheduledBasicEndTime,
  iop.SchedulingIsPerformedBackward AS SchedulingIsPerformedBackward,
  iop.LatestAcceptableCompletionDate AS LatestAcceptableCompletionDate,
  _MaintOperationExecStageCode.SequenceNumber AS SortSequence,
  iop.MaintOperationExecStageCode AS MaintOperationExecStageCode,
  _MaintOpExecStageCodeText[1:LanguageCode = $session.system_language].MaintOpExecutionStageName AS MaintOpExecutionStageName,
  _MaintOpExecStageCodeText[1:LanguageCode = $session.system_language].MaintOpExecStageShortText AS MaintOpExecStageShortText,
  iop.SchedulingType AS SchedulingType,
  _BasicSchedulingType._Text[ 1: Language = $session.system_language ].SchedulingTypeName AS SchedulingTypeName,
  NumberOfCapacities,
  cast('00000000' as rsh_eam_period_type_date) AS PeriodType,
  iop.ProcessingStatus AS ProcessingStatus,
  _ProcessingStatusVH.ProcessingStatusText AS ProcessingStatusText,
  iop.MaterialStatus AS MaterialStatus,
  iop.MaterialStatusCode AS MaterialStatusCode,
  _MaterialStatusVH.MaterialStatusText AS MaterialStatusText,
  iop.HasError AS HasError,
  _HasErrorVH.HasErrorDescription AS HasErrorDescription,
  iop.HasCrossOrderRelationship AS HasCrossOrderRelationship,
  iop.MaintObjectLocAcctAssgmtNmbr AS MaintObjectLocAcctAssgmtNmbr,
  _FirstMaintSched.MaintSchedSimlnUUID AS MaintSchedSimlnUUID,
  coalesce(_FirstMaintSched.MaintSchedSimlnDescription, 'None') AS FirstMaintSchedSimulation,
  _FirstMaintSched.NumberOfMaintSchedSimulations AS NumberOfMaintSchedSimulations,
  _FunctionalLocationVH.MaintObjectInternalID AS MaintObjectFunctionalLocID,
  _Equipment.MaintObjectInternalID AS MaintObjectEquipmentID,
  _OperationEquipment.MaintObjectInternalID AS OpMaintObjectEquipmentID,
  _OperationFunctionalLocation.MaintObjectInternalID AS OpMaintObjectFunctionalLocID,
  iop.AuthorizationGroup AS AuthorizationGroup,
  iop.MaintenanceOrderType AS MaintenanceOrderType,
  MaintenancePlant,
  iop.ControllingArea AS ControllingArea,
  iop.ResponsibleCostCenter AS ResponsibleCostCenter,
  MaintOrdProcessPhaseCode,
  _EAMProcessPhase._EAMProcessPhaseText[1:Language = $session.system_language].EAMProcessPhaseCodeDesc AS MaintOrdProcessPhaseDesc,
  MaintOrdProcessSubPhaseCode,
  _EAMProcessSubPhase._EAMProcessSubPhaseText[1:Language = $session.system_language].EAMProcessSubPhaseCodeDesc AS MaintOrdProcessSubPhaseDesc,
  MaintOrdOpProcessPhaseCode,
  _EAMOpProcessPhase._EAMProcessPhaseText[1:Language = $session.system_language].EAMProcessPhaseCodeDesc AS MaintOrdOpProcessPhaseDesc,
  MaintOrdOpProcessSubPhaseCode,
  _EAMOpProcessSubPhase._EAMProcessSubPhaseText[1:Language = $session.system_language].EAMProcessSubPhaseCodeDesc AS MaintOrdOpProcessSubPhaseDesc,
  MaintenanceOrderInternalID,
  cast ('' as rsh_eam_order_user_status ) AS MaintOrdCnctntdActvUserSts,
  cast ('' as rsh_eam_ordop_user_status ) AS MaintOrdOpCnctntdActvUserSts,
  cast( '00000000' as rsh_eam_assigned_person ) AS AssignedPerson,
  iop.OrderStartDateTime AS OrderStartDateTime,
  iop.OrderEndDateTime AS OrderEndDateTime,
  iop.OpActualExecutionStartDateTime AS OpActualExecutionStartDateTime,
  iop.OpActualExecutionEndDateTime AS OpActualExecutionEndDateTime,
  iop.OrderOperationStartDateTime AS OrderOperationStartDateTime,
  iop.OrderOperationEndDateTime AS OrderOperationEndDateTime,
  iop.ActualWorkQuantity AS ActualWorkQuantity,
  iop.ActualWorkQuantityUnit AS ActualWorkQuantityUnit,
  cast (iop.RemainingWorkQuantity as rsh_eam_remaining_work) AS RemainingWorkQuantity,
  cast(0 as rsh_eam_assigned_start_time) AS AssignedMaintOpStartDateTime,
  cast(0 as rsh_eam_assigned_end_time) AS AssignedMaintOpEndDateTime,
  SortField,
  iop._LocationAccountAssignment AS _LocationAccountAssignment
FROM P_RSHOperations AS iop
LEFT OUTER JOIN I_MaintOrdSubOpStdVH AS _MaintenanceOrderSubOperation ON MaintenanceOrder = _MaintenanceOrderSubOperation.MaintenanceOrder AND MaintenanceOrderOperation = _MaintenanceOrderSubOperation.MaintenanceOrderOperation AND MaintenanceOrderSubOperation = _MaintenanceOrderSubOperation.MaintenanceOrderSubOperation  -- association [0..1]
LEFT OUTER JOIN I_MaintOrdOpStdVH AS _MaintenanceOrderOperation ON MaintenanceOrder = _MaintenanceOrderOperation.MaintenanceOrder AND MaintenanceOrderOperation = _MaintenanceOrderOperation.MaintenanceOrderOperation  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceOrderStdVH AS _MaintenanceOrder ON MaintenanceOrder = _MaintenanceOrder.MaintenanceOrder  -- association [0..1]
LEFT OUTER JOIN C_RSHOperationActiveUserStatus AS _OperationActiveStatus ON _OperationActiveStatus.StatusObject = MaintOrderOperationInternalID  -- association [0..*]
LEFT OUTER JOIN C_RSHOperationDetails AS _OperationDetails ON MaintenanceOrder = _OperationDetails.MaintenanceOrder AND MaintenanceOrderOperation = _OperationDetails.MaintenanceOrderOperation AND MaintenanceOrderSubOperation = _OperationDetails.MaintenanceOrderSubOperation  -- association [0..1]
LEFT OUTER JOIN C_RSHEAMUserVariant AS _MyWorkCenterVH ON WorkCenterTypeCode = _MyWorkCenterVH.WorkCenterTypeCode AND WorkCenter = _MyWorkCenterVH.WorkCenter  -- association [0..1]
LEFT OUTER JOIN C_MaintOrderTypeVH AS _MaintOrderTypeVH ON OrderType = _MaintOrderTypeVH.MaintenanceOrderType  -- association [0..1]
LEFT OUTER JOIN C_RSHOperationProcessStatusVH AS _ProcessingStatusVH ON ProcessingStatus = _ProcessingStatusVH.ProcessingStatus  -- association [0..1]
LEFT OUTER JOIN C_RSHOrderPriorityVH AS _PriorityVH ON MaintPriority = _PriorityVH.MaintPriority AND MaintPriorityType = _PriorityVH.MaintPriorityType  -- association [0..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_RSHOperationHasErrorVH AS _HasErrorVH ON HasError = _HasErrorVH.HasError  -- association [0..1]
LEFT OUTER JOIN C_RSHOrderHasLongTextVH AS _HasLongTextVH ON OperationHasLongText = _HasLongTextVH.OperationHasLongText  -- association [0..1]
LEFT OUTER JOIN C_RSHSchedulingTypeVH AS _SchedulingTypeVH ON SchedulingType = _SchedulingTypeVH.SchedulingType  -- association [0..1]
LEFT OUTER JOIN C_MaintOrderOpCtrlKeyVH AS _ControlKeyVH ON OperationControlKey = _ControlKeyVH.OperationControlProfile  -- association [0..1]
LEFT OUTER JOIN C_RSHOpInMaintSchedVH AS _OpInMaintSchedVH ON MaintOrderRoutingNumber = MaintOrderRoutingNumber  -- association [0..*]
LEFT OUTER JOIN I_FunctionalLocation AS _FunctionalLocationVH ON iop.FunctionalLocation = _FunctionalLocationVH.FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN C_RSHOpSystemConditionVH AS _OperationSystemConditionVH ON OperationSystemCondition = _OperationSystemConditionVH.OperationSystemCondition  -- association [0..1]
LEFT OUTER JOIN C_RSHOpSystemConditionVH AS _OrderSystemConditionVH ON OrderSystemCondition = _OrderSystemConditionVH.OperationSystemCondition  -- association [0..1]
LEFT OUTER JOIN I_MaintOpExecStageCodeText AS _MaintOpExecStageCodeText ON _MaintOpExecStageCodeText.MaintOperationExecStageCode = MaintOperationExecStageCode  -- association [0..*]
LEFT OUTER JOIN I_MaintOperationExecStageCode AS _MaintOperationExecStageCode ON _MaintOperationExecStageCode.MaintOperationExecStageCode = MaintOperationExecStageCode  -- association [0..1]
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]
LEFT OUTER JOIN I_EAMProcessPhase AS _EAMOpProcessPhase ON MaintOrdOpProcessPhaseCode = _EAMOpProcessPhase.EAMProcessPhaseCode  -- association [0..1]
LEFT OUTER JOIN I_EAMProcessSubPhase AS _EAMOpProcessSubPhase ON MaintOrdOpProcessSubPhaseCode = _EAMOpProcessSubPhase.EAMProcessSubPhaseCode  -- 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 I_TechnicalObjectText AS _TechnicalObjectText ON _TechnicalObjectText.TechnicalObject = OperationTechnicalObject AND _TechnicalObjectText.TechObjIsEquipOrFuncnlLoc = OpTechObjEquipOrFuncnlLoc  -- association [0..*]
LEFT OUTER JOIN I_Equipment AS _OperationEquipment ON _OperationEquipment.Equipment = OperationEquipment  -- association [0..*]
LEFT OUTER JOIN I_FunctionalLocation AS _OperationFunctionalLocation ON _OperationFunctionalLocation.FunctionalLocation = OperationFunctionalLocation  -- association [0..*]
LEFT OUTER JOIN E_MaintenanceOrder AS _MaintenanceOrderExtension ON MaintenanceOrder = _MaintenanceOrderExtension.MaintenanceOrder  -- association [0..1]
LEFT OUTER JOIN E_MaintenanceOrderOperation AS _MaintOrderOperExtension ON MaintOrderRoutingNumber = _MaintOrderOperExtension.MaintOrderRoutingNumber AND MaintOrderOperationCounter = _MaintOrderOperExtension.MaintOrderOperationCounter  -- association [0..1]
LEFT OUTER JOIN I_RSHOrderUserStatus AS _MaintOrdActiveUserStatus ON _MaintOrdActiveUserStatus.StatusObject = MaintenanceOrderInternalID  -- association [0..*]
LEFT OUTER JOIN I_RSHOperationUserStatus AS _MaintOrdOpActiveUserStatus ON _MaintOrdOpActiveUserStatus.StatusObject = MaintOrderOperationInternalID  -- association [0..*]
LEFT OUTER JOIN C_ObjPgMaintObjPhaseControl AS _ObjPgMaintObjPhaseControl ON _ObjPgMaintObjPhaseControl.StatusObject = MaintenanceOrderInternalID AND _ObjPgMaintObjPhaseControl.EAMBlockerCodeEntityType = 'ORI' AND _ObjPgMaintObjPhaseControl.MaintenanceOrderType = MaintenanceOrderType  -- association [0..*]
LEFT OUTER JOIN C_ObjPgMaintObjPhaseControl AS _ObjPgMaintObjOrdOpPhaseCntrl ON _ObjPgMaintObjOrdOpPhaseCntrl.StatusObject = MaintOrderOperationInternalID AND _ObjPgMaintObjOrdOpPhaseCntrl.EAMBlockerCodeEntityType = 'OVG' AND _ObjPgMaintObjOrdOpPhaseCntrl.MaintenanceOrderType = MaintenanceOrderType  -- association [0..*]
LEFT OUTER JOIN I_RSHOperationAssignment AS _AssignedPeople ON _AssignedPeople.MaintOrderRoutingNumber = MaintOrderRoutingNumber AND _AssignedPeople.MaintOrderOperationCounter = MaintOrderOperationCounter  -- association [0..1]
;