QIWL SAP (Transfer table for QM subsystems) Table details
Dictionary Type: Table
Description: Transfer table for QM subsystems
Description: Transfer table for QM subsystems
Table field list including key, data, relationships and ABAP select examples
QIWL is a standard SAP Table which is used to store Transfer table for QM subsystems data and is available within R/3 SAP systems depending on the version and release level.
The QIWL table consists of various fields, each holding specific information or linking keys about Transfer table for QM subsystems data available in SAP. These include SUBSYS (Subsystem Identifier for QM Subsystem Interface), PRUEFLOS (Inspection Lot Number), PLNFL (Sequence), VORNR (Operation/Activity Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)
SAP QIWL table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDANT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| SUBSYS | Subsystem Identifier for QM Subsystem Interface | QEIFSUBSYS | CHAR | 6 | QISUB | QEIFSUBSYS | |||
| PRUEFLOS | Inspection Lot Number | QPLOS | NUMC | 12 | QALS | QPLOS | QLS | QALS | |
| PLNFL | Sequence | PLNFOLGE | CHAR | 6 | ALPHA | PLNFOLGE | |||
| VORNR | Operation/Activity Number | VORNR | CHAR | 4 | NUMCV | VORNR | VGN | ||
| PRPLATZ | Work Center | QPRPLATZ | CHAR | 8 | ARBPL | QAP | |||
| PRPLATZWRK | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
| EINFUEGDAT | Date Inspection Lot Was Entered in Worklist Table | QEIFEINDAT | DATS | 8 | DATUM | ||||
| EINFUEGTIM | Time Inspection Lot Was Entered in Worklist Table | QEIFEINTIM | TIMS | 6 | QZEIT | ||||
| AENDERDAT | Change Date of an Inspection Lot Entry in Worklist Table | QEIFCHADAT | DATS | 8 | DATUM | ||||
| AENDERTIM | Change Time of an Inspection Lot Entry in Worklist Table | QEIFCHATIM | TIMS | 6 | QZEIT | ||||
| SENDATERST | Date of First Transfer | QEIFSENDER | DATS | 8 | DATUM | ||||
| SENTIMERST | Time of First Transfer | QEIFSETIER | TIMS | 6 | QZEIT | ||||
| SENDATKOR | Date of Correction Transfer | QEIFSENDKR | DATS | 8 | DATUM | ||||
| SENTIMKOR | Time of correction transmission | QEIFSETIKR | TIMS | 6 | QZEIT | ||||
| SENDSTAT | Transfer Status of QM Subsystem | QEIFSTAREC | CHAR | 1 | QEIFSTAREC | ||||
| PRUEFSTAT | Status of Inspection for QM Subsystem | QEIFSTAINS | CHAR | 1 | QEIFSTAINS | ||||
| ART | Inspection Type | QPART | CHAR | 8 | TQ30 | QPART | QLA | ||
| ENSTEHDAT | Date Inspection Lot Was Created for QM Subsystem Interface | QEIFENTST | DATS | 8 | DATUM | ||||
| HERKUNFT | Inspection Lot Origin | QHERK | CHAR | 2 | Assigned to domain | QHERK | QHK | ||
| VORGWERK | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
| MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
| CHARG | Batch Number | CHARG_D | CHAR | 10 | MCH1 | CHARG | CHA | ||
| AUFNR | Order Number | AUFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ANR | |
| LIFNR | Vendor Account Number | ELIFN | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | KRED_C |
| KUNNR | Account Number of Customer | EKUNN | CHAR | 10 | KNA1 | ALPHA | KUNNR | KUN | |
| MBLNR | Number of Material Document | MBLNR | CHAR | 10 | ALPHA | BELNR | MBN |
| Key field | Non-key field |
How do I retrieve data from SAP table QIWL using ABAP code
The following ABAP code Example will allow you to do a basic selection on QIWL to SELECT all data from the tableDATA: WA_QIWL TYPE QIWL.
SELECT SINGLE *
FROM QIWL
INTO CORRESPONDING FIELDS OF WA_QIWL
WHERE...
How to access SAP table QIWL
Within an ECC or HANA version of SAP you can also view further information about QIWL and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects