I_NotifTaskTimeStamps

DDL: I_NOTIFTASKTIMESTAMPS Type: view_entity COMPOSITE Package: VDM_QM_NOTIFICATION
14 Fields 2 Data Sources

Notification Task Time Stamps

I_NotifTaskTimeStamps is a Composite CDS View that provides data about "Notification Task Time Stamps" in SAP S/4HANA. It reads from 2 data sources (I_QltyMgmtSystAndUsrTmeZn, I_NotificationTask) and exposes 14 fields with key fields Notification, NotificationTask. Part of development package VDM_QM_NOTIFICATION.

Data Sources (2)

SourceAliasJoin Type
I_QltyMgmtSystAndUsrTmeZn _QltyMgmtSystAndUsrTmeZn left_outer
I_NotificationTask I_NotificationTask from

Parameters (1)

NameTypeDefault
P_QltyTimeStampPrepOptn vdm_qltytimestampprepoptn

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
EndUserText.label Notification Task Time Stamps view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY Notification I_NotificationTask Notification Notification
KEY NotificationTask I_NotificationTask NotificationTask Task
QltyMgmtSystemTimeZone I_QltyMgmtSystAndUsrTmeZn QltyMgmtSystemTimeZone
QltyMgmtUserTimeZone I_QltyMgmtSystAndUsrTmeZn QltyMgmtUserTimeZone
NotifTaskPlannedEndDate I_NotificationTask NotifTaskPlannedEndDate Planned End
NotifTaskPlannedEndTime I_NotificationTask NotifTaskPlannedEndTime Time
NotifTaskCompletionDate I_NotificationTask NotifTaskCompletionDate Completed On
NotifTaskCompletionTime I_NotificationTask NotifTaskCompletionTime Completion Time
NotifTaskResubmissionDate I_NotificationTask NotifTaskResubmissionDate Resubmission
NotifTaskResubmissionTime I_NotificationTask NotifTaskResubmissionTime Resubmission Time
CreationDate I_NotificationTask CreationDate Time Stamp
CreationTime I_NotificationTask CreationTime Time of Change
LastChangeDate I_NotificationTask LastChangeDate Time Stamp
LastChangeTime I_NotificationTask LastChangeTime Time changed

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_NotifTaskTimeStamps.
-- 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.
-- Parameters: P_QltyTimeStampPrepOptn : vdm_qltytimestampprepoptn

CREATE VIEW I_NotifTaskTimeStamps AS
SELECT
  I_NotificationTask.Notification AS Notification,
  I_NotificationTask.NotificationTask AS NotificationTask,
  _QltyMgmtSystAndUsrTmeZn.QltyMgmtSystemTimeZone AS QltyMgmtSystemTimeZone,
  _QltyMgmtSystAndUsrTmeZn.QltyMgmtUserTimeZone AS QltyMgmtUserTimeZone,
  I_NotificationTask.NotifTaskPlannedEndDate AS NotifTaskPlannedEndDate,
  I_NotificationTask.NotifTaskPlannedEndTime AS NotifTaskPlannedEndTime,
  I_NotificationTask.NotifTaskCompletionDate AS NotifTaskCompletionDate,
  I_NotificationTask.NotifTaskCompletionTime AS NotifTaskCompletionTime,
  I_NotificationTask.NotifTaskResubmissionDate AS NotifTaskResubmissionDate,
  I_NotificationTask.NotifTaskResubmissionTime AS NotifTaskResubmissionTime,
  I_NotificationTask.CreationDate AS CreationDate,
  I_NotificationTask.CreationTime AS CreationTime,
  I_NotificationTask.LastChangeDate AS LastChangeDate,
  I_NotificationTask.LastChangeTime AS LastChangeTime
FROM I_NotificationTask
LEFT OUTER JOIN I_QltyMgmtSystAndUsrTmeZn AS _QltyMgmtSystAndUsrTmeZn ON /* join condition not captured in parsed metadata */
;

Learn More