I_RSHMaintSchedSmltdOpTP

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 I_RSHMaintSchedSmltdOpTP.
-- 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: IRSHMNTSHSMOPTP

CREATE VIEW I_RSHMaintSchedSmltdOpTP AS
SELECT
  I_RSHMaintSchedSmltdOp.MaintSchedSimlnOperationUUID AS MaintSchedSimlnOperationUUID,
  I_RSHMaintSchedSmltdOp.MaintSchedSimlnUUID AS MaintSchedSimlnUUID,
  I_RSHMaintSchedSmltdOp.MaintOrderRoutingNumber AS MaintOrderRoutingNumber,
  I_RSHMaintSchedSmltdOp.MaintOrderOperationCounter AS MaintOrderOperationCounter,
  I_RSHMaintSchedSmltdOp.MaintOrderConfirmation AS MaintOrderConfirmation,
  I_RSHMaintSchedSmltdOp.MaintOrdOpSimulatedStartDate AS MaintOrdOpSimulatedStartDate,
  I_RSHMaintSchedSmltdOp.MaintOrdOpSimulatedStartTime AS MaintOrdOpSimulatedStartTime,
  I_RSHMaintSchedSmltdOp.MaintOrdOpSimulatedEndDate AS MaintOrdOpSimulatedEndDate,
  I_RSHMaintSchedSmltdOp.MaintOrdOpSimulatedEndTime AS MaintOrdOpSimulatedEndTime,
  I_RSHMaintSchedSmltdOp.MaintSchedSimlnRescheduleUUID AS MaintSchedSimlnRescheduleUUID,
  I_RSHMaintSchedSmltdOp.SimulatedWorkCenterInternalID AS SimulatedWorkCenterInternalID,
  I_RSHMaintSchedSmltdOp.SimulatedWorkCenterTypeCode AS SimulatedWorkCenterTypeCode,
  I_RSHMaintSchedSmltdOp.SimulatedWorkCenter AS SimulatedWorkCenter,
  I_RSHMaintSchedSmltdOp.MaintOrdOpSimulationStatus AS MaintOrdOpSimulationStatus,
  I_RSHMaintSchedSmltdOp.MaintOrdOpSchedSimulationMode AS MaintOrdOpSchedSimulationMode,
  I_RSHMaintSchedSmltdOp.MaintOrdOpSchedWork AS MaintOrdOpSchedWork,
  I_RSHMaintSchedSmltdOp.ProcessingStatus AS ProcessingStatus,
  I_RSHMaintSchedSmltdOp.TechObjIsEquipOrFuncnlLoc AS TechObjIsEquipOrFuncnlLoc,
  I_RSHMaintSchedSmltdOp.OperationTechnicalObject AS OperationTechnicalObject,
  I_RSHMaintSchedSmltdOp.OpTechObjEquipOrFuncnlLoc AS OpTechObjEquipOrFuncnlLoc,
  I_RSHMaintSchedSmltdOp.MaintOrderProcessingContext AS MaintOrderProcessingContext,
  I_RSHMaintSchedSmltdOp.ServiceDocument AS ServiceDocument,
  I_RSHMaintSchedSmltdOp.ServiceDocumentType AS ServiceDocumentType,
  I_RSHMaintSchedSmltdOp.ServiceDocumentItem AS ServiceDocumentItem,
  OperationIsDue,
  I_RSHMaintSchedSmltdOp.UserIsAssignedToOpWrkCtr AS UserIsAssignedToOpWrkCtr,
  I_RSHMaintSchedSmltdOp.UserIsAssignedToOpSimWrkCtr AS UserIsAssignedToOpSimWrkCtr,
  I_RSHMaintSchedSmltdOp.MaintSchedCollaboratorType AS MaintSchedCollaboratorType,
  '' AS ForceSchedulingSimulation,
  cast('' as xfeld) AS MaintOrdOpHasToScheduleAutom,
  cast('' as xfeld) AS MaintOrdOpHasToRespectSetStart,
  cast('' as xfeld) AS MaintSchedSetStartIsTimeBased,
  cast( '' as rsh_eam_maint_sched_sim_state ) AS SimulationSessionState,
  bintohex(MaintSchedSimlnOperationUUID) AS SitnInstceAnchorObjectKey,
  LastChangedByUser,
  LastChangeDateTime,
  MaintenanceOrderInternalID,
  MaintOrderOperationInternalID,
  cast(case when _Operation.Language = '' then '' else 'X' end as rsh_eam_long_text_available preserving type) AS OperationHasLongText,
  cast( _Operation.OperationPersonResponsible as rsh_eam_person_responsible preserving type ) AS OperationPersonResponsible,
  cast( coalesce( _MaterialStatus.MaterialStatus , 30 ) as rsh_eam_material_status_int preserving type ) AS MaterialStatus,
  _Operation.MaintOperationExecStageCode AS MaintOperationExecStageCode,
  _Operation.MaintOrdOpProcessPhaseCode AS MaintOrdOpProcessPhaseCode,
  _Operation.MaintOrdOpProcessSubPhaseCode AS MaintOrdOpProcessSubPhaseCode,
  Equipment,
  RelevantOperationFuncLocation,
  cast(_OperationFuncLocationLabel.FunctionalLocationLabelName as rsh_eams_oper_func_loc preserving type ) AS OperationFunctionalLocation,
  _Operation.OperationSystemCondition AS OperationSystemCondition,
  _MaintenanceOrder._LocationAccountAssignment.FunctionalLocation AS FunctionalLocation,
  coalesce(cast( _MaintenanceOrder._LocationAccountAssignment._FunctionalLocation._FunctionalLocationText[ 1: Language = $session.system_language ].FunctionalLocationName as rsh_eam_func_location_name preserving type ),'') AS FunctionalLocationName,
  cast( '' as rsh_eam_maint_sched_cache_this ) AS MaintSchedCacheIsActive,
  _Operation.SuperiorOperationInternalID AS SuperiorOperationInternalID,
  _MaintenanceOrder.MaintenanceOrderType AS MaintenanceOrderType
LEFT OUTER JOIN I_RSHMaintSchedSimulationTP AS _MaintSchedSimulation ON _MaintSchedSimulation.MaintSchedSimlnUUID = MaintSchedSimlnUUID  -- association [1..1]
LEFT OUTER JOIN I_RSHOrderMaterialStatus AS _MaterialStatus ON MaintenanceOrderInternalID = _MaterialStatus.StatusObject  -- association [1..1]
LEFT OUTER JOIN I_FunctionalLocationLabel AS _OperationFuncLocationLabel ON RelevantOperationFuncLocation = _OperationFuncLocationLabel.FunctionalLocation  -- association [0..1]
;