SAP Table V_TQ80_C
Generated Table for View
V_TQ80_C (Generated Table for View) 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 V_TQ80_C to other SAP tables.
V_TQ80_C table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| QMART | Notification Type | QMART | CHAR | 2 | 0 | |||||||
| QMARTX | Notification Type Texts | QMARTX | CHAR | 20 | 0 | |||||||
| FEKAT | Catalog Type - Problems/Defects | FEKAT | TQ15 | CHAR | 1 | 0 | ||||||
| URKAT | Catalog Type - Causes | URKAT | TQ15 | CHAR | 1 | 0 | ||||||
| MAKAT | Catalog Type - Tasks | MAKAT | TQ15 | CHAR | 1 | 0 | ||||||
| MFKAT | Catalog Type - Activities | MFKAT | TQ15 | CHAR | 1 | 0 | ||||||
| OTKAT | Catalog Type - Object Parts | OTKAT | TQ15 | CHAR | 1 | 0 | ||||||
| KLAKT | Indicator Classification Active | KLAKT | CHAR | 1 | 0 |
Possible values
|
||||||
| SAKAT | Catalog Type - Coding | SAKAT | TQ15 | CHAR | 1 | 0 | ||||||
| QMTYP | Notification Category | QMTYP | TQ8T | CHAR | 2 | 0 | ||||||
| QMTTX | Text for Notification Category | QMTTX | CHAR | 20 | 0 | |||||||
| RBNR | Catalog Profile | RBNR | T352B | CHAR | 9 | 0 | ||||||
V_TQ80_C foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| V_TQ80_C | FEKAT | V_TQ80_C | MANDT | TQ15 | Inspection catalog type index | MANDT |
| V_TQ80_C | FEKAT | V_TQ80_C | FEKAT | TQ15 | Inspection catalog type index | KATALOGART |
| V_TQ80_C | MAKAT | V_TQ80_C | MANDT | TQ15 | Inspection catalog type index | MANDT |
| V_TQ80_C | MAKAT | V_TQ80_C | MAKAT | TQ15 | Inspection catalog type index | KATALOGART |
| V_TQ80_C | MANDT | V_TQ80_C | MANDT | T000 | Clients | MANDT |
| V_TQ80_C | MFKAT | V_TQ80_C | MFKAT | TQ15 | Inspection catalog type index | KATALOGART |
| V_TQ80_C | MFKAT | V_TQ80_C | MANDT | TQ15 | Inspection catalog type index | MANDT |
| V_TQ80_C | OTKAT | V_TQ80_C | MANDT | TQ15 | Inspection catalog type index | MANDT |
| V_TQ80_C | OTKAT | V_TQ80_C | OTKAT | TQ15 | Inspection catalog type index | KATALOGART |
| V_TQ80_C | QMTYP | V_TQ80_C | MANDT | TQ8T | Notification category | MANDT |
| V_TQ80_C | QMTYP | V_TQ80_C | QMTYP | TQ8T | Notification category | QMTYP |
| V_TQ80_C | RBNR | V_TQ80_C | MANDT | T352B | Technical report | MANDT |
| V_TQ80_C | RBNR | V_TQ80_C | RBNR | T352B | Technical report | RBNR |
| V_TQ80_C | SAKAT | V_TQ80_C | MANDT | TQ15 | Inspection catalog type index | MANDT |
| V_TQ80_C | SAKAT | V_TQ80_C | SAKAT | TQ15 | Inspection catalog type index | KATALOGART |
| V_TQ80_C | URKAT | V_TQ80_C | URKAT | TQ15 | Inspection catalog type index | KATALOGART |
| V_TQ80_C | URKAT | V_TQ80_C | MANDT | TQ15 | Inspection catalog type index | MANDT |
