SAP table TQ79 (Table with inspection point/user field combinations)

SAP table TQ79 has 2 primary key fields being MANDT,SLWBEZ.

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 T000 MANDT
SLWBEZ Identifier for Inspection Point Field Combination CHAR 3 0 QSLWBEZ
PPKTTYP Inspection Point Type CHAR 1 0 QPPKTTYP
Freely-Defined Inspection Point
1 Inspection Point for Equipment
2 Inspection Point for Funct. Location
3 Inspection Point for Sample
4 Inspection Point for Serialized Material
EQUNRAKT Field Active CHAR 1 0 QKZUSRAKT
User field not active
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
X User field active, no sort criterion
TPLNRAKT Field Active CHAR 1 0 QKZUSRAKT
User field not active
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
X User field active, no sort criterion
PHYNRAKT Field Active CHAR 1 0 QKZUSRAKT
User field not active
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
X User field active, no sort criterion
SFI_AKT Field Active CHAR 1 0 QKZUSRAKT
User field not active
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
X User field active, no sort criterion
USERC1AKT Field Active CHAR 1 0 QKZUSRAKT
User field not active
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
X User field active, no sort criterion
USERC2AKT Field Active CHAR 1 0 QKZUSRAKT
User field not active
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
X User field active, no sort criterion
USERN1AKT Field Active CHAR 1 0 QKZUSRAKT
User field not active
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
X User field active, no sort criterion
USERN2AKT Field Active CHAR 1 0 QKZUSRAKT
User field not active
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
X User field active, no sort criterion
USERD1AKT Field Active CHAR 1 0 QKZUSRAKT
User field not active
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
X User field active, no sort criterion
USERT1AKT Field Active CHAR 1 0 QKZUSRAKT
User field not active
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
X User field active, no sort criterion
PROBEANZ No. of Inspection Points for Characteristic Summarization NUMC 4 0 QPROBEANZ
LAST_VALID Last Inspected Sample Is Valid CHAR 1 0 QSAMPLE_LAST_VALID
PPVEMENGE Selected Set for Inspection Point Valuation CHAR 8 0 QPAM QPPVEMENGE
PPVEWERK Plant of Selected Set for Inspection Point Valuation CHAR 4 0 T001W QPPVEWERK
PPVECODGRA Code Group for Inspection Point Valuation CHAR 8 0 QPGR QPPVECODGR
PPVECODEA Code for Inspection Point Valuation (Accepted) CHAR 4 0 QPCD QPPVECODA
PPVECODGRR Code Group for Inspection Point Valuation CHAR 8 0 QPGR QPPVECODGR
PPVECODER Code for Inspection Point Valuation (Rejected) CHAR 4 0 QPCD QPPVECODR
FUNCTION1 Name of Function Module CHAR 30 0 TFDIR QFBNAME
FUNCTION1_ACT Function Module Is Used CHAR 1 0 QFB_ACTIVE
FUNCTION2 Name of Function Module CHAR 30 0 TFDIR QFBNAME
FUNCTION2_ACT Function Module Is Used CHAR 1 0 QFB_ACTIVE
FUNCTION3 Name of Function Module CHAR 30 0 TFDIR QFBNAME
FUNCTION3_ACT Function Module Is Used CHAR 1 0 QFB_ACTIVE
FUNCTION4 Name of Function Module CHAR 30 0 TFDIR QFBNAME
FUNCTION4_ACT Function Module Is Used CHAR 1 0 QFB_ACTIVE

TQ79 foreign key relationships

Table Field Check Table Check Field
0 TQ79 FUNCTION1 TFDIR Function Module FUNCNAME
1 TQ79 FUNCTION2 TFDIR Function Module FUNCNAME
0 TQ79 FUNCTION3 TFDIR Function Module FUNCNAME
1 TQ79 FUNCTION4 TFDIR Function Module FUNCNAME
0 TQ79 PPVECODEA QPCD Inspection catalog codes MANDT
0 TQ79 PPVECODEA QPCD Inspection catalog codes KATALOGART
0 TQ79 PPVECODEA QPCD Inspection catalog codes CODEGRUPPE
0 TQ79 PPVECODEA QPCD Inspection catalog codes CODE
0 TQ79 PPVECODEA QPCD Inspection catalog codes VERSION
1 TQ79 PPVECODER QPCD Inspection catalog codes MANDT
1 TQ79 PPVECODER QPCD Inspection catalog codes KATALOGART
1 TQ79 PPVECODER QPCD Inspection catalog codes CODEGRUPPE
1 TQ79 PPVECODER QPCD Inspection catalog codes CODE
1 TQ79 PPVECODER QPCD Inspection catalog codes VERSION
0 TQ79 PPVECODGRA QPGR Inspection catalog code groups MANDT
0 TQ79 PPVECODGRA QPGR Inspection catalog code groups KATALOGART
1 TQ79 PPVECODGRR QPGR Inspection catalog code groups MANDT
1 TQ79 PPVECODGRR QPGR Inspection catalog code groups KATALOGART
0 TQ79 PPVEMENGE QPAM Inspection catalog selected sets MANDT
0 TQ79 PPVEMENGE QPAM Inspection catalog selected sets WERKS
0 TQ79 PPVEMENGE QPAM Inspection catalog selected sets KATALOGART
1 TQ79 PPVEWERK T001W Plants/Branches WERKS