SAP Table QMFE
Quality notification - items
QMFE (Quality notification - items) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link QMFE to other SAP tables.
QMFE table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||
|
QMNUM
Notification No
|
QMNUM | QMEL |
CHAR
|
12 | 0 | |||||||||||
|
FENUM
Item Number in Item Record
|
FELFD |
NUMC
|
4 | 0 | ||||||||||||
|
ERNAM
Name of Person who Created the Object
|
ERNAM |
CHAR
|
12 | 0 | ||||||||||||
|
ERDAT
Date on Which Record Was Created
|
ERDAT |
DATS
|
8 | 0 | ||||||||||||
|
AENAM
Name of Person Who Changed Object
|
AENAM |
CHAR
|
12 | 0 | ||||||||||||
|
AEDAT
Changed On
|
AEDAT |
DATS
|
8 | 0 | ||||||||||||
|
FETXT
Notification Item Short Text
|
FETXT |
CHAR
|
40 | 0 | ||||||||||||
|
FEKAT
Catalog Type - Problems/Defects
|
FEKAT | TQ15 |
CHAR
|
1 | 0 | |||||||||||
|
FEGRP
Code Group - Problem
|
FEGRP | QPGR |
CHAR
|
8 | 0 | |||||||||||
|
FECOD
Problem or Damage Code
|
FECOD |
CHAR
|
4 | 0 | ||||||||||||
|
FEVER
Version Number
|
QVERSNR |
CHAR
|
6 | 0 | ||||||||||||
|
OTKAT
Catalog Type - Object Parts
|
OTKAT | TQ15 |
CHAR
|
1 | 0 | |||||||||||
|
OTGRP
Code Group - Object Parts
|
OTGRP | QPGR |
CHAR
|
8 | 0 | |||||||||||
|
OTEIL
Part of Object
|
OTEIL |
CHAR
|
4 | 0 | ||||||||||||
|
OTVER
Version Number
|
QVERSNR |
CHAR
|
6 | 0 | ||||||||||||
|
BAUTL
Assembly
|
BAUTL | MARA |
CHAR
|
18 | 0 | |||||||||||
|
EBORT
Installation Point for Subitem
|
EBORT |
CHAR
|
20 | 0 | ||||||||||||
|
INDTX
Object Long Text Available
|
INDLTX |
CHAR
|
1 | 0 | ||||||||||||
|
KZMLA
Primary language indicator for text segment
|
KZMLA |
CHAR
|
1 | 0 | ||||||||||||
|
ERZEIT
Time, at Which Record Was Added
|
ERZEIT |
TIMS
|
6 | 0 | ||||||||||||
|
AEZEIT
Time of Change
|
AEZEIT |
TIMS
|
6 | 0 | ||||||||||||
|
KZORG
Originating Defect
|
KZORG |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
WDFEH
Repetitive Defect
|
WDFEH |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
FEQKLAS
Defect Class
|
QFEHLKLAS | TQ17 |
CHAR
|
2 | 0 | |||||||||||
|
FCOAUFNR
Order Number (CO Order) for Item
|
QCOAUFNR | AUFK |
CHAR
|
12 | 0 | |||||||||||
|
FMGFRD
Defective Quantity for Item (External)
|
QMGFRD |
QUAN
|
13 | 3 | ||||||||||||
|
FMGEIG
Defective Quantity for Item (Internal)
|
QMGEIG |
QUAN
|
13 | 3 | ||||||||||||
|
FMGEIN
Unit of Measure for Item
|
QMGEIN | T006 |
UNIT
|
3 | 0 | |||||||||||
|
ANZFEHLER
Number of Defects Found
|
QANZFEHL4 |
INT4
|
10 | 0 | ||||||||||||
|
FEHLBEW
Defect Valuation
|
QFEHLBEW |
FLTP
|
16 | 16 | ||||||||||||
|
UNITFLBEW
Unit for Defect Valuation
|
QUNITFLBEW | T006 |
UNIT
|
3 | 0 | |||||||||||
|
FEART
Report Type for Defects Recording
|
QFEART | TQ86 |
CHAR
|
8 | 0 | |||||||||||
|
PNLKN
Current Node Number from Order Counter APLZL
|
QLFNKN |
NUMC
|
8 | 0 | ||||||||||||
|
MERKNR
Inspection Characteristic Number
|
QMERKNRP |
NUMC
|
4 | 0 | ||||||||||||
|
PROBENR
Sample Number
|
QPROBENR | QASV |
NUMC
|
6 | 0 | |||||||||||
|
PHYNR
Physical Sample Number
|
QPHYSPRNR | QPRS |
CHAR
|
12 | 0 | |||||||||||
|
PRUEFLINR
Single-Unit Number for the Unit to Be Inspected
|
QPRUEFLINR |
CHAR
|
18 | 0 | ||||||||||||
|
CROBJTY
Object types of the CIM resource
|
CR_OBJTY |
CHAR
|
2 | 0 | ||||||||||||
|
||||||||||||||||
|
ARBPL
Object ID of the Work Center
|
LGWID | CRID |
NUMC
|
8 | 0 | |||||||||||
|
ARBPLWERK
Plant for Work Center
|
QARBPWERKS | T001W |
CHAR
|
4 | 0 | |||||||||||
|
FENUMORG
Number of Original Item to Which Reference Is Made
|
QFENUMORG |
NUMC
|
4 | 0 | ||||||||||||
|
KZSYSFE
Systematic Defect
|
QKZSYSFE |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
KZLOESCH
Delete Data Record
|
KZLOESCH |
CHAR
|
1 | 0 | ||||||||||||
|
POSNR
Sort Number for Item
|
QLFDPOS |
NUMC
|
4 | 0 | ||||||||||||
|
HERPOS
Origin of Item Record
|
QMFEHERK |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
AUTKZ
Data Record Created with Function 'Create with Copy Model'
|
QAUTKZ |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
MATNR
Material Number
|
MATNR | MARA |
CHAR
|
18 | 0 | |||||||||||
|
WERKS
Plant
|
WERKS_D | T001W |
CHAR
|
4 | 0 | |||||||||||
|
EKORG
Purchasing Organization
|
EKORG | T024E |
CHAR
|
4 | 0 | |||||||||||
|
INFNR
Number of Purchasing Info Record
|
INFNR | EINA |
CHAR
|
10 | 0 | |||||||||||
|
KOSTL
Cost Center
|
KOSTL | CSKS |
CHAR
|
10 | 0 | |||||||||||
|
LSTAR
Activity Type
|
LSTAR | CSLA |
CHAR
|
6 | 0 | |||||||||||
|
PRZNR
Business Process
|
CO_PRZNR | CBPR |
CHAR
|
12 | 0 | |||||||||||
|
MENGE
Defective Quantity for Item (Internal)
|
QMGPOS |
QUAN
|
13 | 3 | ||||||||||||
|
EQUNR
Equipment Number
|
EQUNR |
CHAR
|
18 | 0 | ||||||||||||
|
TPLNR
Functional Location
|
TPLNR |
CHAR
|
30 | 0 | ||||||||||||
QMFE foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| QMFE | ARBPL | QMFE | MANDT |
CRID
CIM Resource - Entities
|
MANDT |
| QMFE | ARBPL | QMFE | CROBJTY |
CRID
CIM Resource - Entities
|
OBJTY |
| QMFE | ARBPL | QMFE | ARBPL |
CRID
CIM Resource - Entities
|
OBJID |
| QMFE | ARBPLWERK | QMFE | MANDT |
T001W
Plants/Branches
|
MANDT |
| QMFE | ARBPLWERK | QMFE | ARBPLWERK |
T001W
Plants/Branches
|
WERKS |
| QMFE | BAUTL | QMFE | MANDT |
MARA
General Material Data
|
MANDT |
| QMFE | BAUTL | QMFE | BAUTL |
MARA
General Material Data
|
MATNR |
| QMFE | EKORG | QMFE | EKORG |
T024E
Purchasing Organizations
|
EKORG |
| QMFE | EKORG | QMFE | MANDT |
T024E
Purchasing Organizations
|
MANDT |
| QMFE | FCOAUFNR | QMFE | MANDT |
AUFK
Order master data
|
MANDT |
| QMFE | FCOAUFNR | QMFE | FCOAUFNR |
AUFK
Order master data
|
AUFNR |
| QMFE | FEART | QMFE | MANDT |
TQ86
Report category for defects recording
|
MANDT |
| QMFE | FEART | QMFE | FEART |
TQ86
Report category for defects recording
|
FEART |
| QMFE | FEGRP | QMFE | FEGRP |
QPGR
Inspection catalog code groups
|
CODEGRUPPE |
| QMFE | FEGRP | QMFE | MANDT |
QPGR
Inspection catalog code groups
|
MANDT |
| QMFE | FEGRP | QMFE | FEKAT |
QPGR
Inspection catalog code groups
|
KATALOGART |
| QMFE | FEKAT | QMFE | MANDT |
TQ15
Inspection catalog type index
|
MANDT |
| QMFE | FEKAT | QMFE | FEKAT |
TQ15
Inspection catalog type index
|
KATALOGART |
| QMFE | FEQKLAS | QMFE | FEQKLAS |
TQ17
Defect classes
|
FEHLKLASSE |
| QMFE | FEQKLAS | QMFE | MANDT |
TQ17
Defect classes
|
MANDT |
| QMFE | FMGEIN | QMFE | MANDT |
T006
Units of Measurement
|
MANDT |
| QMFE | FMGEIN | QMFE | FMGEIN |
T006
Units of Measurement
|
MSEHI |
| QMFE | INFNR | QMFE | MANDT |
EINA
Purchasing Info Record: General Data
|
MANDT |
| QMFE | INFNR | QMFE | INFNR |
EINA
Purchasing Info Record: General Data
|
INFNR |
| QMFE | KOSTL | QMFE | KOSTL |
CSKS
Cost Center Master Data
|
KOSTL |
| QMFE | KOSTL | * |
CSKS
Cost Center Master Data
|
DATBI | |
| QMFE | KOSTL | QMFE | MANDT |
CSKS
Cost Center Master Data
|
MANDT |
| QMFE | KOSTL | ILOA | KOKRS |
CSKS
Cost Center Master Data
|
KOKRS |
| QMFE | LSTAR | * |
CSLA
Activity master
|
DATBI | |
| QMFE | LSTAR | QMFE | MANDT |
CSLA
Activity master
|
MANDT |
| QMFE | LSTAR | ILOA | KOKRS |
CSLA
Activity master
|
KOKRS |
| QMFE | LSTAR | QMFE | LSTAR |
CSLA
Activity master
|
LSTAR |
| QMFE | MANDT | QMFE | MANDT |
T000
Clients
|
MANDT |
| QMFE | MATNR | QMFE | MATNR |
MARA
General Material Data
|
MATNR |
| QMFE | MATNR | QMFE | MANDT |
MARA
General Material Data
|
MANDT |
| QMFE | OTGRP | QMFE | MANDT |
QPGR
Inspection catalog code groups
|
MANDT |
| QMFE | OTGRP | QMFE | OTKAT |
QPGR
Inspection catalog code groups
|
KATALOGART |
| QMFE | OTGRP | QMFE | OTGRP |
QPGR
Inspection catalog code groups
|
CODEGRUPPE |
| QMFE | OTKAT | QMFE | MANDT |
TQ15
Inspection catalog type index
|
MANDT |
| QMFE | OTKAT | QMFE | OTKAT |
TQ15
Inspection catalog type index
|
KATALOGART |
| QMFE | PHYNR | QMFE | MANDT |
QPRS
Master record for phys. samples
|
MANDT |
| QMFE | PHYNR | QMFE | PHYNR |
QPRS
Master record for phys. samples
|
PHYNR |
| QMFE | PROBENR | QMFE | PROBENR |
QASV
Sample specifications for inspection processing
|
PROBENR |
| QMFE | PROBENR | QMFE | MANDT |
QASV
Sample specifications for inspection processing
|
MANDANT |
| QMFE | PROBENR | QMEL | PRUEFLOS |
QASV
Sample specifications for inspection processing
|
PRUEFLOS |
| QMFE | PROBENR | QMEL | VORGLFNR |
QASV
Sample specifications for inspection processing
|
VORGLFNR |
| QMFE | PROBENR | QMFE | MERKNR |
QASV
Sample specifications for inspection processing
|
MERKNR |
| QMFE | PRZNR | QMFE | MANDT |
CBPR
CO-ABC: Activity Master Table
|
MANDT |
| QMFE | PRZNR | ILOA | KOKRS |
CBPR
CO-ABC: Activity Master Table
|
KOKRS |
| QMFE | PRZNR | QMFE | PRZNR |
CBPR
CO-ABC: Activity Master Table
|
PRZNR |
| QMFE | PRZNR | * |
CBPR
CO-ABC: Activity Master Table
|
DATBI | |
| QMFE | QMNUM | QMFE | MANDT |
QMEL
Quality Notification
|
MANDT |
| QMFE | QMNUM | QMFE | QMNUM |
QMEL
Quality Notification
|
QMNUM |
| QMFE | UNITFLBEW | QMFE | MANDT |
T006
Units of Measurement
|
MANDT |
| QMFE | UNITFLBEW | QMFE | UNITFLBEW |
T006
Units of Measurement
|
MSEHI |
| QMFE | WERKS | QMFE | MANDT |
T001W
Plants/Branches
|
MANDT |
| QMFE | WERKS | QMFE | WERKS |
T001W
Plants/Branches
|
WERKS |