I_QltyNotificationTask

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_QltyNotificationTask.
-- 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: IQNOTIFTSK

CREATE VIEW I_QltyNotificationTask AS
SELECT
  I_NotificationTask.Notification AS QualityNotification,
  I_NotificationTask.NotificationTask AS NotificationTask,
  case when ( I_NotificationTask.Notification like '$%' ) then substring(I_NotificationTask.Notification,2,11) else concat(I_NotificationTask.Notification,I_NotificationTask.NotificationTask) end as QualityTask AS NotificationTaskendasQualityTask,
  I_NotificationTask.QualityTaskOrigin AS QualityTaskOrigin,
  I_NotificationTask.NotificationTaskText AS NotificationTaskText,
  I_NotificationTask.IsDeleted AS IsDeleted,
  I_QltyNotification.NotifProcessingPhase AS NotifProcessingPhase,
  I_NotificationTask.NotifTaskPlannedStartDate AS NotifTaskPlannedStartDate,
  I_NotificationTask.NotifTaskPlannedStartTime AS NotifTaskPlannedStartTime,
  I_NotificationTask.NotifTaskPlannedEndDate AS NotifTaskPlannedEndDate,
  I_NotificationTask.NotifTaskPlannedEndTime AS NotifTaskPlannedEndTime,
  I_NotificationTask.StatusObject AS StatusObject,
  I_NotificationTask.NotifTaskTimeZone AS NotifTaskTimeZone,
  I_NotificationTask.NotifTaskCompletedByUser AS NotifTaskCompletedByUser,
  I_NotificationTask.NotifTaskCompletionDate AS NotifTaskCompletionDate,
  I_NotificationTask.NotifTaskCompletionTime AS NotifTaskCompletionTime,
  I_NotificationTask.NotifTaskResubmissionDate AS NotifTaskResubmissionDate,
  I_NotificationTask.NotifTaskResubmissionTime AS NotifTaskResubmissionTime,
  cast(I_NotificationTask.ResponsiblePersonFunctionCode as qmsm_parvw preserving type ) AS ResponsiblePersonFunctionCode,
  I_NotificationTask.ResponsiblePerson AS ResponsiblePerson,
  I_NotificationTask.NotificationTaskSortNumber AS NotificationTaskSortNumber,
  I_NotificationTask.NotificationItem AS NotificationItem,
  I_NotificationTask.NotificationCauseID AS NotificationCauseID,
  I_QltyNotification.NotificationType AS NotificationType,
  I_QltyNotification.Plant AS Plant,
  I_QltyNotification.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  cast( I_NotificationTask.NotificationTaskCatalog as vdm_qn_makat preserving type ) AS QualityTaskCodeCatalog,
  cast( I_NotificationTask.NotificationTaskCodeGroup as vdm_qn_magrp preserving type ) AS QualityTaskCodeGroup,
  I_NotificationTask.NotificationTaskCode AS QualityTaskCode,
  I_NotificationTask.QltyTaskTimeBasedEffort AS QltyTaskTimeBasedEffort,
  I_NotificationTask.QltyTaskTimeBasedEffortUoM AS QltyTaskTimeBasedEffortUoM,
  I_NotificationTask.ChangedDateTime AS ChangedDateTime,
  I_NotificationTask.CreatedByUser AS CreatedByUser,
  I_NotificationTask.CreationDate AS CreationDate,
  I_NotificationTask.CreationTime AS CreationTime,
  I_NotificationTask.LastChangedByUser AS LastChangedByUser,
  I_NotificationTask.LastChangeDate AS LastChangeDate,
  I_NotificationTask.LastChangeTime AS LastChangeTime,
  I_NotificationTask._QualityTaskOrigin AS _QualityTaskOrigin,
  I_QltyNotification._Plant AS _Plant,
  I_NotificationTask._CreatedByUserContactCard AS _CreatedByUserContactCard,
  I_NotificationTask._LastChangedByUserContactCard AS _LastChangedByUserContactCard,
  I_NotificationTask._PartnerFunction AS _PartnerFunction,
  I_NotificationTask._ContactPerson AS _ContactPerson,
  I_NotificationTask._Employee AS _Employee,
  I_NotificationTask._Customer AS _Customer,
  I_NotificationTask._Supplier AS _Supplier
FROM I_NotificationTask
INNER JOIN I_QltyNotification ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_QltyNotification AS _Notification ON QualityNotification = _Notification.QualityNotification  -- association [0..1]
LEFT OUTER JOIN I_QltyTskCodeGroup AS _QltyTskCodeGroup ON QualityTaskCodeGroup = _QltyTskCodeGroup.QualityTaskCodeGroup  -- association [0..1]
LEFT OUTER JOIN I_QltyTskCode AS _QltyTskCode ON QualityTaskCodeGroup = _QltyTskCode.QualityTaskCodeGroup AND QualityTaskCode = _QltyTskCode.QualityTaskCode  -- association [0..1]
LEFT OUTER JOIN I_QltyNotificationTaskLongText AS _QltyNotificationTaskLongText ON QualityNotification = _QltyNotificationTaskLongText.QualityNotification AND NotificationTask = _QltyNotificationTaskLongText.NotificationTask  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasure AS _QltyTskProcTimeUnit ON QltyTaskTimeBasedEffortUoM = _QltyTskProcTimeUnit.UnitOfMeasure AND _QltyTskProcTimeUnit.UnitOfMeasureDimension = 'TIME'  -- association [0..1]
LEFT OUTER JOIN E_NotificationTask AS _Extension ON QualityNotification = _Extension.Notification AND NotificationTask = _Extension.NotificationTask  -- association [1..1]
;