I_NOTIFICATIONITEM

CDS View
75 Fields 12 CDS Views

Notification Item

I_NOTIFICATIONITEM is a CDS View in S/4HANA. Notification Item. It contains 75 fields. 12 CDS views read from this table.

CDS Views using this table (12)

ViewTypeJoinVDMDescription
I_Defect view from COMPOSITE Defect
I_DefectUnion view union COMPOSITE Defects and Quality Notification Items
I_InspLotCharcNumberOfDefects view_entity from COMPOSITE Number of Defects for Inspection Charc
I_QualityDefectUnion view from COMPOSITE Quality Defect with Independent Defect
I_QualityNotificationItem view from COMPOSITE Quality Notification Item
P_MfgDefectHistory view from COMPOSITE
P_MfgOrderDefectAll view_entity from COMPOSITE Mfg. Notification and Defect Records
P_MfgOrderDefectAll view_entity inner COMPOSITE Mfg. Notification and Defect Records
P_MfgOrderDefectAll view_entity union_all COMPOSITE Mfg. Notification and Defect Records
P_MfgOrderDefectRecord view from COMPOSITE
P_MfgOrderDefectRecord view inner COMPOSITE
P_MfgOrderDefectRecord view union_all COMPOSITE

Fields (75)

KeyField CDS FieldsUsed in Views
KEY Notification DefectInternalID,Notification,QualityNotification 6
KEY NotificationItem NotificationItem,QualityNotificationItem 6
_Assembly _Assembly 1
_CatalogProfile _CatalogProfile 1
_CreatedByUserContactCard _CreatedByUserContactCard 3
_DefectCategory _DefectCategory 3
_DefectClass _DefectClass 1
_DefectCode _DefectCode 1
_DefectCodeCatalog _DefectCodeCatalog 4
_DefectCodeGroup _DefectCodeGroup 1
_DefectiveQtyUnitOfMeasure _DefectiveQtyUnitOfMeasure 1
_DefectiveQuantityUnit _DefectiveQuantityUnit 2
_InspectionLot _InspectionLot 1
_LastChangedByUserContactCard _LastChangedByUserContactCard 3
_Notification _Notification 2
_NotifItmObjectPartCode _NotifItmObjectPartCode 2
_NotifItmObjectPartCodeCtlg _NotifItmObjectPartCodeCtlg 2
_NotifItmObjectPartCodeGroup _NotifItmObjectPartCodeGroup 2
_ProducedMaterial _ProducedMaterial 1
Assembly Assembly 1
Batch Batch 2
BOMItemInstanceUUID BOMItemInstanceUUID 1
CatalogProfile CatalogProfile 1
ChangedDateTime ChangedDateTime 5
CreatedByUser CreatedByUser 6
CreationDate CreationDate 6
DefectCategory DefectCategory 5
DefectCauseCodeVersion DefectCauseCodeVersion 1
DefectClass DefectClass 2
DefectCodeCatalog DefectCodeCatalog 4
DefectCodeVersion DefectCodeVersion 1
DefectIsCreatedAutomatically DefectIsCreatedAutomatically 2
DefectiveQuantity DefectiveQuantity 4
DefectiveQuantityUnit DefectiveQuantityUnit 4
DefectiveSingleUnit DefectiveSingleUnit 4
DefectLifecycleStatus DefectLifecycleStatus 1
DefectOrigin DefectOrigin 3
Equipment Equipment 2
EWMWarehouse Warehouse 1
ExternalDefectiveQuantity ExternalDefectiveQuantity 1
FunctionalLocation FunctionalLocation 1
InspectionCharacteristic InspectionCharacteristic 6
InspectionLot InspectionLot 2
InspectionSubsetInternalID InspectionSubsetInternalID 5
InspPlanOperationInternalID InspPlanOperationInternalID 6
InternalDefectiveQuantity InternalDefectiveQuantity 1
IsDeleted IsDeleted 3
LastChangeDate LastChangeDate 6
LastChangedByUser LastChangedByUser 6
MainWorkCenter MainWorkCenter 5
MainWorkCenterInternalID MainWorkCenterInternalID,WorkCenterInternalID 4
MainWorkCenterPlant MainWorkCenterPlant 5
MasterLanguage MasterLanguage 1
Material Material 1
MaterialSample MaterialSample 2
NotificationItemText NotificationItemText 3
NotifItmObjectPartCode NotifItmObjectPartCode 1
NotifItmObjectPartCodeCtlg NotifItmObjectPartCodeCtlg 1
NotifItmObjectPartCodeGroup NotifItmObjectPartCodeGroup 1
NotifItmObjectPartVersion DefectObjectCodeVersion 1
NumberOfDefects NumberOfDefects 3
OrderInternalID OrderInternalID 3
Plant Plant 3
ProducedMaterial ProducedMaterial 2
ProducedSerialNumber ProducedSerialNumber 2
ProductionOrder ProductionOrder 1
ProductionOrderOpActyVers ProductionOrderOpActyVers 3
ProductionOrderOperationActy ProductionOrderOperationActy 3
ProductionSupplyArea ProductionSupplyArea 1
ReferencedDefect ReferencedDefect 2
SourceStorageBin SourceStorageBin 1
SourceStorageType StorageType 1
StorageLocation StorageLocation 2
WarehouseLogicalSystem WarehouseLogicalSystem 2
WorkCenterTypeCode WorkCenterTypeCode 4

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.

-- Notification Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_NOTIFICATIONITEM (
    NOTIFICATION,
    NOTIFICATIONITEM,
    _ASSEMBLY,
    _CATALOGPROFILE,
    _CREATEDBYUSERCONTACTCARD,
    _DEFECTCATEGORY,
    _DEFECTCLASS,
    _DEFECTCODE,
    _DEFECTCODECATALOG,
    _DEFECTCODEGROUP,
    _DEFECTIVEQTYUNITOFMEASURE,
    _DEFECTIVEQUANTITYUNIT,
    _INSPECTIONLOT,
    _LASTCHANGEDBYUSERCONTACTCARD,
    _NOTIFICATION,
    _NOTIFITMOBJECTPARTCODE,
    _NOTIFITMOBJECTPARTCODECTLG,
    _NOTIFITMOBJECTPARTCODEGROUP,
    _PRODUCEDMATERIAL,
    ASSEMBLY,
    BATCH,
    BOMITEMINSTANCEUUID,
    CATALOGPROFILE,
    CHANGEDDATETIME,
    CREATEDBYUSER,
    CREATIONDATE,
    DEFECTCATEGORY,
    DEFECTCAUSECODEVERSION,
    DEFECTCLASS,
    DEFECTCODECATALOG,
    DEFECTCODEVERSION,
    DEFECTISCREATEDAUTOMATICALLY,
    DEFECTIVEQUANTITY,
    DEFECTIVEQUANTITYUNIT,
    DEFECTIVESINGLEUNIT,
    DEFECTLIFECYCLESTATUS,
    DEFECTORIGIN,
    EQUIPMENT,
    EWMWAREHOUSE,
    EXTERNALDEFECTIVEQUANTITY,
    FUNCTIONALLOCATION,
    INSPECTIONCHARACTERISTIC,
    INSPECTIONLOT,
    INSPECTIONSUBSETINTERNALID,
    INSPPLANOPERATIONINTERNALID,
    INTERNALDEFECTIVEQUANTITY,
    ISDELETED,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    MAINWORKCENTER,
    MAINWORKCENTERINTERNALID,
    MAINWORKCENTERPLANT,
    MASTERLANGUAGE,
    MATERIAL,
    MATERIALSAMPLE,
    NOTIFICATIONITEMTEXT,
    NOTIFITMOBJECTPARTCODE,
    NOTIFITMOBJECTPARTCODECTLG,
    NOTIFITMOBJECTPARTCODEGROUP,
    NOTIFITMOBJECTPARTVERSION,
    NUMBEROFDEFECTS,
    ORDERINTERNALID,
    PLANT,
    PRODUCEDMATERIAL,
    PRODUCEDSERIALNUMBER,
    PRODUCTIONORDER,
    PRODUCTIONORDEROPACTYVERS,
    PRODUCTIONORDEROPERATIONACTY,
    PRODUCTIONSUPPLYAREA,
    REFERENCEDDEFECT,
    SOURCESTORAGEBIN,
    SOURCESTORAGETYPE,
    STORAGELOCATION,
    WAREHOUSELOGICALSYSTEM,
    WORKCENTERTYPECODE,
    PRIMARY KEY (NOTIFICATION, NOTIFICATIONITEM)
);

Learn More