1. Home
  2. Resources
  3. SAP Tables
  4. RQMQMSM1 - General notification - Tasks (reporting)

SAP Table RQMQMSM1

General notification - Tasks (reporting)

RQMQMSM1 (General notification - Tasks (reporting)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link RQMQMSM1 to other SAP tables.

RQMQMSM1 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
QMNUM Notification No QMNUM QMEL CHAR 12 0
MANUM Sequential Task Number MANUM NUMC 4 0
MNKAT Catalog Type - Tasks MAKAT TQ15 CHAR 1 0
MNGRP Code Group - Tasks MAGRP QPGR CHAR 8 0
MNCOD Task Code MNCOD CHAR 4 0
MNVER Version Number QVERSNR CHAR 6 0
FOLGEACT Follow-Up Action for Task QMFOLACT TQ07 CHAR 8 0
FOLACTPROT Log for Follow-Up Action QMFOAPROT CHAR 1 0
NULL Indicator is not set
X Indicator is set
MATXT Short Text for Task MATXT CHAR 40 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
AEDAT Changed On AEDAT DATS 8 0
PSTER Planned Start Date PSTER DATS 8 0
PETER Planned finish date PETER DATS 8 0
OBJNR Object Number for Status Management QMOBJNR ONR00 CHAR 22 0
INDTX Object Long Text Available INDLTX CHAR 1 0
KZMLA Primary language indicator for text segment KZMLA CHAR 1 0
PSTUR Planned Start Time for Task PSTUR TIMS 6 0
PETUR Planned Finish Time for Task PETUR TIMS 6 0
ERLNAM Person Who Completed the Task QMSMERLNAM CHAR 12 0
ERLDAT Date on Which the Task Was Completed QMSMERLDAT DATS 8 0
ERLZEIT Time at Which Task Was Completed QMSMERLTIM TIMS 6 0
WDVDAT Date on Which Task Was Resubmitted QMSMWDVDAT DATS 8 0
FENUM Item Number in Item Record FELFD QMFE NUMC 4 0
URNUM Sequential Number for Cause URNUM NUMC 4 0
ERZEIT Time, at Which Record Was Added ERZEIT TIMS 6 0
AEZEIT Time of Change AEZEIT TIMS 6 0
PARVW Function of Person Responsible for Task QMSM_PARVW TPAR CHAR 2 0
PARNR Person Responsible for Task (Partner Number) QMSM_PARNR CHAR 12 0
MMENGE Quantity QSMMNG QUAN 13 3
MMGEIN Unit of Measure for Item QMGEIN T006 UNIT 3 0
BAUTL Assembly Affected by the Task QMSM_BAUTL CHAR 18 0
KZLOESCH Delete Data Record KZLOESCH CHAR 1 0
QSMNUM Sort Number for Task QSMNUM NUMC 4 0
AUTKZ Data Record Created with Function 'Create with Copy Model' QAUTKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
HANDLE Globally unique identifier (linked to time segment, etc) TSEGGUID CHAR 22 0
TSEGFL Time segment exists TSEGEXISTS CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
TSEGTP Template TSEGTEMPLA TTSEGTPLH CHAR 10 0
TZONSO Time Zone for Notification TZONSO TTZZ CHAR 6 0
TZONSM Time Zone for Task TZONSM TTZZ CHAR 6 0
TZONID Origin of Time Zone in Notification TZONSMID CHAR 1 0
NULL Time zone for user (SY-ZONLO)
1 Equipment
2 Functional location
3 Plant
4 Customer
5 Vendor
KZACTIONBOX Created Using Action Box QNKZACTIONBOX CHAR 1 0
NULL Indicator is not set
X Indicator is set
FUNKTION Keys for Function in Action Box QNFUNKTION CHAR 4 0
/SAPSMOSS/NOTE Note number /SAPSMOSS/NOTE NUMC 7 0
/SAPSMOSS/REPORT Note created by /SAPSMOSS/MEMOREPORT CHAR 35 0
/SAPSMOSS/MTSTMP Time stamp (date + time) /SAPSMOSS/MEMOTSTMP NUMC 14 0
ABC_TEMPL Template ABC_TEMPL COTPL CHAR 10 0
EFFECTPERC Effect in Percentage QN8D_EFFECTPERC NUMC 3 0
EFFECTTEXT Effect Text QN8D_EFFECTTEXT CHAR 40 0
KTXTCD Code Text for Task SMCODETEXT CHAR 80 0
KTXTGR Code Group Text for Task SMGRPTEXT CHAR 40 0
QSMSTTXT Task Status QSMSTTXT CHAR 40 0
QMART Notification Type QMART TQ80 CHAR 2 0
QMTXT Short Text QMTXT CHAR 40 0
ARTPR Priority Type ARTPR T356A CHAR 2 0
PRIOK Priority PRIOK T356 CHAR 1 0
STTXT System Status for Notification QMSTTXT CHAR 40 0
MZEIT Time of Notification MZEIT TIMS 6 0
QMDAT Date of Notification QMDAT DATS 8 0
QMNAM Name of Person Reporting Notification QMNAM CHAR 12 0
STRMN Required start date STRMN DATS 8 0
STRUR Required Start Time STRUR TIMS 6 0
LTRMN Required End Date LTRMN DATS 8 0
LTRUR Requested End Time LTRUR TIMS 6 0
QMDAB Date for Notification Completion QMDAB DATS 8 0
QMZAB Completion Time of Notification QMZAB TIMS 6 0
BARBZT Processing Time BARBZT DEC 11 2
MARBEH Processing Time Unit MARBEH T006 UNIT 3 0
MAWERK Plant for Material QMAWERKS T001W CHAR 4 0
MATNR Material Number MATNR MARA CHAR 18 0
REVLV Revision Level REVLV CHAR 2 0
KUNUM Account Number of Customer QKUNUM KNA1 CHAR 10 0
RBNR Catalog Profile RBNR T352B CHAR 9 0
LIFNUM Vendor Account Number LIFNUM LFA1 CHAR 10 0
BUNAME Author of a Q/PM Notification BUNAME CHAR 12 0
ADRNR Addresses: Address Number CADNR CHAR 10 0
COAUFNR Order Number (QM Order) COAUFNR AUFK CHAR 12 0
NAME_LIST Name for list displays I_NAME_LST CHAR 35 0
TEL_NUMBER First telephone no.: dialling code+number AD_TLNMBR1 CHAR 30 0
POST_CODE1 City postal code AD_PSTCD1 CHAR 10 0
CITY1 City AD_CITY1 CHAR 40 0
CITY2 District AD_CITY2 CHAR 40 0
COUNTRY Country Key LAND1 CHAR 3 0
REGION Region (State, Province, County) REGIO CHAR 3 0
STREET Street AD_STREET CHAR 60 0
PARNAM_INT List name of internal employee resp.for carrying out job I_NAME_INT CHAR 35 0
PRIOKX Priority Text PRIOKX CHAR 20 0
HERSTELLER Number of Manufacturer QLIFNR CHAR 10 0
MATKTX Material Description (Short Text) MAKTX CHAR 40 0

RQMQMSM1 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
RQMQMSM1 ABC_TEMPL RQMQMSM1 MANDT COTPL CO-ABC Template Master Data MANDT
RQMQMSM1 ABC_TEMPL ILOA KOKRS COTPL CO-ABC Template Master Data KOKRS
RQMQMSM1 ABC_TEMPL '214' COTPL CO-ABC Template Master Data CLASS
RQMQMSM1 ABC_TEMPL RQMQMSM1 ABC_TEMPL COTPL CO-ABC Template Master Data TEMPLATE
RQMQMSM1 ARTPR QMSM MANDT T356A Priority type table MANDT
RQMQMSM1 ARTPR RQMQMSM1 ARTPR T356A Priority type table ARTPR
RQMQMSM1 COAUFNR QMSM MANDT AUFK Order master data MANDT
RQMQMSM1 COAUFNR RQMQMSM1 COAUFNR AUFK Order master data AUFNR
RQMQMSM1 FENUM RQMQMSM1 MANDT QMFE Quality notification - items MANDT
RQMQMSM1 FENUM RQMQMSM1 QMNUM QMFE Quality notification - items QMNUM
RQMQMSM1 FENUM RQMQMSM1 FENUM QMFE Quality notification - items FENUM
RQMQMSM1 FOLGEACT RQMQMSM1 MANDT TQ07 Follow-Up Action for Usage Decision of Inspection Lot MANDT
RQMQMSM1 FOLGEACT RQMQMSM1 FOLGEACT TQ07 Follow-Up Action for Usage Decision of Inspection Lot FOLGEAKTI
RQMQMSM1 KUNUM QMSM MANDT KNA1 General Data in Customer Master MANDT
RQMQMSM1 KUNUM RQMQMSM1 KUNUM KNA1 General Data in Customer Master KUNNR
RQMQMSM1 LIFNUM QMSM MANDT LFA1 Vendor Master (General Section) MANDT
RQMQMSM1 LIFNUM RQMQMSM1 LIFNUM LFA1 Vendor Master (General Section) LIFNR
RQMQMSM1 MANDT RQMQMSM1 MANDT T000 Clients MANDT
RQMQMSM1 MARBEH QMSM MANDT T006 Units of Measurement MANDT
RQMQMSM1 MARBEH RQMQMSM1 MARBEH T006 Units of Measurement MSEHI
RQMQMSM1 MATNR RQMQMSM1 MATNR MARA General Material Data MATNR
RQMQMSM1 MATNR QMSM MANDT MARA General Material Data MANDT
RQMQMSM1 MAWERK QMSM MANDT T001W Plants/Branches MANDT
RQMQMSM1 MAWERK RQMQMSM1 MAWERK T001W Plants/Branches WERKS
RQMQMSM1 MMGEIN RQMQMSM1 MANDT T006 Units of Measurement MANDT
RQMQMSM1 MMGEIN RQMQMSM1 MMGEIN T006 Units of Measurement MSEHI
RQMQMSM1 MNGRP RQMQMSM1 MANDT QPGR Inspection catalog code groups MANDT
RQMQMSM1 MNGRP RQMQMSM1 MNKAT QPGR Inspection catalog code groups KATALOGART
RQMQMSM1 MNGRP RQMQMSM1 MNGRP QPGR Inspection catalog code groups CODEGRUPPE
RQMQMSM1 MNKAT RQMQMSM1 MANDT TQ15 Inspection catalog type index MANDT
RQMQMSM1 MNKAT RQMQMSM1 MNKAT TQ15 Inspection catalog type index KATALOGART
RQMQMSM1 OBJNR RQMQMSM1 MANDT ONR00 General Object Number MANDT
RQMQMSM1 OBJNR RQMQMSM1 OBJNR ONR00 General Object Number OBJNR
RQMQMSM1 PARVW RQMQMSM1 MANDT TPAR Business Partner: Functions MANDT
RQMQMSM1 PARVW RQMQMSM1 PARVW TPAR Business Partner: Functions PARVW
RQMQMSM1 PRIOK RQMQMSM1 ARTPR T356 Priorities ARTPR
RQMQMSM1 PRIOK RQMQMSM1 PRIOK T356 Priorities PRIOK
RQMQMSM1 PRIOK QMSM MANDT T356 Priorities MANDT
RQMQMSM1 QMART RQMQMSM1 QMART TQ80 Notification Types QMART
RQMQMSM1 QMART QMSM MANDT TQ80 Notification Types MANDT
RQMQMSM1 QMNUM RQMQMSM1 MANDT QMEL Quality Notification MANDT
RQMQMSM1 QMNUM RQMQMSM1 QMNUM QMEL Quality Notification QMNUM
RQMQMSM1 RBNR QMSM MANDT T352B Technical report MANDT
RQMQMSM1 RBNR RQMQMSM1 RBNR T352B Technical report RBNR
RQMQMSM1 TSEGTP RQMQMSM1 MANDT TTSEGTPLH Time Segment Template Header CLIENT
RQMQMSM1 TSEGTP RQMQMSM1 TSEGTP TTSEGTPLH Time Segment Template Header TEPL
RQMQMSM1 TZONSM RQMQMSM1 MANDT TTZZ Time zones CLIENT
RQMQMSM1 TZONSM RQMQMSM1 TZONSM TTZZ Time zones TZONE
RQMQMSM1 TZONSO RQMQMSM1 MANDT TTZZ Time zones CLIENT
RQMQMSM1 TZONSO RQMQMSM1 TZONSO TTZZ Time zones TZONE