2LIS_18_I0NOTIF

Service Notifications | #TRAN | Extraction method: F1 | Delta: ABR | Component: Customer Service
Tables used: QMELVBAPQMFEVBAKEKPV ... +187 more
Column Name Description
EQUNR Equipment Number
QMNUM Notification Number
SPART FK Division
TPLNR Functional Location
VKORG FK Sales Organization
VTWEG FK Distribution Channel
Column Name Description
Column Name Description
Column Name Description
AUSBS End of Malfunction (Date)
AUSVN Start of Malfunction (Date)
AUZTB End of Malfunction (Time)
AUZTV Start of Malfunction (Time)
QMDAT Date of Notification
Column Name Description
ROCANCEL Indicator: Cancel Data Record Show values
HERKZ Origin of Notification Show values
MSAUS Breakdown Indicator Show values
Column Name Description Domain name
AUSZT1 Breakdown Duration FLTP
BAUTL_HD Assembly MATNR
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
Notification Type
  • Client
  • Notification Type
  • 2LIS_18_I0NOTIF.MANDT == TQ80.MANDT
  • 2LIS_18_I0NOTIF.QMART == TQ80.QMART
Division
  • Client
  • Division
  • 2LIS_18_I0NOTIF.MANDT == TSPA.MANDT
  • 2LIS_18_I0NOTIF.SPART == TSPA.SPART
Sales Organization
  • Client
  • Sales Organization
  • 2LIS_18_I0NOTIF.MANDT == TVKO.MANDT
  • 2LIS_18_I0NOTIF.VKORG == TVKO.VKORG
Distribution Channel
  • Client
  • Distribution Channel
  • 2LIS_18_I0NOTIF.MANDT == TVTW.MANDT
  • 2LIS_18_I0NOTIF.VTWEG == TVTW.VTWEG