SAP table QMFE (Quality notification - items / Defect)

SAP table QMFE has 3 primary key fields being MANDT,QMNUM,FENUM.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
QMNUM Notification Number CHAR 12 0 QMEL QMNUM
FENUM Item Number in Item Record NUMC 4 0 FELFD
CATEGORY Defect Category CHAR 2 0 TQDEFCAT QDEFCATEGORY
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ERDAT Date on which the record was created DATS 8 0 ERDAT
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
AEDAT Last Changed On DATS 8 0 AEDAT
FETXT Notification Item Short Text CHAR 40 0 FETXT
FEKAT Catalog Type - Problems/Defects CHAR 1 0 TQ15 FEKAT
FEGRP Code Group - Problem CHAR 8 0 QPGR FEGRP
FECOD Problem or Damage Code CHAR 4 0 FECOD
FEVER Version Number CHAR 6 0 QVERSNR
OTKAT Catalog Type - Object Parts CHAR 1 0 TQ15 OTKAT
OTGRP Code Group - Object Parts CHAR 8 0 QPGR OTGRP
OTEIL Part of Object CHAR 4 0 OTEIL
OTVER Version Number CHAR 6 0 QVERSNR
INITIALCAUSECAT Catalog Type - Causes CHAR 1 0 URKAT
INITIALCAUSEGROUP Code Group - Causes CHAR 8 0 URGRP
INITIALCAUSECODE Cause Code CHAR 4 0 URCOD
INITIALCAUSECODEVER Version Number CHAR 6 0 QVERSNR
BAUTL Assembly CHAR 40 0 MARA BAUTL
EBORT Installation Point for Subitem CHAR 20 0 EBORT
INDTX Object Long Text Available CHAR 1 0 INDLTX
KZMLA Primary language indicator for text segment CHAR 1 0 KZMLA
ERZEIT Time at Which Record Was Added TIMS 6 0 ERZEIT
AEZEIT Time of Change TIMS 6 0 AEZEIT
KZORG Originating Defect CHAR 1 0 KZORG
WDFEH Repetitive Defect CHAR 1 0 WDFEH
FEQKLAS Defect Class CHAR 2 0 TQ17 QFEHLKLAS
FCOAUFNR Order Number (CO Order) for Item CHAR 12 0 AUFK QCOAUFNR
FMGFRD Defective Quantity for Item (External) QUAN 13 3 QMGFRD
FMGEIG Defective Quantity for Item (Internal) QUAN 13 3 QMGEIG
FMGEIN Unit of Measure for Item UNIT 3 0 T006 QMGEIN
ANZFEHLER Number of Defects Found INT4 10 0 QANZFEHL4
FEHLBEW Defect Valuation FLTP 16 16 QFEHLBEW
UNITFLBEW Unit for Defect Valuation UNIT 3 0 T006 QUNITFLBEW
FEART Report Type for Defects Recording CHAR 8 0 TQ86 QFEART
FERTAUFNR Order Number (Production Order) CHAR 12 0 FERTAUFNR
FERTAUFPL Plan Number for Operations in Order (Production Order) NUMC 10 0 FERTAUFPL
PNLKN Current Node Number from Order Counter NUMC 8 0 QLFNKN
MERKNR Inspection Characteristic Number NUMC 4 0 QMERKNRP
PROBENR Inspection Sample Number NUMC 6 0 QASV QPROBENR
PHYNR Material Sample Number CHAR 12 0 QPRS QPHYSPRNR
PRUEFLINR Single-Unit Number for Unit to Be Inspected CHAR 18 0 QPRUEFLINR
CROBJTY Object types of the CIM resource CHAR 2 0 CR_OBJTY
A Work Center
AA Work center alias
FH Production resources/tools
G Group
H Hierarchy
ARBPL Object ID of the Work Center NUMC 8 0 CRID LGWID
ARBPLWERK Plant for Work Center CHAR 4 0 T001W QARBPWERKS
FENUMORG Number of Original Item to Which Reference Is Made NUMC 4 0 QFENUMORG
KZSYSFE Systematic Defect CHAR 1 0 QKZSYSFE
KZLOESCH Delete Data Record CHAR 1 0 KZLOESCH
POSNR Sort Number for Item NUMC 4 0 QLFDPOS
HERPOS Origin of Item Record CHAR 1 0 QMFEHERK
G Automatically generated defect record
AUTKZ Data Record Created with Function 'Create with Copy Model' CHAR 1 0 QAUTKZ
MATNR Material Number CHAR 40 0 MARA MATNR
WERKS Plant CHAR 4 0 T001W WERKS_D
LGORT Storage location CHAR 4 0 LGORT_D
EKORG Purchasing organization CHAR 4 0 T024E EKORG
INFNR Number of purchasing info record CHAR 10 0 EINA INFNR
KOSTL Cost Center CHAR 10 0 CSKS KOSTL
LSTAR Activity Type CHAR 6 0 CSLA LSTAR
PRZNR Business Process CHAR 12 0 CBPR CO_PRZNR
MENGE Defective Quantity for Item (Internal) QUAN 13 3 QMGPOS
EQUNR Equipment Number CHAR 18 0 EQUNR
TPLNR Functional Location CHAR 30 0 TPLNR
PRUEFLOS Inspection Lot Number NUMC 12 0 QPLOS
CHARG Batch Number CHAR 10 0 CHARG_D
OA_ID Identifies an Operation Activity INT8 19 0 MPE_OA_ID
OA_VERSION_NO Number of an Operation Actiivity Version INT4 10 0 MPE_OA_VERSION_NO
DEFREFNUM Defect Key CHAR 12 0 QDEFREFNUM
RBNR Catalog Profile CHAR 9 0 RBNR
CHANGEDDATETIME UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 TZNTSTMPS
STATLCYCLE Defect Status CHAR 2 0 QDEFLCYCLESTAT
00 Created
10 Not Relevant
12 In Process
20 Completed
STATPANALYSIS Problem Analysis CHAR 2 0 QDEFPANASTAT
00 Initial
10 Required
20 Completed
EXTREFNUM External Reference Number CHAR 40 0 QEXTREFNUM
ISAUTOCREATED Defect Created Automatically CHAR 1 0 QISDEFECTCREATEDAUTOMATICALLY
undefined or false
X true
INTERNALID Internal Defect ID CHAR 12 0 QDEFECTINTERNALID
REPUSER Notification Item Reported By CHAR 12 0 QFREPUSER
REPONDATE Notification Item Reported On DATS 8 0 QFREPONDATE
REPATTIME Notification Item Reported At TIMS 6 0 QFREPATTIME
DEFECTUUID Defect UUID RAW 16 0 QDEFECTUUID
DEFECTCAUSEDBY Defect Caused By CHAR 2 0 QDEFECTCAUSEDBY
BOM_ITEM_INSTANCE Internal Identification for DMU Objects of Type RAW 16 RAW 16 0 DMU_GUID16
DUMMY_QMFE_INCL_EEW_PS Dummy function in length 1 CHAR 1 0 DUMMY
PRVBE Production Supply Area CHAR 10 0 * PRVBE
VLPLA Source Storage Bin CHAR 18 0 * /SCWM/LTAP_VLPLA
LGNUM Warehouse Number/Warehouse Complex CHAR 4 0 /SCWM/LGNUM
VLTYP Source Storage Type CHAR 4 0 * /SCWM/LTAP_VLTYP
PROD_MATNR Material Number CHAR 40 0 MATNR
PROD_SERNR Serial Number CHAR 18 0 GERNR

QMFE foreign key relationships

Table Field Check Table Check Field
0 QMFE ARBPL CRID CIM Resource - Entities MANDT
0 QMFE ARBPL CRID CIM Resource - Entities OBJID
1 QMFE ARBPLWERK T001W Plants/Branches MANDT
1 QMFE ARBPLWERK T001W Plants/Branches WERKS
0 QMFE BAUTL MARA General Material Data MANDT
0 QMFE BAUTL MARA General Material Data MATNR
1 QMFE CATEGORY TQDEFCAT Defect Category MANDANT
1 QMFE CATEGORY TQDEFCAT Defect Category CATEGORY
0 QMFE EKORG T024E Purchasing Organizations EKORG
1 QMFE FCOAUFNR AUFK Order master data AUFNR
0 QMFE FEART TQ86 Report category for defects recording MANDT
1 QMFE FEGRP QPGR Inspection catalog code groups MANDT
1 QMFE FEGRP QPGR Inspection catalog code groups KATALOGART
0 QMFE FEKAT TQ15 Inspection catalog type index KATALOGART
1 QMFE FEQKLAS TQ17 Defect classes MANDT
0 QMFE FMGEIN T006 Units of Measurement MANDT
0 QMFE FMGEIN T006 Units of Measurement MSEHI
1 QMFE INFNR EINA Purchasing Info Record: General Data INFNR
0 QMFE KOSTL CSKS Cost Center Master Record MANDT
0 QMFE KOSTL CSKS Cost Center Master Record KOKRS
0 QMFE KOSTL CSKS Cost Center Master Record KOSTL
0 QMFE KOSTL CSKS Cost Center Master Record DATBI
1 QMFE LSTAR CSLA Activity master MANDT
1 QMFE LSTAR CSLA Activity master KOKRS
1 QMFE LSTAR CSLA Activity master DATBI
0 QMFE MATNR MARA General Material Data MANDT
0 QMFE MATNR MARA General Material Data MATNR
1 QMFE OTGRP QPGR Inspection catalog code groups MANDT
1 QMFE OTGRP QPGR Inspection catalog code groups KATALOGART
0 QMFE OTKAT TQ15 Inspection catalog type index KATALOGART
1 QMFE PHYNR QPRS Master Record for Material Samples MANDT
1 QMFE PHYNR QPRS Master Record for Material Samples PHYNR
0 QMFE PROBENR QASV Sample specifications for inspection processing MANDANT
0 QMFE PROBENR QASV Sample specifications for inspection processing PRUEFLOS
0 QMFE PROBENR QASV Sample specifications for inspection processing VORGLFNR
0 QMFE PROBENR QASV Sample specifications for inspection processing MERKNR
0 QMFE PROBENR QASV Sample specifications for inspection processing PROBENR
1 QMFE PRZNR CBPR CO-ABC: Activity Master Table KOKRS
1 QMFE PRZNR CBPR CO-ABC: Activity Master Table PRZNR
1 QMFE PRZNR CBPR CO-ABC: Activity Master Table DATBI
0 QMFE QMNUM QMEL Quality Notification MANDT
0 QMFE QMNUM QMEL Quality Notification QMNUM
1 QMFE UNITFLBEW T006 Units of Measurement MANDT
1 QMFE UNITFLBEW T006 Units of Measurement MSEHI
0 QMFE WERKS T001W Plants/Branches MANDT
0 QMFE WERKS T001W Plants/Branches WERKS