0NOTIFICATN_2_ATTR

Notification Number 2 (with QSTABI Fields) | #ATTR | Extraction method: V | No Delta | Component: Quality Management Master Data
Tables used: QMEL, QMIH, ILOA → show details
Column Name Description
QMNUM Notification Number
Column Name Description
Column Name Description
Column Name Description
ERDAT Date on which the record was created
AEDAT Last Changed On
QMDAT Date of Notification
STADT Start date
LRMDT Date of last completion in maintenance plan
NPLDA Next planned date
Column Name Description
HERKZ Origin of Notification Show values
MSAUS Breakdown Indicator Show values
Column Name Description Domain name
QMCOD Coding QCODE
KDAUF Sales Document VBELN
MSGRP Room CHAR8
BWSTNTF1 Status Object1 Notification J_STONR
BWSTNTF2 Status Object 2 Notification: Order Assigned J_STONR
BWSTNTF3 Status Object 3 Notification: Internal/External Origin J_STONR
WARPL Maintenance Plan WARPL
STRAT Maintenance Strategy WSTRA
Master Data Relations | to Other Relations ↓ Join Conditions
Order Number
  • Client
  • Order Number
  • 0NOTIFICATN_2_ATTR.MANDT == AUFK.MANDT
  • 0NOTIFICATN_2_ATTR.AUFNR == AUFK.AUFNR
Assembly
  • Client
  • Assembly
  • 0NOTIFICATN_2_ATTR.MANDT == MARA.MANDT
  • 0NOTIFICATN_2_ATTR.BAUTL == MARA.MATNR
Plant Section
  • Maintenance Plant
  • Client
  • Plant Section
  • 0NOTIFICATN_2_ATTR.SWERK == T357.WERKS
  • 0NOTIFICATN_2_ATTR.MANDT == T357.MANDT
  • 0NOTIFICATN_2_ATTR.BEBER == T357.BEBER
Batch Number
  • Batch Number
  • Client
  • Material Number
  • 0NOTIFICATN_2_ATTR.CHARG == MCH1.CHARG
  • 0NOTIFICATN_2_ATTR.MANDT == MCH1.MANDT
  • 0NOTIFICATN_2_ATTR.MATNR == MCH1.MATNR
Order Number (QM Order)
  • Client
  • Order Number (QM Order)
  • 0NOTIFICATN_2_ATTR.MANDT == AUFK.MANDT
  • 0NOTIFICATN_2_ATTR.COAUFNR == AUFK.AUFNR
Purchasing organization
  • Purchasing organization
  • Client
  • 0NOTIFICATN_2_ATTR.EKORG == T024E.EKORG
  • 0NOTIFICATN_2_ATTR.MANDT == T024E.MANDT
Equipment Number
  • Client
  • Equipment Number
  • 0NOTIFICATN_2_ATTR.MANDT == EQUI.MANDT
  • 0NOTIFICATN_2_ATTR.EQUNR == EQUI.EQUNR
Account Number of Customer
  • Account Number of Customer
  • Client
  • 0NOTIFICATN_2_ATTR.KUNUM == KNA1.KUNNR
  • 0NOTIFICATN_2_ATTR.MANDT == KNA1.MANDT
Supplier Account Number
  • Supplier Account Number
  • Client
  • 0NOTIFICATN_2_ATTR.LIFNUM == LFA1.LIFNR
  • 0NOTIFICATN_2_ATTR.MANDT == LFA1.MANDT
Material Number
  • Client
  • Material Number
  • 0NOTIFICATN_2_ATTR.MANDT == MARA.MANDT
  • 0NOTIFICATN_2_ATTR.MATNR == MARA.MATNR
Plant for Material
  • Plant for Material
  • Client
  • 0NOTIFICATN_2_ATTR.MAWERK == T001W.WERKS
  • 0NOTIFICATN_2_ATTR.MANDT == T001W.MANDT
Priority
  • Priority
  • Client
  • 0NOTIFICATN_2_ATTR.PRIOK == T356.PRIOK
  • 0NOTIFICATN_2_ATTR.MANDT == T356.MANDT
Notification Type
  • Notification Type
  • Client
  • 0NOTIFICATN_2_ATTR.QMART == TQ80.QMART
  • 0NOTIFICATN_2_ATTR.MANDT == TQ80.MANDT
Code Group - Coding
  • Code Group - Coding
  • Client
  • Catalog Type - Coding
  • 0NOTIFICATN_2_ATTR.QMGRP == QPGR.CODEGRUPPE
  • 0NOTIFICATN_2_ATTR.MANDT == QPGR.MANDT
  • 0NOTIFICATN_2_ATTR.QMKAT == QPGR.KATALOGART
Catalog Type - Coding
  • Catalog Type - Coding
  • Client
  • 0NOTIFICATN_2_ATTR.QMKAT == TQ15.KATALOGART
  • 0NOTIFICATN_2_ATTR.MANDT == TQ15.MANDT
Division
  • Division
  • Client
  • 0NOTIFICATN_2_ATTR.SPART == TSPA.SPART
  • 0NOTIFICATN_2_ATTR.MANDT == TSPA.MANDT
Location of maintenance object
  • Maintenance Plant
  • Client
  • Location of maintenance object
  • 0NOTIFICATN_2_ATTR.SWERK == T499S.WERKS
  • 0NOTIFICATN_2_ATTR.MANDT == T499S.MANDT
  • 0NOTIFICATN_2_ATTR.STORT == T499S.STAND
Maintenance Plant
  • Maintenance Plant
  • Client
  • 0NOTIFICATN_2_ATTR.SWERK == T001W.WERKS
  • 0NOTIFICATN_2_ATTR.MANDT == T001W.MANDT
Functional Location
  • Functional Location
  • Client
  • 0NOTIFICATN_2_ATTR.TPLNR == IFLOT.TPLNR
  • 0NOTIFICATN_2_ATTR.MANDT == IFLOT.MANDT
Sales Organization
  • Sales Organization
  • Client
  • 0NOTIFICATN_2_ATTR.VKORG == TVKO.VKORG
  • 0NOTIFICATN_2_ATTR.MANDT == TVKO.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • 0NOTIFICATN_2_ATTR.MANDT == TVTW.MANDT
  • 0NOTIFICATN_2_ATTR.VTWEG == TVTW.VTWEG
Other Relations | to Master Data Relations ↑ Join Conditions
Planner Group for Customer Service and Plant Maintenance
  • Planner Group for Customer Service and Plant Maintenance
  • Maintenance Planning Plant
  • Client
  • 0NOTIFICATN_2_ATTR.INGRP == T024I.INGRP
  • 0NOTIFICATN_2_ATTR.IWERK == T024I.IWERK
  • 0NOTIFICATN_2_ATTR.MANDT == T024I.MANDT
Maintenance Planning Plant
  • Client
  • Maintenance Planning Plant
  • 0NOTIFICATN_2_ATTR.MANDT == T399I.MANDT
  • 0NOTIFICATN_2_ATTR.IWERK == T399I.IWERK