SAP table TQMS1 (Types for Multiple Specification Objects)

SAP table TQMS1 has 2 primary key fields being MANDT,OBJECTTYPE.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 * MANDT
OBJECTTYPE Type of Object for Multiple Specifications CHAR 2 0 Q_MS_OBJTYPE
ATINN_OK Class Characteristic (Valuation "Suitable For") NUMC 10 0 * QATINN_OK
ATINN_NOK Class Characteristic (Valuation "Not Suitable for") NUMC 10 0 * QATINN_NOK
MS_CONTROL Control of Object for Multiple Specifications CHAR 1 0 Q_MS_OBJCONTROL
0 Use Object Term for Classification
1 Use Country Key for Classification
2 Use Customer for Classification
MS_FIELD Field Name for Classification by Multiple Specification CHAR 10 0 Q_MS_FIELD