SAP Table
TQ8T Notification category
SAP table TQ8T has 2 primary key fields being MANDT,QMTYP.
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
TQ8T columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| KeyQMTYP | 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 |
/ Relationships
TQ8T foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| TQ8T | ARTPR | T356A | Priority type table | MANDT |
| TQ8T | ARTPR | T356A | Priority type table | ARTPR |
| TQ8T | CUA_FBS | TFDIR | Function Module | FUNCNAME |
| TQ8T | FEKAT | TQ15 | Inspection catalog type index | KATALOGART |
| TQ8T | KLART | TCLA | Class Types | MANDT |
| TQ8T | MAKAT | TQ15 | Inspection catalog type index | KATALOGART |
| TQ8T | MFKAT | TQ15 | Inspection catalog type index | KATALOGART |
| TQ8T | OTKAT | TQ15 | Inspection catalog type index | KATALOGART |
| TQ8T | QMELT | TJ03 | Object types | OBTYP |
| TQ8T | QMSMT | TJ03 | Object types | OBTYP |
| TQ8T | STSMA | TJ20 | Status profiles | MANDT |
| TQ8T | STSMA | TJ20 | Status profiles | STSMA |
| TQ8T | URKAT | TQ15 | Inspection catalog type index | KATALOGART |