SAP Table RIHQMEL_LIST

Display structure reporting for QMEL

RIHQMEL_LIST (Display structure reporting for QMEL) 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 RIHQMEL_LIST to other SAP tables.

Source: RIHQMEL_LIST (Display structure reporting for QMEL)

RIHQMEL_LIST table fields

Field Data element Checktable Datatype Length Decimals
QMNUM Notification No QMNUM QMEL CHAR 12 0
IWERK Maintenance Planning Plant IWERK T001W CHAR 4 0
TPLNR Functional Location Label ILOM_STRNO CHAR 40 0
SWERK Maintenance plant SWERK T001W CHAR 4 0
KOSTL Cost Center KOSTL CSKS CHAR 10 0
ABCKZ ABC indicator for technical object ABCKZ T370C CHAR 1 0
GSBER Business Area GSBER TGSB CHAR 4 0
ANLNR Main Asset Number ANLN1 ANLH CHAR 12 0
ANLUN Asset Subnumber ANLN2 ANLA CHAR 4 0
STORT Location of maintenance object PMLOC T499S CHAR 10 0
BEBER Plant section BEBER T357 CHAR 3 0
EQUNR Equipment Number EQUNR EQUI CHAR 18 0
BAUTL Assembly BAUTL MARA CHAR 18 0
MSAUS Breakdown Indicator MSAUS CHAR 1 0
X Yes
NULL No
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
EAUSZT Breakdown Duration EAUSZT DEC 11 2
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
QMART Notification Type QMART TQ80 CHAR 2 0
QMTXT Short Text QMTXT CHAR 40 0
BUKRS Company Code BUKRS T001 CHAR 4 0
ARTPR Priority Type ARTPR T356A CHAR 2 0
PRIOK Priority PRIOK T356 CHAR 1 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERZEIT Time, at Which Record Was Added ERZEIT TIMS 6 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
AEDAT Changed On AEDAT DATS 8 0
AEZEIT Time of Change AEZEIT TIMS 6 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
WAERS Currency Key WAERS TCURC CUKY 5 0
AUFNR Order Number AUFNR AUFK CHAR 12 0
KUNUM Customer Number KUNUM KNA1 CHAR 10 0
QMDAB Date for Notification Completion QMDAB DATS 8 0
QMZAB Completion Time of Notification QMZAB TIMS 6 0
BEZDT Notification Reference Date BEZDT DATS 8 0
BEZUR Notification Reference Time BEZUR_D TIMS 6 0
RBNR Catalog Profile RBNR T352B CHAR 9 0
STTXT System status line J_STEXT CHAR 40 0
ARBPL Main work center for maintenance tasks GEWRK CHAR 8 0
VAWRK Plant associated with main work center WERGW T001W CHAR 4 0
ILOAN Location and account assignment for technical object ILOAN ILOA CHAR 12 0
USTXT User Status Line J_ATEXT CHAR 40 0
EQKTX Description of technical object KTX01 CHAR 40 0
PLTXT Description of functional location PLTXT CHAR 40 0
VBELN Sales Order Number KDAUF VBUK CHAR 10 0
BSTNK Customer purchase order number BSTKD CHAR 35 0
BSTDK Customer purchase order date BSTDK DATS 8 0
SPART Division SPART TSPA CHAR 2 0
VKORG Sales Organization VKORG TVKO CHAR 4 0
VTWEG Distribution Channel VTWEG TVTW CHAR 2 0
MANDT Client MANDT T000 CLNT 3 0
ADRNR Addresses: Address Number CADNR CHAR 10 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
PARNR_INT Number of partner responsible for performing the job I_PARNRINT CHAR 12 0
PARNAM_INT List name of internal employee resp.for carrying out job I_NAME_INT CHAR 35 0
PARNR_VERA Partner Responsible for Execution (Person/User) I_PARNR_VERA CHAR 12 0
PARNAM_VERA List Name of Partner Responsible for Execution (Pers./User) I_NAME_VERA CHAR 35 0
OBJNR Object number J_OBJNR ONR00 CHAR 22 0
EQFNR Sort field EQFNR CHAR 30 0
KOKRS Controlling Area KOKRS TKA01 CHAR 4 0
KDAUF Sales Document VBELN_VA VBUK CHAR 10 0
KDPOS Sales Document Item POSNR_VA VBUP NUMC 6 0
VKBUR Sales Office VKBUR TVBUR CHAR 4 0
VKGRP Sales Group VKGRP TVKGR CHAR 3 0
SERIALNR Serial Number GERNR CHAR 18 0
MATNR Material Number MATNR CHAR 18 0
DEVICEID Additional Device Data DEVICEID CHAR 40 0
MSGRP Room RAUMNR CHAR 8 0
MAKTX Material Description (Short Text) MAKTX CHAR 40 0
BAUTLX Assembly Description BAUTXL CHAR 40 0
INDTX Object Long Text Available INDLTX CHAR 1 0
QMGRP Code Group - Coding QMGRP CHAR 8 0
QMCOD Coding QMCOD CHAR 4 0
PAGESTAT Paging Status PAGESTAT CHAR 4 0
OK Successful
PEND Triggered
WARN Warning
ERR Error
WARPL Maintenance Plan WARPL CHAR 12 0
WAPOS Maintenance item WAPOS CHAR 16 0
PRIOKX Priority Text PRIOKX CHAR 20 0
KTXTGR Code Group Text for Coding QMGRPTEXT CHAR 40 0
KTXTCD Code Text for Coding QMCODETEXT CHAR 80 0
ARBPLWERK Plant for Work Center QARBPWERKS CHAR 4 0
REVNR Revision for Plant Maintenance and Customer Service REVNI CHAR 8 0
DFPS_CP PM: Distributed Maintenance - Change Authorization /ISDFPS/PM_CP_ICON CHAR 46 0
DFPS_CP_SYS Logical System /ISDFPS/LOGSYS CHAR 10 0
DFPS_CP_SYST Description of Logical System COMT_LOGSYST CHAR 40 0
UII Unique Item Identifier UII_CHAR72 CHAR 72 0

RIHQMEL_LIST foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
RIHQMEL_LIST ABCKZ RIHQMEL_LIST ABCKZ T370C ABC indicator for technical objects ABCKZ
RIHQMEL_LIST ABCKZ RIHQMEL_LIST MANDT T370C ABC indicator for technical objects MANDT
RIHQMEL_LIST ANLNR RIHQMEL_LIST MANDT ANLH Main asset number MANDT
RIHQMEL_LIST ANLNR RIHQMEL_LIST BUKRS ANLH Main asset number BUKRS
RIHQMEL_LIST ANLNR RIHQMEL_LIST ANLNR ANLH Main asset number ANLN1
RIHQMEL_LIST ANLUN RIHQMEL_LIST ANLUN ANLA Asset Master Record Segment ANLN2
RIHQMEL_LIST ANLUN RIHQMEL_LIST ANLNR ANLA Asset Master Record Segment ANLN1
RIHQMEL_LIST ANLUN RIHQMEL_LIST BUKRS ANLA Asset Master Record Segment BUKRS
RIHQMEL_LIST ANLUN RIHQMEL_LIST MANDT ANLA Asset Master Record Segment MANDT
RIHQMEL_LIST ANLZE RIHQMEL_LIST MANDT T357Z Syst.Condition MANDT
RIHQMEL_LIST ANLZE RIHQMEL_LIST ANLZE T357Z Syst.Condition ANLAZ
RIHQMEL_LIST ANLZN RIHQMEL_LIST MANDT T357Z Syst.Condition MANDT
RIHQMEL_LIST ANLZN RIHQMEL_LIST ANLZN T357Z Syst.Condition ANLAZ
RIHQMEL_LIST ANLZV RIHQMEL_LIST MANDT T357Z Syst.Condition MANDT
RIHQMEL_LIST ANLZV RIHQMEL_LIST ANLZV T357Z Syst.Condition ANLAZ
RIHQMEL_LIST ARTPR RIHQMEL_LIST MANDT T356A Priority type table MANDT
RIHQMEL_LIST ARTPR RIHQMEL_LIST ARTPR T356A Priority type table ARTPR
RIHQMEL_LIST AUFNR RIHQMEL_LIST MANDT AUFK Order master data MANDT
RIHQMEL_LIST AUFNR RIHQMEL_LIST AUFNR AUFK Order master data AUFNR
RIHQMEL_LIST AUSWK RIHQMEL_LIST AUSWK T357A Effect of malfunction on the system AUSWK
RIHQMEL_LIST AUSWK RIHQMEL_LIST MANDT T357A Effect of malfunction on the system MANDT
RIHQMEL_LIST BAUTL RIHQMEL_LIST BAUTL MARA General Material Data MATNR
RIHQMEL_LIST BAUTL RIHQMEL_LIST MANDT MARA General Material Data MANDT
RIHQMEL_LIST BEBER RIHQMEL_LIST BEBER T357 Plant Section BEBER
RIHQMEL_LIST BEBER RIHQMEL_LIST SWERK T357 Plant Section WERKS
RIHQMEL_LIST BEBER RIHQMEL_LIST MANDT T357 Plant Section MANDT
RIHQMEL_LIST BEQUI RIHQMEL_LIST BEQUI EQUI Equipment master data EQUNR
RIHQMEL_LIST BEQUI RIHQMEL_LIST MANDT EQUI Equipment master data MANDT
RIHQMEL_LIST BTPLN RIHQMEL_LIST MANDT IFLOT Functional Location (Table) MANDT
RIHQMEL_LIST BTPLN RIHQMEL_LIST BTPLN IFLOT Functional Location (Table) TPLNR
RIHQMEL_LIST BUKRS RIHQMEL_LIST MANDT T001 Company Codes MANDT
RIHQMEL_LIST BUKRS RIHQMEL_LIST BUKRS T001 Company Codes BUKRS
RIHQMEL_LIST EQUNR RIHQMEL_LIST EQUNR EQUI Equipment master data EQUNR
RIHQMEL_LIST EQUNR RIHQMEL_LIST MANDT EQUI Equipment master data MANDT
RIHQMEL_LIST GSBER RIHQMEL_LIST GSBER TGSB Business Areas GSBER
RIHQMEL_LIST GSBER RIHQMEL_LIST MANDT TGSB Business Areas MANDT
RIHQMEL_LIST ILOAN RIHQMEL_LIST MANDT ILOA PM Object Location and Account Assignment MANDT
RIHQMEL_LIST ILOAN RIHQMEL_LIST ILOAN ILOA PM Object Location and Account Assignment ILOAN
RIHQMEL_LIST INGRP RIHQMEL_LIST MANDT T024I Maintenance planner groups MANDT
RIHQMEL_LIST INGRP RIHQMEL_LIST SWERK T024I Maintenance planner groups IWERK
RIHQMEL_LIST INGRP RIHQMEL_LIST INGRP T024I Maintenance planner groups INGRP
RIHQMEL_LIST IWERK RIHQMEL_LIST MANDT T001W Plants/Branches MANDT
RIHQMEL_LIST IWERK RIHQMEL_LIST IWERK T001W Plants/Branches WERKS
RIHQMEL_LIST KDAUF RIHQMEL_LIST KDAUF VBUK Sales Document: Header Status and Administrative Data VBELN
RIHQMEL_LIST KDAUF RIHQMEL_LIST MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
RIHQMEL_LIST KDPOS RIHQMEL_LIST KDPOS VBUP Sales Document: Item Status POSNR
RIHQMEL_LIST KDPOS RIHQMEL_LIST KDAUF VBUP Sales Document: Item Status VBELN
RIHQMEL_LIST KDPOS RIHQMEL_LIST MANDT VBUP Sales Document: Item Status MANDT
RIHQMEL_LIST KOKRS RIHQMEL_LIST KOKRS TKA01 Controlling Areas KOKRS
RIHQMEL_LIST KOKRS RIHQMEL_LIST MANDT TKA01 Controlling Areas MANDT
RIHQMEL_LIST KOSTL RIHQMEL_LIST KOKRS CSKS Cost Center Master Data KOKRS
RIHQMEL_LIST KOSTL RIHQMEL_LIST BEZDT CSKS Cost Center Master Data DATBI
RIHQMEL_LIST KOSTL RIHQMEL_LIST KOSTL CSKS Cost Center Master Data KOSTL
RIHQMEL_LIST KOSTL RIHQMEL_LIST MANDT CSKS Cost Center Master Data MANDT
RIHQMEL_LIST KUNUM RIHQMEL_LIST MANDT KNA1 General Data in Customer Master MANDT
RIHQMEL_LIST KUNUM RIHQMEL_LIST KUNUM KNA1 General Data in Customer Master KUNNR
RIHQMEL_LIST MANDT RIHQMEL_LIST MANDT T000 Clients MANDT
RIHQMEL_LIST MAUEH RIHQMEL_LIST MAUEH T006 Units of Measurement MSEHI
RIHQMEL_LIST MAUEH RIHQMEL_LIST MANDT T006 Units of Measurement MANDT
RIHQMEL_LIST OBJNR RIHQMEL_LIST MANDT ONR00 General Object Number MANDT
RIHQMEL_LIST OBJNR RIHQMEL_LIST OBJNR ONR00 General Object Number OBJNR
RIHQMEL_LIST PRIOK RIHQMEL_LIST PRIOK T356 Priorities PRIOK
RIHQMEL_LIST PRIOK RIHQMEL_LIST ARTPR T356 Priorities ARTPR
RIHQMEL_LIST PRIOK RIHQMEL_LIST MANDT T356 Priorities MANDT
RIHQMEL_LIST QMART RIHQMEL_LIST QMART TQ80 Notification Types QMART
RIHQMEL_LIST QMART RIHQMEL_LIST MANDT TQ80 Notification Types MANDT
RIHQMEL_LIST QMNUM RIHQMEL_LIST QMNUM QMEL Quality Notification QMNUM
RIHQMEL_LIST QMNUM RIHQMEL_LIST MANDT QMEL Quality Notification MANDT
RIHQMEL_LIST RBNR RIHQMEL_LIST RBNR T352B Technical report RBNR
RIHQMEL_LIST RBNR RIHQMEL_LIST MANDT T352B Technical report MANDT
RIHQMEL_LIST SPART RIHQMEL_LIST MANDT TSPA Organizational Unit: Sales Divisions MANDT
RIHQMEL_LIST SPART RIHQMEL_LIST SPART TSPA Organizational Unit: Sales Divisions SPART
RIHQMEL_LIST STORT RIHQMEL_LIST STORT T499S Location STAND
RIHQMEL_LIST STORT RIHQMEL_LIST SWERK T499S Location WERKS
RIHQMEL_LIST STORT RIHQMEL_LIST MANDT T499S Location MANDT
RIHQMEL_LIST SWERK RIHQMEL_LIST SWERK T001W Plants/Branches WERKS
RIHQMEL_LIST SWERK RIHQMEL_LIST MANDT T001W Plants/Branches MANDT
RIHQMEL_LIST VAWRK RIHQMEL_LIST MANDT T001W Plants/Branches MANDT
RIHQMEL_LIST VAWRK RIHQMEL_LIST VAWRK T001W Plants/Branches WERKS
RIHQMEL_LIST VBELN RIHQMEL_LIST VBELN VBUK Sales Document: Header Status and Administrative Data VBELN
RIHQMEL_LIST VBELN RIHQMEL_LIST MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
RIHQMEL_LIST VKBUR RIHQMEL_LIST VKBUR TVBUR Organizational Unit: Sales Offices VKBUR
RIHQMEL_LIST VKBUR RIHQMEL_LIST MANDT TVBUR Organizational Unit: Sales Offices MANDT
RIHQMEL_LIST VKGRP RIHQMEL_LIST VKGRP TVKGR Organizational Unit: Sales Groups VKGRP
RIHQMEL_LIST VKGRP RIHQMEL_LIST MANDT TVKGR Organizational Unit: Sales Groups MANDT
RIHQMEL_LIST VKORG RIHQMEL_LIST MANDT TVKO Organizational Unit: Sales Organizations MANDT
RIHQMEL_LIST VKORG RIHQMEL_LIST VKORG TVKO Organizational Unit: Sales Organizations VKORG
RIHQMEL_LIST VTWEG RIHQMEL_LIST MANDT TVTW Organizational Unit: Distribution Channels MANDT
RIHQMEL_LIST VTWEG RIHQMEL_LIST VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
RIHQMEL_LIST WAERS RIHQMEL_LIST WAERS TCURC Currency Codes WAERS
RIHQMEL_LIST WAERS RIHQMEL_LIST MANDT TCURC Currency Codes MANDT