C_RSHMaintSchedActivityLog

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_RSHMaintSchedActivityLog.
-- 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: CRSHMNTSCHDACT

CREATE VIEW C_RSHMaintSchedActivityLog AS
SELECT
  MaintSchedActivityLogUUID,
  I_RSHMaintSchedActivityLogTP.MaintSchedSimlnUUID AS MaintSchedSimlnUUID,
  I_RSHMaintSchedActivityLogTP.MaintSchedSimlnOperationUUID AS MaintSchedSimlnOperationUUID,
  ReplyToActivityLogUUID,
  MaintSchedActivityLogType,
  MaintSchedActivityLogText,
  SystemMessageIdentification,
  SystemMessageNumber,
  SystemMessageVariable1,
  SystemMessageVariable2,
  SystemMessageVariable3,
  SystemMessageVariable4,
  CreatedByUser,
  _CreatedByUser.UserDescription AS CreatedByUserName,
  CreationDateTime,
  _ReplyCount.NumberOfMaintSchedActyReplies AS NumberOfMaintSchedActyReplies,
  _MessageUserLanguage.SystemMessageText AS MaintSchedActyLogInUserLangTxt,
  _MaintSchedSimulation.MaintSchedSimulationTimeZone AS MaintSchedSimulationTimeZone
FROM I_RSHMaintSchedActivityLogTP
LEFT OUTER JOIN C_RSHMaintSchedSimulation AS _MaintSchedSimulation ON _MaintSchedSimulation.MaintSchedSimlnUUID = MaintSchedSimlnUUID  -- association [1..1]
LEFT OUTER JOIN C_RSHMaintSchedSmltdOp AS _MaintSchedSmltdOp ON _MaintSchedSmltdOp.MaintSchedSimlnOperationUUID = MaintSchedSimlnOperationUUID  -- association [0..*]
LEFT OUTER JOIN I_User AS _CreatedByUser ON _CreatedByUser.UserID = CreatedByUser  -- association [0..1]
LEFT OUTER JOIN C_RSHMaintSchedActivityLog AS _Replies ON _Replies.ReplyToActivityLogUUID = MaintSchedActivityLogUUID  -- association [0..*]
LEFT OUTER JOIN P_RSHMaintSchedActyReplyCount AS _ReplyCount ON _ReplyCount.MaintSchedActivityLogUUID = MaintSchedActivityLogUUID  -- association [0..1]
LEFT OUTER JOIN I_RSHMaintSchedActyLogMsg AS _MessageUserLanguage ON _MessageUserLanguage.SystemMessageNumber = SystemMessageNumber AND _MessageUserLanguage.Language = $session.system_language  -- association [0..1]
;