2LIS_05_Q0ITEM

Quality Notifications - Items | #TRAN | Extraction method: F1 | Delta: ABR | Component: Quality Management
Tables used: QMFE, QMEL, VBAP, VBRP, LIPS ... +187 more
Column Name Description
EKORG FK Purchasing organization
MATNR 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):
BFMGEIG Internal Defective Quantity for Item in Base Unit of Measure
BFMGFRD Extern. Defective Quantity for Item in Base Units of Measure
📏 Unit of Measure for Item (FMGEIN):
FMGEIG Defective Quantity for Item (Internal)
FMGFRD Defective Quantity for Item (External)
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
FEHLBEW Defect Valuation FLTP
OTEIL Part of Object QCODE
ZHLPROBL Problem Frequency INT4
KEY_FENUM Item Number in Item Record FELFD
Master Data Relations Join Conditions
Assembly
  • Client
  • Assembly
  • 2LIS_05_Q0ITEM.MANDT == MARA.MANDT
  • 2LIS_05_Q0ITEM.BAUTL == MARA.MATNR
Purchasing organization
  • Client
  • Purchasing organization
  • 2LIS_05_Q0ITEM.MANDT == T024E.MANDT
  • 2LIS_05_Q0ITEM.EKORG == T024E.EKORG
Code Group - Problem
  • Client
  • Code Group - Problem
  • Catalog Type - Problems/Defects
  • 2LIS_05_Q0ITEM.MANDT == QPGR.MANDT
  • 2LIS_05_Q0ITEM.FEGRP == QPGR.CODEGRUPPE
  • 2LIS_05_Q0ITEM.FEKAT == QPGR.KATALOGART
Catalog Type - Problems/Defects
  • Client
  • Catalog Type - Problems/Defects
  • 2LIS_05_Q0ITEM.MANDT == TQ15.MANDT
  • 2LIS_05_Q0ITEM.FEKAT == TQ15.KATALOGART
Defect Class
  • Client
  • Defect Class
  • 2LIS_05_Q0ITEM.MANDT == TQ17.MANDT
  • 2LIS_05_Q0ITEM.FEQKLAS == TQ17.FEHLKLASSE
Unit of Measure for Item
  • Client
  • Unit of Measure for Item
  • 2LIS_05_Q0ITEM.MANDT == T006.MANDT
  • 2LIS_05_Q0ITEM.FMGEIN == T006.MSEHI
Supplier Account Number
  • Client
  • Supplier Account Number
  • 2LIS_05_Q0ITEM.MANDT == LFA1.MANDT
  • 2LIS_05_Q0ITEM.LIFNUM == LFA1.LIFNR
Plant for Material
  • Client
  • Plant for Material
  • 2LIS_05_Q0ITEM.MANDT == T001W.MANDT
  • 2LIS_05_Q0ITEM.MAWERK == T001W.WERKS
Code Group - Object Parts
  • Client
  • Code Group - Object Parts
  • Catalog Type - Object Parts
  • 2LIS_05_Q0ITEM.MANDT == QPGR.MANDT
  • 2LIS_05_Q0ITEM.OTGRP == QPGR.CODEGRUPPE
  • 2LIS_05_Q0ITEM.OTKAT == QPGR.KATALOGART
Catalog Type - Object Parts
  • Client
  • Catalog Type - Object Parts
  • 2LIS_05_Q0ITEM.MANDT == TQ15.MANDT
  • 2LIS_05_Q0ITEM.OTKAT == TQ15.KATALOGART
Notification Type
  • Client
  • Notification Type
  • 2LIS_05_Q0ITEM.MANDT == TQ80.MANDT
  • 2LIS_05_Q0ITEM.QMART == TQ80.QMART
Division
  • Client
  • Division
  • 2LIS_05_Q0ITEM.MANDT == TSPA.MANDT
  • 2LIS_05_Q0ITEM.SPART == TSPA.SPART
Unit for Defect Valuation
  • Client
  • Unit for Defect Valuation
  • 2LIS_05_Q0ITEM.MANDT == T006.MANDT
  • 2LIS_05_Q0ITEM.UNITFLBEW == T006.MSEHI
Sales Organization
  • Client
  • Sales Organization
  • 2LIS_05_Q0ITEM.MANDT == TVKO.MANDT
  • 2LIS_05_Q0ITEM.VKORG == TVKO.VKORG
Distribution Channel
  • Client
  • Distribution Channel
  • 2LIS_05_Q0ITEM.MANDT == TVTW.MANDT
  • 2LIS_05_Q0ITEM.VTWEG == TVTW.VTWEG