C_RSHMaintSchedSmltdOrdAndOp

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_RSHMaintSchedSmltdOrdAndOp.
-- 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: CRSHMNTSIMORDOP

CREATE VIEW C_RSHMaintSchedSmltdOrdAndOp AS
SELECT
  MaintSchedSimlnUUID,
  MaintSchedSimlnOperationUUID,
  concat(SimulatedOperations.MaintOrderRoutingNumber, SimulatedOperations.MaintOrderOperationCounter) AS OrderOperationRowID,
  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,
  SimulatedOperations._MaintenanceOrder.MaintenanceOrderDesc AS MaintenanceOrderDesc,
  SimulatedOperations._MaintenanceOrder.MaintenanceOrderType AS MaintenanceOrderType,
  cast(SimulatedOperations._MaintenanceOrder.MaintenanceActivityType as rsh_eam_maint_activity_type preserving type ) AS MaintenanceActivityType,
  SimulatedOperations._MaintenanceOrder._MaintenanceActivityType._Text[ 1: Language = $session.system_language ].MaintenanceActivityTypeName AS MaintenanceActivityTypeName,
  SimulatedOperations._MaintenanceOrder.MaintPriority 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,
  SimulatedOperations._MaintenanceOrder.Equipment AS Equipment,
  SimulatedOperations._MaintenanceOrder._Equipment._EquipmentText[ 1: Language = $session.system_language ].EquipmentName AS EquipmentName,
  SimulatedOperations._MaintenanceOrder._LocationAccountAssignment.FunctionalLocation AS FunctionalLocation,
  cast( SimulatedOperations._MaintenanceOrder._LocationAccountAssignment._FunctionalLocation._FunctionalLocationText[ 1: Language = $session.system_language ].FunctionalLocationName as ps_s4_pltxt preserving type ) AS FunctionalLocationName,
  cast(SimulatedOperations.TechObjIsEquipOrFuncnlLoc as rsh_eam_ord_tec_obj_type_value preserving type ) AS TechObjIsEquipOrFuncnlLoc,
  _TechObjIsEquipOrFuncnlLoc._Text[1:Language=$session.system_language].TechObjIsEquipOrFuncnlLocDesc AS TechObjIsEquipOrFuncnlLocDesc,
  _OpEquipment._EquipmentText[ 1: Language = $session.system_language ].EquipmentName AS OperationEquipmentName,
  RelevantOperationFuncLocation,
  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,
  SimulatedOperations._MaintenanceOrder.MaintenancePlannerGroup AS MaintenancePlannerGroup,
  SimulatedOperations._MaintenanceOrder.MaintenanceRevision AS MaintenanceRevision,
  SimulatedOperations._MaintenanceOrder.OperationSystemCondition AS OrderSystemCondition,
  SimulatedOperations._MaintenanceOrder._OperationSystemCondition._Text[1:Language = $session.system_language].OperationSystemConditionText AS OrderSystemConditionText,
  cast( SimulatedOperations.OperationSystemCondition as rsh_eams_op_system_cond preserving type ) AS OperationSystemCondition,
  cast ( _OperationSystemCondition.OperationSystemConditionText as rsh_eam_op_system_cond_text) AS OperationSystemConditionText,
  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_maint_work_center ) AS MainWorkCenter,
  cast( SimulatedOperations._MaintenanceOrder.MainWorkCenterPlant as rsh_eam_main_workcenter_plant ) AS MainWorkCenterPlant,
  SimulatedOperations._Operation.OperationControlProfile AS OperationControlKey,
  SimulatedOperations._Operation.OperationText AS OperationDescription,
  cast( coalesce( SimulatedWorkCenter, _WorkCenter.WorkCenter) as rsh_eam_work_center preserving type ) AS WorkCenter,
  cast( SimulatedOperations.WorkCenterTypeCode as rsh_eam_work_center_object_typ ) 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,
  ForceSchedulingSimulation,
  MaintOrdOpHasToScheduleAutom,
  MaintOrdOpHasToRespectSetStart,
  MaintSchedSetStartIsTimeBased,
  MaterialStatus,
  SimulatedOperations._MaintenanceOrder._Equipment.AuthorizationGroup AS AuthorizationGroup,
  SimulatedOperations._MaintenanceOrder._LocationAccountAssignment.MaintenancePlant AS MaintenancePlant,
  SimulatedOperations._MaintenanceOrder.ControllingArea AS ControllingArea,
  SimulatedOperations._MaintenanceOrder.ResponsibleCostCenter 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,
  MaintOperationExecStageCode,
  _MaintOpExecStageCodeText[1:LanguageCode = $session.system_language].MaintOpExecutionStageName AS MaintOpExecutionStageName,
  _MaintOpExecStageCodeText[1:LanguageCode = $session.system_language].MaintOpExecStageShortText AS MaintOpExecStageShortText,
  'expanded' AS OrderOperationIsExpanded,
  0 AS OrderOperationRowLevel,
  0 AS HierarchyDescendantCount,
  cast ( SimulatedOperations._MaintenanceOrder.MaintOrdProcessPhaseCode as eam_maint_ord_proc_phase_code preserving type) AS MaintOrdProcessPhaseCode,
  SimulatedOperations._MaintenanceOrder._EAMProcessPhase._EAMProcessPhaseText[1:Language = $session.system_language].EAMProcessPhaseCodeDesc AS MaintOrdProcessPhaseDesc,
  cast ( SimulatedOperations._MaintenanceOrder.MaintOrdProcessSubPhaseCode as eam_maint_ord_proc_sph_code preserving type) AS MaintOrdProcessSubPhaseCode,
  SimulatedOperations._MaintenanceOrder._EAMProcessSubPhase._EAMProcessSubPhaseText[1:Language = $session.system_language].EAMProcessSubPhaseCodeDesc AS MaintOrdProcessSubPhaseDesc,
  cast (SimulatedOperations.MaintOrdOpProcessPhaseCode as eam_maint_ordop_proc_phas_code preserving type) AS MaintOrdOpProcessPhaseCode,
  _EAMOrdOpProcessPhase._EAMProcessPhaseText[1:Language = $session.system_language].EAMProcessPhaseCodeDesc AS MaintOrdOpProcessPhaseDesc,
  cast (SimulatedOperations.MaintOrdOpProcessSubPhaseCode as eam_maint_ordop_proc_sph_code preserving type) AS MaintOrdOpProcessSubPhaseCode,
  _EAMOrdOpProcessSubPhase._EAMProcessSubPhaseText[1:Language = $session.system_language].EAMProcessSubPhaseCodeDesc AS MaintOrdOpProcessSubPhaseDesc,
  cast ('' as concatenatedorderphasectrltext) AS MaintenancePhaseControlText,
  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,
  OperationEquipment,
  OperationTechnicalObject,
  OpTechObjEquipOrFuncnlLoc,
  OperationPersonResponsible,
  WorkCenterInternalID,
  WorkCenterInternalID AS WorkCenterCalendarID,
  OperationPlannedWork,
  OperationPlannedWorkUnit,
  OperationDuration,
  OperationDurationUnit,
  OpErlstSchedldExecStrtDte,
  OpErlstSchedldExecEndDte,
  OpLtstSchedldExecStrtDte,
  OpLtstSchedldExecEndDte,
  ProcessingStatus,
  MaterialStatusCode,
  cast('' as rsh_eam_oper_sim_status_text) AS MaintOrdOpSimulationStatusText,
  MaintOrderRoutingNumber AS OrderOperationParentRowID,
  SimulatedOperations.MaintOrderRoutingNumber AS MaintOrderRoutingNumber,
  SimulatedOperations.MaintenanceOrderInternalID AS MaintenanceOrderInternalID,
  _HasLongTextVH.OperationHasLongTextDesc AS OperationHasLongTextDesc,
  _MaintSchedSimulation.LastChangeDateTime AS LastChangeDateTime,
  _MaintSchedStatusVH.ProcessingStatusText AS ProcessingStatusText,
  _MaterialStatusVH.MaterialStatusText AS MaterialStatusText,
  _PersonResponsible.PersonFullName AS OperationPersonRespName
FROM I_RSHMaintSchedSmltdOpTP AS SimulatedOperations
LEFT OUTER JOIN I_RSHAssignedWorkCenters AS AssignedWorkCenter 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  -- 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_MaintenanceOrder AS _maintenanceOrder ON maintenanceorder = _maintenanceOrder.MaintenanceOrder  -- association [1..1]
LEFT OUTER JOIN C_RSHMaintSchedSmltdOpRelshp AS _Relationships ON ( _Relationships.PredecessorOrder = maintenanceorder AND _Relationships.PredecessorOrderOperation = MaintenanceOrderOperation ) OR ( _Relationships.SuccessorOrder = maintenanceorder AND _Relationships.SuccessorOrderOperation = MaintenanceOrderOperation )  -- association [0..*]
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_EAMProcessPhase AS _EAMOrdProcessPhase ON MaintOrdProcessPhaseCode = _EAMOrdProcessPhase.EAMProcessPhaseCode  -- association [0..1]
LEFT OUTER JOIN I_EAMProcessSubPhase AS _EAMOrdProcessSubPhase ON MaintOrdProcessSubPhaseCode = _EAMOrdProcessSubPhase.EAMProcessSubPhaseCode  -- association [0..1]
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_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_FunctionalLocationText AS _OpFunctionalLocationText ON _OpFunctionalLocationText.FunctionalLocation = OperationFunctionalLocation  -- association [0..*]
LEFT OUTER JOIN I_FunctionalLocation AS _OperationFunctionalLocation ON _OperationFunctionalLocation.FunctionalLocation = RelevantOperationFuncLocation  -- association [0..*]
LEFT OUTER JOIN I_Equipment AS _OpEquipment ON _OpEquipment.Equipment = OperationEquipment  -- association [0..*]
LEFT OUTER JOIN I_FunctionalLocationLabel AS _OperFunctionalLocationLabel ON _OperFunctionalLocationLabel.FunctionalLocation = OperationTechnicalObject  -- association [0..1]
LEFT OUTER JOIN C_RSHOpSystemConditionVH AS _OperationSystemCondition ON OperationSystemCondition = _OperationSystemCondition.OperationSystemCondition  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocationLabel AS _FunctionalLocationLabel ON SimulatedOperations.FunctionalLocation = _FunctionalLocationLabel.FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN C_RSHWorkCtrUtilznIndicator AS _UtilIndicator ON _UtilIndicator.MaintOrderRoutingNumber = MaintOrderRoutingNumber  -- association [0..*]
LEFT OUTER JOIN I_EquipmentText AS _OpEquipmentText ON _OpEquipmentText.Equipment = OperationEquipment  -- association [0..*]
LEFT OUTER JOIN I_FunctionalLocationLabel AS _OperationFuncLocationLabel ON RelevantOperationFuncLocation = _OperationFuncLocationLabel.FunctionalLocation  -- association [0..1]
-- UNION ALL with additional select branch(es): I_RSHMaintSchedExistingOp
;