I_QltyNotificationTaskVH

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_QltyNotificationTaskVH.
-- 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: IQNOTIFTSKVH

CREATE VIEW I_QltyNotificationTaskVH 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.NotifTaskPlannedEndDate AS NotifTaskPlannedEndDate,
  I_NotificationTask.NotifTaskPlannedEndTime AS NotifTaskPlannedEndTime,
  I_NotificationTask.NotifTaskTimeZone AS NotifTaskTimeZone,
  I_NotificationTask.NotifTaskCompletionDate AS NotifTaskCompletionDate,
  I_NotificationTask.NotifTaskCompletionTime AS NotifTaskCompletionTime,
  I_NotificationTask.NotifTaskResubmissionDate AS NotifTaskResubmissionDate,
  I_NotificationTask.NotifTaskResubmissionTime AS NotifTaskResubmissionTime,
  I_NotificationTask.ResponsiblePersonFunctionCode AS ResponsiblePersonFunctionCode,
  I_NotificationTask.ResponsiblePerson AS ResponsiblePerson,
  I_NotificationTask.NotificationItem AS NotificationItem,
  I_NotificationTask.CreationDate AS CreationDate,
  I_QltyNotification.NotificationType AS NotificationType,
  I_QltyNotification.Plant AS Plant,
  I_QltyNotification.NotificationOrigin AS NotificationOrigin,
  I_QltyNotification.Supplier AS Supplier,
  I_QltyNotification.Customer AS Customer,
  I_QltyNotification.NotificationText AS NotificationText,
  I_QltyNotification.CreatedByUser AS CreatedByUser,
  I_QltyNotification.NotificationCompletionDate AS NotificationCompletionDate,
  I_QltyNotification.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  I_NotificationTask._Notification AS _Notification,
  I_NotificationTask._QualityTaskOrigin AS _QualityTaskOrigin,
  I_NotificationTask._PartnerFunction AS _PartnerFunction,
  I_QltyNotification._Plant AS _Plant,
  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 */
;