QINF_FAI is a standard SAP table in SAP ECC (or) S/4HANA which stores First article inspection planning in Quality Info Record data. There are total 11 fields in QINF_FAI table.This blog post provides key technical details of SAP table QINF_FAI, including its availability across SAP S/4HANA versions and the list of CDS views for QINF_FAI table in SAP.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering not allowed |
| Buffering Type | No buffering |
| Package | QM in procurement (QB) |
| Technical Component | QM Control in Procurement (QM-PT-RP-PRC) |
SAP QINF_FAI Table Fields
The following is the list of fields that are available in SAP QINF_FAI table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | MANDT | CLNT (3) | |
| MATNR | Material Number | MATNR | MATNR | CHAR (40) | |
| ZAEHL | Internal Counter for DB Objects | Q_COUNT | Q_COUNT | NUMC (6) | |
| EBELN | Purchasing Document Number | EBELN | EBELN | CHAR (10) | |
| EBELP | Item Number of Purchasing Document | EBELP | EBELP | * | NUMC (5) |
| VALUATION | Code Valuation | QBEWERTUNG | QBEWERTUNG | CHAR (1) | |
| FAI_INSP_EXISTS | First Article Inspection (FAI) Exists | QFAI_EXISTS | QKZ | CHAR (1) | |
| ERSTELLER | Name of User who Created the Q-Info Record | QINFERST | QAENDERER | CHAR (12) | |
| ERSTELLDAT | Create Date of Q-Info Record | QINFERSTDT | QFREIDAT | DATS (8) | |
| AENDERER | Name of User who Most Recently Changed the Q-Info Record | QINFAEND | QAENDERER | CHAR (12) | |
| CHANGEDDATETIME | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | TZNTSTMPS | DEC (15) |
Availability
The SAP table QINF_FAI is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
| SAP S/4HANA Version | Available? |
|---|---|
| 1909 | Yes |
| 2020 | Yes |
| 2021 | Yes |
| 2022 | Yes |
| 2023 | Yes |
CDS Views for QINF_FAI table
The following is the list of CDS views for QINF_FAI table, which can also be used instead of QINF_FAI table based on your business requirements.
| CDS View | CDS View Type | Description |
|---|---|---|
| I_QLTYFIRSTARTICLEINSP | BASIC | First Article Inspection |
| A_QLTYFIRSTARTICLEINSP | COMPOSITE | First Article Inspection Data |
| C_QLTYFIRSTARTICLEINSP | CONSUMPTION | First Article Inspection |