QMIH SAP (Quality message - maintenance data excerpt) Table details

Dictionary Type: Table
Description: Quality message - maintenance data excerpt




ABAP Code to SELECT data from QMIH
Related tables to QMIH
Access table QMIH




Table field list including key, data, relationships and ABAP select examples

QMIH is a standard SAP Table which is used to store Quality message - maintenance data excerpt data and is available within R/3 SAP systems depending on the version and release level.

The QMIH table consists of various fields, each holding specific information or linking keys about Quality message - maintenance data excerpt data available in SAP. These include QMNUM (Notification No), IWERK (Maintenance Planning Plant), ILOAN (Location and account assignment for technical object), ILOAI (ILOA Individual).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP QMIH table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
QMNUMNotification No QMNUMCHAR12QMELALPHAQMNUMIQM
IWERKMaintenance Planning Plant IWERKCHAR4T399IWERKSIWK
ILOANLocation and account assignment for technical object ILOANCHAR12ILOAILOAN
ILOAIILOA Individual ILOAICHAR1X
EQUNREquipment Number EQUNRCHAR18EQUIALPHAEQUNREQNEQUI
BAUTLAssembly BAUTLCHAR18MARAMATN1MATNRMAT
EBORTInstallation Point for Subitem EBORTCHAR20TEXT20
MSAUSBreakdown Indicator MSAUSCHAR1XFELD
AUSVNStart of Malfunction (Date) AUSVNDATS8DATUM
AUSBSEnd of Malfunction (Date) AUSBSDATS8DATUM
AUZTVStart of Malfunction (Time) AUZTVTIMS6UHRZT
AUZTBEnd of Malfunction (Time) AUZTBTIMS6UHRZT
AUSZTBreakdown Duration AUSZTFLTP16(16) FLTP
MAUEHUnit for Breakdown Duration MAUEHUNIT3T006CUNITMEINS
BTPLNFunctional Location Affected BTPLNCHAR30IFLOTTPLNRTPLNRIFLIFLM
BEQUIEquipment Affected BEQUICHAR18EQUIALPHAEQUNREQN
AUSWKEffect on Operation AUSWKCHAR1T357AAUSWK
VERFVAvailability Before Malfunction VERFVNUMC3NUM3
VERFNAvailability After Malfunction VERFNNUMC3NUM3
VERFMAvailability After Completion of Task VERFMNUMC3NUM3
ANLZVSystem Condition Before Malfunction ANLZVCHAR1T357ZANLAZ
ANLZNSystem Condition After Malfunction ANLZNCHAR1T357ZANLAZ
ANLZESystem Condition After Completion of Task ANLZECHAR1T357ZANLAZ
INSPKName of Person Responsible for Technical Inspection INSPKCHAR12USNAM
DATANDate of Technical Inspection DATANDATS8DATUM
INGRPPlanner Group for Customer Service and Plant Maintenance INGRPCHAR3T024IINGRPIHG
WARPLMaintenance Plan WARPLCHAR12MPLAALPHAWARPLMPLMPLAL
ABNUMMaintenance Plan Call Number ABNUMINT410ABNUM
WAPOSMaintenance item WAPOSCHAR16ALPHAPOSNUMPSMPOSL
KDAUFSales Document VBELN_VACHAR10VBUKALPHAVBELNAUN
KDPOSSales Document Item POSNR_VANUMC6VBUPPOSNRAPO
SCREENTYScenario or Subscreen Category SCRTPCHAR4Assigned to domainSCRTP
PLNTYTask List Type PLNTYCHAR1Assigned to domainPLNTYPTYH_TCA01
PLNNRKey for Task List Group PLNNRCHAR8ALPHAPLNNRPLNPLKS
PLNALGroup Counter PLNALCHAR2ALPHAALTNRPAL
REVNRRevision for Plant Maintenance and Customer Service REVNICHAR8Assigned to domainREVNI
.INCLU--AP 0
ZAEHLInternal counter CIM_COUNTNUMC8PLKOCIM_COUNT
.INCLU--AP 0
PAMS_PTSTFPlanned Time Stamp (from) PAMS_PTSTFDEC15TZNTSTMPS
PAMS_PTSTTPlanned Time Stamp (to) PAMS_PTSTTDEC15TZNTSTMPS
PAMS_ATSTFActual Start Time PAMS_ATSTFDEC15TZNTSTMPS
PAMS_ATSTTActual End Time PAMS_ATSTTDEC15TZNTSTMPS
PAMS_POOLPAM Pool PAMS_POOLCHAR8PAMS_D_POOLPAMS_POOLPAMS_VFPH_SH
PAMS_KOSTLCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
PAMS_AUFNROrder Number AUFNRCHAR12Assigned to domainALPHAAUFNRANR
PAMS_PROIDWork Breakdown Structure Element (WBS Element) PS_PSP_PNRNUMC8Assigned to domainKONPRPS_POSNR
PAMS_KOKRSControlling Area KOKRSCHAR4Assigned to domainCACCDCAC

Key field Non-key field



How do I retrieve data from SAP table QMIH using ABAP code

The following ABAP code Example will allow you to do a basic selection on QMIH to SELECT all data from the table
DATA: WA_QMIH TYPE QMIH.

SELECT SINGLE *
FROM QMIH
INTO CORRESPONDING FIELDS OF WA_QMIH
WHERE...

How to access SAP table QMIH

Within an ECC or HANA version of SAP you can also view further information about QMIH and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!