SAP Table MTQSS
Material master view: QM
MTQSS (Material master view: QM) 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 MTQSS to other SAP tables.
MTQSS table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MTART
Material Type
|
MTART |
CHAR
|
4 | 0 | ||||||||
|
MBRSH
Industry sector
|
MBRSH |
CHAR
|
1 | 0 | ||||||||
|
MEINS
Base Unit of Measure
|
MEINS |
UNIT
|
3 | 0 | ||||||||
|
MAKTX
Material Description (Short Text)
|
MAKTX |
CHAR
|
40 | 0 | ||||||||
|
QMPUR
QM in Procurement is Active
|
QMPUR |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
AUSME
Unit of issue
|
AUSME |
UNIT
|
3 | 0 | ||||||||
|
INSMK
Post to Inspection Stock
|
QINSMK |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
SSQSS
Control Key for Quality Management in Procurement
|
QSSPUR | TQ08 |
CHAR
|
8 | 0 | |||||||
|
QZGTP
Certificate Type
|
QZGTYP | TQ05 |
CHAR
|
4 | 0 | |||||||
|
WEBAZ
Goods Receipt Processing Time in Days
|
WEBAZ |
DEC
|
3 | 0 | ||||||||
|
MMSTA
Plant-Specific Material Status
|
MMSTA | T141 |
CHAR
|
2 | 0 | |||||||
|
KZDKZ
Documentation required indicator
|
KZDKZ |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
QMATV
Inspection Setup Exists for Material/Plant
|
QMATV |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
BSTME
Purchase Order Unit of Measure
|
BSTME |
UNIT
|
3 | 0 | ||||||||
|
UMREZ
Numerator for Conversion to Base Units of Measure
|
UMREZ |
DEC
|
5 | 0 | ||||||||
|
UMREN
Denominator for conversion to base units of measure
|
UMREN |
DEC
|
5 | 0 | ||||||||
|
KZREV
Revision Level Has Been Assigned to the Material
|
KZREV |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
RBNRM
Catalog Profile
|
RBNR |
CHAR
|
9 | 0 | ||||||||
|
QMATA
Material Authorization Group for Activities in QM
|
QMATAUTH |
CHAR
|
6 | 0 | ||||||||
|
XCHPF
Batch management requirement indicator
|
XCHPF |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
MPROF
Manufacturer Part Profile
|
MPROF |
CHAR
|
4 | 0 | ||||||||
|
SERNP
Serial Number Profile
|
SERAIL |
CHAR
|
4 | 0 | ||||||||
|
XGCHP
Indicator: Approved batch record required
|
XGCHP |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
KZKRI
Indicator: Critical part
|
KZKRI |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
MATKL
Material Group
|
MATKL |
CHAR
|
9 | 0 | ||||||||
|
PRDHA
Product hierarchy
|
PRODH_D |
CHAR
|
18 | 0 | ||||||||
MTQSS foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| MTQSS | MMSTA | SYST | MANDT |
T141
Material Status from Materials Management/PPC View
|
MANDT |
| MTQSS | MMSTA | MTQSS | MMSTA |
T141
Material Status from Materials Management/PPC View
|
MMSTA |
| MTQSS | QZGTP | SYST | MANDT |
TQ05
QM certificate categories for procurement
|
MANDT |
| MTQSS | QZGTP | MTQSS | QZGTP |
TQ05
QM certificate categories for procurement
|
ZGTYP |
| MTQSS | SSQSS | SYST | MANDT |
TQ08
Control of QM in procurement
|
MANDT |
| MTQSS | SSQSS | MTQSS | SSQSS |
TQ08
Control of QM in procurement
|
QM_PUR |