SAP table QMSM (Quality notification - tasks)

SAP table QMSM has 3 primary key fields being MANDT,QMNUM,MANUM.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
QMNUM Notification Number CHAR 12 0 QMEL QMNUM
MANUM Sequential Task Number NUMC 4 0 MANUM
MNKAT Catalog Type - Tasks CHAR 1 0 TQ15 MAKAT
MNGRP Code Group - Tasks CHAR 8 0 QPGR MAGRP
MNCOD Task Code CHAR 4 0 MNCOD
MNVER Version Number CHAR 6 0 QVERSNR
FOLGEACT Follow-Up Action for Task CHAR 8 0 TQ07 QMFOLACT
FOLACTPROT Log for Follow-Up Action CHAR 1 0 QMFOAPROT
MATXT Short Text for Task CHAR 40 0 MATXT
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ERDAT Date on which the record was created DATS 8 0 ERDAT
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
AEDAT Last Changed On DATS 8 0 AEDAT
PSTER Planned Start Date DATS 8 0 PSTER
PETER Planned Finish Date DATS 8 0 PETER
OBJNR Object Number for Status Management CHAR 22 0 ONR00 QMOBJNR
INDTX Object Long Text Available CHAR 1 0 INDLTX
KZMLA Primary language indicator for text segment CHAR 1 0 KZMLA
PSTUR Planned Start Time for Task TIMS 6 0 PSTUR
PETUR Planned Finish Time for Task TIMS 6 0 PETUR
ERLNAM Person Who Completed the Task CHAR 12 0 QMSMERLNAM
ERLDAT Date on Which the Task Was Completed DATS 8 0 QMSMERLDAT
ERLZEIT Time at Which Task Was Completed TIMS 6 0 QMSMERLTIM
WDVDAT Date on Which Task Was Resubmitted DATS 8 0 QMSMWDVDAT
FENUM Item Number in Item Record NUMC 4 0 QMFE FELFD
URNUM Sequential Number for Cause NUMC 4 0 URNUM
ERZEIT Time at Which Record Was Added TIMS 6 0 ERZEIT
AEZEIT Time of Change TIMS 6 0 AEZEIT
PARVW Function of Person Responsible for Task CHAR 2 0 TPAR QMSM_PARVW
PARNR Person Responsible for Task (Partner Number) CHAR 12 0 QMSM_PARNR
MMENGE Quantity QUAN 13 3 QSMMNG
MMGEIN Unit of Measure for Item UNIT 3 0 T006 QMGEIN
BAUTL Assembly Affected by the Task CHAR 40 0 QMSM_BAUTL
KZLOESCH Delete Data Record CHAR 1 0 KZLOESCH
QSMNUM Sort Number for Task NUMC 4 0 QSMNUM
AUTKZ Data Record Created with Function 'Create with Copy Model' CHAR 1 0 QAUTKZ
HANDLE Globally unique identifier (linked to time segment, etc) CHAR 22 0 TSEGGUID
TSEGFL Time segment exists CHAR 1 0 TSEGEXISTS
TSEGTP Template CHAR 10 0 TTSEGTPLH TSEGTEMPLA
TZONSO Time Zone for Notification CHAR 6 0 TTZZ TZONSO
TZONSM Time Zone for Task CHAR 6 0 TTZZ TZONSM
TZONID Origin of Time Zone in Notification CHAR 1 0 TZONSMID
Time zone for user (SY-ZONLO)
1 Equipment
2 Functional location
3 Plant
4 Customer
5 Vendor
TIMEBASEDEFFORT Time Effort for Task QUAN 13 3 QTSKTIMEBASEDEFFORT
TIMEBASEDEFFORTUOM Unit for Task Effort UNIT 3 0 T006 QTSKTIMEBASEDEFFORTUOM
DUMMY_QMSM_INCL_EEW_PS Dummy function in length 1 CHAR 1 0 DUMMY
KZACTIONBOX Created Using Action Box CHAR 1 0 QNKZACTIONBOX
FUNKTION Keys for Function in Action Box CHAR 4 0 QNFUNKTION
/SAPSMOSS/NOTE Note number NUMC 7 0 /SAPSMOSS/NOTE
/SAPSMOSS/REPORT Note created by CHAR 35 0 /SAPSMOSS/MEMOREPORT
/SAPSMOSS/MTSTMP Time stamp (date + time) NUMC 14 0 /SAPSMOSS/MEMOTSTMP
ABC_TEMPL Template CHAR 10 0 COTPL ABC_TEMPL
TASKTYPE Task Type CHAR 2 0 QTSKTYPE
DEFECTINTERNALID Internal Defect ID CHAR 12 0 QDEFECTINTERNALID
PRDCSSRQTASKINTERNALID Predecessor Quality Task Internal ID CHAR 12 0 PRDCSSRQTASKINTERNALID
TASKORIGIN Quality Task Origin CHAR 2 0 TQTASKORIGIN QTASKORIGIN
PROCESSOR Quality Task Processor CHAR 10 0 QTSKPROC
CHANGEDDATETIME UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 TZNTSTMPS
STATLCYCLE Quality Task Status CHAR 2 0 QTSKLCYCLESTAT
00 Created
10 In Process
20 Completed
STATACYCLE Quality Task Archiving Status CHAR 2 0 QTSKACYCLESTAT
Not Archived
10 Locked for Archiving
STATFOA Quality Task Follow-Up Action Status CHAR 2 0 QTSKFOASTAT
00 Assigned
10 Triggered
20 Successful
21 Not Successful
WDVZEIT Time at Which Task Was Resubmitted TIMS 6 0 QMSMWDVTIM
PROBSOLVINGPROCESS Problem-Solving Process NUMC 12 0 QPROBSOLVINGPROCESS
PROBSOLVINGPROCESSSTEP Problem-Solving Process Step CHAR 12 0 QPROBSOLVINGPROCESSSTEP
PRBOBSOLVPROCCAUSE Problem-Solving Process Cause NUMC 5 0 QPROBSOLVINGPROCESSCAUSE
TASKISCONTROLLEDBYORIGIN Quality Task Processing Is Controlled by Task Origin CHAR 1 0 QTASKCONTROLLEDBYORIGIN
EFFECTPERC Effect in Percentage NUMC 3 0 QN8D_EFFECTPERC
EFFECTTEXT Effect Text CHAR 40 0 QN8D_EFFECTTEXT

QMSM foreign key relationships

Table Field Check Table Check Field
0 QMSM ABC_TEMPL COTPL CO-ABC Template Master Data MANDT
0 QMSM ABC_TEMPL COTPL CO-ABC Template Master Data KOKRS
0 QMSM ABC_TEMPL COTPL CO-ABC Template Master Data TEMPLATE
1 QMSM FENUM QMFE Quality notification - items / Defect MANDT
0 QMSM MMGEIN T006 Units of Measurement MANDT
0 QMSM MMGEIN T006 Units of Measurement MSEHI
1 QMSM MNGRP QPGR Inspection catalog code groups MANDT
1 QMSM MNGRP QPGR Inspection catalog code groups KATALOGART
0 QMSM MNKAT TQ15 Inspection catalog type index KATALOGART
1 QMSM OBJNR ONR00 General Object Number MANDT
0 QMSM PARVW TPAR Business Partner: Functions PARVW
1 QMSM QMNUM QMEL Quality Notification MANDT
1 QMSM QMNUM QMEL Quality Notification QMNUM
0 QMSM TASKORIGIN TQTASKORIGIN Quality Task Origin TASKORIGIN
1 QMSM TIMEBASEDEFFORTUOM T006 Units of Measurement MANDT
1 QMSM TIMEBASEDEFFORTUOM T006 Units of Measurement MSEHI
0 QMSM TSEGTP TTSEGTPLH Time Segment Template Header TEPL
1 QMSM TZONSM TTZZ Time zones TZONE
0 QMSM TZONSO TTZZ Time zones TZONE