I_QLTYNOTIFICATIONTASK

CDS View
38 Fields 2 CDS Views

Quality Notification Task

I_QLTYNOTIFICATIONTASK is a CDS View in S/4HANA. Quality Notification Task. It contains 38 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
ESH_N_QUALITYNOTIFTASK view from
R_QltyNotificationTaskTP view_entity from TRANSACTIONAL Quality Notification Task - TP

Fields (38)

KeyField CDS FieldsUsed in Views
KEY NotificationTask NotificationTask 1
KEY QualityNotification QualityNotification 1
_ContactPerson _ContactPerson 1
_Customer _Customer 1
_Employee _Employee 1
_PartnerFunction _PartnerFunction 1
_Supplier _Supplier 1
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
CreationTime CreationTime 1
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 1
IsDeleted IsDeleted 1
LastChangeDate LastChangeDate 1
LastChangedByUser LastChangedByUser 1
LastChangeTime LastChangeTime 1
NotificationCauseID NotificationCauseID 1
NotificationItem NotificationItem 1
NotificationTaskSortNumber NotificationTaskSortNumber 1
NotificationTaskText NotificationTaskText 1
NotificationType NotificationType 1
NotifTaskCompletedByUser NotifTaskCompletedByUser 1
NotifTaskCompletionDate NotifTaskCompletionDate 1
NotifTaskCompletionTime NotifTaskCompletionTime 1
NotifTaskPlannedEndDate NotifTaskPlannedEndDate 1
NotifTaskPlannedEndTime NotifTaskPlannedEndTime 1
NotifTaskPlannedStartDate NotifTaskPlannedStartDate 1
NotifTaskPlannedStartTime NotifTaskPlannedStartTime 1
NotifTaskResubmissionDate NotifTaskResubmissionDate 1
NotifTaskResubmissionTime NotifTaskResubmissionTime 1
NotifTaskTimeZone NotifTaskTimeZone 1
Plant Plant 1
QltyTaskTimeBasedEffort QltyTaskTimeBasedEffort 1
QltyTaskTimeBasedEffortUoM QltyTaskTimeBasedEffortUoM 1
QualityTaskCode QualityTaskCode 1
QualityTaskCodeCatalog QualityTaskCodeCatalog 1
QualityTaskCodeGroup QualityTaskCodeGroup 1
ResponsiblePerson PersonResponsible 1
StatusObject StatusObject 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Quality Notification Task
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_QLTYNOTIFICATIONTASK (
    NOTIFICATIONTASK,
    QUALITYNOTIFICATION,
    _CONTACTPERSON,
    _CUSTOMER,
    _EMPLOYEE,
    _PARTNERFUNCTION,
    _SUPPLIER,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    ISBUSINESSPURPOSECOMPLETED,
    ISDELETED,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    LASTCHANGETIME,
    NOTIFICATIONCAUSEID,
    NOTIFICATIONITEM,
    NOTIFICATIONTASKSORTNUMBER,
    NOTIFICATIONTASKTEXT,
    NOTIFICATIONTYPE,
    NOTIFTASKCOMPLETEDBYUSER,
    NOTIFTASKCOMPLETIONDATE,
    NOTIFTASKCOMPLETIONTIME,
    NOTIFTASKPLANNEDENDDATE,
    NOTIFTASKPLANNEDENDTIME,
    NOTIFTASKPLANNEDSTARTDATE,
    NOTIFTASKPLANNEDSTARTTIME,
    NOTIFTASKRESUBMISSIONDATE,
    NOTIFTASKRESUBMISSIONTIME,
    NOTIFTASKTIMEZONE,
    PLANT,
    QLTYTASKTIMEBASEDEFFORT,
    QLTYTASKTIMEBASEDEFFORTUOM,
    QUALITYTASKCODE,
    QUALITYTASKCODECATALOG,
    QUALITYTASKCODEGROUP,
    RESPONSIBLEPERSON,
    STATUSOBJECT,
    PRIMARY KEY (NOTIFICATIONTASK, QUALITYNOTIFICATION)
);

Learn More