SAP QAPP Inspection point Table

Overview

QAPP is a standard SAP S/4HANA table that stores Inspection point data. There are total 54 fields in the QAPP table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table QAPP belongs to Quality Inspection (QM-IM) module and is located in the package QM inspection points (QLPP).

In addition, following links provide an overview of foreign key relationships, if any, that link QAPP to other SAP tables and standard CDS views available based on QAPP table in SAP S/4HANA.

Techincal Settings of QAPP

Below are technical details of the table QAPP

  • Buffering not allowed
  • No buffering
  • Storage type is Column Store

List of QAPP Fields

The following table gives you an overview of the fields available in QAPP

FieldDescriptionData ElementCheck TableData Type
MANDTClientMANDTT000CLNT(3)
PRUEFLOSInspection Lot NumberQPLOSQALSNUMC(12)
VORGLFNRCurrent Node Number from Order CounterQLFNKNNUMC(8)
PROBENRSample Number (Based on an Inspection Point)QPROBENRPPQASVNUMC(6)
TEILLOSPartial lot numberQTLOSQALTNUMC(6)
PPSORTKEYKey Field (Sort Field) for Inspection PointQPPSORTKEYCHAR(70)
MENGEInspection Point YieldQMENGEPPQUAN(13)
MENGE_AScrap for Inspection PointQMENGEPPAQUAN(13)
MENGE_NRework Quantity for The Inspection PointQMENGEPPNQUAN(13)
MENGENEINHUnit of Measure for the Inspection PointQPPMEINHT006UNIT(3)
EQUNREquipment NumberEQUNREQUICHAR(18)
EQUNRAKTField ActiveQKZUSRAKTCHAR(1)
TPLNRFunctional LocationTPLNRIFLOTCHAR(30)
TPLNRAKTField ActiveQKZUSRAKTCHAR(1)
PHYNRMaterial Sample NumberQPHYSPRNRQPRSCHAR(12)
PHYNRAKTField ActiveQKZUSRAKTCHAR(1)
SFI_AKTField ActiveQKZUSRAKTCHAR(1)
USERC1User Field for 18 CharactersQUSRCHAR18CHAR(18)
USERC1AKTField ActiveQKZUSRAKTCHAR(1)
USERC2User Field for 10 CharactersQUSRCHAR10CHAR(10)
USERC2AKTField ActiveQKZUSRAKTCHAR(1)
USERN1User Field for 10 DigitsQUSRNUMC10NUMC(10)
USERN1AKTField ActiveQKZUSRAKTCHAR(1)
USERN2User Field for 3 DigitsQUSRNUMC3NUMC(3)
USERN2AKTField ActiveQKZUSRAKTCHAR(1)
USERD1User Field for DateQUSRDATSDATS(8)
USERD1AKTField ActiveQKZUSRAKTCHAR(1)
USERT1User Field for TimeQUSRTIMSTIMS(6)
USERT1AKTField ActiveQKZUSRAKTCHAR(1)
VKATARTCatalogQKATARTTQ15CHAR(1)
VWERKSPlantWERKS_DT001WCHAR(4)
VAUSWAHLMGSelected Set of the Usage DecisionQVMENGEQPAMCHAR(8)
VCODEGRPCode Group of the Usage DecisionQVGRUPPEQPGRCHAR(8)
VCODEUsage Decision CodeQVCODEQPCDCHAR(4)
VBEWERTUNGCode ValuationQBEWERTUNGCHAR(1)
KZBEWERTValuation Status Inspection PointQPPBEWERTCHAR(1)
KZFERTIGInspection Point StatusQPPFERTIGCHAR(1)
KZPTLBESTInspection with Stock-Related Partial Lot AssignmentQKZPTLBESTCHAR(1)
RUECKCompletion confirmation number for the operationCO_RUECKNUMC(10)
RMZHLConfirmation counterCO_RMZHLNUMC(8)
MBLNRNumber of Material DocumentMBLNRCHAR(10)
MJAHRMaterial Document YearMJAHRNUMC(4)
ZEILEItem in Material DocumentMBLPONUMC(4)
PRUEFERName of InspectorQPRUEFERCHAR(12)
ENTSTEHDATDate in Time Zone Where Inspection Point CreatedQENTDATPPDATS(8)
ENTSTEHZTTime in Time Zone Where Inspection Point CreatedQENTZEITPPTIMS(6)
ERSTELLERName of Person who Created the ObjectERNAMCHAR(12)
ERSTELDATSystem Date on Which Data Record Was CreatedQDATUMERSTDATS(8)
ERSTELZEITSystem Time at Which Data Record Was CreatedQZEITERSTLTIMS(6)
AENDERERName of person who changed objectAENAMCHAR(12)
AENDERDATSystem Date on Which Data Record Was ChangedQDATUMAENDDATS(8)
AENDERZEITSystem Time at Which Data Record Was ChangedQZEITAENDTIMS(6)
CHANGEDDATETIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)TZNTSTMPSDEC(15)
DUMMY_QAPP_INCL_EEW_PSDummy function in length 1DUMMYCHAR(1)

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for QAPP

Table NameFieldCardinalityCheck Table
QAPPEQUNRC: CNEQUI
QAPPMANDT1: CNT000
QAPPMENGENEINHC: CNT006
QAPPPHYNRC: CNQPRS
QAPPPROBENR1: CNQASV
QAPPPRUEFLOS1: CNQALS
QAPPTEILLOSC: CNQALT
QAPPTPLNRC: CNIFLOT
QAPPVAUSWAHLMGC: CNQPAM
QAPPVCODEC: CNQPCD
QAPPVCODEGRPC: CNQPGR
QAPPVKATARTC: CNTQ15
QAPPVWERKSC: CNT001W

Other References

The following table gives you an overview of SAP S/4HANA tcodes where the table QAPP is used.

Transaction CodeDescription
QA01ACreate Inspection Lot
QE16Display Results for Delivery Note
QC22Quality Certificate for Batch
QE53Worklist: Record results for equip.
QA02Change Inspection Lot
QPR2Change Sample
QF21Record Defects for Operation
QGA3Print Inspection Results
QE05Change Sample Results
QGP1Results History for Task List Charc
QE13Display Results for Inspection Point
QE18Change Results for Equipment
QE23Record Results for Material Sample
QAS4Upload UD (Obsolete)
QPR1Create Sample
QAS3Upload Results (Obsolete)
QA01Create Inspection Lot
QAC3Cancel Sample Determination
QA14Change UD Without History
QC01Create Certificate Profile
QA02AChange Inspection Lot
QCMSCertificate for Inspection Lot w. MS
QE06Display Sample Results
QE73Tabular Results Recording for Charcs
QVM3Lots Without Usage Decision
QC14Create cert.prof.assign.w/copy model
QE17Record Results for Equipment
QC13Display cert. profile assignment
QC19Process Qlty Certificate Assignment
QE54Worklist: Results for funct. loctns
QE11Record results for inspection point
QE22Display Results for Funct. Location
QEDSSignature Process
QC55Worklist: Certificates - Procurement
QC21Quality certificate for the insp.lot
QC02Change Certificate Profile
QA33Display Data for Inspection Lot
QE21Change Results for Funct. Location
QA16Collective UD for Accepted Lots
QE01Record Characteristic Results
QE72Tabular Results Rec. for Insp. Lots
QGP2Results History for Task List Charac
QAC1Change Insp. Lot Actual Quantity
QA03Display Inspection Lot
QE12Change Results for Inspection Point
QA12Change Usage Decision with History
QVM2Inspection Lots with Open Quantities
QE14Record results for delivery note
QC03Display Certificate Profile
QE25Display Results for Material Sample
QF03Display Defect Data
QAC2Transfer Stock to Inspection Lot
QAS1Download Insp. Specs. (Obsolete)
QGA1Display Quality Score Timeline
QA32Change Data for Inspection Lot
QE20Record Results for Funct. Location
QF01Record Defect Data
QGC2Control Charts for Bill of Op. Charc
QS58Usage Indicator - Selected Sets
QA13Display Usage Decision
QE51NResults Recording Worklist
QGC1Qual. Control Charts for Insp. Lots
QGA2Display Inspection Results
QE02Change Characteristic Results
QGA4General QM Evaluations
QE09Individual Display of Charc Result
QVM1Inspection Lots Without Completion
QA19Automatic usage decision
QE15Change Results for Delivery Note
QA10Trigger automatic usage decision
QE03Display Characteristic Results
QC11Create cert. profile assignment
QPR3Display Sample
QE52Worklist: Material Sample Results
QC12Change Cert. Profile Assignment
QE71Tabular Res. Recording for Insp. Pts
QE24Change Results for Material Sample
QF11Record Defects for Inspection Lot
QE19Display Results for Equipment
QF31Record Defects for Characteristic
QA11Record Usage Decision
QE04Record Sample Results
QGC3Control Charts for Master Insp. Char
QF02Change Defect Data
QPR4Confirm Sample Drawing
QF41_WDRecord Defects for Charc/Insp. Point