C_RSHOrdersAndOperations

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_RSHOrdersAndOperations.
-- 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: CRSHORDOPER

CREATE VIEW C_RSHOrdersAndOperations AS
SELECT
  MaintenanceOrderOperation,
  cast(MaintenanceOrderSubOperation as uvorn preserving type ) AS MaintenanceOrderSubOperation,
  cast(_OrderUserStatus.StatusShortName as rsh_eam_order_user_status ) AS MaintOrdCnctntdActvUserSts,
  cast(_OperationUserStatus.StatusShortName as rsh_eam_ordop_user_status ) AS MaintOrdOpCnctntdActvUserSts,
  cast(coalesce(_MaintSchedSimulation.MaintSchedSimlnDescription, 'None') as rsh_eam_op_in_maint_sched_sim) AS MaintSchedSimlnDescription,
  cast( _AssignedPeople.PersonnelNumber as rsh_eam_assigned_person ) AS AssignedPerson,
  MaintOrderRoutingNumber,
  MaintOrderOperationCounter,
  MaintenanceOrderInternalID,
  MaintOrderOperationInternalID,
  cast (OperationDescription as rsh_eam_maintenance_operation) AS OperationDescription,
  cast( MaintenanceOrderDesc as rsh_eam_maintenance_order ) AS MaintenanceOrderDesc,
  MaintenanceOrderType AS OrderType,
  cast(MaintenanceActivityType as rsh_eam_maint_activity_type preserving type ) AS MaintenanceActivityType,
  _MaintenanceActivityType._Text[ 1: Language = $session.system_language ].MaintenanceActivityTypeName AS MaintenanceActivityTypeName,
  MaintPriority,
  MaintPriorityType,
  cast( _MaintenancePriority._Text[ 1: Language = $session.system_language ].MaintPriorityDesc as rsh_eam_priority_text preserving type ) AS MaintPriorityDesc,
  OperationHasLongText,
  MaintenanceNotification,
  cast( _MaintenanceNotification.NotificationText as rsh_eam_notification_text preserving type) AS NotificationText,
  cast( Equipment as rsh_eams_equipment preserving type ) AS Equipment,
  EquipmentName,
  FunctionalLocation AS RelevantFunctionalLocation,
  cast( coalesce(_FunctionalLocationLabel.FunctionalLocationLabelName, '') as rsh_eams_func_location ) AS FunctionalLocation,
  FunctionalLocationName,
  TechObjIsEquipOrFuncnlLoc,
  _TechObjIsEquipOrFuncnlLoc._Text[1:Language=$session.system_language].TechObjIsEquipOrFuncnlLocDesc AS TechObjIsEquipOrFuncnlLocDesc,
  OperationTechnicalObject,
  OpTechObjEquipOrFuncnlLoc,
  _OperationTechObjIsEquip._Text[1:Language=$session.system_language].TechObjIsEquipOrFuncnlLocDesc AS OpTechObjEquipOrFuncnlLocDesc,
  OperationEquipment,
  OperationEquipmentName,
  RelevantOperationFuncLocation,
  OperationFunctionalLocation,
  OpFunctionalLocationName,
  MaintenancePlanningPlant,
  cast( MaintenancePlannerGroup as rsh_eam_planner_group ) AS MaintenancePlannerGroup,
  MaintenanceRevision,
  MaintenanceRevisionDesc,
  cast(OperationSystemCondition as rsh_eams_op_system_cond preserving type) AS OperationSystemCondition,
  cast(OrderSystemCondition as rsh_eams_system_cond preserving type) AS OrderSystemCondition,
  AssetRoom,
  AssetLocation,
  PlantSection,
  MaintenancePlan,
  cast( ABCIndicator as rsh_eam_abc_ind preserving type ) AS ABCIndicator,
  cast( ABCIndicatorDesc as rsh_eam_abc_ind_desc preserving type ) AS ABCIndicatorDesc,
  cast( Project as rsh_eam_project preserving type ) AS Project,
  ProjectDescription,
  cast( WBSElement as rsh_eam_wbs_element preserving type ) AS WBSElement,
  cast( WBSDescription as rsh_eam_wbs_element_desc preserving type ) AS WBSDescription,
  SuperiorProjectNetwork,
  cast(MainWorkCenter as rsh_eam_maint_work_center preserving type) AS MainWorkCenter,
  cast( MainWorkCenterPlant as rsh_eam_main_workcenter_plant) AS MainWorkCenterPlant,
  OperationControlKey,
  cast(OperationPersonResponsible as rsh_eam_person_responsible preserving type) AS OperationPersonResponsible,
  cast ( PersonFullName as rsh_eam_person_resp_name ) AS OperationPersonRespName,
  cast( WorkCenter as rsh_eam_work_center preserving type) AS WorkCenter,
  cast(WorkCenterInternalID as rsh_eam_work_center_object_id preserving type) AS WorkCenterInternalID,
  cast(WorkCenterTypeCode as rsh_eam_work_center_object_typ ) AS WorkCenterTypeCode,
  cast(Plant as rsh_eam_work_center_plant preserving type) AS Plant,
  OperationDuration,
  OperationDurationUnit,
  OperationPlannedWork,
  OperationPlannedWorkUnit,
  SchedulingType,
  _BasicSchedulingType._Text[ 1: Language = $session.system_language ].SchedulingTypeName AS SchedulingTypeName,
  cast( NumberOfCapacities as rsh_eam_number_of_capacities preserving type ) AS NumberOfCapacities,
  cast('00000000' as rsh_eam_period_type_date) AS PeriodType,
  cast(ProcessingStatus as rsh_eam_processing_status_int preserving type ) AS ProcessingStatus,
  cast('' as rsh_eam_processing_status_text) AS ProcessingStatusText,
  cast( Operations.MaterialStatus as rsh_eam_material_status_int preserving type ) AS MaterialStatus,
  MaterialStatusCode,
  HasError,
  AuthorizationGroup,
  MaintenanceOrderType,
  MaintenancePlant,
  ControllingArea,
  cast( ResponsibleCostCenter as rsh_eam_resp_cost_center ) AS ResponsibleCostCenter,
  BasicSchedulingType,
  OrdIsNotSchedldAutomatically,
  LatestAcceptableCompletionDate,
  cast(_FirstMaintSched.MaintSchedSimlnDescription as rsh_eam_op_in_maint_sched_sim) AS FirstMaintSchedSimulation,
  'expanded ' AS OrderOperationIsExpanded,
  concat(MaintenanceOrder,'00000000') AS OrderOperationParentRowID,
  concat(MaintenanceOrder,'00000000') AS OrderOperationRowID,
  0 AS OrderOperationRowLevel,
  OpActualExecutionStartDate,
  OpActualExecutionStartTime,
  OpActualExecutionEndDate,
  OpActualExecutionEndTime,
  OpErlstSchedldExecStrtDte,
  OpErlstSchedldExecStrtTme,
  OpErlstSchedldExecEndDte,
  OpErlstSchedldExecEndTme,
  OpLtstSchedldExecStrtDte,
  OpLtstSchedldExecStrtTme,
  OpLtstSchedldExecEndDte,
  OpLtstSchedldExecEndTme,
  OpBscStartDateConstraintType,
  OpBscEndDateConstraintType,
  SchedulingIsPerformedBackward,
  HasCrossOrderRelationship,
  MaintObjectLocAcctAssgmtNmbr,
  coalesce(_FunctionalLocationVH.MaintObjectInternalID, '') AS MaintObjectFunctionalLocID,
  coalesce( Operations._Equipment.MaintObjectInternalID, '' ) AS MaintObjectEquipmentID,
  OperationIsOnCriticalPath,
  MaintOperationExecStageCode,
  _MaintOpExecStageCodeText[1:LanguageCode = $session.system_language].MaintOpExecutionStageName AS MaintOpExecutionStageName,
  _MaintOpExecStageCodeText[1:LanguageCode = $session.system_language].MaintOpExecStageShortText AS MaintOpExecStageShortText,
  cast ( MaintOrdProcessPhaseCode as eam_maint_ord_proc_phase_code preserving type) AS MaintOrdProcessPhaseCode,
  _EAMProcessPhase._EAMProcessPhaseText[1:Language = $session.system_language].EAMProcessPhaseCodeDesc AS MaintOrdProcessPhaseDesc,
  cast ( MaintOrdProcessSubPhaseCode as eam_maint_ord_proc_sph_code preserving type) AS MaintOrdProcessSubPhaseCode,
  _EAMProcessSubPhase._EAMProcessSubPhaseText[1:Language = $session.system_language].EAMProcessSubPhaseCodeDesc AS MaintOrdProcessSubPhaseDesc,
  cast ( MaintOrdOpProcessPhaseCode as eam_maint_ordop_proc_phas_code preserving type) AS MaintOrdOpProcessPhaseCode,
  _EAMOpProcessPhase._EAMProcessPhaseText[1:Language = $session.system_language].EAMProcessPhaseCodeDesc AS MaintOrdOpProcessPhaseDesc,
  cast ( MaintOrdOpProcessSubPhaseCode as eam_maint_ordop_proc_sph_code preserving type) AS MaintOrdOpProcessSubPhaseCode,
  _EAMOpProcessSubPhase._EAMProcessSubPhaseText[1:Language = $session.system_language].EAMProcessSubPhaseCodeDesc AS MaintOrdOpProcessSubPhaseDesc,
  cast ('' as concatenatedorderphasectrltext) AS MaintenancePhaseControlText,
  cast( '' as rsh_eam_assigned_person_no) AS NumberOfAssignedPersons,
  cast( '99991231' as datum ) AS StartDate,
  cast( '99991231' as datum ) AS EndDate,
  cast (Operations.RemainingWorkQuantity as rsh_eam_remaining_work) AS RemainingWorkQuantity,
  SortField,
  cast(0 as rsh_eam_assigned_start_time) AS AssignedMaintOpStartDateTime,
  cast(0 as rsh_eam_assigned_end_time) AS AssignedMaintOpEndDateTime,
  cast( '' as rsh_eam_is_assigned ) AS MaintOpIsAssignedToPeople,
  Operations.MaintenanceOrder AS MaintenanceOrder,
  Operations.OrderOperationStartDateTime AS OrderOperationStartDateTime,
  Operations.OrderOperationEndDateTime AS OrderOperationEndDateTime,
  Operations.OrderStartDateTime AS OrderStartDateTime,
  Operations.OrderEndDateTime AS OrderEndDateTime,
  Operations.OpActualExecutionStartDateTime AS OpActualExecutionStartDateTime,
  Operations.OpActualExecutionEndDateTime AS OpActualExecutionEndDateTime,
  Operations.ActualWorkQuantity AS ActualWorkQuantity,
  Operations.ActualWorkQuantityUnit AS ActualWorkQuantityUnit,
  _FirstMaintSched.MaintSchedSimlnUUID AS MaintSchedSimlnUUID,
  _FirstMaintSched.NumberOfMaintSchedSimulations AS NumberOfMaintSchedSimulations,
  _HasErrorVH.HasErrorDescription AS HasErrorDescription,
  _HasLongTextVH.OperationHasLongTextDesc AS OperationHasLongTextDesc,
  _MaintOperationExecStageCode.SequenceNumber AS SortSequence,
  _MaterialStatusCodeText.StatusShortName AS MaterialStatusKey,
  _MaterialStatusVH.MaterialStatusText AS MaterialStatusText,
  _OperationEquipment.MaintObjectInternalID AS OpMaintObjectEquipmentID,
  _OperationFunctionalLocation.MaintObjectInternalID AS OpMaintObjectFunctionalLocID,
  _OperationOnCriticalPathVH.OperationOnCriticalPathText AS OperationOnCriticalPathText,
  _OperationSystemConditionVH.OperationSystemConditionText AS OperationSystemConditionText,
  _OrderSystemConditionVH.OperationSystemConditionText AS OrderSystemConditionText
FROM P_RSHOperations AS Operations
LEFT OUTER JOIN C_RSHOrderDetails AS _OrderDetails ON _OrderDetails.MaintenanceOrder = Operations.MaintenanceOrder  -- association [1..1]
LEFT OUTER JOIN C_RSHOrderActiveUserStatus AS _OrderActiveStatus ON _OrderActiveStatus.MaintenanceOrder = MaintenanceOrder  -- association [0..*]
LEFT OUTER JOIN C_RSHOperationRelationships AS _Relationships ON _Relationships.MaintOrderRoutingNumber = MaintOrderRoutingNumber  -- 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_RSHOperationActiveUserStatus AS _OperationActiveStatus ON _OperationActiveStatus.StatusObject = MaintOrderOperationInternalID  -- association [0..*]
LEFT OUTER JOIN I_StatusCodeText AS _MaterialStatusCodeText ON MaterialStatusCode = _MaterialStatusCodeText.StatusCode AND _MaterialStatusCodeText.StatusProfile = '' AND _MaterialStatusCodeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_RSHEAMUserVariant AS _MyWorkCenterVH ON WorkCenterTypeCode = _MyWorkCenterVH.WorkCenterTypeCode AND WorkCenter = _MyWorkCenterVH.WorkCenter  -- association [0..1]
LEFT OUTER JOIN I_MaintenanceOrderStdVH AS _MaintenanceOrderVH ON MaintenanceOrder = _MaintenanceOrderVH.MaintenanceOrder  -- association [0..1]
LEFT OUTER JOIN I_MaintOrdOpStdVH AS _MaintenanceOrderOperationVH ON MaintenanceOrder = _MaintenanceOrderOperationVH.MaintenanceOrder AND MaintenanceOrderOperation = _MaintenanceOrderOperationVH.MaintenanceOrderOperation  -- association [0..1]
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_EquipmentStdVH AS _Equipment ON Equipment = _Equipment.Equipment  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocation AS _FunctionalLocationVH ON RelevantFunctionalLocation = _FunctionalLocationVH.FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocationLabel AS _FunctionalLocationLabel ON RelevantFunctionalLocation = _FunctionalLocationLabel.FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocation AS _OperationFunctionalLocation ON _OperationFunctionalLocation.FunctionalLocation = RelevantOperationFuncLocation  -- association [0..1]
LEFT OUTER JOIN C_MaintOrderOpCtrlKeyVH AS _ControlKeyVH ON OperationControlKey = _ControlKeyVH.OperationControlProfile  -- 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_RSHOpSystemConditionVH AS _OperationSystemConditionVH ON OperationSystemCondition = _OperationSystemConditionVH.OperationSystemCondition  -- association [0..1]
LEFT OUTER JOIN C_RSHOperationOnCriticalPathVH AS _OperationOnCriticalPathVH ON OperationIsOnCriticalPath = _OperationOnCriticalPathVH.OperationIsOnCriticalPath  -- 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 C_RSHWorkCtrUtilznIndicator AS _UtilIndicator ON _UtilIndicator.MaintOrderRoutingNumber = MaintOrderRoutingNumber  -- association [0..*]
LEFT OUTER JOIN I_MaintenanceOrderPhaseControl AS _ObjPgMaintObjPhaseControl ON _ObjPgMaintObjPhaseControl.StatusObject = MaintenanceOrderInternalID AND _ObjPgMaintObjPhaseControl.MaintenanceOrder = MaintenanceOrder AND _ObjPgMaintObjPhaseControl.MaintenanceOrderType = OrderType AND _ObjPgMaintObjPhaseControl.MaintObjPhseCtrlStatusIsActive = 'X'  -- association [0..*]
LEFT OUTER JOIN I_MaintOrderOpPhaseControl AS _ObjPgMaintObjOrdOpPhaseCntrl ON _ObjPgMaintObjOrdOpPhaseCntrl.StatusObject = MaintOrderOperationInternalID AND _ObjPgMaintObjOrdOpPhaseCntrl.MaintenanceOrderType = OrderType AND _ObjPgMaintObjOrdOpPhaseCntrl.MaintenanceOrder = MaintenanceOrder AND _ObjPgMaintObjOrdOpPhaseCntrl.MaintenanceOrderOperation = MaintenanceOrderOperation AND _ObjPgMaintObjOrdOpPhaseCntrl.MaintenanceOrderSubOperation = MaintenanceOrderSubOperation AND _ObjPgMaintObjOrdOpPhaseCntrl.MaintObjPhseCtrlStatusIsActive = 'X'  -- association [0..*]
LEFT OUTER JOIN I_RSHOrderUserStatus AS _OrderUserStatus ON _OrderUserStatus.StatusObject = MaintenanceOrderInternalID  -- association [0..*]
LEFT OUTER JOIN I_RSHOperationUserStatus AS _OperationUserStatus ON _OperationUserStatus.StatusObject = MaintOrderOperationInternalID  -- association [0..*]
LEFT OUTER JOIN I_TechObjIsEquipOrFuncnlLoc AS _TechObjIsEquipOrFuncnlLoc ON _TechObjIsEquipOrFuncnlLoc.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocationLabel AS _OperFunctionalLocationLabel ON _OperFunctionalLocationLabel.FunctionalLocation = OperationTechnicalObject  -- association [0..1]
LEFT OUTER JOIN I_Equipment AS _OperationEquipment ON _OperationEquipment.Equipment = OperationEquipment  -- association [0..*]
LEFT OUTER JOIN I_TechnicalObjectText AS _TechnicalObjectText ON _TechnicalObjectText.TechnicalObject = OperationTechnicalObject  -- association [0..*]
LEFT OUTER JOIN I_TechObjIsEquipOrFuncnlLoc AS _OperationTechObjIsEquip ON _OperationTechObjIsEquip.TechObjIsEquipOrFuncnlLoc = OpTechObjEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN C_RSHOpSystemConditionVH AS _OrderSystemConditionVH ON OrderSystemCondition = _OrderSystemConditionVH.OperationSystemCondition  -- association [0..1]
LEFT OUTER JOIN P_PPH_PlantTimeZone AS _PlanningPlantTimeZone ON _PlanningPlantTimeZone.Plant = MaintenancePlanningPlant  -- association [0..1]
LEFT OUTER JOIN I_RSHOperationAssignment AS _AssignedPeople ON _AssignedPeople.MaintOrderRoutingNumber = MaintOrderRoutingNumber AND _AssignedPeople.MaintOrderOperationCounter = MaintOrderOperationCounter  -- association [0..1]
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]
;