_QLTYNOTIFICATIONTASK

36 Fields

_QLTYNOTIFICATIONTASK is an SAP database table in S/4HANA. It contains 36 fields.

Fields (36)

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
PersonResponsible PersonResponsible 1
Plant Plant 1
QltyTaskTimeBasedEffort QltyTaskTimeBasedEffort 1
QltyTaskTimeBasedEffortUoM QltyTaskTimeBasedEffortUoM 1
QualityTaskCode QualityTaskCode 1
QualityTaskCodeCatalog QualityTaskCodeCatalog 1
QualityTaskCodeGroup QualityTaskCodeGroup 1
ResponsiblePersonFunctionCode ResponsiblePersonFunctionCode 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _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,
    PERSONRESPONSIBLE,
    PLANT,
    QLTYTASKTIMEBASEDEFFORT,
    QLTYTASKTIMEBASEDEFFORTUOM,
    QUALITYTASKCODE,
    QUALITYTASKCODECATALOG,
    QUALITYTASKCODEGROUP,
    RESPONSIBLEPERSONFUNCTIONCODE,
    STATUSOBJECT,
    PRIMARY KEY (NOTIFICATIONTASK, QUALITYNOTIFICATION)
);

Learn More