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 | Possible values | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
HANDLE
Globally unique identifier (linked to time segment, etc)
|
TSEGGUID |
CHAR
|
22 | 0 | ||||||||||||||||
|
TSEGFL
Time segment exists
|
TSEGEXISTS |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
KZACTIONBOX
Created Using Action Box
|
QNKZACTIONBOX |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
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 |