SAP table QFAAI (Defect item table for defects recording)

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

QFAAI foreign key relationships

Table Field Check Table Check Field
0 QFAAI FEQKLAS TQ17 Defect classes MANDT