1. Home
  2. Resources
  3. SAP Tables
  4. QMSM - Quality notification - tasks

SAP Table QMSM

Quality notification - tasks

QMSM (Quality notification - tasks) 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 QMSM to other SAP tables.

QMSM 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

QMSM foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
QMSM ABC_TEMPL QMSM MANDT COTPL CO-ABC Template Master Data MANDT
QMSM ABC_TEMPL ILOA KOKRS COTPL CO-ABC Template Master Data KOKRS
QMSM ABC_TEMPL '214' COTPL CO-ABC Template Master Data CLASS
QMSM ABC_TEMPL QMSM ABC_TEMPL COTPL CO-ABC Template Master Data TEMPLATE
QMSM FENUM QMSM MANDT QMFE Quality notification - items MANDT
QMSM FENUM QMSM QMNUM QMFE Quality notification - items QMNUM
QMSM FENUM QMSM FENUM QMFE Quality notification - items FENUM
QMSM FOLGEACT QMSM MANDT TQ07 Follow-Up Action for Usage Decision of Inspection Lot MANDT
QMSM FOLGEACT QMSM FOLGEACT TQ07 Follow-Up Action for Usage Decision of Inspection Lot FOLGEAKTI
QMSM MANDT QMSM MANDT T000 Clients MANDT
QMSM MMGEIN QMSM MMGEIN T006 Units of Measurement MSEHI
QMSM MMGEIN QMSM MANDT T006 Units of Measurement MANDT
QMSM MNGRP QMSM MANDT QPGR Inspection catalog code groups MANDT
QMSM MNGRP QMSM MNKAT QPGR Inspection catalog code groups KATALOGART
QMSM MNGRP QMSM MNGRP QPGR Inspection catalog code groups CODEGRUPPE
QMSM MNKAT QMSM MNKAT TQ15 Inspection catalog type index KATALOGART
QMSM MNKAT QMSM MANDT TQ15 Inspection catalog type index MANDT
QMSM OBJNR QMSM MANDT ONR00 General Object Number MANDT
QMSM OBJNR QMSM OBJNR ONR00 General Object Number OBJNR
QMSM PARVW QMSM MANDT TPAR Business Partner: Functions MANDT
QMSM PARVW QMSM PARVW TPAR Business Partner: Functions PARVW
QMSM QMNUM QMSM MANDT QMEL Quality Notification MANDT
QMSM QMNUM QMSM QMNUM QMEL Quality Notification QMNUM
QMSM TSEGTP QMSM MANDT TTSEGTPLH Time Segment Template Header CLIENT
QMSM TSEGTP QMSM TSEGTP TTSEGTPLH Time Segment Template Header TEPL
QMSM TZONSM QMSM MANDT TTZZ Time zones CLIENT
QMSM TZONSM QMSM TZONSM TTZZ Time zones TZONE
QMSM TZONSO QMSM MANDT TTZZ Time zones CLIENT
QMSM TZONSO QMSM TZONSO TTZZ Time zones TZONE