SAP Table TQ29
Defaults for target value and tolerances for characteristics
TQ29 (Defaults for target value and tolerances for characteristics) 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 TQ29 to other SAP tables.
TQ29 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT |
CLNT
|
3 | 0 | ||||||||
|
TOLERANZSL
Tolerance Key
|
QTOLERANZ |
CHAR
|
4 | 0 | ||||||||
|
STELLEN
Number of Places to the Right of a Decimal Point (Accuracy)
|
QSTELLEN |
INT1
|
3 | 0 | ||||||||
|
||||||||||||
|
EINHEIT
Unit of Measurement, in Which Quantitative Data Is Stored
|
QMASSEH | T006 |
UNIT
|
3 | 0 | |||||||
|
KZSOLLWERT
Copy Target Value
|
QKZSOLLW |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
SOLLWERT
Target Value for a Quantitative Characteristic
|
QSOLLWERTE |
FLTP
|
16 | 16 | ||||||||
|
SOLLWNI
Value Not Initial if Set
|
QNINITIAL |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
KZTOLREL
Specification Limits Are Relative Values for Target Value
|
QKZTOLREL |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
TOLERANZOB
Upper Specification Limit
|
QTOLOB |
FLTP
|
16 | 16 | ||||||||
|
TOLOBNI
Value Not Initial if Set
|
QNINITIAL |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
TOLERANZUN
Lower Tolerance Limit
|
QTOLUN |
FLTP
|
16 | 16 | ||||||||
|
TOLUNNI
Value Not Initial if Set
|
QNINITIAL |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
TOLSOLL
Target Value-Dependent Specification Limits
|
QTOLSOLL |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||