I_QltyNotification

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