SAP table TQ78 (Status-dependent processing table for insp. characteristics)
SAP table TQ78 has 3 primary key fields being MANDT,TCODE,MODUS.
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 | * | MANDT | |
| TCODE | Transaction Code | CHAR | 20 | 0 | TSTC | TCODE | |
| MODUS | Characteristic Filter (Processing Mode) for Insp. Charcs | CHAR | 4 | 0 | QMODE | ||
| STAT0 | Optional Characteristic (Processing Is Optional) | CHAR | 1 | 0 | QSTAT0 | ||
| STAT1 | Required Characteristic (Processing Required) | CHAR | 1 | 0 | QSTAT1 | ||
| STAT4 | Characteristic Is Skipped | CHAR | 1 | 0 | QSTAT4 | ||
| STAT2 | Characteristic Is Being Processed | CHAR | 1 | 0 | QSTAT2 | ||
| STAT3 | Characteristic Is Valuated | CHAR | 1 | 0 | QSTAT3 | ||
| STAT5 | Characteristic Is Closed | CHAR | 1 | 0 | QSTAT5 | ||
| STAT7 | Characteristic Is Fixed (Processing Not Possible) | CHAR | 1 | 0 | QSTAT7 | ||
| STAT9 | Characteristic Is Blocked for Evaluations | CHAR | 1 | 0 | QSTAT9 | ||
| MBEWERTG | Inspection Result Valuation | CHAR | 1 | 0 | QMBEWERTG | ||
| TSTICHPRKZ | Partial Samples Possible | CHAR | 1 | 0 | QTSTICHPRO | ||
| STAT6 | Copy Inspection Characteristic to Subsystem | CHAR | 1 | 0 | QSTAT6 | ||
| STATA | Required Charac. when Controlling Charac. Is Accepted | CHAR | 1 | 0 | QSTATA | ||
| STATB | Required Charac. when Controlling Charac. is Rejected | CHAR | 1 | 0 | QSTATB |
TQ78 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 TQ78 | TCODE | TSTC | SAP Transaction Codes | TCODE |