VIQMELST 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
VIQMELST 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 VIQMELST table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include OBJNR (Object number), STAT (Object status), QMNUM (Notification No), QMART (Notification 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: Not classified
SAP VIQMELST 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 | |||
OBJNR | Object number | J_OBJNR | CHAR | 22 | ONR00 | J_OBJNR | ONR | ||
STAT | Object status | J_STATUS | CHAR | 5 | J_STATUS | ||||
QMNUM | Notification No | QMNUM | CHAR | 12 | 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 | |
SA_AUFNR | Run schedule header number | SA_AUFNR | CHAR | 12 | SAFK | ALPHA | SA_AUFNR | ||
MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
REVLV | Revision Level | REVLV | CHAR | 2 | NUMCV | REVLV | RVS | ||
MATKL | Material Group | MATKL | CHAR | 9 | T023 | MATKL | MKL | S_WBWG | |
PRDHA | Product hierarchy | PRODH_D | CHAR | 18 | T179 | PRODH | VPR | ||
KZKRI | Indicator: Critical part | KZKRI | CHAR | 1 | XFELD | ||||
KZDKZ | Documentation required indicator | KZDKZ | CHAR | 1 | XFELD | ||||
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 | ||||
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 | 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 | ALPHA | CADRNR | |||
ERZEIT | Time, at Which Record Was Added | ERZEIT | TIMS | 6 | UHRZT | ||||
QMKAT | Catalog Type - Coding | QMKAT | CHAR | 1 | TQ15 | QKATART | |||
QMGRP | Code Group - Coding | QMGRP | CHAR | 8 | QPGR | QCODEGRP | |||
AUSWIRK | Key for a Scenario | QSCENARIO | CHAR | 4 | TQ81 | QSCENARIO | |||
TEILEV | Usage of Parts | QTEILEV | CHAR | 4 | TQ81V | QTEILEV | |||
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 of the SD document | POSNR | NUMC | 6 | VBUP | POSNR | |||
LS_VBELN | Delivery | VBELN_VL | CHAR | 10 | VBUK | ALPHA | VBELN | VL | |
LS_POSNR | Delivery Item | QPOSNR_VL | NUMC | 6 | VBUP | POSNR | |||
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 | ||||
PRODDAT | Production Date | QPRODDAT | DATS | 8 | DATUM | ||||
DEVICEID | Additional Device Data | DEVICEID | CHAR | 40 | DEVICEID | ||||
VKBUR | Sales Office | VKBUR | CHAR | 4 | TVKBZ | VKBUR | VKB | ||
VKGRP | Sales Group | VKGRP | CHAR | 3 | TVBVK | VKGRP | VKG | ||
AUTKZ | Data Record Created with Function 'Create with Copy Model' | QAUTKZ | CHAR | 1 | QKZ | ||||
BEDID | ID of the capacity requirements record | BEDID | NUMC | 12 | BEDID | ||||
BEDZL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
PROFIL_TYP | Object Type | OTYPE | CHAR | 2 | OTYPE | POT | |||
PROFIL_ID | Object ID | OBJEKTID | NUMC | 8 | NUM08 | PON | |||
HANDLE | Globally unique identifier (linked to time segment, etc) | TSEGGUID | CHAR | 22 | SYSUUID_22 | ||||
TSEGFL | Time segment exists | TSEGEXISTS | CHAR | 1 | FLAG | ||||
TSEGTP | Template | TSEGTEMPLA | CHAR | 10 | TTSEGTPLH | TMPLA | TSEGTEMPLA | ||
TZONSO | Time Zone for Notification | TZONSO | CHAR | 6 | TTZZ | TZNZONE | |||
TZONID | Origin of Time Zone in Notification | TZONSMID | CHAR | 1 | TZONSMID | ||||
FUNKTION | Keys for Function in Action Box | QNFUNKTION | CHAR | 4 | CHAR4 | ||||
/SAPSMOSS/INSTN | Installation number | /SAPSMOSS/R3INSTN | CHAR | 10 | /SAPSMOSS/INSTN | /SAPSMOSS/R3INSTN | |||
/SAPSMOSS/MNUMM | SAPNet notification number | /SAPSMOSS/MNUMM | NUMC | 24 | /SAPSMOSS/MNUMM | ||||
/SAPSMOSS/OSSYS | Operating system and version | /SAPSMOSS/OSSYS | CHAR | 10 | /SAPSMOSS/OSYS | /SAPSMOSS/OSSYS | |||
/SAPSMOSS/DBSYS | Database system | /SAPSMOSS/DBSYS | CHAR | 10 | /SAPSMOSS/DBSY | /SAPSMOSS/DBSYS | |||
/SAPSMOSS/REL | R/3 Release | /SAPSMOSS/R3REL | CHAR | 10 | /SAPSMOSS/REL | /SAPSMOSS/R3REL | |||
/SAPSMOSS/COMP | Area | /SAPSMOSS/R3COMP | CHAR | 20 | /SAPSMOSS/R3COMP | ||||
/SAPSMOSS/FRONT | Frontend | /SAPSMOSS/FRONTEND | CHAR | 10 | /SAPSMOSS/FRNT | /SAPSMOSS/FRONTEND | |||
/SAPSMOSS/SYSTYP | R/3 System type | /SAPSMOSS/R3SYSTYPE | CHAR | 1 | /SAPSMOSS/SYST | /SAPSMOSS/R3SYSTYPE | |||
/SAPSMOSS/ADDID | Add-on ID | /SAPSMOSS/R3ADDID | CHAR | 10 | /SAPSMOSS/ADDID | /SAPSMOSS/R3ADDID | |||
/SAPSMOSS/ADDREL | Add-On Release | /SAPSMOSS/R3ADDREL | CHAR | 10 | /SAPSMOSS/ADDRL | /SAPSMOSS/R3ADDREL | |||
/SAPSMOSS/TSTMP | SAPNet time stamp | /SAPSMOSS/NSTSTMP | NUMC | 14 | TZNTIMESTP | ||||
/SAPSMOSS/STATUS | Status of R/3 notification in SAPNet | /SAPSMOSS/STATUS | CHAR | 1 | /SAPSMOSS/STAT | /SAPSMOSS/STATUS | |||
/SAPSMOSS/ERDAT | Date on which notification was completed at SAP | /SAPSMOSS/ERDAT | DATS | 8 | DATUM | ||||
/SAPSMOSS/ERZEIT | Time when notification was completed at SAP | /SAPSMOSS/ERZEIT | TIMS | 6 | UHRZT | ||||
/SAPSMOSS/SYSID | Name of SAP System | SYSYSID | CHAR | 8 | SYCHAR08 | ||||
/SAPSMOSS/MANDT | Client ID | SYMANDT | CLNT | 3 | MANDT | ||||
PSP_NR | WBS Element | PS_POSNR | NUMC | 8 | ABPSP | PS_POSNR | |||
ESTIMATED_COSTS | Estimated Costs for a Claim | PS_COSTS | CURR | 13(2) | WERTV7 | ||||
CLAIMED_COSTS | Costs Claimed | COSTS_CLAIM | CURR | 13(2) | WERTV7 | ||||
RESULT_COSTS | Costs Accepted | COSTS_RESULT | CURR | 13(2) | WERTV7 | ||||
CHANCE | Chance of Completing a Claim | PS_CHANCE | NUMC | 2 | PS_CHANCE | ||||
OPPONENT | Partner Type | PS_OPPONENT | CHAR | 2 | OPPONENT | ||||
KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | CK_KALNR | NUMC | 12 | CK_KALNR | KNR | |||
KALVAR | Costing Variant for Postprocessing with Unit Costing | CK_KALVAR | CHAR | 4 | KLVAR | ||||
OBJNR_REAL | Object number of real CO account assignment | J_OBJNR_REAL | CHAR | 22 | ONR00 | J_OBJNR | ONR | ||
OBJNR_STAT | Auxiliary account assignment 1 | OBJNR_N1 | CHAR | 22 | ONR00 | J_OBJNR | |||
PHASE | Notification Processing Phase | QM_PHASE | CHAR | 1 | QM_PHASE | ||||
/ISDFPS/OBJNR | Object number | J_OBJNR | CHAR | 22 | J_OBJNR | ONR | |||
LOGSYSTEM | Logical System | LOGSYSTEM | CHAR | 10 | ALPHA | LOGSYS | |||
/ISDFPS/MEQUI | Master Equipment | /ISDFPS/MEQUI | CHAR | 18 | ALPHA | EQUNR | |||
SHN_OBJTY | Object types of the CIM resource | CR_OBJTY | CHAR | 2 | CR_OBJTY | ||||
SHN_OBJID | Object ID of the resource | CR_OBJID | NUMC | 8 | CR_OBJID | ||||
SHN_FUNCT_LOC | Functional Location | TPLNR | CHAR | 30 | TPLNR | TPLNR | IFL | IFLM | |
SHN_EQUIPMENT | Equipment Number | EQUNR | CHAR | 18 | ALPHA | EQUNR | EQN | EQUI | |
SHN_ORIGIN | Origin or Use of Shift Note or Report | COCF_SRN_ORIGIN | NUMC | 2 | COCF_SRN_ORIGIN | ||||
UII | Unique Item Identifier | UII_CHAR72 | CHAR | 72 | UII_CHAR72 | UII | H_UII | ||
ILOAN | Location and account assignment for technical object | ILOAN | CHAR | 12 | ILOAN | ||||
IWERK | Maintenance Planning Plant | IWERK | CHAR | 4 | T399I | WERKS | IWK | ||
EQUNR | Equipment Number | EQUNR | CHAR | 18 | EQUI | ALPHA | EQUNR | EQN | EQUI |
BAUTL | Assembly | BAUTL | CHAR | 18 | MARA | MATN1 | MATNR | MAT | |
EBORT | Installation Point for Subitem | EBORT | CHAR | 20 | TEXT20 | ||||
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 | ||
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 | |
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 | |
PPSID | Object ID of PP work center | PPSID | NUMC | 8 | CRID | CR_OBJID | |||
ILOAI | ILOA Individual | ILOAI | CHAR | 1 | X | ||||
ABCKZI | Data origin for ABC indicator field | INH_ABCKZI | CHAR | 1 | INHER | ||||
EQFNRI | Data origin for sort field | INH_EQFNRI | CHAR | 1 | INHER | ||||
SWERKI | Data origin for maintenance plant field | INH_SWERKI | CHAR | 1 | INHER | ||||
STORTI | Data origin for location field | INH_STORTI | CHAR | 1 | INHER | ||||
MSGRPI | Data origin for room number field | INH_MSGRPI | CHAR | 1 | INHER | ||||
BEBERI | Data origin for plant section field | INH_BEBERI | CHAR | 1 | INHER | ||||
CR_OBJTY | Object types of the CIM resource | CR_OBJTY | CHAR | 2 | CR_OBJTY | ||||
PPSIDI | Data origin for PP work center field | INH_PPSIDI | CHAR | 1 | INHER | ||||
GSBERI | Data origin for business area field | INH_GSBERI | CHAR | 1 | INHER | ||||
KOKRSI | Data origin for controlling area field | INH_KOKRSI | CHAR | 1 | INHER | ||||
KOSTLI | Data origin for cost center field | INH_KOSTLI | CHAR | 1 | INHER | ||||
PROID | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | PRPS | KONPR | PS_POSNR | ||
PROIDI | Data origin for WBS element field | INH_PROIDI | CHAR | 1 | INHER | ||||
BUKRSI | Data origin for company code field | INH_BUKRSI | CHAR | 1 | INHER | ||||
ANLNRI | Data origin for asset main no./sub-no. fields | INH_ANLNRI | CHAR | 1 | INHER | ||||
ANLUNI | Data origin indicator | INHER | CHAR | 1 | INHER | ||||
DAUFN | Standing order number | DAUFN | CHAR | 12 | AUFK | ALPHA | AUFNR | ORDP | |
DAUFNI | Data origin of standing order number field | INH_DAUFNI | CHAR | 1 | INHER | ||||
KAUFN | Settlement order | ILOM_ORDST | CHAR | 12 | AUFK | ALPHA | AUFNR | ORDE | |
AUFNRI | Data origin for settlement order field | INH_AUFNRI | CHAR | 1 | INHER | ||||
ADRNR_ILOA | Address number | AD_ADDRNUM | CHAR | 10 | ADRC | ALPHA | AD_ADDRNUM | ADR | |
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 | ||
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 | ||
AEZEIT | Time of Change | AEZEIT | TIMS | 6 | UHRZT | ||||
MAWERK | Plant for Material | QMAWERKS | CHAR | 4 | T001W | WERKS | WRK | ||
QMCOD | Coding | QMCOD | CHAR | 4 | QCODE | ||||
WARPL | Maintenance Plan | WARPL | CHAR | 12 | MPLA | ALPHA | WARPL | MPL | MPLAL |
WAPOS | Maintenance item | WAPOS | CHAR | 16 | ALPHA | POSNU | MPS | MPOSL | |
REVNR | Revision for Plant Maintenance and Customer Service | REVNI | CHAR | 8 | REVNI |
Key field | Non-key field |
How do I retrieve data from SAP table VIQMELST using ABAP code
The following ABAP code Example will allow you to do a basic selection on VIQMELST to SELECT all data from the tableDATA: WA_VIQMELST TYPE VIQMELST.
SELECT SINGLE *
FROM VIQMELST
INTO CORRESPONDING FIELDS OF WA_VIQMELST
WHERE...
How to access SAP table VIQMELST
Within an ECC or HANA version of SAP you can also view further information about VIQMELST 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