SAP Table QINF
QM-info record for material and vendor
Unsere Literaturempfehlung
SAP-Änderungs- und Transportmanagement: Architektur und Wartung der SAP-Systemlandschaft
Das Standardwerk zum Änderungs- und Transportmanagement in der 4. Auflage! In diesem Buch finden Sie alle Informationen, die Sie zum Planen, Implementieren und Warten von Systemlandschaften benötigen. Sie lernen die Grundlagen und die Bedienung aller relevanten Werkzeuge und erhalten detaillierte Anleitungen zur Änderungs- und Transportverwaltung. Diese Neuauflage berücksichtigt Neuerungen in den Bereichen SAP NetWeaver AS Java und Development Infrastructure, CTS+, SAP Solution Manager und Enhancement Packages. Bringen Sie ihr Wissen auf den neuesten Stand!
Bei amazon.de ansehen →
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 |