SAP table TQ29 (Defaults for target value and tolerances for characteristics)

SAP table TQ29 has 2 primary key fields being MANDT,TOLERANZSL.

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
TOLERANZSL Tolerance Key CHAR 4 0 QTOLERANZ
STELLEN Number of Places to the Right of a Decimal Point (Accuracy) INT1 3 0 QSTELLEN
0 To a maximum of 10 decimal places
EINHEIT Unit of Measurement in Which Quantitative Data Is Stored UNIT 3 0 T006 QMASSEH
KZSOLLWERT Copy Target Value CHAR 1 0 QKZSOLLW
SOLLWERT Target Value for a Quantitative Characteristic FLTP 16 16 QSOLLWERTE
SOLLWNI Value Not Initial if Set CHAR 1 0 QNINITIAL
KZTOLREL Specification Limits Are Relative Values for Target Value CHAR 1 0 QKZTOLREL
TOLERANZOB Upper Specification Limit FLTP 16 16 QTOLOB
TOLOBNI Value Not Initial if Set CHAR 1 0 QNINITIAL
TOLERANZUN Lower Specification Limit FLTP 16 16 QTOLUN
TOLUNNI Value Not Initial if Set CHAR 1 0 QNINITIAL
TOLSOLL Target Value-Dependent Specification Limits CHAR 1 0 QTOLSOLL

TQ29 foreign key relationships

Table Field Check Table Check Field
0 TQ29 EINHEIT T006 Units of Measurement MSEHI