ESH_N_QUALITYNOTIFITEM

Anchor view -QUALITYNOTIFITEM | view: ESH_L_QLTYITEM | TRAN | Extraction: Not supported | Component: Quality Notifications
Tables used: QMELQMFEQDEFLTEXTMARAQPCDQPGRQPGTQPCTTQ80TQ80_TT001WMARAT023TMAKTADCPADR2ADR3ADR6ADRPUSR21CRHD
Column Name Description
NOTIFICATIONITEM Item Number in Item Record
QUALITYNOTIFICATION FK Notification Number
Column Name Description
Column Name Description
Column Name Description
CREATIONDATE Date on which the record was created
Column Name Description
ISBUSINESSPURPOSECOMPLETED Business Purpose Completed Flag Show values
NOTIFPROCESSINGPHASE Notification Processing Phase Show values
Column Name Description Domain name
CREATEDBYUSER Name of Person Responsible for Creating the Object USNAM
DEFECTCODE Defect Code QCODE
DEFECTCODEGROUPTEXT Text for Defect Code Group QKURZTEXT
DEFECTCODETEXT Text for Defect Code QKURZTEXT
MATERIALGROUPNAME Product Group Description TEXT20
NOTIFICATIONITEMLONGTEXT Long Text
NOTIFICATIONITEMTEXT Notification Item Short Text TEXT40
NOTIFICATIONTYPENAME Notification Type Text TEXT20
PLANTNAME Plant Name TEXT30
PRODUCTNAMEMATERIAL Product Description TEXT40
PRODUCTNAME Product Description TEXT40
USERCHANGED User Description SUIDTECHDESC
USERCREATED User Description SUIDTECHDESC
Master Data Relations Join Conditions
Assembly
  • Assembly
  • Client
  • ESH_N_QUALITYNOTIFITEM.ASSEMBLY == MARA.MATNR
  • ESH_N_QUALITYNOTIFITEM.MANDT == MARA.MANDT
Defect Code Group
  • ?
  • Defect Code Group
  • Client
  • ESH_N_QUALITYNOTIFITEM.[column in domain "QKATART"] == QPGR.KATALOGART
  • ESH_N_QUALITYNOTIFITEM.DEFECTCODEGROUP == QPGR.CODEGRUPPE
  • ESH_N_QUALITYNOTIFITEM.MANDT == QPGR.MANDT
Plant for Work Center
  • Plant for Work Center
  • Client
  • ESH_N_QUALITYNOTIFITEM.MAINWORKCENTERPLANT == T001W.WERKS
  • ESH_N_QUALITYNOTIFITEM.MANDT == T001W.MANDT
Material Number
  • Material Number
  • Client
  • ESH_N_QUALITYNOTIFITEM.MATERIAL == MARA.MATNR
  • ESH_N_QUALITYNOTIFITEM.MANDT == MARA.MANDT
Notification Type
  • Notification Type
  • Client
  • ESH_N_QUALITYNOTIFITEM.NOTIFICATIONTYPE == TQ80.QMART
  • ESH_N_QUALITYNOTIFITEM.MANDT == TQ80.MANDT
Plant for Material
  • Plant for Material
  • Client
  • ESH_N_QUALITYNOTIFITEM.PLANT == T001W.WERKS
  • ESH_N_QUALITYNOTIFITEM.MANDT == T001W.MANDT
Material Group
  • Client
  • Product Group
  • ESH_N_QUALITYNOTIFITEM.MANDT == T023.MANDT
  • ESH_N_QUALITYNOTIFITEM.PRODUCTGROUP == T023.MATKL