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 |