C_RSHMaintSchedSimlnSearch

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_RSHMaintSchedSimlnSearch.
-- 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: CRSHMNTSCHDSIMS

CREATE VIEW C_RSHMaintSchedSimlnSearch AS
SELECT
  I_RSHMaintSchedSimulationTP.MaintSchedSimlnUUID AS MaintSchedSimlnUUID,
  I_RSHMaintSchedSimulationTP.MaintSchedSimulationStartDate AS MaintSchedSimulationStartDate,
  I_RSHMaintSchedSimulationTP.MaintSchedSimulationEndDate AS MaintSchedSimulationEndDate,
  cast( I_RSHMaintSchedSimulationTP.MaintSchedSimStartDateTime as rsh_eam_schedule_start preserving type ) AS MaintSchedSimStartDateTime,
  cast( I_RSHMaintSchedSimulationTP.MaintSchedSimEndDateTime as rsh_eam_schedule_end preserving type ) AS MaintSchedSimEndDateTime,
  I_RSHMaintSchedSimulationTP.MaintSchedSimulationStartTime AS MaintSchedSimulationStartTime,
  I_RSHMaintSchedSimulationTP.MaintSchedSimulationEndTime AS MaintSchedSimulationEndTime,
  I_RSHMaintSchedSimulationTP.MaintSchedSimulationTimeZone AS MaintSchedSimulationTimeZone,
  MaintSchedSimlnDescription,
  MaintSchedSimlnLongText,
  cast ( CreatedByUser as rsh_eam_maint_sched_created_by preserving type ) AS CreatedByUser,
  _CreatedByUser.UserDescription AS CreatedByUserName,
  cast( CreationDateTime as rsh_eam_maint_sched_created_at preserving type ) AS CreationDateTime,
  cast ( LastChangedByUser as rsh_eam_maint_sched_changed_by preserving type ) AS LastChangedByUser,
  _ChangedByUser.UserDescription AS LastChangedByUserName,
  cast( LastChangeDateTime as rsh_eam_maint_sched_changed_at preserving type ) AS LastChangeDateTime,
  SimulationSessionState,
  cast( SessionStateLastChangeDateTime as rsh_eam_maint_sched_st_chgd_at preserving type ) AS SessionStateLastChangeDateTime,
  cast ( MaintOrdSchedExecutionStatus as rsh_eam_track_exec_status_int preserving type ) AS MaintOrdSchedExecutionStatus,
  cast ( _ExecutionStatusTxt.MaintOrdSchedExecutionStatTxt as rsh_eam_track_exec_status_text preserving type ) AS MaintOrdSchedExecutionStatTxt,
  cast( coalesce(MaintSchedCollaboratorType, 'P') as rsh_eam_mnt_schd_my_role preserving type ) AS MaintSchedCollaboratorType,
  cast( ' ' as rsh_eam_mnt_schd_my_role_text preserving type ) AS MaintSchedCollaboratorTypeText
FROM I_RSHMaintSchedSimulationTP
INNER JOIN P_RSHMaintSchedExecutionStatus AS ExecutionStatus ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_RSHMaintSchedExecStatusTxt AS _ExecutionStatusTxt ON _ExecutionStatusTxt.MaintOrdSchedExecutionStatus = MaintOrdSchedExecutionStatus  -- association [0..1]
LEFT OUTER JOIN C_RSHMaintSchedCollabtrTypeTxt AS _CollaboratorTypeTxt ON _CollaboratorTypeTxt.MaintSchedCollaboratorType = MaintSchedCollaboratorType  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON _CreatedByUser.UserID = I_RSHMaintSchedSimulationTP.CreatedByUser  -- association [0..1]
LEFT OUTER JOIN I_User AS _ChangedByUser ON _ChangedByUser.UserID = I_RSHMaintSchedSimulationTP.LastChangedByUser  -- association [0..1]
;