SAP table INOTIFICATION (Generated Table for View)

SAP table INOTIFICATION has 2 primary key fields being MANDT,NOTIFICATION.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
NOTIFICATION Notification Number CHAR 12 0 QMNUM
NOTIFICATIONTYPE Notification Type CHAR 2 0 TQ80 QMART
NOTIFICATIONTEXT Short Text CHAR 40 0 QMTXT
NOTIFICATIONPRIORITYTYPE Priority Type CHAR 2 0 T356A ARTPR
NOTIFICATIONPRIORITY Priority CHAR 1 0 T356 PRIOK
CREATEDBYUSER Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
CREATIONDATE Date on which the record was created DATS 8 0 ERDAT
LASTCHANGEDBYUSER Name of Person Who Changed Object CHAR 12 0 AENAM
LASTCHANGEDDATE Last Changed On DATS 8 0 AEDAT
NOTIFICATIONCREATIONTIME Time of Notification TIMS 6 0 MZEIT
NOTIFICATIONREPORTINGDATE Date of Notification DATS 8 0 QMDAT
REPORTEDBYUSER Name of Person Reporting Notification CHAR 12 0 QMNAM
NOTIFICATIONREQUIREDSTARTDATE Required start date DATS 8 0 STRMN
NOTIFICATIONREQUIREDSTARTTIME Required Start Time TIMS 6 0 STRUR
NOTIFICATIONREQUIREDENDDATE Required End Date DATS 8 0 LTRMN
NOTIFICATIONREQUIREDENDTIME Required End Time TIMS 6 0 LTRUR
ORDERID Order Number CHAR 12 0 AUFK AUFNR
PRODUCTIONVERSION Production Version CHAR 4 0 QM_VERID
MATERIAL Material Number CHAR 40 0 MARA MATNR
MATERIALGROUP Material Group CHAR 9 0 T023 MATKL
CUSTOMER Account Number of Customer CHAR 10 0 KNA1 QKUNUM
NOTIFICATIONSTATUSOBJECT Object Number for Status Management CHAR 22 0 ONR00 QMOBJNR
NOTIFICATIONCOMPLETIONDATE Date for Notification Completion DATS 8 0 QMDAB
MASTERLANGUAGE Master Language LANG 1 0 VDM_J_MASTERLANGUAGE
NOTIFICATIONORIGIN Origin of Notification CHAR 2 0 HERKZ
01 General maintenance notification
02 Malfunction report
03 Activity report
04 Problem notification
05 Activity report (service)
06 General notification (service)
C1 Internal claim
C2 External claim
G1 General notification
Q1 Customer complaint
Q2 Complaint against supplier
Q3 Internal problem notification
R3 SAP notification to SAP support line
SUPPLIER Supplier Account Number CHAR 10 0 LFA1 LIFNUM
PURCHASEORDERBYCUSTOMER Customer Reference CHAR 35 0 BSTKD
CUSTOMERPURCHASEORDERDATE Customer Reference Date DATS 8 0 BSTDK
ACTIVEDIVISION Division CHAR 2 0 TSPA SPART
SALESORGANIZATION Sales Organization CHAR 4 0 TVKO VKORG
DISTRIBUTIONCHANNEL Distribution Channel CHAR 2 0 TVTW VTWEG
PLANT Plant for Material CHAR 4 0 T001W QMAWERKS
NOTIFICATIONCATALOG Catalog Type - Coding CHAR 1 0 TQ15 QMKAT
NOTIFICATIONCODEGROUP Code Group - Coding CHAR 8 0 QPGR QMGRP
NOTIFICATIONCODEID Coding CHAR 4 0 QMCOD
INSPECTIONLOT Inspection Lot Number NUMC 12 0 QALS QPLOS
BATCH Batch Number CHAR 10 0 MCH1 CHARG_D
MANUFACTURER Number of Manufacturer CHAR 10 0 LFA1 QLIFNR
PURCHASINGORGANIZATION Purchasing organization CHAR 4 0 T024E EKORG
PURCHASINGGROUP Purchasing Group CHAR 3 0 T024 BKGRP
PRODUCTIONORDER Order Number (Production Order) CHAR 12 0 AUFK FERTAUFNR
MFGORDERINTERNALID Plan Number for Operations in Order (Production Order) NUMC 10 0 FERTAUFPL
PURCHASINGDOCUMENT Purchasing Document Number CHAR 10 0 EKKO QM_EBELN
PURCHASINGDOCUMENTITEM Item Number of Purchasing Document NUMC 5 0 EKPO QEBELP
MATERIALDOCUMENTYEAR Material Document Year NUMC 4 0 QM_MJAHR
MATERIALDOCUMENT Number of Material Document CHAR 10 0 QM_MBLNR
MATERIALDOCUMENTITEM Item in Material Document NUMC 4 0 QMBLPO
ORDERDOCUMENT Sales Order Number CHAR 10 0 VBAK QM_KDAUF
DELIVERYDOCUMENT Delivery CHAR 10 0 LIKP VBELN_VL
DELIVERYDOCUMENTITEM Delivery Item NUMC 6 0 LIPS QPOSNR_VL
WORKCENTERTYPECODE Object types of the CIM resource CHAR 2 0 CR_OBJTY
A Work Center
AA Work center alias
FH Production resources/tools
G Group
H Hierarchy
MAINWORKCENTERINTERNALID Object ID of the Work Center NUMC 8 0 CRID LGWID
MAINWORKCENTERPLANT Plant for Work Center CHAR 4 0 T001W QARBPWERKS
ORDEROPERATIONINTERNALID Current Node Number from Order Counter NUMC 8 0 QLFNKN
NOTIFICATIONINTERNALQUANTITY Defective Quantity (Internal) QUAN 13 3 MGEIG
NOTIFICATIONEXTERNALQTY Defective Quantity (External) QUAN 13 3 MGFRD
NOTIFICATIONQUANTITYUNIT Unit of Measure UNIT 3 0 T006 MGEIN
NOTIFICATIONREFERENCEQUANTITY General Reference Quantity QUAN 13 3 QBZMNG
NOTIFICATIONCOMPLAINTQUANTITY Complaint Quantity QUAN 13 3 RKMNG
NOTIFRETURNDELIVERYQUANTITY Return Delivery Quantity QUAN 13 3 RGMNG
NOTIFICATIONRETURNDELIVERYDATE Date of Return Delivery DATS 8 0 RKDAT
NOTIFICATIONLINKEDNOTIFICATION Reference Notification Number CHAR 12 0 QMEL QWRNUM
NOTIFICATIONEXTREFERENCENUMBER External Reference Number CHAR 20 0 QMEXTNR
ISDELETED Delete Data Record CHAR 1 0 KZLOESCH
ISBUSINESSPURPOSECOMPLETED Business Purpose Completed Flag CHAR 1 0 CVP_XBLCK
not blocked
X blocked
ADDITIONALDEVICEDATA Additional Device Data CHAR 40 0 DEVICEID
WBSELEMENTINTERNALID WBS Element NUMC 8 0 PS_S4_PSPNR
NOTIFPROCESSINGPHASE Notification Processing Phase CHAR 1 0 QM_PHASE
1 Outstanding
2 Postponed
3 In Process
4 Completed
5 Deletion Flag

INOTIFICATION foreign key relationships

Table Field Check Table Check Field
0 INOTIFICATION ACTIVEDIVISION TSPA Organizational Unit: Sales Divisions MANDT
0 INOTIFICATION ACTIVEDIVISION TSPA Organizational Unit: Sales Divisions SPART
1 INOTIFICATION BATCH MCH1 Batches (if Batch Management Cross-Plant) MANDT
0 INOTIFICATION CUSTOMER KNA1 General Data in Customer Master MANDT
0 INOTIFICATION CUSTOMER KNA1 General Data in Customer Master KUNNR
1 INOTIFICATION DELIVERYDOCUMENT LIKP SD Document: Delivery Header Data MANDT
1 INOTIFICATION DELIVERYDOCUMENT LIKP SD Document: Delivery Header Data VBELN
0 INOTIFICATION DELIVERYDOCUMENTITEM LIPS SD document: Delivery: Item data MANDT
0 INOTIFICATION DELIVERYDOCUMENTITEM LIPS SD document: Delivery: Item data VBELN
0 INOTIFICATION DELIVERYDOCUMENTITEM LIPS SD document: Delivery: Item data POSNR
1 INOTIFICATION DISTRIBUTIONCHANNEL TVTW Organizational Unit: Distribution Channels MANDT
1 INOTIFICATION DISTRIBUTIONCHANNEL TVTW Organizational Unit: Distribution Channels VTWEG
0 INOTIFICATION INSPECTIONLOT QALS Inspection lot record MANDANT
1 INOTIFICATION MAINWORKCENTERINTERNALID CRID CIM Resource - Entities MANDT
1 INOTIFICATION MAINWORKCENTERINTERNALID CRID CIM Resource - Entities OBJID
0 INOTIFICATION MAINWORKCENTERPLANT T001W Plants/Branches MANDT
0 INOTIFICATION MAINWORKCENTERPLANT T001W Plants/Branches WERKS
1 INOTIFICATION MANDT T000 Clients MANDT
0 INOTIFICATION MANUFACTURER LFA1 Supplier Master (General Section) MANDT
0 INOTIFICATION MANUFACTURER LFA1 Supplier Master (General Section) LIFNR
1 INOTIFICATION MATERIAL MARA General Material Data MANDT
1 INOTIFICATION MATERIAL MARA General Material Data MATNR
0 INOTIFICATION MATERIALGROUP T023 Material Groups MATKL
1 INOTIFICATION NOTIFICATIONCATALOG TQ15 Inspection catalog type index KATALOGART
0 INOTIFICATION NOTIFICATIONCODEGROUP QPGR Inspection catalog code groups MANDT
0 INOTIFICATION NOTIFICATIONCODEGROUP QPGR Inspection catalog code groups KATALOGART
1 INOTIFICATION NOTIFICATIONLINKEDNOTIFICATION QMEL Quality Notification MANDT
1 INOTIFICATION NOTIFICATIONLINKEDNOTIFICATION QMEL Quality Notification QMNUM
0 INOTIFICATION NOTIFICATIONPRIORITY T356 Priorities MANDT
0 INOTIFICATION NOTIFICATIONPRIORITY T356 Priorities ARTPR
1 INOTIFICATION NOTIFICATIONPRIORITYTYPE T356A Priority type table MANDT
1 INOTIFICATION NOTIFICATIONPRIORITYTYPE T356A Priority type table ARTPR
0 INOTIFICATION NOTIFICATIONQUANTITYUNIT T006 Units of Measurement MANDT
1 INOTIFICATION NOTIFICATIONSTATUSOBJECT ONR00 General Object Number MANDT
0 INOTIFICATION NOTIFICATIONTYPE TQ80 Notification Types MANDT
0 INOTIFICATION NOTIFICATIONTYPE TQ80 Notification Types QMART
1 INOTIFICATION ORDERDOCUMENT VBAK Sales Document: Header Data MANDT
1 INOTIFICATION ORDERDOCUMENT VBAK Sales Document: Header Data VBELN
0 INOTIFICATION ORDERID AUFK Order master data AUFNR
1 INOTIFICATION PLANT T001W Plants/Branches MANDT
1 INOTIFICATION PLANT T001W Plants/Branches WERKS
0 INOTIFICATION PRODUCTIONORDER AUFK Order master data AUFNR
1 INOTIFICATION PURCHASINGDOCUMENT EKKO Purchasing Document Header MANDT
1 INOTIFICATION PURCHASINGDOCUMENT EKKO Purchasing Document Header EBELN
0 INOTIFICATION PURCHASINGDOCUMENTITEM EKPO Purchasing Document Item MANDT
0 INOTIFICATION PURCHASINGDOCUMENTITEM EKPO Purchasing Document Item EBELN
1 INOTIFICATION PURCHASINGGROUP T024 Purchasing Groups EKGRP
0 INOTIFICATION PURCHASINGORGANIZATION T024E Purchasing Organizations EKORG
1 INOTIFICATION SALESORGANIZATION TVKO Organizational Unit: Sales Organizations MANDT
1 INOTIFICATION SALESORGANIZATION TVKO Organizational Unit: Sales Organizations VKORG
0 INOTIFICATION SUPPLIER LFA1 Supplier Master (General Section) MANDT
0 INOTIFICATION SUPPLIER LFA1 Supplier Master (General Section) LIFNR