I_NotificationItem

Notification Item | view: INOTIFITM | TRAN | Extraction: Not supported | Component: Quality Notifications
Tables used: QMFECRHD
Column Name Description
Notification FK Notification Number
NotificationItem Item Number in Item Record
Column Name Description
Column Name Description
📏 Unit of Measure for Item (DefectiveQuantityUnit):
DefectiveQuantity Defective Quantity for Item (Internal)
Column Name Description
CreationDate Date on which the record was created
LastChangeDate Last Changed On
CreationTime Time at Which Record Was Added
LastChangeTime Time of Change
NotifItmReportingDate Notification Item Reported On
NotifItmReportingTime Notification Item Reported At
Column Name Description
WorkCenterTypeCode Object types of the CIM resource Show values
DefectOrigin Origin of Item Record Show values
DefectLifecycleStatus Defect Status Show values
ProblemAnalysisStatus Problem Analysis Show values
DefectIsCreatedAutomatically Defect Created Automatically Show values
Column Name Description Domain name
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser Name of Person Who Changed Object USNAM
NotificationItemText Notification Item Short Text TEXT40
DefectCode Problem or Damage Code QCODE
DefectCodeVersion Version Number QVERSNR
NotifItmObjectPartCode Part of Object QCODE
NotifItmObjectPartVersion Version Number QVERSNR
DefectCauseCodeCatalog Catalog Type - Causes QKATART
DefectCauseCodeGroup Code Group - Causes QCODEGRP
DefectCauseCode Cause Code QCODE
DefectCauseCodeVersion Version Number QVERSNR
MasterLanguage Primary language indicator for text segment CHAR1
NumberOfDefects Number of Defect Occurrences QANZAHL4
ProductionOrder Order Number (Production Order) AUFNR
OrderInternalID Plan Number for Operations in Order (Production Order) AUFPL
InspPlanOperationInternalID Current Node Number from Order Counter KNTNR
InspectionCharacteristic Inspection Characteristic Number QMERKNRP
DefectiveSingleUnit Single-Unit Number for Unit to Be Inspected QSERIALNR
MainWorkCenter Work Center ARBPL
IsDeleted Delete Data Record CHAR1
NotificationItemExternalID Sort Number for Item QFELFD
StorageLocation Storage location LGORT
Equipment Equipment Number EQUNR
FunctionalLocation Functional Location TPLNR
InspectionLot Inspection Lot Number QPLOS
Batch Batch Number CHARG
ProductionOrderOperationActy Identifies an Operation Activity MPE_OAN_ELEMENT_ID
ProductionOrderOpActyVers Number of an Operation Actiivity Version
ReferencedDefect Defect Key QDEFREFNUM
CatalogProfile Catalog Profile RBNR
ChangedDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
QualityIssueReference External Reference Number QEXTREFNUM
DefectInternalID Internal Defect ID QDEFECTINTERNALID
NotifItmReportedByUser Notification Item Reported By USNAM
DefectUUID Defect UUID QDEFECTUUID
ProductionSupplyArea Production Supply Area PRVBE
Warehouse Warehouse Number/Warehouse Complex /SCWM/LGNUM
EWMWarehouse Warehouse Number/Warehouse Complex /SCWM/LGNUM
StorageType Source Storage Type /SCWM/LGTYP
SourceStorageType Source Storage Type /SCWM/LGTYP
SourceStorageBin Source Storage Bin /SCWM/LGPLA
DefectCausedBy Defect Caused By QDEFECTCAUSEDBY
BOMItemInstanceUUID Internal Identification for DMU Objects of Type RAW 16 DMU_GUID16
ProducedMaterial Material Number MATNR
ProducedSerialNumber Serial Number GERNR
Master Data Relations Join Conditions
Assembly
  • Assembly
  • Client
  • I_NOTIFICATIONITEM.ASSEMBLY == MARA.MATNR
  • I_NOTIFICATIONITEM.MANDT == MARA.MANDT
Cost Center
  • ?
  • ?
  • Cost Center
  • Client
  • I_NOTIFICATIONITEM.[column in domain "DATBI"] == CSKS.DATBI
  • I_NOTIFICATIONITEM.[column in domain "KOKRS"] == CSKS.KOKRS
  • I_NOTIFICATIONITEM.COSTCENTER == CSKS.KOSTL
  • I_NOTIFICATIONITEM.MANDT == CSKS.MANDT
Defect Category
  • Defect Category
  • Client
  • I_NOTIFICATIONITEM.DEFECTCATEGORY == TQDEFCAT.CATEGORY
  • I_NOTIFICATIONITEM.MANDT == TQDEFCAT.MANDANT
Defect Class
  • Defect Class
  • Client
  • I_NOTIFICATIONITEM.DEFECTCLASS == TQ17.FEHLKLASSE
  • I_NOTIFICATIONITEM.MANDT == TQ17.MANDT
Catalog Type - Problems/Defects
  • Catalog Type - Problems/Defects
  • Client
  • I_NOTIFICATIONITEM.DEFECTCODECATALOG == TQ15.KATALOGART
  • I_NOTIFICATIONITEM.MANDT == TQ15.MANDT
Code Group - Problem
  • Code Group - Problem
  • Catalog Type - Problems/Defects
  • Client
  • I_NOTIFICATIONITEM.DEFECTCODEGROUP == QPGR.CODEGRUPPE
  • I_NOTIFICATIONITEM.DEFECTCODECATALOG == QPGR.KATALOGART
  • I_NOTIFICATIONITEM.MANDT == QPGR.MANDT
Unit of Measure for Item
  • Client
  • Unit of Measure for Item
  • I_NOTIFICATIONITEM.MANDT == T006.MANDT
  • I_NOTIFICATIONITEM.DEFECTIVEQUANTITYUNIT == T006.MSEHI
Object ID of the Work Center
  • Object types of the CIM resource
  • Object ID of the Work Center
  • Work Center
  • Client
  • I_NOTIFICATIONITEM.WORKCENTERTYPECODE == CRID.OBJTY
  • I_NOTIFICATIONITEM.MAINWORKCENTERINTERNALID == CRID.OBJID
  • I_NOTIFICATIONITEM.MAINWORKCENTER == CRID.OBJID
  • I_NOTIFICATIONITEM.MANDT == CRID.MANDT
Plant for Work Center
  • Plant for Work Center
  • Client
  • I_NOTIFICATIONITEM.MAINWORKCENTERPLANT == T001W.WERKS
  • I_NOTIFICATIONITEM.MANDT == T001W.MANDT
Material Number
  • Client
  • Material Number
  • I_NOTIFICATIONITEM.MANDT == MARA.MANDT
  • I_NOTIFICATIONITEM.MATERIAL == MARA.MATNR
Catalog Type - Object Parts
  • Client
  • Catalog Type - Object Parts
  • I_NOTIFICATIONITEM.MANDT == TQ15.MANDT
  • I_NOTIFICATIONITEM.NOTIFITMOBJECTPARTCODECTLG == TQ15.KATALOGART
Code Group - Object Parts
  • Client
  • Catalog Type - Object Parts
  • Code Group - Object Parts
  • I_NOTIFICATIONITEM.MANDT == QPGR.MANDT
  • I_NOTIFICATIONITEM.NOTIFITMOBJECTPARTCODECTLG == QPGR.KATALOGART
  • I_NOTIFICATIONITEM.NOTIFITMOBJECTPARTCODEGROUP == QPGR.CODEGRUPPE
Plant
  • Plant
  • Client
  • I_NOTIFICATIONITEM.PLANT == T001W.WERKS
  • I_NOTIFICATIONITEM.MANDT == T001W.MANDT