WQMSM SAP (Work Table for Tasks) Structure details

Dictionary Type: Structure
Description: Work Table for Tasks




ABAP Code to SELECT data from WQMSM
Related tables to WQMSM
Access table WQMSM




Structure field list including key, data, relationships and ABAP select examples

WQMSM 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 "Work Table for Tasks" 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_WQMSM TYPE WQMSM.

The WQMSM table consists of various fields, each holding specific information or linking keys about Work Table for Tasks data available in SAP. These include MANDT (Client), QMNUM (Notification No), MANUM (Sequential Task Number), MNKAT (Catalog Type - Tasks).. 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 WQMSM 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
MANDTClient MANDTCLNT3T000MANDT
QMNUMNotification No QMNUMCHAR12QMELALPHAQMNUMIQM
MANUMSequential Task Number MANUMNUMC4NUM4IMA
MNKATCatalog Type - Tasks MAKATCHAR1TQ15QKATART
MNGRPCode Group - Tasks MAGRPCHAR8QPGRQCODEGRP
MNCODTask Code MNCODCHAR4Assigned to domainQCODE
MNVERVersion Number QVERSNRCHAR6ALPHAQVERSNR
FOLGEACTFollow-Up Action for Task QMFOLACTCHAR8TQ07QFOLGEAKTI
FOLACTPROTLog for Follow-Up Action QMFOAPROTCHAR1QKZ
MATXTShort Text for Task MATXTCHAR40TEXT40
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
ERDATDate on Which Record Was Created ERDATDATS8DATUM
AENAMName of Person Who Changed Object AENAMCHAR12USNAM
AEDATChanged On AEDATDATS8DATUM
PSTERPlanned Start Date PSTERDATS8DATUM
PETERPlanned finish date PETERDATS8DATUM
OBJNRObject Number for Status Management QMOBJNRCHAR22ONR00J_OBJNR
INDTXObject Long Text Available INDLTXCHAR1CHAR1
KZMLAPrimary language indicator for text segment KZMLACHAR1CHAR1
PSTURPlanned Start Time for Task PSTURTIMS6UZEIT
PETURPlanned Finish Time for Task PETURTIMS6UZEIT
ERLNAMPerson Who Completed the Task QMSMERLNAMCHAR12USNAM
ERLDATDate on Which the Task Was Completed QMSMERLDATDATS8DATUM
ERLZEITTime at Which Task Was Completed QMSMERLTIMTIMS6UZEIT
WDVDATDate on Which Task Was Resubmitted QMSMWDVDATDATS8DATUM
FENUMItem Number in Item Record FELFDNUMC4QMFEFELFD
URNUMSequential Number for Cause URNUMNUMC4NUM4
ERZEITTime, at Which Record Was Added ERZEITTIMS6UHRZT
AEZEITTime of Change AEZEITTIMS6UHRZT
PARVWFunction of Person Responsible for Task QMSM_PARVWCHAR2TPARPARVWPARVWPAR
PARNRPerson Responsible for Task (Partner Number) QMSM_PARNRCHAR12ALPHAI_PARNR
MMENGEQuantity QSMMNGQUAN13(3) MENGE
MMGEINUnit of Measure for Item QMGEINUNIT3T006CUNITMEINS
BAUTLAssembly Affected by the Task QMSM_BAUTLCHAR18Assigned to domainMATN1MATNRMAT1
KZLOESCHDelete Data Record KZLOESCHCHAR1CHAR1
QSMNUMSort Number for Task QSMNUMNUMC4NUMC04
AUTKZData Record Created with Function 'Create with Copy Model' QAUTKZCHAR1QKZ
HANDLEGlobally unique identifier (linked to time segment, etc) TSEGGUIDCHAR22SYSUUID_22
TSEGFLTime segment exists TSEGEXISTSCHAR1FLAG
TSEGTPTemplate TSEGTEMPLACHAR10TTSEGTPLHTMPLATSEGTEMPLA
TZONSOTime Zone for Notification TZONSOCHAR6TTZZTZNZONE
TZONSMTime Zone for Task TZONSMCHAR6TTZZTZNZONE
TZONIDOrigin of Time Zone in Notification TZONSMIDCHAR1TZONSMID
KZACTIONBOXCreated Using Action Box QNKZACTIONBOXCHAR1QKZ
FUNKTIONKeys for Function in Action Box QNFUNKTIONCHAR4CHAR4
/SAPSMOSS/NOTENote number /SAPSMOSS/NOTENUMC7/SAPSMOSS/NOTE
/SAPSMOSS/REPORTNote created by /SAPSMOSS/MEMOREPORTCHAR35/SAPSMOSS/MEMOREPORT
/SAPSMOSS/MTSTMPTime stamp (date + time) /SAPSMOSS/MEMOTSTMPNUMC14TZNTIMESTP
ABC_TEMPLTemplate ABC_TEMPLCHAR10COTPLABC_TEMPLABT
.INCLU--AP 0
EFFECTPERCEffect in Percentage QN8D_EFFECTPERCNUMC3
EFFECTTEXTEffect Text QN8D_EFFECTTEXTCHAR40CHAR40K
AEKNZChange indicator AEKNZCHAR1FLAG
PRTKZPrint Indicator PRTKZCHAR1XFELD
TXTGRShort Description of the Code Group QKTEXTGRCHAR40QKURZTEXT
TXTCDTask Code Short Text TXTCDSMCHAR40TEXT40
TXTCDGRShort Text for Task Code QTXTCDGRSMCHAR80QTEXT80
STTXTSystem Status for Notification QMSTTXTCHAR40TEXT40
ASTEXUser Status Active QMASTEXCHAR1KREUZ
ASTXTField displaying user status CO_ASTTXCHAR40CHAR40
KZQMSMIndicator: Task Completed QKZQMSMCHAR1CHAR1
FOLGEACTXTShort Text QKURZTEXTCHAR40QKURZTEXT

Key field Non-key field



How do I retrieve data from SAP structure WQMSM using ABAP code?

As WQMSM 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 WQMSM as there is no data to select.

How to access SAP table WQMSM

Within an ECC or HANA version of SAP you can also view further information about WQMSM and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!