QINF is a standard SAP table in SAP ECC (or) S/4HANA which stores QM-info record for material and vendor data. There are total 39 fields in QINF table.This blog post provides key technical details of SAP table QINF, including its availability across SAP S/4HANA versions and the list of CDS views for QINF 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 Table Fields
The following is the list of fields that are available in SAP QINF table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | MANDT | T000 | CLNT (3) |
| MATNR | Material Number | MATNR | MATNR | MARA | CHAR (40) |
| ZAEHL | Internal Counter for DB Objects | Q_COUNT | Q_COUNT | NUMC (6) | |
| 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) | |
| AENDERDAT | Change Date of Q-Info Record | QINFAENDDT | QFREIDAT | DATS (8) | |
| CHANGEDDATETIME | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | TZNTSTMPS | DEC (15) | |
| LIEFERANT | Vendor’s account number | ELIFN | LIFNR | LFA1 | CHAR (10) |
| WERK | Plant | WERKS_D | WERKS | T001W | CHAR (4) |
| FREI_DAT | Date Until Which the Release Is Valid | QFREIDAT | QFREIDAT | DATS (8) | |
| FREI_MGKZ | Release Quantity Is Active | QFREIMGKZ | QKZ | CHAR (1) | |
| ME | Base Unit of Measure for the Material | QBSTME | MEINS | T006 | UNIT (3) |
| FREI_MNG | Quantity Released for the Material | QFREIMG | MENG13 | QUAN (13) | |
| BEST_MG | Quantity Ordered for the Material | QBSTMG | MENG13 | QUAN (13) | |
| DAT_RUECK | Date when the Ordered Quantity Was Reset | QRSDAT | QFREIDAT | DATS (8) | |
| SPERRGRUND | Blocking reason | QSPERRGR | QKURZTEXT | CHAR (40) | |
| SPRACHE | Language Key | SPRAS | SPRAS | T002 | LANG (1) |
| SPERRFKT | Function That Will Be Blocked | QSPERRFKT | QSPERRFKT | TQ04A | CHAR (2) |
| QVVORH | Quality Assurance Agreement Exists | QQSVVORH | QKZ | CHAR (1) | |
| NOINSP | Inspection Control in the QM Info Record | QNOINSP | QNOINSP | CHAR (1) | |
| QSSYSFAM | Supplier’s QM system | QSSYS_IST | QSSYSFAM | TQ02B | CHAR (4) |
| QSSYSDAT | Validity date of certification | QQSSYSDAT | QQSSYSDAT | DATS (8) | |
| VARIABNAHM | Inspection Type for Insp. Lot Origin (Source Inspection) | QINFVAR1 | QPART | TQ30 | CHAR (8) |
| LTEXTKZ | Inspection Characteristic Long Text Exists | QLTEXTKZ | QKZ | CHAR (1) | |
| SPRAS | Language Key | SPRAS | SPRAS | T002 | LANG (1) |
| PLOS | Inspection Lot No. in QINF for Current Status | QPLOSQINF | QPLOS | QALS | NUMC (12) |
| PLOS2 | Inspection Lot No. in QINF for Next Status | QPLOSQINF2 | QPLOS | QALS | NUMC (12) |
| PPAP_IS_REQUIRED | Production Part Approval Is Required | QPPAP_IS_REQUIRED | SAP_BOOL | CHAR (1) | |
| PPAP_LEVEL | Production Part Approval for Part Submission Warrant | QPPAP_LEVEL | QPPAP_LEVEL | CHAR (2) | |
| PPAP_STATUS | Production Part Approval Status | QPPAP_STATUS | QPPAP_STATUS | CHAR (2) | |
| STSMA | Status Profile Assigned to Quality Info Record | QSTSMAQINF | J_STSMA | TJ20 | CHAR (8) |
| OBJNR | QINF Object Number in Status Management | QINFOBJNR | J_OBJNR | ONR00 | CHAR (22) |
| NOINSPABN | No GR Inspection if Source Inspection Lot Exists | QNOWEABN | QKZ | CHAR (1) | |
| VORLABN | Lot Creation Lead Time (in Days) for Source Inspection | QVORLABN | QANZAHL1 | INT1 (3) | |
| REVLV | Revision Level | REVLV | REVLV | CHAR (2) | |
| LOEKZ | Deletion Flag | QLOEKZ | QKZ | CHAR (1) | |
| CERTCONTROL | Control of Certificate Receipt | QCERTCONTROL | QCERTCONTROL | CHAR (1) | |
| DUMMY_QINF_INCL_EEW_PS | Dummy function in length 1 | DUMMY | DUMMY | CHAR (1) |
Availability
The SAP table QINF 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 table
The following is the list of CDS views for QINF table, which can also be used instead of QINF table based on your business requirements.
| CDS View | CDS View Type | Description |
|---|---|---|
| I_QUALITYINPROCUREMENT | BASIC | Quality In Procurement |
| P_DOCOBJKEYFORQLTYINPROCMT | BASIC | Doc Object Key for Quality In Procmt |
| P_REVLVLFORQLTYINPROCMT | BASIC | Revision Level for Quality In Procurement |
| A_QUALITYINPROCUREMENT | COMPOSITE | Quality Info Record Data |
| I_PRODEXQLTYINFORECDINPROCMT | COMPOSITE | Products without Q-Info records |
| I_QLTYINFORECDINPROCMTUNION | COMPOSITE | Union of Products with and without Q-info Records |
| I_QUALITYINFORECDINPROCMT | COMPOSITE | Products with or without Quality Info Records In Procurement |
| I_QUALITYINPROCUREMENTFLDCTRL | COMPOSITE | Field control for Q-Info Record Procmt |
| C_QLTYFIRSTARTICLEINSP | CONSUMPTION | First Article Inspection |
| C_QLTYINFORECDWTHEXCEPTION | CONSUMPTION | Q- Info Records with exception |
| C_QLTYINFORECDWTHEXCEPTIONCALC | CONSUMPTION | Q- Info Record with Exception Calculation |
| C_QLTYINPROCMTMANAGECALC | CONSUMPTION | Manage Quality Info Record Procurement Calc |
| C_QLTYINPROCUREMENTMANAGE | CONSUMPTION | Manage Quality Inforecord in Procurement |
| C_QLTYINPROCUREMENTOBJPAGE | CONSUMPTION | Quality Info Record in Procurement |
| E_QUALITYINPROCUREMENT | EXTENSION | Quality In Procurement Extension |
