QFAAB SAP (Defect item: basis table definition) Structure details
Description: Defect item: basis table definition
Structure field list including key, data, relationships and ABAP select examples
QFAAB 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: basis table definition" 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_QFAAB TYPE QFAAB.
The QFAAB table consists of various fields, each holding specific information or linking keys about Defect item: basis table definition data available in SAP. These include QMNUM (Notification No), TMP (Ind. temporary number), FEART (Report Type for Defects Recording), PNLKN (Current Node Number from Order Counter APLZL).. 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 QFAAB 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 |
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 |
Key field | Non-key field |
How do I retrieve data from SAP structure QFAAB using ABAP code?
As QFAAB 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 QFAAB as there is no data to select.How to access SAP table QFAAB
Within an ECC or HANA version of SAP you can also view further information about QFAAB 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