1. Home
  2. Resources
  3. SAP Tables
  4. QAPP - Inspection point

SAP Table QAPP

Inspection point

QAPP (Inspection point) 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 QAPP to other SAP tables.

QAPP table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
PRUEFLOS Inspection Lot Number QPLOS QALS NUMC 12 0
VORGLFNR Current Node Number from Order Counter APLZL QLFNKN NUMC 8 0
PROBENR Sample Number (Based on an Inspection Point) QPROBENRPP QASV NUMC 6 0
TEILLOS Partial lot number QTLOS QALT NUMC 6 0
PPSORTKEY Key Field (Sort Field) for Inspection Point QPPSORTKEY CHAR 70 0
MENGE Inspection Point Yield QMENGEPP QUAN 13 3
MENGE_A Scrap for Inspection Point QMENGEPPA QUAN 13 3
MENGE_N Rework Quantity for The Inspection Point QMENGEPPN QUAN 13 3
MENGENEINH Unit of Measure for the Inspection Point QPPMEINH T006 UNIT 3 0
EQUNR Equipment Number EQUNR EQUI CHAR 18 0
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
TPLNR Functional Location TPLNR IFLOT CHAR 30 0
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
PHYNR Physical Sample Number QPHYSPRNR QPRS CHAR 12 0
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
USERC1 User Field for 18 Characters QUSRCHAR18 CHAR 18 0
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
USERC2 User Field for 10 Characters QUSRCHAR10 CHAR 10 0
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
USERN1 User Field for 10 Digits QUSRNUMC10 NUMC 10 0
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
USERN2 User Field for 3 Digits QUSRNUMC3 NUMC 3 0
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
USERD1 User Field for Date QUSRDATS DATS 8 0
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
USERT1 User Field for Time QUSRTIMS TIMS 6 0
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
VKATART Catalog QKATART TQ15 CHAR 1 0
VWERKS Plant WERKS_D T001W CHAR 4 0
VAUSWAHLMG Selected Set of the Usage Decision QVMENGE QPAM CHAR 8 0
VCODEGRP Code Group of the Usage Decision QVGRUPPE QPGR CHAR 8 0
VCODE Usage Decision Code QVCODE QPCD CHAR 4 0
VBEWERTUNG Code Valuation QBEWERTUNG CHAR 1 0
NULL Not valuated
A Accepted (OK)
R Rejected (not OK)
KZBEWERT Valuation Status Inspection Point QPPBEWERT CHAR 1 0
NULL Not valuated
1 Valuated, yield
2 Valuated, scrap quantity
3 Valuated, yield and scrap quantity
4 Valuated, without quantity assignment
KZFERTIG Inspection Point Status QPPFERTIG CHAR 1 0
0 Inactive inspection point
NULL In inspection
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 QKZPTLBEST CHAR 1 0
NULL Indicator is not set
X Indicator is set
RUECK Completion confirmation number for the operation CO_RUECK NUMC 10 0
RMZHL Confirmation counter CO_RMZHL NUMC 8 0
MBLNR Number of Material Document MBLNR CHAR 10 0
MJAHR Material Document Year MJAHR NUMC 4 0
ZEILE Item in Material Document MBLPO NUMC 4 0
PRUEFER Name of the Inspector QPRUEFER CHAR 12 0
ENTSTEHDAT Date of Inspection Point Creation QENTDATPP DATS 8 0
ENTSTEHZT Time of Inspection Point Creation QENTZEITPP TIMS 6 0
ERSTELLER Name of Person who Created the Object ERNAM CHAR 12 0
ERSTELDAT Date on Which Record Was Created ERDAT DATS 8 0
ERSTELZEIT Time at which data record was created QZEITERSTL TIMS 6 0
AENDERER Name of Person Who Changed Object AENAM CHAR 12 0
AENDERDAT Changed On AEDAT DATS 8 0
AENDERZEIT Time at which data record was last changed QZEITAEND TIMS 6 0

QAPP foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
QAPP EQUNR QAPP MANDT EQUI Equipment master data MANDT
QAPP EQUNR QAPP EQUNR EQUI Equipment master data EQUNR
QAPP MANDT QAPP MANDT T000 Clients MANDT
QAPP MENGENEINH QAPP MANDT T006 Units of Measurement MANDT
QAPP MENGENEINH QAPP MENGENEINH T006 Units of Measurement MSEHI
QAPP PHYNR QAPP MANDT QPRS Master record for phys. samples MANDT
QAPP PHYNR QAPP PHYNR QPRS Master record for phys. samples PHYNR
QAPP PROBENR * QASV Sample specifications for inspection processing MERKNR
QAPP PROBENR QAPP PROBENR QASV Sample specifications for inspection processing PROBENR
QAPP PROBENR QAPP MANDT QASV Sample specifications for inspection processing MANDANT
QAPP PROBENR QAPP PRUEFLOS QASV Sample specifications for inspection processing PRUEFLOS
QAPP PROBENR QAPP VORGLFNR QASV Sample specifications for inspection processing VORGLFNR
QAPP PRUEFLOS QAPP MANDT QALS Inspection lot record MANDANT
QAPP PRUEFLOS QAPP PRUEFLOS QALS Inspection lot record PRUEFLOS
QAPP TEILLOS QAPP PRUEFLOS QALT Partial lot PRUEFLOS
QAPP TEILLOS QAPP TEILLOS QALT Partial lot TEILLOS
QAPP TEILLOS QAPP MANDT QALT Partial lot MANDANT
QAPP TPLNR QAPP MANDT IFLOT Functional Location (Table) MANDT
QAPP TPLNR QAPP TPLNR IFLOT Functional Location (Table) TPLNR
QAPP VAUSWAHLMG QAPP MANDT QPAM Inspection catalog selected sets MANDT
QAPP VAUSWAHLMG QAPP VWERKS QPAM Inspection catalog selected sets WERKS
QAPP VAUSWAHLMG QAPP VKATART QPAM Inspection catalog selected sets KATALOGART
QAPP VAUSWAHLMG QAPP VAUSWAHLMG QPAM Inspection catalog selected sets AUSWAHLMGE
QAPP VCODE QAPP MANDT QPCD Inspection catalog codes MANDT
QAPP VCODE QAPP VKATART QPCD Inspection catalog codes KATALOGART
QAPP VCODE QAPP VCODEGRP QPCD Inspection catalog codes CODEGRUPPE
QAPP VCODE QAPP VCODE QPCD Inspection catalog codes CODE
QAPP VCODE * QPCD Inspection catalog codes VERSION
QAPP VCODEGRP QAPP MANDT QPGR Inspection catalog code groups MANDT
QAPP VCODEGRP QAPP VKATART QPGR Inspection catalog code groups KATALOGART
QAPP VCODEGRP QAPP VCODEGRP QPGR Inspection catalog code groups CODEGRUPPE
QAPP VKATART QAPP VKATART TQ15 Inspection catalog type index KATALOGART
QAPP VKATART QAPP MANDT TQ15 Inspection catalog type index MANDT
QAPP VWERKS QAPP MANDT T001W Plants/Branches MANDT
QAPP VWERKS QAPP VWERKS T001W Plants/Branches WERKS