ESH_S_QUALITYNOTIFICATION

Search view -QUALITYNOTIFICATION | view: ESH_U_QLTYNOTIF | TRAN | Extraction: Not supported | Component: Quality Notifications
Tables used: QMELQMELLTEXTMARAQPCDQPGRQPGTQPCTT356T356_TTQ80TQ80_TT001WMARAT023T023TT179T179TMAKTADCPADR2ADR3ADR6ADRPUSR21
Column Name Description
QUALITYNOTIFICATION Notification Number
Column Name Description
Column Name Description
Column Name Description
CREATIONDATE Date on which the record was created
LASTCHANGEDDATE Last Changed On
NOTIFICATIONCOMPLETIONDATE Date for Notification Completion
NOTIFICATIONREPORTINGDATE Date of Notification
Column Name Description
ISBUSINESSPURPOSECOMPLETED Business Purpose Completed Flag Show values
NOTIFICATIONORIGIN Origin of Notification Show values
Column Name Description Domain name
ISDELETED Delete Data Record CHAR1
MATERIALGROUP Product Group
MATERIALGROUPNAME Product Group Description
NOTIFICATIONCODEGROUP Code Group QCODEGRP
NOTIFICATIONCODEGROUPTEXT Short Description of Code Group QKURZTEXT
NOTIFICATIONCODEID Code QCODE
NOTIFICATIONCODETEXT Short Text for Code QKURZTEXT
NOTIFICATIONPRIORITYTEXT Priority Text TEXT20
NOTIFICATIONTEXT Short Text TEXT40
NOTIFICATIONTYPENAME Notification Type Text TEXT20
NOTIFPROCESSINGPHASE Notification Processing Phase
NOTIFPROCESSINGPHASEDESC Short Text for Fixed Values
PLANTNAME Plant Name TEXT30
PRODUCTHIERARCHY Product hierarchy PRODH
PRODUCTHIERARCHYTEXT Product Hierarchy Text TEXT40
PRODUCTNAME Product Description
QLTYNOTIFICATIONLONGTEXT Long Text
USERCHANGED User Description
USERCREATED User Description
Master Data Relations Join Conditions
Material Number
  • Material Number
  • Client
  • ESH_S_QUALITYNOTIFICATION.MATERIAL == MARA.MATNR
  • ESH_S_QUALITYNOTIFICATION.MANDT == MARA.MANDT
Priority
  • ?
  • Priority
  • Client
  • ESH_S_QUALITYNOTIFICATION.[column in domain "ARTPR"] == T356.ARTPR
  • ESH_S_QUALITYNOTIFICATION.NOTIFICATIONPRIORITY == T356.PRIOK
  • ESH_S_QUALITYNOTIFICATION.MANDT == T356.MANDT
Notification Type
  • Client
  • Notification Type
  • ESH_S_QUALITYNOTIFICATION.MANDT == TQ80.MANDT
  • ESH_S_QUALITYNOTIFICATION.NOTIFICATIONTYPE == TQ80.QMART
Plant for Material
  • Client
  • Plant for Material
  • ESH_S_QUALITYNOTIFICATION.MANDT == T001W.MANDT
  • ESH_S_QUALITYNOTIFICATION.PLANT == T001W.WERKS
Supplier Account Number
  • Supplier Account Number
  • Client
  • ESH_S_QUALITYNOTIFICATION.SUPPLIER == LFA1.LIFNR
  • ESH_S_QUALITYNOTIFICATION.MANDT == LFA1.MANDT