2LIS_05_Q0NOTIF

Quality Notifications | #TRAN | Extraction method: F1 | Delta: ABR | Component: Quality Management
Tables used: QMELVBAPVBRPLIPSPMSDO ... +187 more
Column Name Description
EKORG FK Purchasing organization
MATNR FK Material Number
QMNUM Notification Number
SPART FK Division
VKORG FK Sales Organization
VTWEG FK Distribution Channel
Column Name Description
Column Name Description
📏 Base Unit of Measure (BASIC_UNIT):
BMGEIG Internal Defective Quantity in Base Units of Measure
BMGFRD External Defective Quantity in Base Units of Measure
BRGMNG Return Delivery Quantity in Base Units of Measure
BRKMNG Complaint Quantity in Base Units of Measure
📏 Unit of Measure (MGEIN):
MGEIG Defective Quantity (Internal)
MGFRD Defective Quantity (External)
RGMNG Return Delivery Quantity
RKMNG Complaint Quantity
Column Name Description
QMDAT Date of Notification
Column Name Description
ROCANCEL Indicator: Cancel Data Record Show values
HERKZ Origin of Notification Show values
Column Name Description Domain name
KUNUM Customer Number KUNNR
SUMDLZT Total Lead Time of Notifications QSTATWERT
ZHLERL_TE Number of Notifications Completed on Schedule INT4
ZHLMAOF Number of Tasks with Status 'Outstanding' or 'Released' INT4
ZHLMASS No. of Tasks INT4
ZHLMELD No. of Notifications INT4
ZHLMERF No. of Tasks with Status Successful INT4
ZHLMOFN No. of Notifications with Status Outstanding INT4
Master Data Relations Join Conditions
Purchasing organization
  • Client
  • Purchasing organization
  • 2LIS_05_Q0NOTIF.MANDT == T024E.MANDT
  • 2LIS_05_Q0NOTIF.EKORG == T024E.EKORG
Supplier Account Number
  • Client
  • Supplier Account Number
  • 2LIS_05_Q0NOTIF.MANDT == LFA1.MANDT
  • 2LIS_05_Q0NOTIF.LIFNUM == LFA1.LIFNR
Material Number
  • Client
  • Material Number
  • 2LIS_05_Q0NOTIF.MANDT == MARA.MANDT
  • 2LIS_05_Q0NOTIF.MATNR == MARA.MATNR
Plant for Material
  • Client
  • Plant for Material
  • 2LIS_05_Q0NOTIF.MANDT == T001W.MANDT
  • 2LIS_05_Q0NOTIF.MAWERK == T001W.WERKS
Unit of Measure
  • Client
  • Unit of Measure
  • 2LIS_05_Q0NOTIF.MANDT == T006.MANDT
  • 2LIS_05_Q0NOTIF.MGEIN == T006.MSEHI
Notification Type
  • Client
  • Notification Type
  • 2LIS_05_Q0NOTIF.MANDT == TQ80.MANDT
  • 2LIS_05_Q0NOTIF.QMART == TQ80.QMART
Division
  • Client
  • Division
  • 2LIS_05_Q0NOTIF.MANDT == TSPA.MANDT
  • 2LIS_05_Q0NOTIF.SPART == TSPA.SPART
Sales Organization
  • Client
  • Sales Organization
  • 2LIS_05_Q0NOTIF.MANDT == TVKO.MANDT
  • 2LIS_05_Q0NOTIF.VKORG == TVKO.VKORG
Distribution Channel
  • Client
  • Distribution Channel
  • 2LIS_05_Q0NOTIF.MANDT == TVTW.MANDT
  • 2LIS_05_Q0NOTIF.VTWEG == TVTW.VTWEG