SAP table TQ8T (Notification category)

SAP table TQ8T has 2 primary key fields being MANDT,QMTYP.

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 T000 MANDT
QMTYP Notification Category CHAR 2 0 QMTYP
FEKAT Catalog Type - Problems/Defects CHAR 1 0 TQ15 FEKAT
URKAT Catalog Type - Causes CHAR 1 0 TQ15 URKAT
MAKAT Catalog Type - Tasks CHAR 1 0 TQ15 MAKAT
MFKAT Catalog Type - Activities CHAR 1 0 TQ15 MFKAT
OTKAT Catalog Type - Object Parts CHAR 1 0 TQ15 OTKAT
KLAKT Indicator Classification Active CHAR 1 0 KLAKT
ARTPR Priority Type CHAR 2 0 T356A ARTPR
KLART Class Type CHAR 3 0 TCLA KLASSENART
STSMA Status Profile CHAR 8 0 TJ20 J_STSMA
QMELT Status Management: Object Type Notification CHAR 3 0 TJ03 QMEL_T
QMSMT Status Management: Object Type Tasks CHAR 3 0 TJ03 QMSM_T
CUA_FBS Function Module that Sets CUA Menu CHAR 30 0 TFDIR Q_CUA_FBS
AEKNZ Change indicator CHAR 1 0 AEKNZ

TQ8T foreign key relationships

Table Field Check Table Check Field
0 TQ8T ARTPR T356A Priority type table MANDT
0 TQ8T ARTPR T356A Priority type table ARTPR
1 TQ8T CUA_FBS TFDIR Function Module FUNCNAME
0 TQ8T FEKAT TQ15 Inspection catalog type index KATALOGART
1 TQ8T KLART TCLA Class Types MANDT
0 TQ8T MAKAT TQ15 Inspection catalog type index KATALOGART
1 TQ8T MFKAT TQ15 Inspection catalog type index KATALOGART
0 TQ8T OTKAT TQ15 Inspection catalog type index KATALOGART
1 TQ8T QMELT TJ03 Object types OBTYP
0 TQ8T QMSMT TJ03 Object types OBTYP
1 TQ8T STSMA TJ20 Status profiles MANDT
1 TQ8T STSMA TJ20 Status profiles STSMA
0 TQ8T URKAT TQ15 Inspection catalog type index KATALOGART