I_QUALITYNOTIFICATIONITEM

CDS View
43 Fields 4 CDS Views

Quality Notification Item

I_QUALITYNOTIFICATIONITEM is a CDS View in S/4HANA. Quality Notification Item. It contains 43 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_QltyNotificationItemFDP view from CONSUMPTION Item Data of Quality Notification
ESH_N_QUALITYNOTIFITEM view from
I_QualityNotificationItem_TP view from TRANSACTIONAL Quality Notification Item
R_QualityNotificationItemTP view_entity from TRANSACTIONAL Quality Notification Item

Fields (43)

KeyField CDS FieldsUsed in Views
KEY NotificationItem NotificationItem 2
KEY QualityNotification QualityNotification 2
_DefectCode _DefectCode 1
_DefectCodeCatalog _DefectCodeCatalog 1
_DefectCodeGroup _DefectCodeGroup 1
_Notification _Notification 2
_NotifItmObjectPartCode _NotifItmObjectPartCode 1
_NotifItmObjectPartCodeCtlg _NotifItmObjectPartCodeCtlg 1
_NotifItmObjectPartCodeGroup _NotifItmObjectPartCodeGroup 1
_QltyNotification _QltyNotification 1
Assembly Assembly 1
ChangedDateTime ChangedDateTime 1
CreatedByUser CreatedByUser 2
CreationDate CreationDate 2
CreationTime CreationTime 2
DefectClass DefectClass 1
DefectCode DefectCode 2
DefectCodeCatalog DefectCodeCatalog 2
DefectCodeGroup DefectCodeGroup 2
DefectiveQuantityUnit DefectiveQuantityUnit 1
DefectiveSingleUnit DefectiveSingleUnit 1
DefectOrigin DefectOrigin 1
ExternalDefectiveQuantity ExternalDefectiveQuantity 1
InspectionCharacteristic InspectionCharacteristic 1
InspectionSubsetInternalID InspectionSubsetInternalID 1
InspPlanOperationInternalID InspPlanOperationInternalID 1
InternalDefectiveQuantity InternalDefectiveQuantity 1
IsDeleted IsDeleted 2
LastChangeDate LastChangeDate 2
LastChangedByUser LastChangedByUser 2
LastChangeTime LastChangeTime 2
MainWorkCenter MainWorkCenter 1
MainWorkCenterInternalID MainWorkCenterInternalID 1
MainWorkCenterPlant MainWorkCenterPlant 1
MaterialSample MaterialSample 1
NotificationItemExternalID NotificationItemExternalID 1
NotificationItemText NotificationItemText 2
NotifItmObjectPartCode NotifItmObjectPartCode 2
NotifItmObjectPartCodeCtlg NotifItmObjectPartCodeCtlg 2
NotifItmObjectPartCodeGroup NotifItmObjectPartCodeGroup 2
NumberOfDefects NumberOfDefects 1
ReferencedDefect ReferencedDefect 2
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.

-- Quality Notification Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_QUALITYNOTIFICATIONITEM (
    NOTIFICATIONITEM,
    QUALITYNOTIFICATION,
    _DEFECTCODE,
    _DEFECTCODECATALOG,
    _DEFECTCODEGROUP,
    _NOTIFICATION,
    _NOTIFITMOBJECTPARTCODE,
    _NOTIFITMOBJECTPARTCODECTLG,
    _NOTIFITMOBJECTPARTCODEGROUP,
    _QLTYNOTIFICATION,
    ASSEMBLY,
    CHANGEDDATETIME,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    DEFECTCLASS,
    DEFECTCODE,
    DEFECTCODECATALOG,
    DEFECTCODEGROUP,
    DEFECTIVEQUANTITYUNIT,
    DEFECTIVESINGLEUNIT,
    DEFECTORIGIN,
    EXTERNALDEFECTIVEQUANTITY,
    INSPECTIONCHARACTERISTIC,
    INSPECTIONSUBSETINTERNALID,
    INSPPLANOPERATIONINTERNALID,
    INTERNALDEFECTIVEQUANTITY,
    ISDELETED,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    LASTCHANGETIME,
    MAINWORKCENTER,
    MAINWORKCENTERINTERNALID,
    MAINWORKCENTERPLANT,
    MATERIALSAMPLE,
    NOTIFICATIONITEMEXTERNALID,
    NOTIFICATIONITEMTEXT,
    NOTIFITMOBJECTPARTCODE,
    NOTIFITMOBJECTPARTCODECTLG,
    NOTIFITMOBJECTPARTCODEGROUP,
    NUMBEROFDEFECTS,
    REFERENCEDDEFECT,
    WORKCENTERTYPECODE,
    PRIMARY KEY (NOTIFICATIONITEM, QUALITYNOTIFICATION)
);

Learn More