ESH_S_QUALITYNOTIFTASK

Search view -QUALITYNOTIFTASK | view: ESH_U_QLTYTASK | TRAN | Extraction: Not supported | Component: Quality Notifications
Tables used: QMELQMSMQTASKLTEXTMARATQ80TQ80_TT001WMARAT023T023TMAKTQPCDQPGRQPGTQPCTADCPADR2ADR3ADR6ADRPUSR21
Column Name Description
NOTIFICATIONTASK Sequential Task Number
QUALITYNOTIFICATION FK Notification Number
Column Name Description
Column Name Description
Column Name Description
CREATIONDATE Date on which the record was created
NOTIFTASKPLANNEDENDDATE Planned Finish Date
NOTIFTASKPLANNEDSTARTDATE Planned Start Date
NOTIFTASKPLANNEDSTARTTIME Planned Start Time for Task
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
MATERIALGROUPNAME Product Group Description
NOTIFICATIONTASKTEXT Short Text for Task TEXT40
NOTIFICATIONTYPENAME Notification Type Text TEXT20
PLANTNAME Plant Name TEXT30
PRODUCTNAME Product Description TEXT40
QLTYNOTIFICATIONTASKLONGTEXT Long Text
QUALITYTASKCODE Task Code QCODE
QUALITYTASKCODEGROUPTEXT Text for Quality Task Code Group QKURZTEXT
QUALITYTASKCODETEXT Text for Task Code QKURZTEXT
RESPONSIBLEPERSON Person Responsible for Task (Partner Number) I_PARNR
USERCREATED User Description
USERCHANGED User Description
Master Data Relations Join Conditions
Material Number
  • Client
  • Material Number
  • ESH_S_QUALITYNOTIFTASK.MANDT == MARA.MANDT
  • ESH_S_QUALITYNOTIFTASK.MATERIAL == MARA.MATNR
Notification Type
  • Client
  • Notification Type
  • ESH_S_QUALITYNOTIFTASK.MANDT == TQ80.MANDT
  • ESH_S_QUALITYNOTIFTASK.NOTIFICATIONTYPE == TQ80.QMART
Plant for Material
  • Plant for Material
  • Client
  • ESH_S_QUALITYNOTIFTASK.PLANT == T001W.WERKS
  • ESH_S_QUALITYNOTIFTASK.MANDT == T001W.MANDT
Material Group
  • Client
  • Product Group
  • ESH_S_QUALITYNOTIFTASK.MANDT == T023.MANDT
  • ESH_S_QUALITYNOTIFTASK.PRODUCTGROUP == T023.MATKL
Code Group - Tasks
  • ?
  • Client
  • Code Group - Tasks
  • ESH_S_QUALITYNOTIFTASK.[column in domain "QKATART"] == QPGR.KATALOGART
  • ESH_S_QUALITYNOTIFTASK.MANDT == QPGR.MANDT
  • ESH_S_QUALITYNOTIFTASK.QUALITYTASKCODEGROUP == QPGR.CODEGRUPPE