SAP Table TQ79
Table with inspection point/user field combinations
TQ79 (Table with inspection point/user field combinations) 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 TQ79 to other SAP tables.
TQ79 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||||||||||
|
SLWBEZ
Identification for the Inspection Point Field Combination
|
QSLWBEZ |
CHAR
|
3 | 0 | ||||||||||||||||||||
|
PPKTTYP
Inspection Point Type
|
QPPKTTYP |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
EQUNRAKT
Field Active
|
QKZUSRAKT |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
TPLNRAKT
Field Active
|
QKZUSRAKT |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
PHYNRAKT
Field Active
|
QKZUSRAKT |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
USERC1AKT
Field Active
|
QKZUSRAKT |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
USERC2AKT
Field Active
|
QKZUSRAKT |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
USERN1AKT
Field Active
|
QKZUSRAKT |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
USERN2AKT
Field Active
|
QKZUSRAKT |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
USERD1AKT
Field Active
|
QKZUSRAKT |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
USERT1AKT
Field Active
|
QKZUSRAKT |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
PROBEANZ
No. of Inspection Points for Characteristic Summarization
|
QPROBEANZ |
NUMC
|
4 | 0 | ||||||||||||||||||||
|
LAST_VALID
Last Inspected Sample Is Valid
|
QSAMPLE_LAST_VALID |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
PPVEMENGE
Selected Set for Inspection Point Valuation
|
QPPVEMENGE | QPAM |
CHAR
|
8 | 0 | |||||||||||||||||||
|
PPVEWERK
Plant of Selected Set for Inspection Point Valuation
|
QPPVEWERK | T001W |
CHAR
|
4 | 0 | |||||||||||||||||||
|
PPVECODGRA
Code Group for Inspection Point Valuation
|
QPPVECODGR | QPGR |
CHAR
|
8 | 0 | |||||||||||||||||||
|
PPVECODEA
Code for Inspection Point Valuation (Accepted)
|
QPPVECODA | QPCD |
CHAR
|
4 | 0 | |||||||||||||||||||
|
PPVECODGRR
Code Group for Inspection Point Valuation
|
QPPVECODGR | QPGR |
CHAR
|
8 | 0 | |||||||||||||||||||
|
PPVECODER
Code for Inspection Point Valuation (Rejected)
|
QPPVECODR | QPCD |
CHAR
|
4 | 0 | |||||||||||||||||||
|
FUNCTION1
Name of Function Module
|
QFBNAME | TFDIR |
CHAR
|
30 | 0 | |||||||||||||||||||
|
FUNCTION1_ACT
Function Module Is Used
|
QFB_ACTIVE |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
FUNCTION2
Name of Function Module
|
QFBNAME | TFDIR |
CHAR
|
30 | 0 | |||||||||||||||||||
|
FUNCTION2_ACT
Function Module Is Used
|
QFB_ACTIVE |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
FUNCTION3
Name of Function Module
|
QFBNAME | TFDIR |
CHAR
|
30 | 0 | |||||||||||||||||||
|
FUNCTION3_ACT
Function Module Is Used
|
QFB_ACTIVE |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
FUNCTION4
Name of Function Module
|
QFBNAME | TFDIR |
CHAR
|
30 | 0 | |||||||||||||||||||
|
FUNCTION4_ACT
Function Module Is Used
|
QFB_ACTIVE |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
TQ79 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| TQ79 | FUNCTION1 | TQ79 | FUNCTION1 |
TFDIR
Function Module
|
FUNCNAME |
| TQ79 | FUNCTION2 | TQ79 | FUNCTION2 |
TFDIR
Function Module
|
FUNCNAME |
| TQ79 | FUNCTION3 | TQ79 | FUNCTION3 |
TFDIR
Function Module
|
FUNCNAME |
| TQ79 | FUNCTION4 | TQ79 | FUNCTION4 |
TFDIR
Function Module
|
FUNCNAME |
| TQ79 | MANDT | TQ79 | MANDT |
T000
Clients
|
MANDT |
| TQ79 | PPVECODEA | TQ79 | PPVECODGRA |
QPCD
Inspection catalog codes
|
CODEGRUPPE |
| TQ79 | PPVECODEA | TQ79 | PPVECODEA |
QPCD
Inspection catalog codes
|
CODE |
| TQ79 | PPVECODEA | * |
QPCD
Inspection catalog codes
|
VERSION | |
| TQ79 | PPVECODEA | TQ79 | MANDT |
QPCD
Inspection catalog codes
|
MANDT |
| TQ79 | PPVECODEA | '3' |
QPCD
Inspection catalog codes
|
KATALOGART | |
| TQ79 | PPVECODER | TQ79 | PPVECODGRR |
QPCD
Inspection catalog codes
|
CODEGRUPPE |
| TQ79 | PPVECODER | TQ79 | PPVECODER |
QPCD
Inspection catalog codes
|
CODE |
| TQ79 | PPVECODER | * |
QPCD
Inspection catalog codes
|
VERSION | |
| TQ79 | PPVECODER | TQ79 | MANDT |
QPCD
Inspection catalog codes
|
MANDT |
| TQ79 | PPVECODER | '3' |
QPCD
Inspection catalog codes
|
KATALOGART | |
| TQ79 | PPVECODGRA | TQ79 | PPVECODGRA |
QPGR
Inspection catalog code groups
|
CODEGRUPPE |
| TQ79 | PPVECODGRA | TQ79 | MANDT |
QPGR
Inspection catalog code groups
|
MANDT |
| TQ79 | PPVECODGRA | '3' |
QPGR
Inspection catalog code groups
|
KATALOGART | |
| TQ79 | PPVECODGRR | TQ79 | MANDT |
QPGR
Inspection catalog code groups
|
MANDT |
| TQ79 | PPVECODGRR | '3' |
QPGR
Inspection catalog code groups
|
KATALOGART | |
| TQ79 | PPVECODGRR | TQ79 | PPVECODGRR |
QPGR
Inspection catalog code groups
|
CODEGRUPPE |
| TQ79 | PPVEMENGE | TQ79 | MANDT |
QPAM
Inspection catalog selected sets
|
MANDT |
| TQ79 | PPVEMENGE | TQ79 | PPVEWERK |
QPAM
Inspection catalog selected sets
|
WERKS |
| TQ79 | PPVEMENGE | '3' |
QPAM
Inspection catalog selected sets
|
KATALOGART | |
| TQ79 | PPVEMENGE | TQ79 | PPVEMENGE |
QPAM
Inspection catalog selected sets
|
AUSWAHLMGE |
| TQ79 | PPVEWERK | TQ79 | PPVEWERK |
T001W
Plants/Branches
|
WERKS |
| TQ79 | PPVEWERK | TQ79 | MANDT |
T001W
Plants/Branches
|
MANDT |