RIHQMEL_LIST SAP (Display structure reporting for QMEL) Structure details
Description: Display structure reporting for QMEL
Structure field list including key, data, relationships and ABAP select examples
RIHQMEL_LIST is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Display structure reporting for QMEL" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_RIHQMEL_LIST TYPE RIHQMEL_LIST.
The RIHQMEL_LIST table consists of various fields, each holding specific information or linking keys about Display structure reporting for QMEL data available in SAP. These include IWERK (Maintenance Planning Plant), TPLNR (Functional Location Label), SWERK (Maintenance plant), KOSTL (Cost Center).. 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP RIHQMEL_LIST structure 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 |
QMNUM | Notification No | QMNUM | CHAR | 12 | QMEL | ALPHA | QMNUM | IQM | |
IWERK | Maintenance Planning Plant | IWERK | CHAR | 4 | T001W | WERKS | IWK | ||
TPLNR | Functional Location Label | ILOM_STRNO | CHAR | 40 | ILOM_STRNO | ||||
SWERK | Maintenance plant | SWERK | CHAR | 4 | T001W | WERKS | SWK | ||
KOSTL | Cost Center | KOSTL | CHAR | 10 | CSKS | ALPHA | KOSTL | KOS | |
ABCKZ | ABC indicator for technical object | ABCKZ | CHAR | 1 | T370C | ABCKZ | |||
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
ANLNR | Main Asset Number | ANLN1 | CHAR | 12 | ANLH | ALPHA | ANLN1 | AN1 | |
ANLUN | Asset Subnumber | ANLN2 | CHAR | 4 | ANLA | ALPHA | ANLN2 | AN2 | |
STORT | Location of maintenance object | PMLOC | CHAR | 10 | T499S | AP_STAND | |||
BEBER | Plant section | BEBER | CHAR | 3 | T357 | BEBER | BBE | ||
EQUNR | Equipment Number | EQUNR | CHAR | 18 | EQUI | ALPHA | EQUNR | EQN | EQUI |
BAUTL | Assembly | BAUTL | CHAR | 18 | MARA | MATN1 | MATNR | MAT | |
MSAUS | Breakdown Indicator | MSAUS | CHAR | 1 | XFELD | ||||
AUSVN | Start of Malfunction (Date) | AUSVN | DATS | 8 | DATUM | ||||
AUSBS | End of Malfunction (Date) | AUSBS | DATS | 8 | DATUM | ||||
AUZTV | Start of Malfunction (Time) | AUZTV | TIMS | 6 | UHRZT | ||||
AUZTB | End of Malfunction (Time) | AUZTB | TIMS | 6 | UHRZT | ||||
EAUSZT | Breakdown Duration | EAUSZT | DEC | 11(2) | DEC9_2 | ||||
MAUEH | Unit for Breakdown Duration | MAUEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
BTPLN | Functional Location Affected | BTPLN | CHAR | 30 | IFLOT | TPLNR | TPLNR | IFL | IFLM |
BEQUI | Equipment Affected | BEQUI | CHAR | 18 | EQUI | ALPHA | EQUNR | EQN | |
AUSWK | Effect on Operation | AUSWK | CHAR | 1 | T357A | AUSWK | |||
VERFV | Availability Before Malfunction | VERFV | NUMC | 3 | NUM3 | ||||
VERFN | Availability After Malfunction | VERFN | NUMC | 3 | NUM3 | ||||
VERFM | Availability After Completion of Task | VERFM | NUMC | 3 | NUM3 | ||||
ANLZV | System Condition Before Malfunction | ANLZV | CHAR | 1 | T357Z | ANLAZ | |||
ANLZN | System Condition After Malfunction | ANLZN | CHAR | 1 | T357Z | ANLAZ | |||
ANLZE | System Condition After Completion of Task | ANLZE | CHAR | 1 | T357Z | ANLAZ | |||
INSPK | Name of Person Responsible for Technical Inspection | INSPK | CHAR | 12 | USNAM | ||||
DATAN | Date of Technical Inspection | DATAN | DATS | 8 | DATUM | ||||
INGRP | Planner Group for Customer Service and Plant Maintenance | INGRP | CHAR | 3 | T024I | INGRP | IHG | ||
QMART | Notification Type | QMART | CHAR | 2 | TQ80 | QMART | QMR | ||
QMTXT | Short Text | QMTXT | CHAR | 40 | TEXT40 | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
ARTPR | Priority Type | ARTPR | CHAR | 2 | T356A | ARTPR | |||
PRIOK | Priority | PRIOK | CHAR | 1 | T356 | PRIOK | PRIOK | ||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
ERZEIT | Time, at Which Record Was Added | ERZEIT | TIMS | 6 | UHRZT | ||||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
AEZEIT | Time of Change | AEZEIT | TIMS | 6 | UHRZT | ||||
MZEIT | Time of Notification | MZEIT | TIMS | 6 | UHRZT | ||||
QMDAT | Date of Notification | QMDAT | DATS | 8 | DATUM | ||||
QMNAM | Name of Person Reporting Notification | QMNAM | CHAR | 12 | USNAM | ||||
STRMN | Required start date | STRMN | DATS | 8 | DATUM | ||||
STRUR | Required Start Time | STRUR | TIMS | 6 | UZEIT | ||||
LTRMN | Required End Date | LTRMN | DATS | 8 | DATUM | ||||
LTRUR | Requested End Time | LTRUR | TIMS | 6 | UZEIT | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
AUFNR | Order Number | AUFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ANR | |
KUNUM | Customer Number | KUNUM | CHAR | 10 | KNA1 | ALPHA | KUNNR | KUN | |
QMDAB | Date for Notification Completion | QMDAB | DATS | 8 | DATUM | ||||
QMZAB | Completion Time of Notification | QMZAB | TIMS | 6 | UZEIT | ||||
BEZDT | Notification Reference Date | BEZDT | DATS | 8 | DATUM | ||||
BEZUR | Notification Reference Time | BEZUR_D | TIMS | 6 | UZEIT | ||||
RBNR | Catalog Profile | RBNR | CHAR | 9 | T352B | RBNR | |||
STTXT | System status line | J_STEXT | CHAR | 40 | TEXT40 | ||||
ARBPL | Main work center for maintenance tasks | GEWRK | CHAR | 8 | ARBPL | VAP | |||
VAWRK | Plant associated with main work center | WERGW | CHAR | 4 | T001W | WERKS | |||
ILOAN | Location and account assignment for technical object | ILOAN | CHAR | 12 | ILOA | ILOAN | |||
USTXT | User Status Line | J_ATEXT | CHAR | 40 | TEXT40 | ||||
EQKTX | Description of technical object | KTX01 | CHAR | 40 | TEXT40 | ||||
PLTXT | Description of functional location | PLTXT | CHAR | 40 | TEXT40 | ||||
VBELN | Sales Order Number | KDAUF | CHAR | 10 | VBUK | ALPHA | VBELN | AUN | |
BSTNK | Customer purchase order number | BSTKD | CHAR | 35 | BSTKD | ||||
BSTDK | Customer purchase order date | BSTDK | DATS | 8 | DATUM | ||||
SPART | Division | SPART | CHAR | 2 | TSPA | SPART | SPA | C_SPART | |
VKORG | Sales Organization | VKORG | CHAR | 4 | TVKO | VKORG | VKO | C_VKORG | |
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | TVTW | VTWEG | VTW | C_VTWEG | |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
ADRNR | Addresses: Address Number | CADNR | CHAR | 10 | Assigned to domain | ALPHA | CADRNR | ||
NAME_LIST | Name for list displays | I_NAME_LST | CHAR | 35 | NAME | ||||
TEL_NUMBER | First telephone no.: dialling code+number | AD_TLNMBR1 | CHAR | 30 | CHAR30 | ||||
POST_CODE1 | City postal code | AD_PSTCD1 | CHAR | 10 | CHAR10 | ||||
CITY1 | City | AD_CITY1 | CHAR | 40 | TEXT40 | CLCITYNAME | |||
CITY2 | District | AD_CITY2 | CHAR | 40 | TEXT40 | CITY_PART | |||
COUNTRY | Country Key | LAND1 | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
REGION | STATE (State, Province, County) | REGIO | CHAR | 3 | Assigned to domain | REGIO | |||
STREET | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
PARNR_INT | Number of partner responsible for performing the job | I_PARNRINT | CHAR | 12 | ALPHA | I_PARNR | |||
PARNAM_INT | List name of internal employee resp.for carrying out job | I_NAME_INT | CHAR | 35 | NAME | ||||
PARNR_VERA | Partner Responsible for Execution (Person/User) | I_PARNR_VERA | CHAR | 12 | ALPHA | I_PARNR | |||
PARNAM_VERA | List Name of Partner Responsible for Execution (Pers./User) | I_NAME_VERA | CHAR | 35 | NAME | ||||
OBJNR | Object number | J_OBJNR | CHAR | 22 | ONR00 | J_OBJNR | ONR | ||
EQFNR | Sort field | EQFNR | CHAR | 30 | CHAR30 | ||||
KOKRS | Controlling Area | KOKRS | CHAR | 4 | TKA01 | CACCD | CAC | ||
KDAUF | Sales Document | VBELN_VA | CHAR | 10 | VBUK | ALPHA | VBELN | AUN | |
KDPOS | Sales Document Item | POSNR_VA | NUMC | 6 | VBUP | POSNR | APO | ||
VKBUR | Sales Office | VKBUR | CHAR | 4 | TVBUR | VKBUR | VKB | ||
VKGRP | Sales Group | VKGRP | CHAR | 3 | TVKGR | VKGRP | VKG | ||
SERIALNR | Serial Number | GERNR | CHAR | 18 | GERNR | GERNR | SER | ||
MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
DEVICEID | Additional Device Data | DEVICEID | CHAR | 40 | DEVICEID | ||||
MSGRP | Room | RAUMNR | CHAR | 8 | CHAR8 | ||||
MAKTX | Material Description (Short Text) | MAKTX | CHAR | 40 | TEXT40 | ||||
BAUTLX | Assembly Description | BAUTXL | CHAR | 40 | TEXT40 | ||||
INDTX | Object Long Text Available | INDLTX | CHAR | 1 | CHAR1 | ||||
QMGRP | Code Group - Coding | QMGRP | CHAR | 8 | Assigned to domain | QCODEGRP | |||
QMCOD | Coding | QMCOD | CHAR | 4 | Assigned to domain | QCODE | |||
PAGESTAT | Paging Status | PAGESTAT | CHAR | 4 | PAGESTAT | ||||
WARPL | Maintenance Plan | WARPL | CHAR | 12 | Assigned to domain | ALPHA | WARPL | MPL | MPLAL |
WAPOS | Maintenance item | WAPOS | CHAR | 16 | ALPHA | POSNU | MPS | MPOSL | |
PRIOKX | Priority Text | PRIOKX | CHAR | 20 | TEXT20 | ||||
KTXTGR | Code Group Text for Coding | QMGRPTEXT | CHAR | 40 | QKURZTEXT | ||||
KTXTCD | Code Text for Coding | QMCODETEXT | CHAR | 80 | QTEXT80 | ||||
ARBPLWERK | Plant for Work Center | QARBPWERKS | CHAR | 4 | Assigned to domain | WERKS | WRK | ||
REVNR | Revision for Plant Maintenance and Customer Service | REVNI | CHAR | 8 | Assigned to domain | REVNI | |||
.INCLU--AP | 0 | ||||||||
DFPS_CP | PM: Distributed Maintenance - Change Authorization | /ISDFPS/PM_CP_ICON | CHAR | 46 | TV_IMAGE | ||||
DFPS_CP_SYS | Logical System | /ISDFPS/LOGSYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | /ISDFPS/ALE_SYNC_SYSTEM | |
DFPS_CP_SYST | Description of Logical System | COMT_LOGSYST | CHAR | 40 | TEXT40 | ||||
.INCLU--AP | 0 | ||||||||
UII | Unique Item Identifier | UII_CHAR72 | CHAR | 72 | UII_CHAR72 | UII | H_UII |
Key field | Non-key field |
How do I retrieve data from SAP structure RIHQMEL_LIST using ABAP code?
As RIHQMEL_LIST is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on RIHQMEL_LIST as there is no data to select.How to access SAP table RIHQMEL_LIST
Within an ECC or HANA version of SAP you can also view further information about RIHQMEL_LIST and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects