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_RSHScheduleOperationsE.
-- 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: PRSHSCHEDOPSE
CREATE VIEW P_RSHScheduleOperationsE 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.MaintOrdBasicStartTime AS MaintOrdBasicStartTime,
SimulatedOperations._MaintenanceOrder.MaintOrdBasicEndDate AS MaintOrdBasicEndDate,
SimulatedOperations._MaintenanceOrder.MaintOrdBasicEndTime AS MaintOrdBasicEndTime,
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,
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,
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 ('' as rsh_eam_processing_status_text ) 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,
_MaintOperationExecStageCode.SequenceNumber AS SortSequence,
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,
SimulatedOperations._MaintenanceOrder._LocationAccountAssignment.MaintObjectFreeDefinedAttrib AS SortField,
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
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_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 P_RSHCacheProcessingStatus AS _ProcStatus ON _ProcStatus.StatusObject = SimulatedOperations.MaintOrderOperationInternalID -- association [1..1]
;