_QLTYNOTIFICATION

_QLTYNOTIFICATION is an SAP database table in S/4HANA. It contains 47 fields.

Fields (47)

KeyField CDS FieldsUsed in Views
KEY QualityNotification QualityNotification 1
ActiveDivision ActiveDivision 1
Batch Batch 1
ChangedDateTime ChangedDateTime 1
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
Customer Customer 1
DistributionChannel DistributionChannel 1
InspectionLot InspectionLot 1
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 1
IsDeleted IsDeleted 1
LastChangedByUser LastChangedByUser 1
LastChangedDate LastChangedDate 1
MainWorkCenterInternalID MainWorkCenterInternalID 1
MainWorkCenterPlant MainWorkCenterPlant 1
MasterLanguage MasterLanguage 1
Material Material 1
MaterialDocument MaterialDocument 1
MaterialDocumentItem MaterialDocumentItem 1
MaterialDocumentYear MaterialDocumentYear 1
MaterialGroup MaterialGroup 1
NotificationCatalog NotificationCatalog 1
NotificationCodeGroup NotificationCodeGroup 1
NotificationCodeID NotificationCodeID 1
NotificationCompletionDate NotificationCompletionDate 1
NotificationOrigin NotificationOrigin 1
NotificationPriority NotificationPriority 1
NotificationPriorityType NotificationPriorityType 1
NotificationReportingDate NotificationReportingDate 1
NotificationRequiredEndDate NotificationRequiredEndDate 1
NotificationRequiredEndTime NotificationRequiredEndTime 1
NotificationRequiredStartDate NotificationRequiredStartDate 1
NotificationRequiredStartTime NotificationRequiredStartTime 1
NotificationStatusObject NotificationStatusObject 1
NotificationText NotificationText 1
NotificationTimeZone NotificationTimeZone 1
NotificationType NotificationType 1
NotifProcessingPhase NotifProcessingPhase 1
Plant Plant 1
PurchasingDocument PurchasingDocument 1
PurchasingDocumentItem PurchasingDocumentItem 1
PurchasingGroup PurchasingGroup 1
PurchasingOrganization PurchasingOrganization 1
SalesOrganization SalesOrganization 1
Supplier Supplier 1
WBSElementInternalID WBSElementInternalID 1
WorkCenterTypeCode WorkCenterTypeCode 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 _QLTYNOTIFICATION (
    QUALITYNOTIFICATION,
    ACTIVEDIVISION,
    BATCH,
    CHANGEDDATETIME,
    CREATEDBYUSER,
    CREATIONDATE,
    CUSTOMER,
    DISTRIBUTIONCHANNEL,
    INSPECTIONLOT,
    ISBUSINESSPURPOSECOMPLETED,
    ISDELETED,
    LASTCHANGEDBYUSER,
    LASTCHANGEDDATE,
    MAINWORKCENTERINTERNALID,
    MAINWORKCENTERPLANT,
    MASTERLANGUAGE,
    MATERIAL,
    MATERIALDOCUMENT,
    MATERIALDOCUMENTITEM,
    MATERIALDOCUMENTYEAR,
    MATERIALGROUP,
    NOTIFICATIONCATALOG,
    NOTIFICATIONCODEGROUP,
    NOTIFICATIONCODEID,
    NOTIFICATIONCOMPLETIONDATE,
    NOTIFICATIONORIGIN,
    NOTIFICATIONPRIORITY,
    NOTIFICATIONPRIORITYTYPE,
    NOTIFICATIONREPORTINGDATE,
    NOTIFICATIONREQUIREDENDDATE,
    NOTIFICATIONREQUIREDENDTIME,
    NOTIFICATIONREQUIREDSTARTDATE,
    NOTIFICATIONREQUIREDSTARTTIME,
    NOTIFICATIONSTATUSOBJECT,
    NOTIFICATIONTEXT,
    NOTIFICATIONTIMEZONE,
    NOTIFICATIONTYPE,
    NOTIFPROCESSINGPHASE,
    PLANT,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    SALESORGANIZATION,
    SUPPLIER,
    WBSELEMENTINTERNALID,
    WORKCENTERTYPECODE,
    PRIMARY KEY (QUALITYNOTIFICATION)
);