SAP Table QINF
QM-info record for material and vendor
Recommended Now
All-new Echo Dot Smart speaker with Alexa
This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
Check it out on amazon.com →
The table QINF (QM-info record for material and vendor) is a standard table in SAP ERP. It belongs to the package QB.
Technical Information
| Table | QINF |
| Short Text | QM-info record for material and vendor |
| Package | QB |
| Table Type | Transparent Table |
Fields for Table QINF
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | ✔ | Client | MANDT | CLNT | 3 | T000 |
| MATNR | ✔ | Material Number | MATNR | CHAR | 18 | MARA |
| ZAEHL | ✔ | Internal Counter for DB Objects | Q_COUNT | NUMC | 6 | |
| ERSTELLER | Name of User who Created the Q-Info Record | QINFERST | CHAR | 12 | ||
| ERSTELLDAT | Create Date of Q-Info Record | QINFERSTDT | DATS | 8 | ||
| AENDERER | Name of User who Most Recently Changed the Q-Info Record | QINFAEND | CHAR | 12 | ||
| AENDERDAT | Change Date of Q-Info Record | QINFAENDDT | DATS | 8 | ||
| LIEFERANT | Vendor Account Number | ELIFN | CHAR | 10 | LFA1 | |
| WERK | Plant | WERKS_D | CHAR | 4 | T001W | |
| FREI_DAT | Date Until Which the Release Is Valid | QFREIDAT | DATS | 8 | ||
| FREI_MGKZ | Release Quantity Is Active | QFREIMGKZ | CHAR | 1 | ||
| ME | Base Unit of Measure for the Material | QBSTME | UNIT | 3 | T006 | |
| FREI_MNG | Quantity Released for the Material | QFREIMG | QUAN | 13 | ||
| BEST_MG | Quantity Ordered for the Material | QBSTMG | QUAN | 13 | ||
| DAT_RUECK | Date when the Ordered Quantity Was Reset | QRSDAT | DATS | 8 | ||
| SPERRGRUND | Blocking reason | QSPERRGR | CHAR | 40 | ||
| SPRACHE | Language Key | SPRAS | LANG | 1 | T002 | |
| SPERRFKT | Function That Will Be Blocked | QSPERRFKT | CHAR | 2 | TQ04A | |
| QVVORH | Quality Assurance Agreement Exists | QQSVVORH | CHAR | 1 | ||
| NOINSP | Inspection Control in the QM Info Record | QNOINSP | CHAR | 1 | ||
| QSSYSFAM | Vendor's QM system | QSSYS_IST | CHAR | 4 | TQ02B | |
| QSSYSDAT | Validity date of certification | QQSSYSDAT | DATS | 8 | ||
| VARIABNAHM | Inspection Type for Insp. Lot Origin (Source Inspection) | QINFVAR1 | CHAR | 8 | TQ30 | |
| LTEXTKZ | Inspection Characteristic Long Text Exists | QLTEXTKZ | CHAR | 1 | ||
| SPRAS | Language Key | SPRAS | LANG | 1 | T002 | |
| PLOS | Inspection Lot No. in QINF for Current Status | QPLOSQINF | NUMC | 12 | QALS | |
| PLOS2 | Inspection Lot No. in QINF for Next Status | QPLOSQINF2 | NUMC | 12 | QALS | |
| STSMA | Status Profile Assigned to Quality Info Record | QSTSMAQINF | CHAR | 8 | TJ20 | |
| OBJNR | QINF Object Number in Status Management | QINFOBJNR | CHAR | 22 | ONR00 | |
| NOINSPABN | No GR Inspection if Source Inspection Lot Exists | QNOWEABN | CHAR | 1 | ||
| VORLABN | Lot Creation Lead Time (in Days) for Source Inspection | QVORLABN | INT1 | 3 | ||
| REVLV | Revision Level | REVLV | CHAR | 2 | ||
| LOEKZ | Deletion Flag | QLOEKZ | CHAR | 1 | ||
| CERTCONTROL | Control of Certificate Receipt | QCERTCONTROL | CHAR | 1 |