QINF - QM-Info Record for Material and Supplier
QM-Info Record for Material and Supplier information is stored in SAP table QINF.
It is part of development package QB in software component QM-PT-RP-PRC. This development package consists of objects that can be grouped under "QM in procurement".
It is part of development package QB in software component QM-PT-RP-PRC. This development package consists of objects that can be grouped under "QM in procurement".
Fields for table QINF
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| MATNR | Material Number | X | MATNR | CHAR | 80 | MARA |
| ERSTELLER | Name of User who Created the Q-Info Record | QINFERST | CHAR | 24 | ||
| ERSTELLDAT | Create Date of Q-Info Record | QINFERSTDT | DATS | 16 | ||
| AENDERER | Name of User who Most Recently Changed the Q-Info Record | QINFAEND | CHAR | 24 | ||
| AENDERDAT | Change Date of Q-Info Record | QINFAENDDT | DATS | 16 | ||
| CHANGEDDATETIME | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | DEC | 8 | ||
| LIEFERANT | Vendor's account number | ELIFN | CHAR | 20 | LFA1 | |
| WERK | Plant | WERKS_D | CHAR | 8 | T001W | |
| FREI_DAT | Date Until Which the Release Is Valid | QFREIDAT | DATS | 16 | ||
| FREI_MGKZ | Release Quantity Is Active | QFREIMGKZ | CHAR | 2 | ||
| ME | Base Unit of Measure for the Material | QBSTME | UNIT | 6 | T006 | |
| FREI_MNG | Quantity Released for the Material | QFREIMG | QUAN | 7 | ||
| BEST_MG | Quantity Ordered for the Material | QBSTMG | QUAN | 7 | ||
| DAT_RUECK | Date when the Ordered Quantity Was Reset | QRSDAT | DATS | 16 | ||
| SPERRGRUND | Blocking Reason | QSPERRGR | CHAR | 80 | ||
| SPRACHE | Language Key | SPRAS | LANG | 2 | T002 | |
| SPERRFKT | Function That Will Be Blocked | QSPERRFKT | CHAR | 4 | TQ04A | |
| QVVORH | Quality Assurance Agreement Exists | QQSVVORH | CHAR | 2 | ||
| NOINSP | Inspection Control in the QM Info Record | QNOINSP | CHAR | 2 | ||
| QSSYSFAM | Supplier's QM System | QSSYS_IST | CHAR | 8 | TQ02B | |
| QSSYSDAT | Validity Date of Certification | QQSSYSDAT | DATS | 16 | ||
| VARIABNAHM | Inspection Type for Insp. Lot Origin (Source Inspection) | QINFVAR1 | CHAR | 16 | TQ30 | |
| LTEXTKZ | Inspection Characteristic Long Text Exists | QLTEXTKZ | CHAR | 2 | ||
| SPRAS | Language Key | SPRAS | LANG | 2 | T002 | |
| PLOS | Inspection Lot No. in QINF for Current Status | QPLOSQINF | NUMC | 24 | QALS | |
| PLOS2 | Inspection Lot No. in QINF for Next Status | QPLOSQINF2 | NUMC | 24 | QALS | |
| PPAP_IS_REQUIRED | Production Part Approval Is Required | QPPAP_IS_REQUIRED | CHAR | 2 | ||
| PPAP_LEVEL | Production Part Approval for Part Submission Warrant | QPPAP_LEVEL | CHAR | 4 | ||
| PPAP_STATUS | Production Part Approval Status | QPPAP_STATUS | CHAR | 4 | ||
| PPAP_ID | Production Part Approval Identifier | QPPAP_ID | CHAR | 20 | ||
| STSMA | Status Profile Assigned to Quality Info Record | QSTSMAQINF | CHAR | 16 | TJ20 | |
| OBJNR | QINF Object Number in Status Management | QINFOBJNR | CHAR | 44 | ONR00 | |
| NOINSPABN | No GR Inspection if Source Inspection Lot Exists | QNOWEABN | CHAR | 2 | ||
| VORLABN | Lot Creation Lead Time (in Days) for Source Inspection | QVORLABN | INT1 | 1 | ||
| REVLV | Revision Level | REVLV | CHAR | 4 | ||
| LOEKZ | Deletion Flag | QLOEKZ | CHAR | 2 | ||
| CERTCONTROL | Control of Certificate Receipt | QCERTCONTROL | CHAR | 2 | ||
| .INCLUDE | EXT | QINF_INCL_EEW_PS | 0 | |||
| DUMMY_QINF_INCL_EEW_PS | Dummy function in length 1 | DUMMY | CHAR | 2 |