RQMQMEL3 SAP (General Notification - Notifications (Reporting)) Structure details
Description: General Notification - Notifications (Reporting)
Structure field list including key, data, relationships and ABAP select examples
RQMQMEL3 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 "General Notification - Notifications (Reporting)" 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_RQMQMEL3 TYPE RQMQMEL3.
The RQMQMEL3 table consists of various fields, each holding specific information or linking keys about General Notification - Notifications (Reporting) data available in SAP. These include QMNUM (Notification No), QMART (Notification Type), QMTXT (Short Text), ARTPR (Priority Type).. 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 RQMQMEL3 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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
QMNUM | Notification No | QMNUM | CHAR | 12 | Assigned to domain | ALPHA | QMNUM | IQM | |
QMART | Notification Type | QMART | CHAR | 2 | TQ80 | QMART | QMR | ||
QMTXT | Short Text | QMTXT | CHAR | 40 | TEXT40 | ||||
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 | ||||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
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 | |
VERID | Production Version | VERID | CHAR | 4 | MKAL | VERID | VER | ||
RM_MATNR | Material number of the production version | RM_MATNR | CHAR | 18 | MKAL | MATN1 | MATNR | MAT | MAT1 |
RM_WERKS | Plant of production version | RM_WERKS | CHAR | 4 | MKAL | WERKS | WRK | H_T001W | |
MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
REVLV | Revision Level | REVLV | CHAR | 2 | NUMCV | REVLV | RVS | ||
KUNUM | Account Number of Customer | QKUNUM | CHAR | 10 | KNA1 | ALPHA | KUNNR | KUN | |
FEKNZ | Error Records Exist | FEKNZ | CHAR | 1 | CHAR1 | ||||
MAKNZ | Task Records Exist | MAKNZ | CHAR | 1 | CHAR1 | ||||
OBJNR | Object Number for Status Management | QMOBJNR | CHAR | 22 | ONR00 | J_OBJNR | |||
QMDAB | Date for Notification Completion | QMDAB | DATS | 8 | DATUM | ||||
QMZAB | Completion Time of Notification | QMZAB | TIMS | 6 | UZEIT | ||||
RBNR | Catalog Profile | RBNR | CHAR | 9 | T352B | RBNR | |||
RBNRI | Origin of Notifications Catalog Profile | RBNRI | CHAR | 1 | RBNRI | ||||
INDTX | Object Long Text Available | INDLTX | CHAR | 1 | CHAR1 | ||||
KZMLA | Primary language indicator for text segment | KZMLA | CHAR | 1 | CHAR1 | ||||
HERKZ | Origin of Notification | HERKZ | CHAR | 2 | HERKZ | ||||
BEZDT | Notification Reference Date | BEZDT | DATS | 8 | DATUM | ||||
BEZUR | Notification Reference Time | BEZUR_D | TIMS | 6 | UZEIT | ||||
LIFNUM | Vendor Account Number | LIFNUM | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | |
BUNAME | Author of a Q/PM Notification | BUNAME | CHAR | 12 | Assigned to domain | XUBNAME | XUS | ||
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 | |
ADRNR | Addresses: Address Number | CADNR | CHAR | 10 | Assigned to domain | ALPHA | CADRNR | ||
AEZEIT | Time of Change | AEZEIT | TIMS | 6 | UHRZT | ||||
ERZEIT | Time, at Which Record Was Added | ERZEIT | TIMS | 6 | UHRZT | ||||
MAWERK | Plant for Material | QMAWERKS | CHAR | 4 | T001W | WERKS | WRK | ||
QMKAT | Catalog Type - Coding | QMKAT | CHAR | 1 | TQ15 | QKATART | |||
QMGRP | Code Group - Coding | QMGRP | CHAR | 8 | QPGR | QCODEGRP | |||
QMCOD | Coding | QMCOD | CHAR | 4 | Assigned to domain | QCODE | |||
PRUEFLOS | Inspection Lot Number | QPLOS | NUMC | 12 | QALS | QPLOS | QLS | QALS | |
CHARG | Batch Number | CHARG_D | CHAR | 10 | MCH1 | CHARG | CHA | ||
LGORTCHARG | Storage Location of Batch | QLGORTCHAR | CHAR | 4 | T001L | LGORT | LAG | ||
LICHN | Vendor Batch Number | LICHN | CHAR | 15 | LICHN | ||||
HERSTELLER | Number of Manufacturer | QLIFNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | |
EMATNR | Material Number Corresponding to Manufacturer Part Number | EMATN | CHAR | 18 | MARA | MATN1 | MATNR | HTN | |
EKORG | Purchasing Organization | EKORG | CHAR | 4 | T024E | EKORG | EKO | ||
BKGRP | Purchasing Group | BKGRP | CHAR | 3 | T024 | EKGRP | EKG | ||
LGORTVORG | Storage Location for Inspection Lot Stock | QLGORTVORG | CHAR | 4 | T001L | LGORT | |||
FERTAUFNR | Order Number (Production Order) | FERTAUFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ANR | |
FERTAUFPL | Plan Number for Operations in Order (Production Order) | FERTAUFPL | NUMC | 10 | AUFPL | ||||
EBELN | Purchasing Document Number | EBELN | CHAR | 10 | EKKO | ALPHA | EBELN | BES | MEKK_C |
EBELP | Item Number of Purchasing Document | QEBELP | NUMC | 5 | EKPO | EBELP | BSP | ||
MJAHR | Material Document Year | MJAHR | NUMC | 4 | GJAHR | GJAHR | MJA | ||
MBLNR | Number of Material Document | MBLNR | CHAR | 10 | ALPHA | BELNR | MBN | ||
MBLPO | Item in Material Document | QMBLPO | NUMC | 4 | MBLPO | POS | |||
LS_KDAUF | Sales Order Number | KDAUF | CHAR | 10 | VBUK | ALPHA | VBELN | AUN | |
LS_KDPOS | Item Number in Sales Order | KDPOS | NUMC | 6 | NUM06 | KPO | |||
LS_VBELN | Delivery | VBELN_VL | CHAR | 10 | VBUK | ALPHA | VBELN | VL | |
LS_POSNR | Delivery Item | QPOSNR_VL | NUMC | 6 | VBUP | POSNR | |||
CROBJTY | Object types of the CIM resource | CR_OBJTY | CHAR | 2 | CR_OBJTY | ||||
ARBPL | Object ID of the Work Center | LGWID | NUMC | 8 | CRID | CR_OBJID | |||
ARBPLWERK | Plant for Work Center | QARBPWERKS | CHAR | 4 | T001W | WERKS | WRK | ||
FEART | Report Type for Defects Recording | QFEART | CHAR | 8 | TQ86 | QFEART | QFE | ||
PNLKN | Current Node Number from Order Counter APLZL | QLFNKN | NUMC | 8 | KNTNR | ||||
MGEIG | Defective Quantity (Internal) | MGEIG | QUAN | 13(3) | MENGE | ||||
MGFRD | Defective Quantity (External) | MGFRD | QUAN | 13(3) | MENGE | ||||
MGEIN | Unit of Measure | MGEIN | UNIT | 3 | T006 | CUNIT | MEINS | ||
BZMNG | General Reference Quantity | QBZMNG | QUAN | 13(3) | MENGE | ||||
RKMNG | Complaint Quantity | RKMNG | QUAN | 13(3) | MENGE | ||||
RGMNG | Return Delivery Quantity | RGMNG | QUAN | 13(3) | MENGE | ||||
RKDAT | Date of Return Delivery | RKDAT | DATS | 8 | DATUM | ||||
COAUFNR | Order Number (QM Order) | COAUFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ANR | |
QWRNUM | Reference Notification Number | QWRNUM | CHAR | 12 | QMEL | ALPHA | QMNUM | IQM | |
REFNUM | External Reference Number | QMEXTNR | CHAR | 20 | CHAR020 | ||||
KDMAT | Material Number Used by Customer | MATNR_KU | CHAR | 35 | IDNEX | ||||
IDNLF | Material Number Used by Vendor | IDNLF | CHAR | 35 | IDNEX | ||||
SERIALNR | Serial Number | GERNR | CHAR | 18 | GERNR | GERNR | SER | ||
KZLOESCH | Delete Data Record | KZLOESCH | CHAR | 1 | CHAR1 | ||||
DEVICEID | Additional Device Data | DEVICEID | CHAR | 40 | DEVICEID | ||||
KTXTGR | Code Group Text for Coding | QMGRPTEXT | CHAR | 40 | QKURZTEXT | ||||
KTXTCD | Code Text for Coding | QMCODETEXT | CHAR | 80 | QTEXT80 | ||||
STTXT | System Status for Notification | QMSTTXT | CHAR | 40 | TEXT40 | ||||
BARBZT | Processing Time | BARBZT | DEC | 11(2) | DEC9_2 | ||||
MARBEH | Processing Time Unit | MARBEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
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 | T005 | LAND1 | LND | ||
REGION | STATE (State, Province, County) | REGIO | CHAR | 3 | T005S | REGIO | |||
STREET | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
ARBPL_I | Work center | ARBPL | CHAR | 8 | ARBPL | AGR | |||
VORNR | Operation Number | QVORNR | CHAR | 4 | NUMCV | VORNR | QVO | ||
VORKTEXT | Short Text | QKURZTEXT | CHAR | 40 | QKURZTEXT | ||||
FERTVORNR | Operation Number | QVORNR | CHAR | 4 | NUMCV | VORNR | QVO | ||
FERTVORKTX | Short Text | QKURZTEXT | CHAR | 40 | QKURZTEXT | ||||
VKBUR | Sales Office | VKBUR | CHAR | 4 | Assigned to domain | VKBUR | VKB | ||
VKGRP | Sales Group | VKGRP | CHAR | 3 | Assigned to domain | VKGRP | VKG | ||
PRIOKX | Priority Text | PRIOKX | CHAR | 20 | TEXT20 | ||||
MATKTX | Material Description (Short Text) | MAKTX | CHAR | 40 | TEXT40 |
Key field | Non-key field |
How do I retrieve data from SAP structure RQMQMEL3 using ABAP code?
As RQMQMEL3 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 RQMQMEL3 as there is no data to select.How to access SAP table RQMQMEL3
Within an ECC or HANA version of SAP you can also view further information about RQMQMEL3 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