2LIS_18_I0TASK

Service Notifications - Tasks | #TRAN | Extraction method: F1 | Delta: ABR | Component: Customer Service
Tables used: QMFE, QMEL, QMSM, VBAP, VBAK ... +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
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
FECOD Problem or Damage Code QCODE
OTEIL Part of Object QCODE
MNCOD Task Code QCODE
ZHLMAOF Number of Tasks with Status 'Outstanding' or 'Released' INT4
ZHLMASS No. of Tasks INT4
ZHLMERF No. of Tasks with Status Successful INT4
KEY_MANUM Sequential Task Number NUM4
Master Data Relations Join Conditions
Assembly
  • Client
  • Assembly
  • Assembly
  • 2LIS_18_I0TASK.MANDT == MARA.MANDT
  • 2LIS_18_I0TASK.BAUTL == MARA.MATNR
  • 2LIS_18_I0TASK.BAUTL_HD == MARA.MATNR
Assembly
  • Client
  • Assembly
  • Assembly
  • 2LIS_18_I0TASK.MANDT == MARA.MANDT
  • 2LIS_18_I0TASK.BAUTL == MARA.MATNR
  • 2LIS_18_I0TASK.BAUTL_HD == MARA.MATNR
Code Group - Problem
  • Client
  • Code Group - Problem
  • Catalog Type - Problems/Defects
  • 2LIS_18_I0TASK.MANDT == QPGR.MANDT
  • 2LIS_18_I0TASK.FEGRP == QPGR.CODEGRUPPE
  • 2LIS_18_I0TASK.FEKAT == QPGR.KATALOGART
Catalog Type - Problems/Defects
  • Client
  • Catalog Type - Problems/Defects
  • 2LIS_18_I0TASK.MANDT == TQ15.MANDT
  • 2LIS_18_I0TASK.FEKAT == TQ15.KATALOGART
Defect Class
  • Client
  • Defect Class
  • 2LIS_18_I0TASK.MANDT == TQ17.MANDT
  • 2LIS_18_I0TASK.FEQKLAS == TQ17.FEHLKLASSE
Code Group - Tasks
  • Client
  • Code Group - Tasks
  • Catalog Type - Tasks
  • 2LIS_18_I0TASK.MANDT == QPGR.MANDT
  • 2LIS_18_I0TASK.MNGRP == QPGR.CODEGRUPPE
  • 2LIS_18_I0TASK.MNKAT == QPGR.KATALOGART
Catalog Type - Tasks
  • Client
  • Catalog Type - Tasks
  • 2LIS_18_I0TASK.MANDT == TQ15.MANDT
  • 2LIS_18_I0TASK.MNKAT == TQ15.KATALOGART
Code Group - Object Parts
  • Client
  • Code Group - Object Parts
  • Catalog Type - Object Parts
  • 2LIS_18_I0TASK.MANDT == QPGR.MANDT
  • 2LIS_18_I0TASK.OTGRP == QPGR.CODEGRUPPE
  • 2LIS_18_I0TASK.OTKAT == QPGR.KATALOGART
Catalog Type - Object Parts
  • Client
  • Catalog Type - Object Parts
  • 2LIS_18_I0TASK.MANDT == TQ15.MANDT
  • 2LIS_18_I0TASK.OTKAT == TQ15.KATALOGART
Notification Type
  • Client
  • Notification Type
  • 2LIS_18_I0TASK.MANDT == TQ80.MANDT
  • 2LIS_18_I0TASK.QMART == TQ80.QMART
Division
  • Client
  • Division
  • 2LIS_18_I0TASK.MANDT == TSPA.MANDT
  • 2LIS_18_I0TASK.SPART == TSPA.SPART
Sales Organization
  • Client
  • Sales Organization
  • 2LIS_18_I0TASK.MANDT == TVKO.MANDT
  • 2LIS_18_I0TASK.VKORG == TVKO.VKORG
Distribution Channel
  • Client
  • Distribution Channel
  • 2LIS_18_I0TASK.MANDT == TVTW.MANDT
  • 2LIS_18_I0TASK.VTWEG == TVTW.VTWEG