I_QltyNotificationTaskTP

DDL: I_QLTYNOTIFICATIONTASKTP Type: view_entity TRANSACTIONAL Package: VDM_QM_NOTIFICATION
36 Fields 1 Data Sources

Quality Notification Task - TP

I_QltyNotificationTaskTP is a Transactional CDS View that provides data about "Quality Notification Task - TP" in SAP S/4HANA. It reads from 1 data source (R_QltyNotificationTaskTP) and exposes 36 fields with key fields QualityNotification, NotificationTask. Part of development package VDM_QM_NOTIFICATION.

Data Sources (1)

SourceAliasJoin Type
R_QltyNotificationTaskTP R_QltyNotificationTaskTP projection

Annotations (10)

NameValueLevelField
EndUserText.label Quality Notification Task - TP view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.representativeKey NotificationTask view
Metadata.ignorePropagatedAnnotations true view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY QualityNotification _QualityNotificationTask QualityNotification
KEY NotificationTask _QualityNotificationTask NotificationTask
NotificationTaskText _QualityNotificationTask NotificationTaskText
IsDeleted _QualityNotificationTask IsDeleted TRUE
NotifTaskPlannedStartDate _QualityNotificationTask NotifTaskPlannedStartDate
NotifTaskPlannedStartTime _QualityNotificationTask NotifTaskPlannedStartTime
NotifTaskPlannedEndDate _QualityNotificationTask NotifTaskPlannedEndDate
NotifTaskPlannedEndTime _QualityNotificationTask NotifTaskPlannedEndTime
StatusObject _QualityNotificationTask StatusObject Status Object
NotifTaskCompletedByUser _QualityNotificationTask NotifTaskCompletedByUser
NotifTaskCompletionDate _QualityNotificationTask NotifTaskCompletionDate
NotifTaskCompletionTime _QualityNotificationTask NotifTaskCompletionTime
ResponsiblePersonFunctionCode _QualityNotificationTask ResponsiblePersonFunctionCode
PersonResponsible _QualityNotificationTask PersonResponsible Person Responsible
NotificationTaskSortNumber _QualityNotificationTask NotificationTaskSortNumber
NotificationItem _QualityNotificationTask NotificationItem
NotificationCauseID _QualityNotificationTask NotificationCauseID
QualityTaskCodeCatalog _QualityNotificationTask QualityTaskCodeCatalog
QualityTaskCodeGroup _QualityNotificationTask QualityTaskCodeGroup
QualityTaskCode _QualityNotificationTask QualityTaskCode
QltyTaskTimeBasedEffort _QualityNotificationTask QltyTaskTimeBasedEffort
QltyTaskTimeBasedEffortUoM _QualityNotificationTask QltyTaskTimeBasedEffortUoM
CreatedByUser _QualityNotificationTask CreatedByUser User Name
CreationDate _QualityNotificationTask CreationDate Time Stamp
CreationTime _QualityNotificationTask CreationTime Time of Change
LastChangedByUser _QualityNotificationTask LastChangedByUser User Name
LastChangeDate _QualityNotificationTask LastChangeDate Time Stamp
LastChangeTime _QualityNotificationTask LastChangeTime Time changed
NotificationType _QualityNotificationTask NotificationType Notifictn Type
Plant _QualityNotificationTask Plant Valuation Area
IsBusinessPurposeCompleted _QualityNotificationTask IsBusinessPurposeCompleted Purpose Completed
_PartnerFunction _QualityNotificationTask _PartnerFunction
_ContactPerson _QualityNotificationTask _ContactPerson
_Employee _QualityNotificationTask _Employee
_Customer _QualityNotificationTask _Customer
_Supplier _QualityNotificationTask _Supplier

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_QltyNotificationTaskTP.
-- 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.

CREATE VIEW I_QltyNotificationTaskTP AS
SELECT
  _QualityNotificationTask.QualityNotification AS QualityNotification,
  _QualityNotificationTask.NotificationTask AS NotificationTask,
  _QualityNotificationTask.NotificationTaskText AS NotificationTaskText,
  _QualityNotificationTask.IsDeleted AS IsDeleted,
  _QualityNotificationTask.NotifTaskPlannedStartDate AS NotifTaskPlannedStartDate,
  _QualityNotificationTask.NotifTaskPlannedStartTime AS NotifTaskPlannedStartTime,
  _QualityNotificationTask.NotifTaskPlannedEndDate AS NotifTaskPlannedEndDate,
  _QualityNotificationTask.NotifTaskPlannedEndTime AS NotifTaskPlannedEndTime,
  _QualityNotificationTask.StatusObject AS StatusObject,
  _QualityNotificationTask.NotifTaskCompletedByUser AS NotifTaskCompletedByUser,
  _QualityNotificationTask.NotifTaskCompletionDate AS NotifTaskCompletionDate,
  _QualityNotificationTask.NotifTaskCompletionTime AS NotifTaskCompletionTime,
  _QualityNotificationTask.ResponsiblePersonFunctionCode AS ResponsiblePersonFunctionCode,
  _QualityNotificationTask.PersonResponsible AS PersonResponsible,
  _QualityNotificationTask.NotificationTaskSortNumber AS NotificationTaskSortNumber,
  _QualityNotificationTask.NotificationItem AS NotificationItem,
  _QualityNotificationTask.NotificationCauseID AS NotificationCauseID,
  _QualityNotificationTask.QualityTaskCodeCatalog AS QualityTaskCodeCatalog,
  _QualityNotificationTask.QualityTaskCodeGroup AS QualityTaskCodeGroup,
  _QualityNotificationTask.QualityTaskCode AS QualityTaskCode,
  _QualityNotificationTask.QltyTaskTimeBasedEffort AS QltyTaskTimeBasedEffort,
  _QualityNotificationTask.QltyTaskTimeBasedEffortUoM AS QltyTaskTimeBasedEffortUoM,
  _QualityNotificationTask.CreatedByUser AS CreatedByUser,
  _QualityNotificationTask.CreationDate AS CreationDate,
  _QualityNotificationTask.CreationTime AS CreationTime,
  _QualityNotificationTask.LastChangedByUser AS LastChangedByUser,
  _QualityNotificationTask.LastChangeDate AS LastChangeDate,
  _QualityNotificationTask.LastChangeTime AS LastChangeTime,
  _QualityNotificationTask.NotificationType AS NotificationType,
  _QualityNotificationTask.Plant AS Plant,
  _QualityNotificationTask.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _QualityNotificationTask._PartnerFunction AS _PartnerFunction,
  _QualityNotificationTask._ContactPerson AS _ContactPerson,
  _QualityNotificationTask._Employee AS _Employee,
  _QualityNotificationTask._Customer AS _Customer,
  _QualityNotificationTask._Supplier AS _Supplier
FROM R_QltyNotificationTaskTP
;

Learn More