QFAAI SAP (Defect item table for defects recording) Structure details
Dictionary Type: Structure
Description: Defect item table for defects recording
Description: Defect item table for defects recording
Structure field list including key, data, relationships and ABAP select examples
QFAAI is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Defect item table for defects recording" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_QFAAI TYPE QFAAI.
The QFAAI table consists of various fields, each holding specific information or linking keys about Defect item table for defects recording data available in SAP. These include SERIALNR (Single-Unit Number for the Unit to Be Inspected), QMNUM (Notification No), TMP (Ind. temporary number), FEART (Report Type for Defects Recording).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP QFAAI structure fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| POS | Item Number in Item Record Without Value Table | QFELFD | NUMC | 4 | QFELFD | ||||
| SERIALNR | Single-Unit Number for the Unit to Be Inspected | QSERIALNR | CHAR | 18 | ALPHA | QSERIALNR | |||
| QMNUM | Notification No | QMNUM | CHAR | 12 | Assigned to domain | ALPHA | QMNUM | IQM | |
| TMP | Ind. temporary number | 0 | |||||||
| FEART | Report Type for Defects Recording | QFEART | CHAR | 8 | Assigned to domain | QFEART | QFE | ||
| PNLKN | Current Node Number from Order Counter APLZL | QLFNKN | NUMC | 8 | KNTNR | ||||
| MERKNR | Inspection Characteristic Number | QMERKNRP | NUMC | 4 | QMERKNRP | ||||
| FENUM | Item Number in Item Record | FELFD | NUMC | 4 | Assigned to domain | FELFD | |||
| PROBENR | Sample Number | QPROBENR | NUMC | 6 | Assigned to domain | QPROBENR | QPO | ||
| POSNR | Sort Number for Item | QLFDPOS | NUMC | 4 | QFELFD | ||||
| PHYNR | Physical Sample Number | QPHYSPRNR | CHAR | 12 | Assigned to domain | ALPHA | QPHYSPRNR | QPN | |
| OBJNR_PVO | Object number | J_OBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
| DET_VORH | Additional Data for the Object | QEXDATEN | CHAR | 1 | QKZ | ||||
| FEKAT | Catalog Type for the Defect Catalog | QKATFEHLER | CHAR | 1 | Assigned to domain | QKATART | |||
| TXTGR | Short Description of the Code Group | QKTEXTGR | CHAR | 40 | QKURZTEXT | ||||
| TXTCD | Problem Code Short Text | TXTCDFE | CHAR | 40 | TEXT40 | ||||
| TXTCDGR | Short Text for Problem or Damage Code | QTXTCDGRFE | CHAR | 80 | QTEXT80 | ||||
| DET_FEHLER | Additional Data for the Object | QEXDATEN | CHAR | 1 | QKZ | ||||
| OTKAT | Catalog Type for Defect Location | QKATFHLORT | CHAR | 1 | Assigned to domain | QKATART | |||
| TXTGROT | Short Description of the Code Group | QKTEXTGR | CHAR | 40 | QKURZTEXT | ||||
| TXTCDOT | Object Part Code Short Text | TXTCDOT | CHAR | 40 | TEXT40 | ||||
| TXTCDGROT | Short Text for Object Part Code | QTXTCDGROT | CHAR | 80 | QTEXT80 | ||||
| DET_ORT | Additional Data for the Object | QEXDATEN | CHAR | 1 | QKZ | ||||
| DET_URSA | Additional Data for the Object | QEXDATEN | CHAR | 1 | QKZ | ||||
| DET_MASSN | Additional Data for the Object | QEXDATEN | CHAR | 1 | QKZ | ||||
| INDTX | Object Long Text Available | INDLTX | CHAR | 1 | CHAR1 | ||||
| KZMLA | Primary language indicator for text segment | KZMLA | CHAR | 1 | CHAR1 | ||||
| UNITFLBEW | Unit for Defect Valuation | QUNITFLBEW | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| MSEHT | Unit of Measurement Text (Maximum 10 Characters) | MSEHT | CHAR | 10 | TEXT10 | ||||
| KZSYSFE | Systematic Defect | QKZSYSFE | CHAR | 1 | QKZ | ||||
| AEKNZ | Change indicator | AEKNZ | CHAR | 1 | FLAG | ||||
| HERPOS | Origin of Item Record | QMFEHERK | CHAR | 1 | QMFEHERK | ||||
| FECOD | Defect Code | QCODEFHLR | CHAR | 4 | Assigned to domain | QCODE | |||
| FEGRP | Code Group for Problem | QCGRFEHLER | CHAR | 8 | Assigned to domain | QCODEGRP | |||
| FEQKLAS | Defect Class | QFEHLKLAS | CHAR | 2 | TQ17 | QFEHLKLAS | |||
| FEHLKLTEXT | Short Text | QKURZTEXT | CHAR | 40 | QKURZTEXT | ||||
| ANZFEHLER | Number of Defects Found | QANZFEHL4 | INT4 | 10 | QANZAHL4 | ||||
| FETXT | Defects | QTXTFEHLER | CHAR | 40 | QTXT40 | ||||
| OTEIL | Code for Defect Location | QCODEFHORT | CHAR | 4 | Assigned to domain | QCODE | |||
| OTGRP | Code Group for Objects Section | QCGRFHLORT | CHAR | 8 | Assigned to domain | QCODEGRP | |||
| OTTXT | Defect Location | QTXTFHLORT | CHAR | 40 | QTXT40 | ||||
| FRKLS | Classification | FRKLS | CHAR | 18 | KLASSE | ||||
| KLTXT | Class Description | KLSBEZ | CHAR | 40 | TEXT40 | KBZ | |||
| BAUTL | Assembly | BAUTL | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | |
| BAUTX | Description of PM Assembly | BAUTX | CHAR | 40 | TEXT40 | ||||
| FEHLBEW | Defect Valuation | QFEHLBEW | FLTP | 16(16) | FLTP | ||||
| FEHLBEWC | Quantitative Defect Valuation | QFEHLBEWC | CHAR | 10 | CHAR10 | ||||
| LAST_URNUM | Sequential Number for Cause | URNUM | NUMC | 4 | NUM4 | ||||
| CONTROL | Control Parameters | QCONTROL | CHAR | 1 | CHAR01 | ||||
| PRUEFER | Name of the Inspector | QPRUEFER | CHAR | 12 | QPRUEFER | QPR | |||
| PRUEFDATUV | Inspection Start Date | QPRUEFDATV | DATS | 8 | DATUM | QDV | |||
| PRUEFZEITV | Starting Time of the Inspection | QPRUEFZTV | TIMS | 6 | QZEIT | QZV | |||
| CROBJTY | Object types of the CIM resource | CR_OBJTY | CHAR | 2 | CR_OBJTY | ||||
| ARBPL | Object ID of the Work Center | LGWID | NUMC | 8 | Assigned to domain | CR_OBJID | |||
| ARBPLWERK | Plant for Work Center | QARBPWERKS | CHAR | 4 | Assigned to domain | WERKS | WRK | ||
| FENUMORG | Number of Original Item to Which Reference Is Made | QFENUMORG | NUMC | 4 | QFELFD | ||||
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
| ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
| ERZEIT | Time, at Which Record Was Added | ERZEIT | TIMS | 6 | UHRZT | ||||
| AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
| AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
| AEZEIT | Time of Change | AEZEIT | TIMS | 6 | UHRZT | ||||
| PRE_DEL | X and Blank | QKZ | CHAR | 1 | QKZ | ||||
| QMACTIVE | Item Is Being Processed as a Quality Notification | QMACTIVE | CHAR | 1 | QKZ | ||||
| FEARTTXT | Short Text | QKURZTEXT | CHAR | 40 | QKURZTEXT | ||||
| MARK | Selection Field | QEEMARK | CHAR | 1 | QKZ | ||||
| INVALID | X and Blank | QKZ | CHAR | 1 | QKZ |
| Key field | Non-key field |
How do I retrieve data from SAP structure QFAAI using ABAP code?
As QFAAI is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on QFAAI as there is no data to select.How to access SAP table QFAAI
Within an ECC or HANA version of SAP you can also view further information about QFAAI and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects