I_Notification

Notification | view: INOTIFICATION | TRAN | Extraction: Not supported | Component: Quality Notifications
Tables used: QMEL
Column Name Description
Notification Notification Number
Column Name Description
Column Name Description
📏 Unit of Measure (NotificationQuantityUnit):
NotificationInternalQuantity Defective Quantity (Internal)
NotificationExternalQty Defective Quantity (External)
NotificationReferenceQuantity General Reference Quantity
NotificationComplaintQuantity Complaint Quantity
NotifReturnDeliveryQuantity Return Delivery Quantity
Column Name Description
CreationDate Date on which the record was created
LastChangedDate Last Changed On
NotificationCreationTime Time of Notification
NotificationReportingDate Date of Notification
NotificationRequiredStartDate Required start date
NotificationRequiredStartTime Required Start Time
NotificationRequiredEndDate Required End Date
NotificationRequiredEndTime Required End Time
NotificationCompletionDate Date for Notification Completion
CustomerPurchaseOrderDate Customer Reference Date
NotificationReturnDeliveryDate Date of Return Delivery
Column Name Description
NotificationOrigin Origin of Notification Show values
WorkCenterTypeCode Object types of the CIM resource Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
NotifProcessingPhase Notification Processing Phase Show values
Column Name Description Domain name
NotificationText Short Text TEXT40
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser Name of Person Who Changed Object USNAM
ReportedByUser Name of Person Reporting Notification USNAM
MasterLanguage Master Language SPRAS
PurchaseOrderByCustomer Customer Reference BSTKD
NotificationCodeID Coding QCODE
MfgOrderInternalID Plan Number for Operations in Order (Production Order) AUFPL
MaterialDocumentYear Material Document Year GJAHR
MaterialDocument Number of Material Document BELNR
MaterialDocumentItem Item in Material Document MBLPO
OrderOperationInternalID Current Node Number from Order Counter KNTNR
NotificationExtReferenceNumber External Reference Number CHAR020
IsDeleted Delete Data Record CHAR1
AdditionalDeviceData Additional Device Data DEVICEID
Master Data Relations Join Conditions
Division
  • Client
  • Division
  • I_NOTIFICATION.MANDT == TSPA.MANDT
  • I_NOTIFICATION.ACTIVEDIVISION == TSPA.SPART
Batch Number
  • Client
  • Batch Number
  • Material Number
  • I_NOTIFICATION.MANDT == MCH1.MANDT
  • I_NOTIFICATION.BATCH == MCH1.CHARG
  • I_NOTIFICATION.MATERIAL == MCH1.MATNR
Account Number of Customer
  • Account Number of Customer
  • Client
  • I_NOTIFICATION.CUSTOMER == KNA1.KUNNR
  • I_NOTIFICATION.MANDT == KNA1.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • I_NOTIFICATION.MANDT == TVTW.MANDT
  • I_NOTIFICATION.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Foreign key work center
  • Object ID of the Work Center
  • Client
  • Object types of the CIM resource
  • I_NOTIFICATION.MAINWORKCENTERINTERNALID == CRID.OBJID
  • I_NOTIFICATION.MANDT == CRID.MANDT
  • I_NOTIFICATION.WORKCENTERTYPECODE == CRID.OBJTY
Plant for Work Center
  • Client
  • Plant for Work Center
  • I_NOTIFICATION.MANDT == T001W.MANDT
  • I_NOTIFICATION.MAINWORKCENTERPLANT == T001W.WERKS
Number of Manufacturer
  • Number of Manufacturer
  • Client
  • I_NOTIFICATION.MANUFACTURER == LFA1.LIFNR
  • I_NOTIFICATION.MANDT == LFA1.MANDT
Material Number
  • Client
  • Material Number
  • I_NOTIFICATION.MANDT == MARA.MANDT
  • I_NOTIFICATION.MATERIAL == MARA.MATNR
Material Group
  • Material Group
  • Client
  • I_NOTIFICATION.MATERIALGROUP == T023.MATKL
  • I_NOTIFICATION.MANDT == T023.MANDT
Catalog Type - Coding
  • Client
  • Catalog Type - Coding
  • I_NOTIFICATION.MANDT == TQ15.MANDT
  • I_NOTIFICATION.NOTIFICATIONCATALOG == TQ15.KATALOGART
Code Group - Coding
  • Code Group - Coding
  • Client
  • Catalog Type - Coding
  • I_NOTIFICATION.NOTIFICATIONCODEGROUP == QPGR.CODEGRUPPE
  • I_NOTIFICATION.MANDT == QPGR.MANDT
  • I_NOTIFICATION.NOTIFICATIONCATALOG == QPGR.KATALOGART
Priority
  • Client
  • Priority Type
  • Priority
  • I_NOTIFICATION.MANDT == T356.MANDT
  • I_NOTIFICATION.NOTIFICATIONPRIORITYTYPE == T356.ARTPR
  • I_NOTIFICATION.NOTIFICATIONPRIORITY == T356.PRIOK
Priority Type
  • Client
  • Priority Type
  • I_NOTIFICATION.MANDT == T356A.MANDT
  • I_NOTIFICATION.NOTIFICATIONPRIORITYTYPE == T356A.ARTPR
Unit of Measure
  • Client
  • Unit of Measure
  • I_NOTIFICATION.MANDT == T006.MANDT
  • I_NOTIFICATION.NOTIFICATIONQUANTITYUNIT == T006.MSEHI
Notification Type
  • Notification Type
  • Client
  • I_NOTIFICATION.NOTIFICATIONTYPE == TQ80.QMART
  • I_NOTIFICATION.MANDT == TQ80.MANDT
Order Number
  • Order Number
  • Client
  • I_NOTIFICATION.ORDERID == AUFK.AUFNR
  • I_NOTIFICATION.MANDT == AUFK.MANDT
Plant for Material
  • Plant for Material
  • Client
  • I_NOTIFICATION.PLANT == T001W.WERKS
  • I_NOTIFICATION.MANDT == T001W.MANDT
Order Number (Production Order)
  • Order Number (Production Order)
  • Client
  • I_NOTIFICATION.PRODUCTIONORDER == AUFK.AUFNR
  • I_NOTIFICATION.MANDT == AUFK.MANDT
Production Version
  • Client
  • ?
  • ?
  • Production Version
  • I_NOTIFICATION.MANDT == MKAL.MANDT
  • I_NOTIFICATION.[column in domain "MATNR"] == MKAL.MATNR
  • I_NOTIFICATION.[column in domain "WERKS_D"] == MKAL.WERKS
  • I_NOTIFICATION.PRODUCTIONVERSION == MKAL.VERID
Purchasing Group
  • Purchasing Group
  • Client
  • I_NOTIFICATION.PURCHASINGGROUP == T024.EKGRP
  • I_NOTIFICATION.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • I_NOTIFICATION.PURCHASINGORGANIZATION == T024E.EKORG
  • I_NOTIFICATION.MANDT == T024E.MANDT
Sales Organization
  • Sales Organization
  • Client
  • I_NOTIFICATION.SALESORGANIZATION == TVKO.VKORG
  • I_NOTIFICATION.MANDT == TVKO.MANDT
Supplier Account Number
  • Client
  • Supplier Account Number
  • I_NOTIFICATION.MANDT == LFA1.MANDT
  • I_NOTIFICATION.SUPPLIER == LFA1.LIFNR