SAP Table QMIH
Quality message - maintenance data excerpt
QMIH (Quality message - maintenance data excerpt) 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 QMIH to other SAP tables.
QMIH table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| QMNUM | Notification No | QMNUM | QMEL | CHAR | 12 | 0 | ||||||
| IWERK | Maintenance Planning Plant | IWERK | T399I | CHAR | 4 | 0 | ||||||
| ILOAN | Location and account assignment for technical object | ILOAN | ILOA | CHAR | 12 | 0 | ||||||
| ILOAI | ILOA Individual | ILOAI | CHAR | 1 | 0 |
Possible values
|
||||||
| EQUNR | Equipment Number | EQUNR | EQUI | CHAR | 18 | 0 | ||||||
| BAUTL | Assembly | BAUTL | MARA | CHAR | 18 | 0 | ||||||
| EBORT | Installation Point for Subitem | EBORT | CHAR | 20 | 0 | |||||||
| MSAUS | Breakdown Indicator | MSAUS | CHAR | 1 | 0 |
Possible values
|
||||||
| AUSVN | Start of Malfunction (Date) | AUSVN | DATS | 8 | 0 | |||||||
| AUSBS | End of Malfunction (Date) | AUSBS | DATS | 8 | 0 | |||||||
| AUZTV | Start of Malfunction (Time) | AUZTV | TIMS | 6 | 0 | |||||||
| AUZTB | End of Malfunction (Time) | AUZTB | TIMS | 6 | 0 | |||||||
| AUSZT | Breakdown Duration | AUSZT | FLTP | 16 | 16 | |||||||
| MAUEH | Unit for Breakdown Duration | MAUEH | T006 | UNIT | 3 | 0 | ||||||
| BTPLN | Functional Location Affected | BTPLN | IFLOT | CHAR | 30 | 0 | ||||||
| BEQUI | Equipment Affected | BEQUI | EQUI | CHAR | 18 | 0 | ||||||
| AUSWK | Effect on Operation | AUSWK | T357A | CHAR | 1 | 0 | ||||||
| VERFV | Availability Before Malfunction | VERFV | NUMC | 3 | 0 | |||||||
| VERFN | Availability After Malfunction | VERFN | NUMC | 3 | 0 | |||||||
| VERFM | Availability After Completion of Task | VERFM | NUMC | 3 | 0 | |||||||
| ANLZV | System Condition Before Malfunction | ANLZV | T357Z | CHAR | 1 | 0 | ||||||
| ANLZN | System Condition After Malfunction | ANLZN | T357Z | CHAR | 1 | 0 | ||||||
| ANLZE | System Condition After Completion of Task | ANLZE | T357Z | CHAR | 1 | 0 | ||||||
| INSPK | Name of Person Responsible for Technical Inspection | INSPK | CHAR | 12 | 0 | |||||||
| DATAN | Date of Technical Inspection | DATAN | DATS | 8 | 0 | |||||||
| INGRP | Planner Group for Customer Service and Plant Maintenance | INGRP | T024I | CHAR | 3 | 0 | ||||||
| WARPL | Maintenance Plan | WARPL | MPLA | CHAR | 12 | 0 | ||||||
| ABNUM | Maintenance Plan Call Number | ABNUM | INT4 | 10 | 0 | |||||||
| WAPOS | Maintenance item | WAPOS | CHAR | 16 | 0 | |||||||
| KDAUF | Sales Document | VBELN_VA | VBUK | CHAR | 10 | 0 | ||||||
| KDPOS | Sales Document Item | POSNR_VA | VBUP | NUMC | 6 | 0 | ||||||
| SCREENTY | Scenario or Subscreen Category | SCRTP | CHAR | 4 | 0 | |||||||
| PLNTY | Task List Type | PLNTY | CHAR | 1 | 0 | |||||||
| PLNNR | Key for Task List Group | PLNNR | CHAR | 8 | 0 | |||||||
| PLNAL | Group Counter | PLNAL | CHAR | 2 | 0 | |||||||
| REVNR | Revision for Plant Maintenance and Customer Service | REVNI | CHAR | 8 | 0 | |||||||
| ZAEHL | Internal counter | CIM_COUNT | PLKO | NUMC | 8 | 0 | ||||||
| PAMS_PTSTF | Planned Time Stamp (from) | PAMS_PTSTF | DEC | 15 | 0 | |||||||
| PAMS_PTSTT | Planned Time Stamp (to) | PAMS_PTSTT | DEC | 15 | 0 | |||||||
| PAMS_ATSTF | Actual Start Time | PAMS_ATSTF | DEC | 15 | 0 | |||||||
| PAMS_ATSTT | Actual End Time | PAMS_ATSTT | DEC | 15 | 0 | |||||||
| PAMS_POOL | PAM Pool | PAMS_POOL | CHAR | 8 | 0 | |||||||
| PAMS_KOSTL | Cost Center | KOSTL | CHAR | 10 | 0 | |||||||
| PAMS_AUFNR | Order Number | AUFNR | CHAR | 12 | 0 | |||||||
| PAMS_PROID | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | 0 | |||||||
| PAMS_KOKRS | Controlling Area | KOKRS | CHAR | 4 | 0 | |||||||
QMIH foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| QMIH | ANLZE | QMIH | ANLZE | T357Z | Syst.Condition | ANLAZ |
| QMIH | ANLZE | QMIH | MANDT | T357Z | Syst.Condition | MANDT |
| QMIH | ANLZN | QMIH | MANDT | T357Z | Syst.Condition | MANDT |
| QMIH | ANLZN | QMIH | ANLZN | T357Z | Syst.Condition | ANLAZ |
| QMIH | ANLZV | QMIH | MANDT | T357Z | Syst.Condition | MANDT |
| QMIH | ANLZV | QMIH | ANLZV | T357Z | Syst.Condition | ANLAZ |
| QMIH | AUSWK | QMIH | MANDT | T357A | Effect of malfunction on the system | MANDT |
| QMIH | AUSWK | QMIH | AUSWK | T357A | Effect of malfunction on the system | AUSWK |
| QMIH | BAUTL | QMIH | MANDT | MARA | General Material Data | MANDT |
| QMIH | BAUTL | QMIH | BAUTL | MARA | General Material Data | MATNR |
| QMIH | BEQUI | QMIH | MANDT | EQUI | Equipment master data | MANDT |
| QMIH | BEQUI | QMIH | BEQUI | EQUI | Equipment master data | EQUNR |
| QMIH | BTPLN | QMIH | MANDT | IFLOT | Functional Location (Table) | MANDT |
| QMIH | BTPLN | QMIH | BTPLN | IFLOT | Functional Location (Table) | TPLNR |
| QMIH | EQUNR | QMIH | MANDT | EQUI | Equipment master data | MANDT |
| QMIH | EQUNR | QMIH | EQUNR | EQUI | Equipment master data | EQUNR |
| QMIH | ILOAN | QMIH | ILOAN | ILOA | PM Object Location and Account Assignment | ILOAN |
| QMIH | ILOAN | QMIH | MANDT | ILOA | PM Object Location and Account Assignment | MANDT |
| QMIH | INGRP | QMIH | IWERK | T024I | Maintenance planner groups | IWERK |
| QMIH | INGRP | QMIH | INGRP | T024I | Maintenance planner groups | INGRP |
| QMIH | INGRP | QMIH | MANDT | T024I | Maintenance planner groups | MANDT |
| QMIH | IWERK | QMIH | IWERK | T399I | Planning plant parameters | IWERK |
| QMIH | IWERK | QMIH | MANDT | T399I | Planning plant parameters | MANDT |
| QMIH | KDAUF | QMIH | MANDT | VBUK | Sales Document: Header Status and Administrative Data | MANDT |
| QMIH | KDAUF | QMIH | KDAUF | VBUK | Sales Document: Header Status and Administrative Data | VBELN |
| QMIH | KDPOS | QMIH | KDPOS | VBUP | Sales Document: Item Status | POSNR |
| QMIH | KDPOS | QMIH | MANDT | VBUP | Sales Document: Item Status | MANDT |
| QMIH | KDPOS | QMIH | KDAUF | VBUP | Sales Document: Item Status | VBELN |
| QMIH | MANDT | QMIH | MANDT | T000 | Clients | MANDT |
| QMIH | MAUEH | QMIH | MANDT | T006 | Units of Measurement | MANDT |
| QMIH | MAUEH | QMIH | MAUEH | T006 | Units of Measurement | MSEHI |
| QMIH | QMNUM | QMIH | QMNUM | QMEL | Quality Notification | QMNUM |
| QMIH | QMNUM | QMIH | MANDT | QMEL | Quality Notification | MANDT |
| QMIH | WARPL | QMIH | MANDT | MPLA | Maintenance plan | MANDT |
| QMIH | WARPL | QMIH | WARPL | MPLA | Maintenance plan | WARPL |
| QMIH | ZAEHL | QMIH | MANDT | PLKO | Task list - header | MANDT |
| QMIH | ZAEHL | QMIH | PLNTY | PLKO | Task list - header | PLNTY |
| QMIH | ZAEHL | QMIH | PLNNR | PLKO | Task list - header | PLNNR |
| QMIH | ZAEHL | QMIH | PLNAL | PLKO | Task list - header | PLNAL |
| QMIH | ZAEHL | QMIH | ZAEHL | PLKO | Task list - header | ZAEHL |
