C_RSHMaintSchedSmltdOp

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_RSHMaintSchedSmltdOp.
-- 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: CRSHMNTSCHDSMOP

CREATE VIEW C_RSHMaintSchedSmltdOp AS
SELECT
  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,
  cast ( SimulatedOperations._MaintenanceOrder.MaintenanceOrderDesc as rsh_order_description preserving type ) AS MaintenanceOrderDesc,
  SimulatedOperations._MaintenanceOrder.MaintenanceOrderType AS MaintenanceOrderType,
  cast( SimulatedOperations._MaintenanceOrder.MaintenanceActivityType as rsh_eam_maint_activity_type preserving type ) AS MaintenanceActivityType,
  cast( SimulatedOperations._MaintenanceOrder._MaintenanceActivityType._Text[ 1: Language = $session.system_language ].MaintenanceActivityTypeName as eam_maint_activity_type_name ) AS MaintenanceActivityTypeName,
  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._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( _FunctionalLocationLabel.FunctionalLocationLabelName as rsh_eams_ord_func_location) AS FunctionalLocation,
  cast( FunctionalLocationName as rsh_eam_func_location_name preserving type ) AS FunctionalLocationName,
  _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,
  _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,
  cast (SimulatedOperations._MaintenanceOrder._LocationAccountAssignment.ABCIndicator as rsh_eam_abc_ind preserving type ) AS ABCIndicator,
  cast (SimulatedOperations._MaintenanceOrder._LocationAccountAssignment._ABCIndicator._Text[1:Language = $session.system_language].ABCIndicatorDesc as rsh_eam_abc_ind_desc preserving type ) AS ABCIndicatorDesc,
  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,
  SimulatedOperations._Operation.OperationControlProfile AS OperationControlKey,
  cast ( SimulatedOperations._Operation.OperationText as rsh_eam_maintenance_operation) AS OperationDescription,
  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,
  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,
  ForceSchedulingSimulation,
  MaintOrdOpHasToScheduleAutom,
  MaintOrdOpHasToRespectSetStart,
  MaintSchedSetStartIsTimeBased,
  cast( _MaterialStatusVH.MaterialStatusText as rsh_eam_material_status_text ) AS MaterialStatusText,
  SimulatedOperations._MaintenanceOrder._Equipment.AuthorizationGroup AS AuthorizationGroup,
  SimulatedOperations._MaintenanceOrder._LocationAccountAssignment.MaintenancePlant AS MaintenancePlant,
  SimulatedOperations._MaintenanceOrder.ControllingArea AS ControllingArea,
  cast(SimulatedOperations._MaintenanceOrder.ResponsibleCostCenter as rsh_eam_resp_cost_center) AS ResponsibleCostCenter,
  SimulatedWorkCenterInternalID,
  SimulatedWorkCenterTypeCode,
  MaintOrdOpSimulationStatus,
  MaintOrdOpSimulatedStartDate,
  MaintOrdOpSimulatedStartTime,
  MaintOrdOpSimStartDateTime,
  MaintOrdOpSimulatedEndDate,
  MaintOrdOpSimulatedEndTime,
  SimulatedOperations._MaintenanceOrder.MaintObjectLocAcctAssgmtNmbr AS MaintObjectLocAcctAssgmtNmbr,
  SimulatedOperations._MaintenanceOrder.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  LastChangedByUser,
  case when SimulatedOperations.LastChangeDateTime > _MaintSchedSimulation.CreationDateTime then SimulatedOperations.LastChangeDateTime else _MaintSchedSimulation.CreationDateTime end as LastChangeDateTime AS CreationDateTimeendasLastChangeDateTime,
  SimulationSessionState,
  SimulatedOperations._MaintenanceOrder.LatestAcceptableCompletionDate AS LatestAcceptableCompletionDate,
  _MaintOpExecStageCodeText[1:LanguageCode = $session.system_language].MaintOpExecutionStageName AS MaintOpExecutionStageName,
  _MaintOpExecStageCodeText[1:LanguageCode = $session.system_language].MaintOpExecStageShortText AS MaintOpExecStageShortText,
  SimulatedOperations._MaintenanceOrder.MaintOrdProcessPhaseCode AS MaintOrdProcessPhaseCode,
  SimulatedOperations._MaintenanceOrder._EAMProcessPhase._EAMProcessPhaseText[1:Language = $session.system_language].EAMProcessPhaseCodeDesc AS MaintOrdProcessPhaseDesc,
  SimulatedOperations._MaintenanceOrder.MaintOrdProcessSubPhaseCode AS MaintOrdProcessSubPhaseCode,
  SimulatedOperations._MaintenanceOrder._EAMProcessSubPhase._EAMProcessSubPhaseText[1:Language = $session.system_language].EAMProcessSubPhaseCodeDesc AS MaintOrdProcessSubPhaseDesc,
  _EAMOrdOpProcessPhase._EAMProcessPhaseText[1:Language = $session.system_language].EAMProcessPhaseCodeDesc AS MaintOrdOpProcessPhaseDesc,
  _EAMOrdOpProcessSubPhase._EAMProcessSubPhaseText[1:Language = $session.system_language].EAMProcessSubPhaseCodeDesc AS MaintOrdOpProcessSubPhaseDesc,
  MaintenanceOrderInternalID,
  cast( SimulatedOperations._MaintenanceOrder._Project.Project as rsh_eam_project preserving type ) 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,
  SimulatedOperations._MaintenanceOrder._LocationAccountAssignment.MaintObjectFreeDefinedAttrib AS SortField,
  MaintSchedCacheIsActive,
  SimulatedOperations._MaintenanceOrder._LocationAccountAssignment AS _LocationAccountAssignment,
  SimulatedOperations._MaintenanceOrder._Equipment AS _Equipment,
  MaintOrderOperationCounter,
  MaintOrderConfirmation,
  MaintOrderOperationInternalID,
  OperationHasLongText,
  TechObjIsEquipOrFuncnlLoc,
  OperationTechnicalObject,
  OpTechObjEquipOrFuncnlLoc,
  OperationPersonResponsible,
  OperationPlannedWork,
  OperationPlannedWorkUnit,
  OperationDuration,
  OperationDurationUnit,
  OpErlstSchedldExecStrtDte,
  OpErlstSchedldExecEndDte,
  OpLtstSchedldExecStrtDte,
  OpLtstSchedldExecEndDte,
  MaterialStatus,
  MaterialStatusCode,
  cast('' as rsh_eam_oper_sim_status_text) AS MaintOrdOpSimulationStatusText,
  MaintOperationExecStageCode,
  cast ( existingOp.MaintOrdOpProcessPhaseCode as eam_maint_ordop_proc_phas_code preserving type) AS MaintOrdOpProcessPhaseCode,
  cast (existingOp.MaintOrdOpProcessSubPhaseCode as eam_maint_ordop_proc_sph_code preserving type) AS MaintOrdOpProcessSubPhaseCode,
  SimulatedOperations.MaintOrderRoutingNumber AS MaintOrderRoutingNumber,
  _HasLongTextVH.OperationHasLongTextDesc AS OperationHasLongTextDesc,
  _MaintOperationExecStageCode.SequenceNumber AS SortSequence,
  _MaintSchedSimulation.LastChangeDateTime AS LastChangeDateTime,
  _MaintSchedStatusVH.ProcessingStatusText AS ProcessingStatusText,
  _PersonResponsible.PersonFullName AS OperationPersonRespName
FROM I_RSHMaintSchedSmltdOpTP AS SimulatedOperations
LEFT OUTER JOIN I_RSHMaintSchedSimulation AS DummyOperation ON /* join condition not captured in parsed metadata */
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 C_MaintOrderOpCtrlKeyVH 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_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_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 _EAMOrdOpProcessPhase ON MaintOrdOpProcessPhaseCode = _EAMOrdOpProcessPhase.EAMProcessPhaseCode  -- association [0..1]
LEFT OUTER JOIN I_EAMProcessSubPhase AS _EAMOrdOpProcessSubPhase ON MaintOrdOpProcessSubPhaseCode = _EAMOrdOpProcessSubPhase.EAMProcessSubPhaseCode  -- 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]
-- UNION ALL with additional select branch(es): I_RSHMaintSchedExistingOp
;