I_NotificationTask

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_NotificationTask.
-- 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: INOTIFTSK

CREATE VIEW I_NotificationTask AS
SELECT
  qmsm.qmnum AS Notification,
  qmsm.manum AS NotificationTask,
  qmsm.taskorigin AS QualityTaskOrigin,
  qmsm.tasktype AS QualityTaskType,
  qmsm.processor AS QualityTaskProcessor,
  qmsm.matxt AS NotificationTaskText,
  qmsm.kzloesch AS IsDeleted,
  qmsm.pster AS NotifTaskPlannedStartDate,
  qmsm.pstur AS NotifTaskPlannedStartTime,
  qmsm.peter AS NotifTaskPlannedEndDate,
  qmsm.objnr AS StatusObject,
  qmsm.petur AS NotifTaskPlannedEndTime,
  qmsm.tzonsm AS NotifTaskTimeZone,
  qmsm.erlnam AS NotifTaskCompletedByUser,
  qmsm.erldat AS NotifTaskCompletionDate,
  qmsm.erlzeit AS NotifTaskCompletionTime,
  qmsm.wdvdat AS NotifTaskResubmissionDate,
  qmsm.wdvzeit AS NotifTaskResubmissionTime,
  cast(qmsm.parvw as vdm_q_parvw_vera preserving type ) AS ResponsiblePersonFunctionCode,
  qmsm.parnr AS ResponsiblePerson,
  qmsm.qsmnum AS NotificationTaskSortNumber,
  qmsm.fenum AS NotificationItem,
  qmsm.urnum AS NotificationCauseID,
  qmsm.mnkat AS NotificationTaskCatalog,
  qmsm.mngrp AS NotificationTaskCodeGroup,
  qmsm.mncod AS NotificationTaskCode,
  qmsm.folgeact AS QltyTaskFollowUpAction,
  qmsm.statfoa AS QltyTaskFllwUpActionSts,
  qmsm.timebasedeffort AS QltyTaskTimeBasedEffort,
  qmsm.timebasedeffortuom AS QltyTaskTimeBasedEffortUoM,
  case qmsm.changeddatetime when 0 then cast( '19000101010101' as tzntstmps ) else qmsm.changeddatetime end as ChangedDateTime AS changeddatetimeendasChangedDateTime,
  qmsm.ernam AS CreatedByUser,
  qmsm.erdat AS CreationDate,
  qmsm.erzeit AS CreationTime,
  qmsm.aenam AS LastChangedByUser,
  qmsm.aedat AS LastChangeDate,
  qmsm.aezeit AS LastChangeTime
FROM qmsm
LEFT OUTER JOIN I_Notification AS _Notification ON Notification = _Notification.Notification  -- association [0..1]
LEFT OUTER JOIN I_NotifTaskFllwUpActionParam AS _NotifTaskFllwUpActionParam ON Notification = _NotifTaskFllwUpActionParam.Notification AND NotificationTask = _NotifTaskFllwUpActionParam.NotificationTask  -- association [0..*]
LEFT OUTER JOIN I_QltyTaskOrigin AS _QualityTaskOrigin ON QualityTaskOrigin = _QualityTaskOrigin.QualityTaskOrigin  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _QualityTaskProcessor ON QualityTaskProcessor = _QualityTaskProcessor.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_PartnerFunction AS _PartnerFunction ON ResponsiblePersonFunctionCode = _PartnerFunction.PartnerFunction  -- association [0..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_StsObjConcatActiveStsILL AS _StsObjConcatActiveStsILL ON StatusObject = _StsObjConcatActiveStsILL.StatusObject  -- association [0..1]
LEFT OUTER JOIN I_ContactPerson AS _ContactPerson ON _ContactPerson.ContactPerson = ResponsiblePerson  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON _Customer.Customer = ResponsiblePerson  -- association [0..1]
LEFT OUTER JOIN I_WorkforcePerson AS _Employee ON _Employee.PersonExternalID = ResponsiblePerson  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON _Supplier.Supplier = ResponsiblePerson  -- association [0..1]
;