_QUALITYNOTIFICATIONITEM

36 Fields

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

Fields (36)

KeyField CDS FieldsUsed in Views
KEY NotificationItem NotificationItem 2
KEY QualityNotification QualityNotification 2
_Notification _Notification 2
Assembly Assembly 2
CreatedByUser CreatedByUser 2
CreationDate CreationDate 2
CreationTime CreationTime 2
DefectClass DefectClass 2
DefectCode DefectCode 2
DefectCodeCatalog DefectCodeCatalog 2
DefectCodeGroup DefectCodeGroup 2
DefectiveQuantityUnit DefectiveQuantityUnit 2
DefectiveSingleUnit DefectiveSingleUnit 2
DefectOrigin DefectOrigin 2
ExternalDefectiveQuantity ExternalDefectiveQuantity 2
InspectionCharacteristic InspectionCharacteristic 2
InspectionSubsetInternalID InspectionSubsetInternalID 2
InspPlanOperationInternalID InspPlanOperationInternalID 2
InternalDefectiveQuantity InternalDefectiveQuantity 2
IsDeleted IsDeleted 2
LastChangeDate LastChangeDate 2
LastChangedByUser LastChangedByUser 2
LastChangeTime LastChangeTime 2
MainWorkCenter MainWorkCenter 2
MainWorkCenterInternalID MainWorkCenterInternalID 2
MainWorkCenterPlant MainWorkCenterPlant 2
MasterLanguage MasterLanguage 2
MaterialSample MaterialSample 2
NotificationItemExternalID NotificationItemExternalID 2
NotificationItemText NotificationItemText 2
NotifItmObjectPartCode NotifItmObjectPartCode 2
NotifItmObjectPartCodeCtlg NotifItmObjectPartCodeCtlg 2
NotifItmObjectPartCodeGroup NotifItmObjectPartCodeGroup 2
NumberOfDefects NumberOfDefects 2
ReferencedDefect ReferencedDefect 2
WorkCenterTypeCode WorkCenterTypeCode 2

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 _QUALITYNOTIFICATIONITEM (
    NOTIFICATIONITEM,
    QUALITYNOTIFICATION,
    _NOTIFICATION,
    ASSEMBLY,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    DEFECTCLASS,
    DEFECTCODE,
    DEFECTCODECATALOG,
    DEFECTCODEGROUP,
    DEFECTIVEQUANTITYUNIT,
    DEFECTIVESINGLEUNIT,
    DEFECTORIGIN,
    EXTERNALDEFECTIVEQUANTITY,
    INSPECTIONCHARACTERISTIC,
    INSPECTIONSUBSETINTERNALID,
    INSPPLANOPERATIONINTERNALID,
    INTERNALDEFECTIVEQUANTITY,
    ISDELETED,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    LASTCHANGETIME,
    MAINWORKCENTER,
    MAINWORKCENTERINTERNALID,
    MAINWORKCENTERPLANT,
    MASTERLANGUAGE,
    MATERIALSAMPLE,
    NOTIFICATIONITEMEXTERNALID,
    NOTIFICATIONITEMTEXT,
    NOTIFITMOBJECTPARTCODE,
    NOTIFITMOBJECTPARTCODECTLG,
    NOTIFITMOBJECTPARTCODEGROUP,
    NUMBEROFDEFECTS,
    REFERENCEDDEFECT,
    WORKCENTERTYPECODE,
    PRIMARY KEY (NOTIFICATIONITEM, QUALITYNOTIFICATION)
);

Learn More