SAP Table RQMQMFE
Quality notification - items (reporting)
RQMQMFE (Quality notification - items (reporting)) 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 RQMQMFE to other SAP tables.
RQMQMFE 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 | ||||||||
|
FEHLBEWC
Quantitative Defect Valuation
|
QFEHLBEWC |
CHAR
|
10 | 0 | ||||||||
|
UNITFLBEW
Unit for Defect Valuation
|
QUNITFLBEW | T006 |
UNIT
|
3 | 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 | ||||||||
|
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 | ||||||||
|
||||||||||||
|
FEKTXTCD
Code Text for Problem
|
FECODETEXT |
CHAR
|
80 | 0 | ||||||||
|
FEKTXTGR
Code Group Text for Problem
|
FEGRPTEXT |
CHAR
|
40 | 0 | ||||||||
|
OTKTXTCD
Code Text for Object Part
|
OTCODETEXT |
CHAR
|
80 | 0 | ||||||||
|
OTKTXTGR
Code Group Text for Object Part
|
OTGRPTEXT |
CHAR
|
40 | 0 | ||||||||
|
URNUM
Sequential Number for Cause
|
URNUM |
NUMC
|
4 | 0 | ||||||||
|
QURNUM
Sort Number for Cause
|
QURNUM |
NUMC
|
4 | 0 | ||||||||
|
URTXT
Cause Text
|
URSTX |
CHAR
|
40 | 0 | ||||||||
|
URKAT
Catalog Type - Causes
|
URKAT | TQ15 |
CHAR
|
1 | 0 | |||||||
|
URGRP
Code Group - Causes
|
URGRP | QPGR |
CHAR
|
8 | 0 | |||||||
|
URCOD
Cause Code
|
URCOD | QPCD |
CHAR
|
4 | 0 | |||||||
|
KTXTCD
Code Text for Cause
|
URCODETEXT |
CHAR
|
80 | 0 | ||||||||
|
KTXTGR
Code Group Text for Cause
|
URGRPTEXT |
CHAR
|
40 | 0 | ||||||||
|
QMART
Notification Type
|
QMART | TQ80 |
CHAR
|
2 | 0 | |||||||
|
QMTXT
Short Text
|
QMTXT |
CHAR
|
40 | 0 | ||||||||
|
ARTPR
Priority Type
|
ARTPR | T356A |
CHAR
|
2 | 0 | |||||||
|
PRIOK
Priority
|
PRIOK | T356 |
CHAR
|
1 | 0 | |||||||
|
STTXT
System Status for Notification
|
QMSTTXT |
CHAR
|
40 | 0 | ||||||||
|
MZEIT
Time of Notification
|
MZEIT |
TIMS
|
6 | 0 | ||||||||
|
QMDAT
Date of Notification
|
QMDAT |
DATS
|
8 | 0 | ||||||||
|
QMNAM
Name of Person Reporting Notification
|
QMNAM |
CHAR
|
12 | 0 | ||||||||
|
STRMN
Required start date
|
STRMN |
DATS
|
8 | 0 | ||||||||
|
STRUR
Required Start Time
|
STRUR |
TIMS
|
6 | 0 | ||||||||
|
LTRMN
Required End Date
|
LTRMN |
DATS
|
8 | 0 | ||||||||
|
LTRUR
Requested End Time
|
LTRUR |
TIMS
|
6 | 0 | ||||||||
|
QMDAB
Date for Notification Completion
|
QMDAB |
DATS
|
8 | 0 | ||||||||
|
QMZAB
Completion Time of Notification
|
QMZAB |
TIMS
|
6 | 0 | ||||||||
|
BARBZT
Processing Time
|
BARBZT |
DEC
|
11 | 2 | ||||||||
|
MARBEH
Processing Time Unit
|
MARBEH | T006 |
UNIT
|
3 | 0 | |||||||
|
MAWERK
Plant for Material
|
QMAWERKS | T001W |
CHAR
|
4 | 0 | |||||||
|
REVLV
Revision Level
|
REVLV |
CHAR
|
2 | 0 | ||||||||
|
MATNR
Material Number
|
MATNR | MARA |
CHAR
|
18 | 0 | |||||||
|
KUNUM
Account Number of Customer
|
QKUNUM | KNA1 |
CHAR
|
10 | 0 | |||||||
|
RBNR
Catalog Profile
|
RBNR | T352B |
CHAR
|
9 | 0 | |||||||
|
LIFNUM
Vendor Account Number
|
LIFNUM | LFA1 |
CHAR
|
10 | 0 | |||||||
|
BUNAME
Author of a Q/PM Notification
|
BUNAME |
CHAR
|
12 | 0 | ||||||||
|
ADRNR
Addresses: Address Number
|
CADNR |
CHAR
|
10 | 0 | ||||||||
|
COAUFNR
Order Number (QM Order)
|
COAUFNR | AUFK |
CHAR
|
12 | 0 | |||||||
|
NAME_LIST
Name for list displays
|
I_NAME_LST |
CHAR
|
35 | 0 | ||||||||
|
TEL_NUMBER
First telephone no.: dialling code+number
|
AD_TLNMBR1 |
CHAR
|
30 | 0 | ||||||||
|
POST_CODE1
City postal code
|
AD_PSTCD1 |
CHAR
|
10 | 0 | ||||||||
|
CITY1
City
|
AD_CITY1 |
CHAR
|
40 | 0 | ||||||||
|
CITY2
District
|
AD_CITY2 |
CHAR
|
40 | 0 | ||||||||
|
COUNTRY
Country Key
|
LAND1 |
CHAR
|
3 | 0 | ||||||||
|
REGION
Region (State, Province, County)
|
REGIO |
CHAR
|
3 | 0 | ||||||||
|
STREET
Street
|
AD_STREET |
CHAR
|
60 | 0 | ||||||||
|
AUSVN
Start of Malfunction (Date)
|
AUSVN |
DATS
|
8 | 0 | ||||||||
|
AUZTV
Start of Malfunction (Time)
|
AUZTV |
TIMS
|
6 | 0 | ||||||||
|
AUSBS
End of Malfunction (Date)
|
AUSBS |
DATS
|
8 | 0 | ||||||||
|
AUZTB
End of Malfunction (Time)
|
AUZTB |
TIMS
|
6 | 0 | ||||||||
|
VORNR
Operation Number
|
QVORNR |
CHAR
|
4 | 0 | ||||||||
|
VORKTEXT
Short Text
|
QKURZTEXT |
CHAR
|
40 | 0 | ||||||||
|
FERTVORNR
Operation Number
|
QVORNR |
CHAR
|
4 | 0 | ||||||||
|
FERTVORKTX
Short Text
|
QKURZTEXT |
CHAR
|
40 | 0 | ||||||||
|
PRUEFLOS
Inspection Lot Number
|
QPLOS |
NUMC
|
12 | 0 | ||||||||
|
PNLKN
Current Node Number from Order Counter APLZL
|
QLFNKN |
NUMC
|
8 | 0 | ||||||||
|
FERTAUFNR
Order Number (Production Order)
|
FERTAUFNR |
CHAR
|
12 | 0 | ||||||||
|
FERTAUFPL
Plan Number for Operations in Order (Production Order)
|
FERTAUFPL |
NUMC
|
10 | 0 | ||||||||
|
ARBPL
Object ID of the Work Center
|
LGWID |
NUMC
|
8 | 0 | ||||||||
|
ARBPLWERK
Plant for Work Center
|
QARBPWERKS |
CHAR
|
4 | 0 | ||||||||
|
ARBPL_I
Work center
|
ARBPL |
CHAR
|
8 | 0 | ||||||||
|
PRIOKX
Priority Text
|
PRIOKX |
CHAR
|
20 | 0 | ||||||||
|
HERSTELLER
Number of Manufacturer
|
QLIFNR |
CHAR
|
10 | 0 | ||||||||
|
MATKTX
Material Description (Short Text)
|
MAKTX |
CHAR
|
40 | 0 | ||||||||
|
BAUTX
Description of PM Assembly
|
BAUTX |
CHAR
|
40 | 0 | ||||||||
RQMQMFE foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| RQMQMFE | ARTPR | QMFE | MANDT |
T356A
Priority type table
|
MANDT |
| RQMQMFE | ARTPR | RQMQMFE | ARTPR |
T356A
Priority type table
|
ARTPR |
| RQMQMFE | BAUTL | RQMQMFE | MANDT |
MARA
General Material Data
|
MANDT |
| RQMQMFE | BAUTL | RQMQMFE | BAUTL |
MARA
General Material Data
|
MATNR |
| RQMQMFE | COAUFNR | QMFE | MADT |
AUFK
Order master data
|
MANDT |
| RQMQMFE | COAUFNR | RQMQMFE | COAUFNR |
AUFK
Order master data
|
AUFNR |
| RQMQMFE | FCOAUFNR | RQMQMFE | MANDT |
AUFK
Order master data
|
MANDT |
| RQMQMFE | FCOAUFNR | RQMQMFE | FCOAUFNR |
AUFK
Order master data
|
AUFNR |
| RQMQMFE | FEGRP | RQMQMFE | MANDT |
QPGR
Inspection catalog code groups
|
MANDT |
| RQMQMFE | FEGRP | RQMQMFE | FEKAT |
QPGR
Inspection catalog code groups
|
KATALOGART |
| RQMQMFE | FEGRP | RQMQMFE | FEGRP |
QPGR
Inspection catalog code groups
|
CODEGRUPPE |
| RQMQMFE | FEKAT | RQMQMFE | MANDT |
TQ15
Inspection catalog type index
|
MANDT |
| RQMQMFE | FEKAT | RQMQMFE | FEKAT |
TQ15
Inspection catalog type index
|
KATALOGART |
| RQMQMFE | FEQKLAS | RQMQMFE | MANDT |
TQ17
Defect classes
|
MANDT |
| RQMQMFE | FEQKLAS | RQMQMFE | FEQKLAS |
TQ17
Defect classes
|
FEHLKLASSE |
| RQMQMFE | FMGEIN | RQMQMFE | MANDT |
T006
Units of Measurement
|
MANDT |
| RQMQMFE | FMGEIN | RQMQMFE | FMGEIN |
T006
Units of Measurement
|
MSEHI |
| RQMQMFE | KUNUM | QMFE | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| RQMQMFE | KUNUM | RQMQMFE | KUNUM |
KNA1
General Data in Customer Master
|
KUNNR |
| RQMQMFE | LIFNUM | QMFE | MANDT |
LFA1
Vendor Master (General Section)
|
MANDT |
| RQMQMFE | LIFNUM | RQMQMFE | LIFNUM |
LFA1
Vendor Master (General Section)
|
LIFNR |
| RQMQMFE | MANDT | RQMQMFE | MANDT |
T000
Clients
|
MANDT |
| RQMQMFE | MARBEH | QMFE | MANDT |
T006
Units of Measurement
|
MANDT |
| RQMQMFE | MARBEH | RQMQMFE | MARBEH |
T006
Units of Measurement
|
MSEHI |
| RQMQMFE | MATNR | RQMQMFE | MATNR |
MARA
General Material Data
|
MATNR |
| RQMQMFE | MATNR | QMFE | MANDT |
MARA
General Material Data
|
MANDT |
| RQMQMFE | MAWERK | QMFE | MANDT |
T001W
Plants/Branches
|
MANDT |
| RQMQMFE | MAWERK | RQMQMFE | MAWERK |
T001W
Plants/Branches
|
WERKS |
| RQMQMFE | OTGRP | RQMQMFE | MANDT |
QPGR
Inspection catalog code groups
|
MANDT |
| RQMQMFE | OTGRP | RQMQMFE | OTKAT |
QPGR
Inspection catalog code groups
|
KATALOGART |
| RQMQMFE | OTGRP | RQMQMFE | OTGRP |
QPGR
Inspection catalog code groups
|
CODEGRUPPE |
| RQMQMFE | OTKAT | RQMQMFE | OTKAT |
TQ15
Inspection catalog type index
|
KATALOGART |
| RQMQMFE | OTKAT | RQMQMFE | MANDT |
TQ15
Inspection catalog type index
|
MANDT |
| RQMQMFE | PHYNR | RQMQMFE | MANDT |
QPRS
Master record for phys. samples
|
MANDT |
| RQMQMFE | PHYNR | RQMQMFE | PHYNR |
QPRS
Master record for phys. samples
|
PHYNR |
| RQMQMFE | PRIOK | RQMQMFE | PRIOK |
T356
Priorities
|
PRIOK |
| RQMQMFE | PRIOK | QMFE | MANDT |
T356
Priorities
|
MANDT |
| RQMQMFE | PRIOK | RQMQMFE | ARTPR |
T356
Priorities
|
ARTPR |
| RQMQMFE | PROBENR | RQMQMFE | PROBENR |
QASV
Sample specifications for inspection processing
|
PROBENR |
| RQMQMFE | PROBENR | RQMQMFE | MANDT |
QASV
Sample specifications for inspection processing
|
MANDANT |
| RQMQMFE | PROBENR | QMEL | PRUEFLOS |
QASV
Sample specifications for inspection processing
|
PRUEFLOS |
| RQMQMFE | PROBENR | QMEL | VORGLFNR |
QASV
Sample specifications for inspection processing
|
VORGLFNR |
| RQMQMFE | PROBENR | RQMQMFE | MERKNR |
QASV
Sample specifications for inspection processing
|
MERKNR |
| RQMQMFE | QMART | QMFE | MANDT |
TQ80
Notification Types
|
MANDT |
| RQMQMFE | QMART | RQMQMFE | QMART |
TQ80
Notification Types
|
QMART |
| RQMQMFE | QMNUM | RQMQMFE | MANDT |
QMEL
Quality Notification
|
MANDT |
| RQMQMFE | QMNUM | RQMQMFE | QMNUM |
QMEL
Quality Notification
|
QMNUM |
| RQMQMFE | RBNR | QMFE | MANDT |
T352B
Technical report
|
MANDT |
| RQMQMFE | RBNR | RQMQMFE | RBNR |
T352B
Technical report
|
RBNR |
| RQMQMFE | UNITFLBEW | RQMQMFE | UNITFLBEW |
T006
Units of Measurement
|
MSEHI |
| RQMQMFE | UNITFLBEW | RQMQMFE | MANDT |
T006
Units of Measurement
|
MANDT |
| RQMQMFE | URCOD | RQMQMFE | URCOD |
QPCD
Inspection catalog codes
|
CODE |
| RQMQMFE | URCOD | '000001' |
QPCD
Inspection catalog codes
|
VERSION | |
| RQMQMFE | URCOD | QMFE | MANDT |
QPCD
Inspection catalog codes
|
MANDT |
| RQMQMFE | URCOD | RQMQMFE | URKAT |
QPCD
Inspection catalog codes
|
KATALOGART |
| RQMQMFE | URCOD | RQMQMFE | URGRP |
QPCD
Inspection catalog codes
|
CODEGRUPPE |
| RQMQMFE | URGRP | RQMQMFE | URGRP |
QPGR
Inspection catalog code groups
|
CODEGRUPPE |
| RQMQMFE | URGRP | QMFE | MANDT |
QPGR
Inspection catalog code groups
|
MANDT |
| RQMQMFE | URGRP | RQMQMFE | URKAT |
QPGR
Inspection catalog code groups
|
KATALOGART |
| RQMQMFE | URKAT | QMFE | MANDT |
TQ15
Inspection catalog type index
|
MANDT |
| RQMQMFE | URKAT | RQMQMFE | URKAT |
TQ15
Inspection catalog type index
|
KATALOGART |