SAP Table QFAAI

Defect item table for defects recording

QFAAI (Defect item table for defects recording) 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 QFAAI to other SAP tables.

QFAAI table fields

Field Data element Checktable Datatype Length Decimals
POS Item Number in Item Record Without Value Table QFELFD NUMC 4 0
SERIALNR Single-Unit Number for the Unit to Be Inspected QSERIALNR CHAR 18 0
QMNUM Notification No QMNUM CHAR 12 0
TMP CHAR 2 0
FEART Report Type for Defects Recording QFEART CHAR 8 0
PNLKN Current Node Number from Order Counter APLZL QLFNKN NUMC 8 0
MERKNR Inspection Characteristic Number QMERKNRP NUMC 4 0
FENUM Item Number in Item Record FELFD NUMC 4 0
PROBENR Sample Number QPROBENR NUMC 6 0
POSNR Sort Number for Item QLFDPOS NUMC 4 0
PHYNR Physical Sample Number QPHYSPRNR CHAR 12 0
OBJNR_PVO Object number J_OBJNR CHAR 22 0
DET_VORH Additional Data for the Object QEXDATEN CHAR 1 0
NULL Indicator is not set
X Indicator is set
FEKAT Catalog Type for the Defect Catalog QKATFEHLER CHAR 1 0
TXTGR Short Description of the Code Group QKTEXTGR CHAR 40 0
TXTCD Problem Code Short Text TXTCDFE CHAR 40 0
TXTCDGR Short Text for Problem or Damage Code QTXTCDGRFE CHAR 80 0
DET_FEHLER Additional Data for the Object QEXDATEN CHAR 1 0
NULL Indicator is not set
X Indicator is set
OTKAT Catalog Type for Defect Location QKATFHLORT CHAR 1 0
TXTGROT Short Description of the Code Group QKTEXTGR CHAR 40 0
TXTCDOT Object Part Code Short Text TXTCDOT CHAR 40 0
TXTCDGROT Short Text for Object Part Code QTXTCDGROT CHAR 80 0
DET_ORT Additional Data for the Object QEXDATEN CHAR 1 0
NULL Indicator is not set
X Indicator is set
DET_URSA Additional Data for the Object QEXDATEN CHAR 1 0
NULL Indicator is not set
X Indicator is set
DET_MASSN Additional Data for the Object QEXDATEN CHAR 1 0
NULL Indicator is not set
X Indicator is set
INDTX Object Long Text Available INDLTX CHAR 1 0
KZMLA Primary language indicator for text segment KZMLA CHAR 1 0
UNITFLBEW Unit for Defect Valuation QUNITFLBEW UNIT 3 0
MSEHT Unit of Measurement Text (Maximum 10 Characters) MSEHT CHAR 10 0
KZSYSFE Systematic Defect QKZSYSFE CHAR 1 0
NULL Indicator is not set
X Indicator is set
AEKNZ Change indicator AEKNZ CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
HERPOS Origin of Item Record QMFEHERK CHAR 1 0
G Automatically generated defect record
FECOD Defect Code QCODEFHLR CHAR 4 0
FEGRP Code Group for Problem QCGRFEHLER CHAR 8 0
FEQKLAS Defect Class QFEHLKLAS TQ17 CHAR 2 0
FEHLKLTEXT Short Text QKURZTEXT CHAR 40 0
ANZFEHLER Number of Defects Found QANZFEHL4 INT4 10 0
FETXT Defects QTXTFEHLER CHAR 40 0
OTEIL Code for Defect Location QCODEFHORT CHAR 4 0
OTGRP Code Group for Objects Section QCGRFHLORT CHAR 8 0
OTTXT Defect Location QTXTFHLORT CHAR 40 0
FRKLS Classification FRKLS CHAR 18 0
KLTXT Class Description KLSBEZ CHAR 40 0
BAUTL Assembly BAUTL CHAR 18 0
BAUTX Description of PM Assembly BAUTX CHAR 40 0
FEHLBEW Defect Valuation QFEHLBEW FLTP 16 16
FEHLBEWC Quantitative Defect Valuation QFEHLBEWC CHAR 10 0
LAST_URNUM Sequential Number for Cause URNUM NUMC 4 0
CONTROL Control Parameters QCONTROL CHAR 1 0
PRUEFER Name of the Inspector QPRUEFER CHAR 12 0
PRUEFDATUV Inspection Start Date QPRUEFDATV DATS 8 0
PRUEFZEITV Starting Time of the Inspection QPRUEFZTV TIMS 6 0
CROBJTY Object types of the CIM resource CR_OBJTY CHAR 2 0
A Work center
AA Work center alias
FH Production resources/tools
H Hierarchy
ARBPL Object ID of the Work Center LGWID NUMC 8 0
ARBPLWERK Plant for Work Center QARBPWERKS CHAR 4 0
FENUMORG Number of Original Item to Which Reference Is Made QFENUMORG NUMC 4 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERZEIT Time, at Which Record Was Added ERZEIT TIMS 6 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
AEDAT Changed On AEDAT DATS 8 0
AEZEIT Time of Change AEZEIT TIMS 6 0
PRE_DEL X and Blank QKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
QMACTIVE Item Is Being Processed as a Quality Notification QMACTIVE CHAR 1 0
NULL Indicator is not set
X Indicator is set
FEARTTXT Short Text QKURZTEXT CHAR 40 0
MARK Selection Field QEEMARK CHAR 1 0
NULL Indicator is not set
X Indicator is set
INVALID X and Blank QKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set

QFAAI foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
QFAAI FEQKLAS SYST MANDT TQ17 Defect classes MANDT
QFAAI FEQKLAS QFAAI FEQKLAS TQ17 Defect classes FEHLKLASSE