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 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
Possible values
|
||||||
| AUSME | Unit of issue | AUSME | UNIT | 3 | 0 | |||||||
| INSMK | Post to Inspection Stock | QINSMK | CHAR | 1 | 0 |
Possible values
|
||||||
| 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 |
Possible values
|
||||||
| QMATV | Inspection Setup Exists for Material/Plant | QMATV | CHAR | 1 | 0 |
Possible values
|
||||||
| 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 |
Possible values
|
||||||
| 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 |
Possible values
|
||||||
| 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 |
Possible values
|
||||||
| KZKRI | Indicator: Critical part | KZKRI | CHAR | 1 | 0 |
Possible values
|
||||||
| 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 |
