I_ShiftNote

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_ShiftNote.
-- 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.

CREATE VIEW I_ShiftNote AS
SELECT
  cast(sn.Notification as cocf_sn_id preserving type) AS ShiftNoteID,
  sn.CreatedByUser AS CreatedByUser,
  sn.CreationDate AS CreationDate,
  sn.LastChangedByUser AS LastChangedByUser,
  sn.LastChangedDate AS LastChangedDate,
  sn.ChangedDateTime AS ChangedDateTime,
  sn.NotificationReportingDate AS ReportingDate,
  sn.ReportedByUser AS ReportedByUser,
  cast(sn.IsDeleted as aufloekz preserving type) AS ShiftNoteIsMarkedForDeletion,
  cast(sn.NotificationType as cocf_sn_sntype preserving type) AS ShiftNoteType,
  cast(sn.NotificationText as cocf_sn_sntext preserving type) AS ShiftNoteText,
  sn.NotificationCodeGroup AS NotificationCodeGroup,
  sn.ShiftNoteOrigin AS ShiftNoteOrigin,
  sn.ShiftNoteWorkCenterType AS ShiftNoteWorkCenterType,
  sn.ShiftNoteWorkCenterInternalID AS ShiftNoteWorkCenterInternalID,
  _WorkCenter.WorkCenter AS WorkCenter,
  _WorkCenter.Plant AS Plant,
  cast(sn.FunctionalLocation as ps_s4_tplnr preserving type) AS FunctionalLocation,
  sn.Equipment AS Equipment
FROM I_Notification AS sn
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [1..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _ReportedByUser ON ReportedByUser = _ReportedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_NotificationType AS _ShiftNoteType ON ShiftNoteType = _ShiftNoteType.NotificationType  -- association [1..1]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON ShiftNoteWorkCenterInternalID = _WorkCenter.WorkCenterInternalID AND ShiftNoteWorkCenterType = _WorkCenter.WorkCenterTypeCode  -- association [0..1]
LEFT OUTER JOIN I_ShiftNoteReferenceObject AS _ReferenceObject ON ShiftNoteID = _ReferenceObject.ShiftNoteID  -- association [0..1]
LEFT OUTER JOIN I_ShiftNoteDocumentLink AS _DocumentLink ON ShiftNoteID = _DocumentLink.ShiftNoteID  -- association [0..*]
;