ESH_N_QUALITYNOTIFICATION

Anchor view -QUALITYNOTIFICATION | view: ESH_L_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
NOTIFPROCESSINGPHASE Notification Processing Phase Show values
Column Name Description Domain name
ISDELETED Delete Data Record CHAR1
MATERIALGROUP Product Group MATKL
MATERIALGROUPNAME Product Group Description TEXT20
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
NOTIFPROCESSINGPHASEDESC Short Text for Fixed Values DDTEXT
PLANTNAME Plant Name TEXT30
PRODUCTHIERARCHY Product hierarchy PRODH
PRODUCTHIERARCHYTEXT Product Hierarchy Text TEXT40
PRODUCTNAME Product Description TEXT40
QLTYNOTIFICATIONLONGTEXT Long Text
USERCHANGED User Description SUIDTECHDESC
USERCREATED User Description SUIDTECHDESC
Master Data Relations Join Conditions
Material Number
  • Client
  • Material Number
  • ESH_N_QUALITYNOTIFICATION.MANDT == MARA.MANDT
  • ESH_N_QUALITYNOTIFICATION.MATERIAL == MARA.MATNR
Priority
  • ?
  • Client
  • Priority
  • ESH_N_QUALITYNOTIFICATION.[column in domain "ARTPR"] == T356.ARTPR
  • ESH_N_QUALITYNOTIFICATION.MANDT == T356.MANDT
  • ESH_N_QUALITYNOTIFICATION.NOTIFICATIONPRIORITY == T356.PRIOK
Notification Type
  • Notification Type
  • Client
  • ESH_N_QUALITYNOTIFICATION.NOTIFICATIONTYPE == TQ80.QMART
  • ESH_N_QUALITYNOTIFICATION.MANDT == TQ80.MANDT
Plant for Material
  • Client
  • Plant for Material
  • ESH_N_QUALITYNOTIFICATION.MANDT == T001W.MANDT
  • ESH_N_QUALITYNOTIFICATION.PLANT == T001W.WERKS
Supplier Account Number
  • Client
  • Supplier Account Number
  • ESH_N_QUALITYNOTIFICATION.MANDT == LFA1.MANDT
  • ESH_N_QUALITYNOTIFICATION.SUPPLIER == LFA1.LIFNR