I_NotificationCause

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_NotificationCause.
-- 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: INOTIFCAUSE

CREATE VIEW I_NotificationCause AS
SELECT
  qmur.qmnum AS Notification,
  qmur.fenum AS NotificationItem,
  qmur.urnum AS NotificationCauseID,
  qmur.qurnum AS NotificationCauseSortNumber,
  qmur.ernam AS CreatedByUser,
  qmur.erdat AS CreationDate,
  qmur.erzeit AS CreationTime,
  qmur.aenam AS LastChangedByUser,
  qmur.aedat AS LastChangeDate,
  qmur.aezeit AS LastChangeTime,
  qmur.urtxt AS NotificationCauseText,
  qmur.urkat AS NotificationCauseCodeCatalog,
  qmur.urgrp AS NotificationCauseCodeGroup,
  qmur.urcod AS NotificationCauseCode,
  cast(qmur.kzmla as vdm_j_masterlanguage ) AS MasterLanguage,
  qmur.kzloesch AS IsDeleted,
  cast( qmur.rootcause as vdm_notificationrootcause preserving type ) AS NotificationRootCause,
  _Notification.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted
FROM qmur
LEFT OUTER JOIN I_Notification AS _Notification ON Notification = _Notification.Notification  -- association [1..1]
LEFT OUTER JOIN I_NotificationItem AS _NotificationItem ON Notification = _NotificationItem.Notification AND NotificationItem = _NotificationItem.NotificationItem  -- association [1..1]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUserContactCard ON CreatedByUser = _CreatedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _LastChangedByUserContactCard ON LastChangedByUser = _LastChangedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_NotifCauseCodeCatalog AS _NotifCauseCodeCatalog ON NotificationCauseCodeCatalog = _NotifCauseCodeCatalog.NotificationCauseCodeCatalog  -- association [0..1]
LEFT OUTER JOIN I_NotifCauseCodeGroup AS _NotifCauseCodeGroup ON NotificationCauseCodeCatalog = _NotifCauseCodeGroup.NotificationCauseCodeCatalog AND NotificationCauseCodeGroup = _NotifCauseCodeGroup.NotificationCauseCodeGroup  -- association [0..1]
LEFT OUTER JOIN I_NotifCauseCode AS _NotifCauseCode ON NotificationCauseCodeCatalog = _NotifCauseCode.NotificationCauseCodeCatalog AND NotificationCauseCodeGroup = _NotifCauseCode.NotificationCauseCodeGroup AND NotificationCauseCode = _NotifCauseCode.NotificationCauseCode  -- association [0..1]
LEFT OUTER JOIN I_NotificationRootCause AS _NotificationRootCause ON NotificationRootCause = _NotificationRootCause.NotificationRootCause  -- association [0..1]
LEFT OUTER JOIN E_NotificationCause AS _Extension ON Notification = _Extension.Notification AND NotificationItem = _Extension.NotificationItem AND NotificationCauseID = _Extension.NotificationCauseID  -- association [1..1]
;