SAP Table

TQ86 Report category for defects recording

SAP table TQ86 has 2 primary key fields being MANDT,FEART.

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

/ Fields

TQ86 columns.

Field Description Data Type Length Decimals Checktable Data Element
KeyMANDT Client CLNT 3 0 T000 MANDT
KeyFEART Report Type for Defects Recording CHAR 8 0 QFEART
RPROFIL Confirmation Profile CHAR 4 0 TQ84 QRPROFIL
RBNR Catalog Profile CHAR 9 0 T352B RBNR
KZATOM Import Default Values Automatically CHAR 1 0 QKZAUTOM
KZRBQMART Copy Catalog Profile from Quality Notification Type CHAR 1 0 QRBNRQMART
KZRBMATNR Copy Catalog Profile from Material Master CHAR 1 0 QRBNRMATNR
KZRBEQUI Copy Catalog Profile from Equipment CHAR 1 0 QRBNREQUI
KZRBTECHPL Copy Catalog Profile from Functional Location CHAR 1 0 QRBNRTCHPL
/ Relationships

TQ86 foreign keys.

Table Field Check Table Description Check Field
TQ86 RBNR T352B Technical report MANDT
TQ86 RPROFIL TQ84 Confirmation profile MANDT
TQ86 RPROFIL TQ84 Confirmation profile RPROFIL