ESH_S_DEFECT

Search view -DEFECT | view: ESH_U_DEFECT | TRAN | Extraction: Not supported | Component: Quality Notifications
Tables used: QMFEQDEFLTEXTQPCDQPGRQPGTQPCTADCPADR2ADR3ADR6ADRPUSR21CRHD
Column Name Description
DEFECTINTERNALID FK Internal Defect ID
Column Name Description
Column Name Description
Column Name Description
CREATIONDATE Date on which the record was created
LASTCHANGEDATE Last Changed On
Column Name Description
ISDELETED Is Deleted Show values
Column Name Description Domain name
DEFECTCODE Defect Code QCODE
DEFECTCODEGROUPTEXT Text for Defect Code Group QKURZTEXT
DEFECTCODETEXT Text for Defect Code QKURZTEXT
DEFECTLONGTEXT Long Text
DEFECTTEXT Defect Text TEXT40
MAINWORKCENTER Work Center ARBPL
CHANGED_BY User Description
CREATED_BY User Description
Master Data Relations Join Conditions
Defect Category
  • Defect Category
  • Client
  • ESH_S_DEFECT.DEFECTCATEGORY == TQDEFCAT.CATEGORY
  • ESH_S_DEFECT.MANDT == TQDEFCAT.MANDANT
Defect Code Group
  • Defect Code Group
  • Client
  • ?
  • ESH_S_DEFECT.DEFECTCODEGROUP == QPGR.CODEGRUPPE
  • ESH_S_DEFECT.MANDT == QPGR.MANDT
  • ESH_S_DEFECT.[column in domain "QKATART"] == QPGR.KATALOGART
Plant for Work Center
  • Client
  • Plant for Work Center
  • ESH_S_DEFECT.MANDT == T001W.MANDT
  • ESH_S_DEFECT.MAINWORKCENTERPLANT == T001W.WERKS