SAP Table DIQMFE
PM Notification Item
DIQMFE (PM Notification Item) 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 DIQMFE to other SAP tables.
DIQMFE table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||
| QMNUM | Notification No | QMNUM | QMEL | CHAR | 12 | 0 | ||||||||||
| FENUM | Item Number in Item Record | FELFD | QMFE | 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 |
Possible values
|
||||||||||
| WDFEH | Repetitive Defect | WDFEH | CHAR | 1 | 0 |
Possible values
|
||||||||||
| 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 |
Possible values
|
||||||||||
| 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 |
Possible values
|
||||||||||
| 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 |
Possible values
|
||||||||||
| AUTKZ | Data Record Created with Function 'Create with Copy Model' | QAUTKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||
| 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 | |||||||||||
| URNUM | Sequential Number for Cause | URNUM | NUMC | 4 | 0 | |||||||||||
| URTXT | Cause Text | URSTX | CHAR | 40 | 0 | |||||||||||
| URKAT | Catalog Type - Causes | URKAT | TQ15 | CHAR | 1 | 0 | ||||||||||
| URGRP | Code Group - Causes | URGRP | CHAR | 8 | 0 | |||||||||||
| URCOD | Cause Code | URCOD | CHAR | 4 | 0 | |||||||||||
| URVER | Version Number | QVERSNR | CHAR | 6 | 0 | |||||||||||
| INDTXU | Object Long Text Available | INDLTX | CHAR | 1 | 0 | |||||||||||
| KZMLAU | Primary language indicator for text segment | KZMLA | CHAR | 1 | 0 | |||||||||||
| TXTGRCO | Short Description of the Code Group | QKTEXTGR | CHAR | 40 | 0 | |||||||||||
| TXTCDCO | Problem Code Short Text | TXTCDFE | CHAR | 40 | 0 | |||||||||||
| TXTGROT | Short Text | QKURZTEXT | CHAR | 40 | 0 | |||||||||||
| TXTCDOT | Object Part Code Short Text | TXTCDOT | CHAR | 40 | 0 | |||||||||||
| TXTGRUR | Short Description of the Code Group | QKTEXTGR | CHAR | 40 | 0 | |||||||||||
| TXTCDUR | Cause Code Short Text | TXTCDUR | CHAR | 40 | 0 | |||||||||||
DIQMFE foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| DIQMFE | ARBPL | DIQMFE | MANDT | CRID | CIM Resource - Entities | MANDT |
| DIQMFE | ARBPL | DIQMFE | CROBJTY | CRID | CIM Resource - Entities | OBJTY |
| DIQMFE | ARBPL | DIQMFE | ARBPL | CRID | CIM Resource - Entities | OBJID |
| DIQMFE | ARBPLWERK | DIQMFE | MANDT | T001W | Plants/Branches | MANDT |
| DIQMFE | ARBPLWERK | DIQMFE | ARBPLWERK | T001W | Plants/Branches | WERKS |
| DIQMFE | BAUTL | DIQMFE | MANDT | MARA | General Material Data | MANDT |
| DIQMFE | BAUTL | DIQMFE | BAUTL | MARA | General Material Data | MATNR |
| DIQMFE | EKORG | DIQMFE | MANDT | T024E | Purchasing Organizations | MANDT |
| DIQMFE | EKORG | DIQMFE | EKORG | T024E | Purchasing Organizations | EKORG |
| DIQMFE | FCOAUFNR | DIQMFE | FCOAUFNR | AUFK | Order master data | AUFNR |
| DIQMFE | FCOAUFNR | DIQMFE | MANDT | AUFK | Order master data | MANDT |
| DIQMFE | FEART | DIQMFE | MANDT | TQ86 | Report category for defects recording | MANDT |
| DIQMFE | FEART | DIQMFE | FEART | TQ86 | Report category for defects recording | FEART |
| DIQMFE | FEGRP | DIQMFE | MANDT | QPGR | Inspection catalog code groups | MANDT |
| DIQMFE | FEGRP | DIQMFE | FEKAT | QPGR | Inspection catalog code groups | KATALOGART |
| DIQMFE | FEGRP | DIQMFE | FEGRP | QPGR | Inspection catalog code groups | CODEGRUPPE |
| DIQMFE | FEKAT | DIQMFE | MANDT | TQ15 | Inspection catalog type index | MANDT |
| DIQMFE | FEKAT | DIQMFE | FEKAT | TQ15 | Inspection catalog type index | KATALOGART |
| DIQMFE | FENUM | DIQMFE | MANDT | QMFE | Quality notification - items | MANDT |
| DIQMFE | FENUM | DIQMFE | QMNUM | QMFE | Quality notification - items | QMNUM |
| DIQMFE | FENUM | DIQMFE | FENUM | QMFE | Quality notification - items | FENUM |
| DIQMFE | FEQKLAS | DIQMFE | MANDT | TQ17 | Defect classes | MANDT |
| DIQMFE | FEQKLAS | DIQMFE | FEQKLAS | TQ17 | Defect classes | FEHLKLASSE |
| DIQMFE | FMGEIN | DIQMFE | MANDT | T006 | Units of Measurement | MANDT |
| DIQMFE | FMGEIN | DIQMFE | FMGEIN | T006 | Units of Measurement | MSEHI |
| DIQMFE | INFNR | DIQMFE | MANDT | EINA | Purchasing Info Record: General Data | MANDT |
| DIQMFE | INFNR | DIQMFE | INFNR | EINA | Purchasing Info Record: General Data | INFNR |
| DIQMFE | KOSTL | * | CSKS | Cost Center Master Data | DATBI | |
| DIQMFE | KOSTL | DIQMFE | MANDT | CSKS | Cost Center Master Data | MANDT |
| DIQMFE | KOSTL | ILOA | KOKRS | CSKS | Cost Center Master Data | KOKRS |
| DIQMFE | KOSTL | DIQMFE | KOSTL | CSKS | Cost Center Master Data | KOSTL |
| DIQMFE | LSTAR | DIQMFE | MANDT | CSLA | Activity master | MANDT |
| DIQMFE | LSTAR | ILOA | KOKRS | CSLA | Activity master | KOKRS |
| DIQMFE | LSTAR | DIQMFE | LSTAR | CSLA | Activity master | LSTAR |
| DIQMFE | LSTAR | * | CSLA | Activity master | DATBI | |
| DIQMFE | MANDT | DIQMFE | MANDT | T000 | Clients | MANDT |
| DIQMFE | MATNR | DIQMFE | MATNR | MARA | General Material Data | MATNR |
| DIQMFE | MATNR | DIQMFE | MANDT | MARA | General Material Data | MANDT |
| DIQMFE | OTGRP | DIQMFE | OTGRP | QPGR | Inspection catalog code groups | CODEGRUPPE |
| DIQMFE | OTGRP | DIQMFE | MANDT | QPGR | Inspection catalog code groups | MANDT |
| DIQMFE | OTGRP | DIQMFE | OTKAT | QPGR | Inspection catalog code groups | KATALOGART |
| DIQMFE | OTKAT | DIQMFE | MANDT | TQ15 | Inspection catalog type index | MANDT |
| DIQMFE | OTKAT | DIQMFE | OTKAT | TQ15 | Inspection catalog type index | KATALOGART |
| DIQMFE | PHYNR | DIQMFE | MANDT | QPRS | Master record for phys. samples | MANDT |
| DIQMFE | PHYNR | DIQMFE | PHYNR | QPRS | Master record for phys. samples | PHYNR |
| DIQMFE | PROBENR | DIQMFE | MANDT | QASV | Sample specifications for inspection processing | MANDANT |
| DIQMFE | PROBENR | QMEL | PRUEFLOS | QASV | Sample specifications for inspection processing | PRUEFLOS |
| DIQMFE | PROBENR | QMEL | VORGLFNR | QASV | Sample specifications for inspection processing | VORGLFNR |
| DIQMFE | PROBENR | DIQMFE | MERKNR | QASV | Sample specifications for inspection processing | MERKNR |
| DIQMFE | PROBENR | DIQMFE | PROBENR | QASV | Sample specifications for inspection processing | PROBENR |
| DIQMFE | PRZNR | DIQMFE | MANDT | CBPR | CO-ABC: Activity Master Table | MANDT |
| DIQMFE | PRZNR | ILOA | KOKRS | CBPR | CO-ABC: Activity Master Table | KOKRS |
| DIQMFE | PRZNR | DIQMFE | PRZNR | CBPR | CO-ABC: Activity Master Table | PRZNR |
| DIQMFE | PRZNR | * | CBPR | CO-ABC: Activity Master Table | DATBI | |
| DIQMFE | QMNUM | DIQMFE | MANDT | QMEL | Quality Notification | MANDT |
| DIQMFE | QMNUM | DIQMFE | QMNUM | QMEL | Quality Notification | QMNUM |
| DIQMFE | UNITFLBEW | DIQMFE | UNITFLBEW | T006 | Units of Measurement | MSEHI |
| DIQMFE | UNITFLBEW | DIQMFE | MANDT | T006 | Units of Measurement | MANDT |
| DIQMFE | URKAT | DIQMFE | MANDT | TQ15 | Inspection catalog type index | MANDT |
| DIQMFE | URKAT | DIQMFE | URKAT | TQ15 | Inspection catalog type index | KATALOGART |
| DIQMFE | WERKS | DIQMFE | MANDT | T001W | Plants/Branches | MANDT |
| DIQMFE | WERKS | DIQMFE | WERKS | T001W | Plants/Branches | WERKS |
