I_NOTIFICATIONITEM

CDS View
98 Fields 14 CDS Views

Notification Item

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

CDS Views using this table (14)

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_MfgOrderDefect view from COMPOSITE
P_MfgOrderDefect view inner COMPOSITE
P_MfgOrderDefect view union_all 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 union_all COMPOSITE
P_SFODefectOAInstceMigration view_entity from CONSUMPTION

Fields (98)

KeyField CDS FieldsUsed in Views
KEY DefectInternalID DefectInternalID 1
KEY Notification Notification,QualityNotification 8
KEY NotificationItem NotificationItem,QualityNotificationItem 8
_Assembly _Assembly 1
_CatalogProfile _CatalogProfile 1
_CreatedByUserContactCard _CreatedByUserContactCard 4
_DefectCategory _DefectCategory 4
_DefectClass _DefectClass 1
_DefectCode _DefectCode 2
_DefectCodeCatalog _DefectCodeCatalog 5
_DefectCodeGroup _DefectCodeGroup 2
_DefectiveQtyUnitOfMeasure _DefectiveQtyUnitOfMeasure 1
_DefectiveQuantityUnit _DefectiveQuantityUnit 2
_DefectStatus _DefectStatus 1
_InspectionLot _InspectionLot 1
_LastChangedByUserContactCard _LastChangedByUserContactCard 4
_Notification _Notification 3
_NotifItmObjectPartCode _NotifItmObjectPartCode 2
_NotifItmObjectPartCodeCtlg _NotifItmObjectPartCodeCtlg 2
_NotifItmObjectPartCodeGroup _NotifItmObjectPartCodeGroup 2
_NotifProcessingPhase _NotifProcessingPhase 1
_ProducedMaterial _ProducedMaterial 2
_WorkCenter _WorkCenter 1
Assembly Assembly 1
Batch Batch 3
BillOfMaterial BillOfMaterial 1
BillOfMaterialCategory BillOfMaterialCategory 3
BillOfMaterialInternalID BillOfMaterialInternalID 1
BillOfMaterialItemNodeNumber BillOfMaterialItemNodeNumber 3
BillOfMaterialVariant BillOfMaterialVariant 3
BOMItemInstanceUUID BOMItemInstanceUUID 3
BOMItemInternalChangeCount BOMItemInternalChangeCount 3
CatalogProfile CatalogProfile 1
ChangedDateTime ChangedDateTime 6
CreatedByUser CreatedByUser 7
CreationDate CreationDate 7
CreationTime CreationTime 1
Defect Defect 1
DefectCategory DefectCategory 7
DefectCauseCodeVersion DefectCauseCodeVersion 1
DefectClass DefectClass 2
DefectCode DefectCode 2
DefectCodeCatalog DefectCodeCatalog 6
DefectCodeGroup DefectCodeGroup 2
DefectCodeVersion DefectCodeVersion 1
DefectIsCreatedAutomatically DefectIsCreatedAutomatically 3
DefectiveQuantity DefectiveQuantity 5
DefectiveQuantityUnit DefectiveQuantityUnit 5
DefectiveSingleUnit DefectiveSingleUnit,SerialNumber 5
DefectLifecycleStatus DefectLifecycleStatus 2
DefectOrigin DefectOrigin 3
DefectText DefectText 1
Equipment Equipment 3
EWMWarehouse Warehouse 1
ExternalDefectiveQuantity ExternalDefectiveQuantity 1
FunctionalLocation FunctionalLocation 1
InspectionCharacteristic InspectionCharacteristic 7
InspectionLot InspectionLot 3
InspectionSubsetInternalID InspectionSubsetInternalID 6
InspPlanOperationInternalID InspPlanOperationInternalID 8
InternalDefectiveQuantity InternalDefectiveQuantity 1
IsDeleted IsDeleted 4
LastChangeDate LastChangeDate 7
LastChangedByUser LastChangedByUser 7
LastChangeTime LastChangeTime 1
MainWorkCenter MainWorkCenter 6
MainWorkCenterInternalID MainWorkCenterInternalID,WorkCenterInternalID 5
MainWorkCenterPlant MainWorkCenterPlant 6
MasterLanguage MasterLanguage 1
Material Material 3
MaterialSample MaterialSample 2
NotificationItemText NotificationItemText 3
NotificationText NotificationText 1
NotificationType NotificationType 1
NotifItmObjectPartCode NotifItmObjectPartCode 1
NotifItmObjectPartCodeCtlg NotifItmObjectPartCodeCtlg 1
NotifItmObjectPartCodeGroup NotifItmObjectPartCodeGroup 1
NotifItmObjectPartVersion DefectObjectCodeVersion 1
NotifProcessingPhase NotifProcessingPhase 1
NumberOfDefects NumberOfDefects 3
OpActyNtwkElement OpActyNtwkElement 5
OpActyNtwkInstance OpActyNtwkInstance 5
OrderInternalID OrderInternalID 4
Plant Plant 5
ProducedMaterial ProducedMaterial 4
ProducedSerialNumber ProducedSerialNumber 4
ProductionOrder ProductionOrder 2
ProductionOrderOpActyVers ProductionOrderOpActyVers 5
ProductionOrderOperationActy ProductionOrderOperationActy 5
ProductionSupplyArea ProductionSupplyArea 1
ReferencedDefect ReferencedDefect 2
ShopFloorItem ShopFloorItem 1
SourceStorageBin SourceStorageBin 1
SourceStorageType StorageType 1
StorageLocation StorageLocation 2
WarehouseLogicalSystem WarehouseLogicalSystem 2
WorkCenterInternalID WorkCenterInternalID 1
WorkCenterTypeCode WorkCenterTypeCode 5

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 (
    DEFECTINTERNALID,
    NOTIFICATION,
    NOTIFICATIONITEM,
    _ASSEMBLY,
    _CATALOGPROFILE,
    _CREATEDBYUSERCONTACTCARD,
    _DEFECTCATEGORY,
    _DEFECTCLASS,
    _DEFECTCODE,
    _DEFECTCODECATALOG,
    _DEFECTCODEGROUP,
    _DEFECTIVEQTYUNITOFMEASURE,
    _DEFECTIVEQUANTITYUNIT,
    _DEFECTSTATUS,
    _INSPECTIONLOT,
    _LASTCHANGEDBYUSERCONTACTCARD,
    _NOTIFICATION,
    _NOTIFITMOBJECTPARTCODE,
    _NOTIFITMOBJECTPARTCODECTLG,
    _NOTIFITMOBJECTPARTCODEGROUP,
    _NOTIFPROCESSINGPHASE,
    _PRODUCEDMATERIAL,
    _WORKCENTER,
    ASSEMBLY,
    BATCH,
    BILLOFMATERIAL,
    BILLOFMATERIALCATEGORY,
    BILLOFMATERIALINTERNALID,
    BILLOFMATERIALITEMNODENUMBER,
    BILLOFMATERIALVARIANT,
    BOMITEMINSTANCEUUID,
    BOMITEMINTERNALCHANGECOUNT,
    CATALOGPROFILE,
    CHANGEDDATETIME,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    DEFECT,
    DEFECTCATEGORY,
    DEFECTCAUSECODEVERSION,
    DEFECTCLASS,
    DEFECTCODE,
    DEFECTCODECATALOG,
    DEFECTCODEGROUP,
    DEFECTCODEVERSION,
    DEFECTISCREATEDAUTOMATICALLY,
    DEFECTIVEQUANTITY,
    DEFECTIVEQUANTITYUNIT,
    DEFECTIVESINGLEUNIT,
    DEFECTLIFECYCLESTATUS,
    DEFECTORIGIN,
    DEFECTTEXT,
    EQUIPMENT,
    EWMWAREHOUSE,
    EXTERNALDEFECTIVEQUANTITY,
    FUNCTIONALLOCATION,
    INSPECTIONCHARACTERISTIC,
    INSPECTIONLOT,
    INSPECTIONSUBSETINTERNALID,
    INSPPLANOPERATIONINTERNALID,
    INTERNALDEFECTIVEQUANTITY,
    ISDELETED,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    LASTCHANGETIME,
    MAINWORKCENTER,
    MAINWORKCENTERINTERNALID,
    MAINWORKCENTERPLANT,
    MASTERLANGUAGE,
    MATERIAL,
    MATERIALSAMPLE,
    NOTIFICATIONITEMTEXT,
    NOTIFICATIONTEXT,
    NOTIFICATIONTYPE,
    NOTIFITMOBJECTPARTCODE,
    NOTIFITMOBJECTPARTCODECTLG,
    NOTIFITMOBJECTPARTCODEGROUP,
    NOTIFITMOBJECTPARTVERSION,
    NOTIFPROCESSINGPHASE,
    NUMBEROFDEFECTS,
    OPACTYNTWKELEMENT,
    OPACTYNTWKINSTANCE,
    ORDERINTERNALID,
    PLANT,
    PRODUCEDMATERIAL,
    PRODUCEDSERIALNUMBER,
    PRODUCTIONORDER,
    PRODUCTIONORDEROPACTYVERS,
    PRODUCTIONORDEROPERATIONACTY,
    PRODUCTIONSUPPLYAREA,
    REFERENCEDDEFECT,
    SHOPFLOORITEM,
    SOURCESTORAGEBIN,
    SOURCESTORAGETYPE,
    STORAGELOCATION,
    WAREHOUSELOGICALSYSTEM,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    PRIMARY KEY (DEFECTINTERNALID, NOTIFICATION, NOTIFICATIONITEM)
);

Learn More