VIQMFEL SAP (Generated Table for View) Table View details
Dictionary Type: Table View
Description: Generated Table for View
Description: Generated Table for View
Table View field list including key, data, relationships and ABAP select examples
VIQMFEL is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.
The VIQMFEL table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include QMNUM (Notification No), FENUM (Item Number in Item Record), ERNAM (Name of Person who Created the Object), ERDAT (Date on Which Record Was Created).. 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: Not classified
SAP VIQMFEL table view 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 | QMEL | ALPHA | QMNUM | IQM | |
| FENUM | Item Number in Item Record | FELFD | NUMC | 4 | FELFD | ||||
| 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 | ||||
| FETXT | Notification Item Short Text | FETXT | CHAR | 40 | TEXT40 | ||||
| FEGRP | Code Group - Problem | FEGRP | CHAR | 8 | QPGR | QCODEGRP | |||
| FECOD | Problem or Damage Code | FECOD | CHAR | 4 | QCODE | ||||
| FEVER | Version Number | QVERSNR | CHAR | 6 | ALPHA | QVERSNR | |||
| OTGRP | Code Group - Object Parts | OTGRP | CHAR | 8 | QPGR | QCODEGRP | |||
| OTEIL | Part of Object | OTEIL | CHAR | 4 | QCODE | ||||
| OTVER | Version Number | QVERSNR | CHAR | 6 | ALPHA | QVERSNR | |||
| BAUTL | Assembly | BAUTL | CHAR | 18 | MARA | MATN1 | MATNR | MAT | |
| ERZEIT | Time, at Which Record Was Added | ERZEIT | TIMS | 6 | UHRZT | ||||
| AEZEIT | Time of Change | AEZEIT | TIMS | 6 | UHRZT | ||||
| KZORG | Originating Defect | KZORG | CHAR | 1 | QKZ | ||||
| WDFEH | Repetitive Defect | WDFEH | CHAR | 1 | QKZ | ||||
| ANZFEHLER | Number of Defects Found | QANZFEHL4 | INT4 | 10 | QANZAHL4 | ||||
| KZSYSFE | Systematic Defect | QKZSYSFE | CHAR | 1 | QKZ | ||||
| PROBENR | Sample Number | QPROBENR | NUMC | 6 | QASV | QPROBENR | QPO | ||
| MERKNR | Inspection Characteristic Number | QMERKNRP | NUMC | 4 | QMERKNRP | ||||
| UNITFLBEW | Unit for Defect Valuation | QUNITFLBEW | UNIT | 3 | T006 | CUNIT | MEINS | ||
| FEHLBEW | Defect Valuation | QFEHLBEW | FLTP | 16(16) | FLTP | ||||
| INDTX | Object Long Text Available | INDLTX | CHAR | 1 | CHAR1 | ||||
| KZMLA | Primary language indicator for text segment | KZMLA | CHAR | 1 | CHAR1 | ||||
| FEKAT | Catalog Type - Problems/Defects | FEKAT | CHAR | 1 | TQ15 | QKATART | |||
| OTKAT | Catalog Type - Object Parts | OTKAT | CHAR | 1 | TQ15 | QKATART | |||
| EBORT | Installation Point for Subitem | EBORT | CHAR | 20 | TEXT20 | ||||
| QMART | Notification Type | QMART | CHAR | 2 | TQ80 | QMART | QMR | ||
| QMTXT | Short Text | QMTXT | CHAR | 40 | TEXT40 | ||||
| ARTPR | Priority Type | ARTPR | CHAR | 2 | T356A | ARTPR | |||
| 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 | |
| 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 | ||||
| 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 | |
| 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 | ALPHA | CADRNR | |||
| QMKAT | Catalog Type - Coding | QMKAT | CHAR | 1 | TQ15 | QKATART | |||
| QMGRP | Code Group - Coding | QMGRP | CHAR | 8 | QPGR | QCODEGRP | |||
| QMCOD | Coding | QMCOD | CHAR | 4 | QCODE | ||||
| ARBPL | Object ID of the Work Center | LGWID | NUMC | 8 | 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 | ||||
| IWERK | Maintenance Planning Plant | IWERK | CHAR | 4 | T399I | WERKS | IWK | ||
| ILOAN | Location and account assignment for technical object | ILOAN | CHAR | 12 | ILOA | ILOAN | |||
| ILOAI | ILOA Individual | ILOAI | CHAR | 1 | X | ||||
| EQUNR | Equipment Number | EQUNR | CHAR | 18 | EQUI | ALPHA | EQUNR | EQN | EQUI |
| 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 | ||||
| AUSZT | Breakdown Duration | AUSZT | FLTP | 16(16) | FLTP | ||||
| 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 | ||
| TPLNR | Functional Location | TPLNR | CHAR | 30 | IFLOT | TPLNR | TPLNR | IFL | IFLM |
| ABCKZ | ABC indicator for technical object | ABCKZ | CHAR | 1 | T370C | ABCKZ | |||
| EQFNR | Sort field | EQFNR | CHAR | 30 | CHAR30 | ||||
| SWERK | Maintenance plant | SWERK | CHAR | 4 | T001W | WERKS | SWK | ||
| STORT | Location of maintenance object | PMLOC | CHAR | 10 | T499S | AP_STAND | |||
| MSGRP | Room | RAUMNR | CHAR | 8 | CHAR8 | ||||
| BEBER | Plant section | BEBER | CHAR | 3 | T357 | BEBER | BBE | ||
| CR_OBJTY | Object types of the CIM resource | CR_OBJTY | CHAR | 2 | CR_OBJTY | ||||
| PPSID | Object ID of PP work center | PPSID | NUMC | 8 | CRID | CR_OBJID | |||
| GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
| KOKRS | Controlling Area | KOKRS | CHAR | 4 | TKA01 | CACCD | CAC | ||
| KOSTL | Cost Center | KOSTL | CHAR | 10 | CSKS | ALPHA | KOSTL | KOS | |
| PROID | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | PRPS | KONPR | PS_POSNR | ||
| BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
| ANLNR | Main Asset Number | ANLN1 | CHAR | 12 | ANLH | ALPHA | ANLN1 | AN1 | |
| ANLUN | Asset Subnumber | ANLN2 | CHAR | 4 | ANLA | ALPHA | ANLN2 | AN2 | |
| DAUFN | Standing order number | DAUFN | CHAR | 12 | AUFK | ALPHA | AUFNR | ORDP | |
| ADRNR_ILOA | Address number | AD_ADDRNUM | CHAR | 10 | ADRC | ALPHA | AD_ADDRNUM | ADR | |
| PRIOK | Priority | PRIOK | CHAR | 1 | T356 | PRIOK | PRIOK | ||
| OWNER | Object reference indicator | ILOM_OWNER | CHAR | 1 | ILOM_OWNER | ||||
| KDAUF | Sales Document | VBELN_VA | CHAR | 10 | VBUK | ALPHA | VBELN | AUN | |
| KDPOS | Sales Document Item | POSNR_VA | NUMC | 6 | VBUP | POSNR | APO | ||
| KZLOESCH | Delete Data Record | KZLOESCH | CHAR | 1 | CHAR1 | ||||
| VKBUR | Sales Office | VKBUR | CHAR | 4 | TVKBZ | VKBUR | VKB | ||
| VKGRP | Sales Group | VKGRP | CHAR | 3 | TVBVK | VKGRP | VKG | ||
| SERIALNR | Serial Number | GERNR | CHAR | 18 | GERNR | GERNR | SER | ||
| DEVICEID | Additional Device Data | DEVICEID | CHAR | 40 | DEVICEID | ||||
| POSNR | Sort Number for Item | QLFDPOS | NUMC | 4 | QFELFD | ||||
| FEQKLAS | Defect Class | QFEHLKLAS | CHAR | 2 | TQ17 | QFEHLKLAS | |||
| PHASE | Notification Processing Phase | QM_PHASE | CHAR | 1 | QM_PHASE | ||||
| UII | Unique Item Identifier | UII_CHAR72 | CHAR | 72 | UII_CHAR72 | UII | H_UII | ||
| EQUNR_ITEM | Equipment Number | EQUNR | CHAR | 18 | ALPHA | EQUNR | EQN | EQUI | |
| TPLNR_ITEM | Functional Location | TPLNR | CHAR | 30 | TPLNR | TPLNR | IFL | IFLM |
| Key field | Non-key field |
How do I retrieve data from SAP table VIQMFEL using ABAP code
The following ABAP code Example will allow you to do a basic selection on VIQMFEL to SELECT all data from the tableDATA: WA_VIQMFEL TYPE VIQMFEL.
SELECT SINGLE *
FROM VIQMFEL
INTO CORRESPONDING FIELDS OF WA_VIQMFEL
WHERE...
How to access SAP table VIQMFEL
Within an ECC or HANA version of SAP you can also view further information about VIQMFEL 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