SAP table RQMQMSM1 (General notification - Tasks (reporting))

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
KTXTCD Code Text for Task CHAR 80 0 SMCODETEXT
KTXTGR Code Group Text for Task CHAR 40 0 SMGRPTEXT
QSMSTTXT Task Status CHAR 40 0 QSMSTTXT
QMART Notification Type CHAR 2 0 TQ80 QMART
QMTXT Short Text CHAR 40 0 QMTXT
ARTPR Priority Type CHAR 2 0 T356A ARTPR
PRIOK Priority CHAR 1 0 T356 PRIOK
STTXT System Status for Notification CHAR 40 0 QMSTTXT
MZEIT Time of Notification TIMS 6 0 MZEIT
QMDAT Date of Notification DATS 8 0 QMDAT
QMNAM Name of Person Reporting Notification CHAR 12 0 QMNAM
STRMN Required start date DATS 8 0 STRMN
STRUR Required Start Time TIMS 6 0 STRUR
LTRMN Required End Date DATS 8 0 LTRMN
LTRUR Required End Time TIMS 6 0 LTRUR
QMDAB Date for Notification Completion DATS 8 0 QMDAB
QMZAB Completion Time of Notification TIMS 6 0 QMZAB
BARBZT Processing Time DEC 11 2 BARBZT
MARBEH Processing Time Unit UNIT 3 0 T006 MARBEH
MAWERK Plant for Material CHAR 4 0 T001W QMAWERKS
MATNR Material Number CHAR 40 0 MARA MATNR
REVLV Revision Level CHAR 2 0 REVLV
KUNUM Account Number of Customer CHAR 10 0 KNA1 QKUNUM
RBNR Catalog Profile CHAR 9 0 T352B RBNR
LIFNUM Supplier Account Number CHAR 10 0 LFA1 LIFNUM
BUNAME Author of a QM/PM Notification CHAR 12 0 BUNAME
ADRNR Addresses: Address Number CHAR 10 0 CADNR
COAUFNR Order Number (QM Order) CHAR 12 0 AUFK COAUFNR
NAME_LIST Name for List Displays CHAR 35 0 I_NAME_LST
TEL_NUMBER First telephone no.: dialling code+number CHAR 30 0 AD_TLNMBR1
POST_CODE1 City postal code CHAR 10 0 AD_PSTCD1
CITY1 City CHAR 40 0 AD_CITY1
CITY2 District CHAR 40 0 AD_CITY2
COUNTRY Country/Region Key CHAR 3 0 LAND1
REGION Region (State, Province, County) CHAR 3 0 REGIO
STREET Street CHAR 60 0 AD_STREET
PARNAM_INT List name of internal employee resp.for carrying out job CHAR 35 0 I_NAME_INT
PRIOKX Priority Text CHAR 20 0 PRIOKX
HERSTELLER Number of Manufacturer CHAR 10 0 QLIFNR
MATKTX Material Description CHAR 40 0 MAKTX

RQMQMSM1 foreign key relationships

Table Field Check Table Check Field
0 RQMQMSM1 ABC_TEMPL COTPL CO-ABC Template Master Data MANDT
0 RQMQMSM1 ABC_TEMPL COTPL CO-ABC Template Master Data KOKRS
0 RQMQMSM1 ABC_TEMPL COTPL CO-ABC Template Master Data TEMPLATE
1 RQMQMSM1 ARTPR T356A Priority type table MANDT
1 RQMQMSM1 ARTPR T356A Priority type table ARTPR
0 RQMQMSM1 COAUFNR AUFK Order master data AUFNR
1 RQMQMSM1 FENUM QMFE Quality notification - items / Defect MANDT
0 RQMQMSM1 KUNUM KNA1 General Data in Customer Master MANDT
0 RQMQMSM1 KUNUM KNA1 General Data in Customer Master KUNNR
1 RQMQMSM1 LIFNUM LFA1 Supplier Master (General Section) MANDT
1 RQMQMSM1 LIFNUM LFA1 Supplier Master (General Section) LIFNR
0 RQMQMSM1 MARBEH T006 Units of Measurement MANDT
0 RQMQMSM1 MARBEH T006 Units of Measurement MSEHI
1 RQMQMSM1 MATNR MARA General Material Data MANDT
1 RQMQMSM1 MATNR MARA General Material Data MATNR
0 RQMQMSM1 MAWERK T001W Plants/Branches MANDT
0 RQMQMSM1 MAWERK T001W Plants/Branches WERKS
1 RQMQMSM1 MMGEIN T006 Units of Measurement MANDT
1 RQMQMSM1 MMGEIN T006 Units of Measurement MSEHI
0 RQMQMSM1 MNGRP QPGR Inspection catalog code groups MANDT
0 RQMQMSM1 MNGRP QPGR Inspection catalog code groups KATALOGART
1 RQMQMSM1 MNKAT TQ15 Inspection catalog type index KATALOGART
0 RQMQMSM1 OBJNR ONR00 General Object Number MANDT
1 RQMQMSM1 PARVW TPAR Business Partner: Functions PARVW
0 RQMQMSM1 PRIOK T356 Priorities MANDT
0 RQMQMSM1 PRIOK T356 Priorities ARTPR
1 RQMQMSM1 QMART TQ80 Notification Types MANDT
1 RQMQMSM1 QMART TQ80 Notification Types QMART
0 RQMQMSM1 QMNUM QMEL Quality Notification MANDT
0 RQMQMSM1 QMNUM QMEL Quality Notification QMNUM
1 RQMQMSM1 RBNR T352B Technical report MANDT
0 RQMQMSM1 TASKORIGIN TQTASKORIGIN Quality Task Origin TASKORIGIN
1 RQMQMSM1 TIMEBASEDEFFORTUOM T006 Units of Measurement MANDT
1 RQMQMSM1 TIMEBASEDEFFORTUOM T006 Units of Measurement MSEHI
0 RQMQMSM1 TSEGTP TTSEGTPLH Time Segment Template Header TEPL
1 RQMQMSM1 TZONSM TTZZ Time zones TZONE
0 RQMQMSM1 TZONSO TTZZ Time zones TZONE