1. Home
  2. Resources
  3. SAP Tables
  4. TQ29 - Defaults for target value and tolerances for characteristics

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
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
0 To a maximum of 10 decimal places
EINHEIT Unit of Measurement, in Which Quantitative Data Is Stored QMASSEH T006 UNIT 3 0
KZSOLLWERT Copy Target Value QKZSOLLW CHAR 1 0
NULL Indicator is not set
X Indicator is set
SOLLWERT Target Value for a Quantitative Characteristic QSOLLWERTE FLTP 16 16
SOLLWNI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
KZTOLREL Specification Limits Are Relative Values for Target Value QKZTOLREL CHAR 1 0
NULL Indicator is not set
X Indicator is set
TOLERANZOB Upper Specification Limit QTOLOB FLTP 16 16
TOLOBNI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
TOLERANZUN Lower Tolerance Limit QTOLUN FLTP 16 16
TOLUNNI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
TOLSOLL Target Value-Dependent Specification Limits QTOLSOLL CHAR 1 0
NULL Indicator is not set
X Indicator is set

TQ29 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TQ29 EINHEIT TQ29 MANDT T006 Units of Measurement MANDT
TQ29 EINHEIT TQ29 EINHEIT T006 Units of Measurement MSEHI