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