SAP table QAPP (Inspection point)

SAP table QAPP has 4 primary key fields being MANDT,PRUEFLOS,VORGLFNR,PROBENR.

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
PRUEFLOS Inspection Lot Number NUMC 12 0 QALS QPLOS
VORGLFNR Current Node Number from Order Counter NUMC 8 0 QLFNKN
PROBENR Sample Number (Based on an Inspection Point) NUMC 6 0 QASV QPROBENRPP
TEILLOS Partial Lot Number NUMC 6 0 QALT QTLOS
PPSORTKEY Key Field (Sort Field) for Inspection Point CHAR 70 0 QPPSORTKEY
MENGE Inspection Point Yield QUAN 13 3 QMENGEPP
MENGE_A Scrap for Inspection Point QUAN 13 3 QMENGEPPA
MENGE_N Rework Quantity for Inspection Point QUAN 13 3 QMENGEPPN
MENGENEINH Unit of Measure for the Inspection Point UNIT 3 0 T006 QPPMEINH
EQUNR Equipment Number CHAR 18 0 EQUI EQUNR
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
TPLNR Functional Location CHAR 30 0 IFLOT TPLNR
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
PHYNR Material Sample Number CHAR 12 0 QPRS QPHYSPRNR
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_ID ID of Serialized Material INT8 19 0 MPE_SFI_ID
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
USERC1 User Field for 18 Characters CHAR 18 0 QUSRCHAR18
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
USERC2 User Field for 10 Characters CHAR 10 0 QUSRCHAR10
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
USERN1 User Field for 10 Digits NUMC 10 0 QUSRNUMC10
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
USERN2 User Field for 3 Digits NUMC 3 0 QUSRNUMC3
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
USERD1 User Field for Date DATS 8 0 QUSRDATS
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
USERT1 User Field for Time TIMS 6 0 QUSRTIMS
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
VKATART Catalog CHAR 1 0 TQ15 QKATART
VWERKS Plant CHAR 4 0 T001W WERKS_D
VAUSWAHLMG Selected Set of the Usage Decision CHAR 8 0 QPAM QVMENGE
VCODEGRP Code Group of the Usage Decision CHAR 8 0 QPGR QVGRUPPE
VCODE Usage Decision Code CHAR 4 0 QPCD QVCODE
VBEWERTUNG Code Valuation CHAR 1 0 QBEWERTUNG
Not valuated
A Accepted (OK)
R Rejected (not OK)
KZBEWERT Valuation Status Inspection Point CHAR 1 0 QPPBEWERT
Not valuated
1 Valuated, yield
2 Valuated, scrap quantity
3 Valuated, yield and scrap quantity
4 Valuated, without quantity assignment
KZFERTIG Inspection Point Status CHAR 1 0 QPPFERTIG
In inspection
0 Inactive inspection point
1 Goods receipt for inspection point cancelled
2 Quantity of the insp. point confirmed to order operation
3 Quantity of the inspection point posted to warehouse
KZPTLBEST Inspection with Stock-Related Partial Lot Assignment CHAR 1 0 QKZPTLBEST
RUECK Completion confirmation number for the operation NUMC 10 0 CO_RUECK
RMZHL Confirmation counter NUMC 8 0 CO_RMZHL
MBLNR Number of Material Document CHAR 10 0 MBLNR
MJAHR Material Document Year NUMC 4 0 MJAHR
ZEILE Item in Material Document NUMC 4 0 MBLPO
PRUEFER Name of Inspector CHAR 12 0 QPRUEFER
ENTSTEHDAT Date in Time Zone Where Inspection Point Created DATS 8 0 QENTDATPP
ENTSTEHZT Time in Time Zone Where Inspection Point Created TIMS 6 0 QENTZEITPP
ERSTELLER Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ERSTELDAT System Date on Which Data Record Was Created DATS 8 0 QDATUMERST
ERSTELZEIT System Time at Which Data Record Was Created TIMS 6 0 QZEITERSTL
AENDERER Name of Person Who Changed Object CHAR 12 0 AENAM
AENDERDAT System Date on Which Data Record Was Changed DATS 8 0 QDATUMAEND
AENDERZEIT System Time at Which Data Record Was Changed TIMS 6 0 QZEITAEND
CHANGEDDATETIME UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 TZNTSTMPS
DUMMY_QAPP_INCL_EEW_PS Dummy function in length 1 CHAR 1 0 DUMMY

QAPP foreign key relationships

Table Field Check Table Check Field
0 QAPP EQUNR EQUI Equipment master data MANDT
1 QAPP MENGENEINH T006 Units of Measurement MANDT
1 QAPP MENGENEINH T006 Units of Measurement MSEHI
0 QAPP PHYNR QPRS Master Record for Material Samples MANDT
0 QAPP PHYNR QPRS Master Record for Material Samples PHYNR
1 QAPP PROBENR QASV Sample specifications for inspection processing MANDANT
1 QAPP PROBENR QASV Sample specifications for inspection processing PRUEFLOS
1 QAPP PROBENR QASV Sample specifications for inspection processing VORGLFNR
1 QAPP PROBENR QASV Sample specifications for inspection processing MERKNR
1 QAPP PROBENR QASV Sample specifications for inspection processing PROBENR
0 QAPP PRUEFLOS QALS Inspection lot record MANDANT
1 QAPP TEILLOS QALT Partial lot MANDANT
1 QAPP TEILLOS QALT Partial lot PRUEFLOS
1 QAPP TEILLOS QALT Partial lot TEILLOS
0 QAPP VAUSWAHLMG QPAM Inspection catalog selected sets MANDT
0 QAPP VAUSWAHLMG QPAM Inspection catalog selected sets WERKS
0 QAPP VAUSWAHLMG QPAM Inspection catalog selected sets KATALOGART
1 QAPP VCODE QPCD Inspection catalog codes MANDT
1 QAPP VCODE QPCD Inspection catalog codes KATALOGART
1 QAPP VCODE QPCD Inspection catalog codes CODEGRUPPE
1 QAPP VCODE QPCD Inspection catalog codes CODE
1 QAPP VCODE QPCD Inspection catalog codes VERSION
0 QAPP VCODEGRP QPGR Inspection catalog code groups MANDT
0 QAPP VCODEGRP QPGR Inspection catalog code groups KATALOGART
1 QAPP VKATART TQ15 Inspection catalog type index KATALOGART
0 QAPP VWERKS T001W Plants/Branches WERKS