SAP Table

TQ79 Table with inspection point/user field combinations

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

If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.

/ Fields

TQ79 columns.

Field

Description

Data Type

Length

Decimals

Checktable

Data Element

KeyMANDT

Client

CLNT

T000

MANDT

KeySLWBEZ

Identifier for Inspection Point Field Combination

CHAR

QSLWBEZ

PPKTTYP

Inspection Point Type

CHAR

QPPKTTYP

EQUNRAKT

Field Active

CHAR

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

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

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

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

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

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

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

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

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

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

QPROBEANZ

LAST_VALID

Last Inspected Sample Is Valid

CHAR

QSAMPLE_LAST_VALID

PPVEMENGE

Selected Set for Inspection Point Valuation

CHAR

QPAM

QPPVEMENGE

PPVEWERK

Plant of Selected Set for Inspection Point Valuation

CHAR

T001W

QPPVEWERK

PPVECODGRA

Code Group for Inspection Point Valuation

CHAR

QPGR

QPPVECODGR

PPVECODEA

Code for Inspection Point Valuation (Accepted)

CHAR

QPCD

QPPVECODA

PPVECODGRR

Code Group for Inspection Point Valuation

CHAR

QPGR

QPPVECODGR

PPVECODER

Code for Inspection Point Valuation (Rejected)

CHAR

QPCD

QPPVECODR

FUNCTION1

Name of Function Module

CHAR

TFDIR

QFBNAME

FUNCTION1_ACT

Function Module Is Used

CHAR

QFB_ACTIVE

FUNCTION2

Name of Function Module

CHAR

TFDIR

QFBNAME

FUNCTION2_ACT

Function Module Is Used

CHAR

QFB_ACTIVE

FUNCTION3

Name of Function Module

CHAR

TFDIR

QFBNAME

FUNCTION3_ACT

Function Module Is Used

CHAR

QFB_ACTIVE

FUNCTION4

Name of Function Module

CHAR

TFDIR

QFBNAME

FUNCTION4_ACT

Function Module Is Used

CHAR

QFB_ACTIVE

/ Relationships

TQ79 foreign keys.

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

Back to SAP tables