1. Home
  2. Resources
  3. SAP Tables
  4. TQ79 - Table with inspection point/user field combinations

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
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
NULL Freely-defined inspection point
1 Inspection point for equipment
2 Inspection point for funct. location
3 Inspection point for phys. sample
EQUNRAKT Field Active QKZUSRAKT CHAR 1 0
NULL User field not active
X User field active, no sort criterion
1 User field active, 1st sort field
2 User field active, 2nd sort field
3 User field active, 3rd sort field
4 User field active, 4th sort field
5 User field active, 5th sort field
6 User field active, 6th sort field
TPLNRAKT Field Active QKZUSRAKT CHAR 1 0
NULL User field not active
X User field active, no sort criterion
1 User field active, 1st sort field
2 User field active, 2nd sort field
3 User field active, 3rd sort field
4 User field active, 4th sort field
5 User field active, 5th sort field
6 User field active, 6th sort field
PHYNRAKT Field Active QKZUSRAKT CHAR 1 0
NULL User field not active
X User field active, no sort criterion
1 User field active, 1st sort field
2 User field active, 2nd sort field
3 User field active, 3rd sort field
4 User field active, 4th sort field
5 User field active, 5th sort field
6 User field active, 6th sort field
USERC1AKT Field Active QKZUSRAKT CHAR 1 0
NULL User field not active
X User field active, no sort criterion
1 User field active, 1st sort field
2 User field active, 2nd sort field
3 User field active, 3rd sort field
4 User field active, 4th sort field
5 User field active, 5th sort field
6 User field active, 6th sort field
USERC2AKT Field Active QKZUSRAKT CHAR 1 0
NULL User field not active
X User field active, no sort criterion
1 User field active, 1st sort field
2 User field active, 2nd sort field
3 User field active, 3rd sort field
4 User field active, 4th sort field
5 User field active, 5th sort field
6 User field active, 6th sort field
USERN1AKT Field Active QKZUSRAKT CHAR 1 0
NULL User field not active
X User field active, no sort criterion
1 User field active, 1st sort field
2 User field active, 2nd sort field
3 User field active, 3rd sort field
4 User field active, 4th sort field
5 User field active, 5th sort field
6 User field active, 6th sort field
USERN2AKT Field Active QKZUSRAKT CHAR 1 0
NULL User field not active
X User field active, no sort criterion
1 User field active, 1st sort field
2 User field active, 2nd sort field
3 User field active, 3rd sort field
4 User field active, 4th sort field
5 User field active, 5th sort field
6 User field active, 6th sort field
USERD1AKT Field Active QKZUSRAKT CHAR 1 0
NULL User field not active
X User field active, no sort criterion
1 User field active, 1st sort field
2 User field active, 2nd sort field
3 User field active, 3rd sort field
4 User field active, 4th sort field
5 User field active, 5th sort field
6 User field active, 6th sort field
USERT1AKT Field Active QKZUSRAKT CHAR 1 0
NULL User field not active
X User field active, no sort criterion
1 User field active, 1st sort field
2 User field active, 2nd sort field
3 User field active, 3rd sort field
4 User field active, 4th sort field
5 User field active, 5th sort field
6 User field active, 6th sort field
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
NULL Indicator is not set
X Indicator is set
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
NULL Indicator is not set
X Indicator is set
FUNCTION2 Name of Function Module QFBNAME TFDIR CHAR 30 0
FUNCTION2_ACT Function Module Is Used QFB_ACTIVE CHAR 1 0
NULL Indicator is not set
X Indicator is set
FUNCTION3 Name of Function Module QFBNAME TFDIR CHAR 30 0
FUNCTION3_ACT Function Module Is Used QFB_ACTIVE CHAR 1 0
NULL Indicator is not set
X Indicator is set
FUNCTION4 Name of Function Module QFBNAME TFDIR CHAR 30 0
FUNCTION4_ACT Function Module Is Used QFB_ACTIVE CHAR 1 0
NULL Indicator is not set
X Indicator is set

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 MANDT QPCD Inspection catalog codes MANDT
TQ79 PPVECODEA '3' QPCD Inspection catalog codes KATALOGART
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 PPVECODER '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 PPVECODGRA '3' QPGR Inspection catalog code groups KATALOGART
TQ79 PPVECODGRA TQ79 PPVECODGRA QPGR Inspection catalog code groups CODEGRUPPE
TQ79 PPVECODGRA TQ79 MANDT QPGR Inspection catalog code groups MANDT
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 MANDT T001W Plants/Branches MANDT
TQ79 PPVEWERK TQ79 PPVEWERK T001W Plants/Branches WERKS