SAP Table QDQL
Quality level
QDQL (Quality level) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link QDQL to other SAP tables.
Source: QDQL (Quality level)
QDQL table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||
WERKS | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||||||||||
MATNR | Material Number | QMATNRQL | MARA | CHAR | 18 | 0 | ||||||||||
PLNTY | Task List Type | QPLNTYQL | TCA01 | CHAR | 1 | 0 | ||||||||||
PLNNR | Key for Task List Group | QPLNNRQL | PLKO | CHAR | 8 | 0 | ||||||||||
PLNAL | Group Counter | QPLNALQL | CHAR | 2 | 0 | |||||||||||
PLNFL | Sequence of Operations Within a Plan | QPLNFLQL | CHAR | 6 | 0 | |||||||||||
PLNKN | Number of Task List Node | QPLNKNQL | NUMC | 8 | 0 | |||||||||||
ZAEHLERQL | Sequential Counter for Different Quality Levels | QZAEHLERQL | INT4 | 10 | 0 | |||||||||||
LIFNR | Vendor Account Number | QELIFNQL | LFA1 | CHAR | 10 | 0 | ||||||||||
HERSTELLER | Manufacturer Account Number | QHERSTQL | LFA1 | CHAR | 10 | 0 | ||||||||||
KUNNR | Customer Account Number | QEKUNNQL | KNA1 | CHAR | 10 | 0 | ||||||||||
PRUEFART | Inspection Type | QPART | TQ30 | CHAR | 8 | 0 | ||||||||||
VORNR | Operation Number in the Quality Level | QVORNRD | CHAR | 4 | 0 | |||||||||||
MERKNR | Characteristic Number in the Quality Level | QMERKNRD | NUMC | 4 | 0 | |||||||||||
VPLTY | Type of the referenced task list | VPLNTY | TCA01 | CHAR | 1 | 0 | ||||||||||
VPLNR | Group of the referenced task list | VPLNNR | CHAR | 8 | 0 | |||||||||||
VPLAL | Group counter of the referenced task list | VPLNAL | CHAR | 2 | 0 | |||||||||||
VPLFL | Referenced sequence in routing | VPLBFL | CHAR | 6 | 0 | |||||||||||
VPLNKN | Number of the task list node | PLNKN | NUMC | 8 | 0 | |||||||||||
AENDLOSA | User who Last Changed the Quality Level | QAENDLOSA | CHAR | 12 | 0 | |||||||||||
AENDLOSM | User who Manually Changed the Quality Level | QAENDLOSM | CHAR | 12 | 0 | |||||||||||
AEDATLOSA | Change Date of the Quality Level | QAEDATLOSA | DATS | 8 | 0 | |||||||||||
AEDATLOSM | Change Date (Manual) of the Quality Level | QAEDATLOSM | DATS | 8 | 0 | |||||||||||
AEZEILOSA | Change Time of Q-Level | QAEZEILOSA | TIMS | 6 | 0 | |||||||||||
AEZEILOSM | Change Time (Manual) of Q-Level | QAEZEILOSM | TIMS | 6 | 0 | |||||||||||
PRUEFLOS | Number of the Last Inspection Lot with Usage Decision | QPLOSQL | NUMC | 12 | 0 | |||||||||||
BWLOS | Valuation (Usage Decision) of the Last Inspection Lot | QBWLOS | CHAR | 1 | 0 |
Possible values
|
||||||||||
BWLOSDYN | Dynamic Modification Valuation of the Last Inspection Lot | QBWLOSDYN | CHAR | 1 | 0 |
Possible values
|
||||||||||
STICHPRVER | Sampling Procedure | QSTPRVER | QDSV | CHAR | 8 | 0 | ||||||||||
DYNREGEL | Dynamic Modification Rule | QDYNREGEL | QDDR | CHAR | 3 | 0 | ||||||||||
PRSTUFENAE | Inspection Stage for Next Inspection | QPRSTNAE | QDPS | NUMC | 4 | 0 | ||||||||||
ANZLOSEOVE | Number of Inspection Lots Without Usage Decision | QANZLOSOVE | INT2 | 5 | 0 | |||||||||||
ANZPRAEN | Number of Inspections Since Inspection Stage Change | QANZPRAEN | INT2 | 5 | 0 | |||||||||||
ANZNIOAEN | Number of Not-OK Inspections (Rejections) Since Stage Change | QANZNIOAEN | INT2 | 5 | 0 | |||||||||||
DBEWERTG | Dynamic Modification Valuation (Accept/Reject) of Char. | QDDBEWERTG | CHAR | 1 | 0 |
Possible values
|
||||||||||
MBEWERTG | Valuation of the Characteristic from Results Recording | QDMBEWERTG | CHAR | 1 | 0 |
Possible values
|
||||||||||
PLOSOVE | Number of Last Inspection Lot Without Usage Decision | QPLOSQL1 | NUMC | 12 | 0 | |||||||||||
DATLPRUEF | Date of Last Inspection | QDATLPRUEF | DATS | 8 | 0 | |||||||||||
ANZPRSTOP | No. of Cancelled Inspections per Char. Since Last Inspection | QANZPRSTOP | INT2 | 5 | 0 | |||||||||||
DELDATUM | Deletion Date of the Quality Level | QDELDAT | DATS | 8 | 0 | |||||||||||
RESDATUM | Reset Date of Quality Level | QRESDAT | DATS | 8 | 0 |
QDQL foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
QDQL | DYNREGEL | QDQL | MANDT | QDDR | Dynamic modification rule (header) | MANDT |
QDQL | DYNREGEL | QDQL | DYNREGEL | QDDR | Dynamic modification rule (header) | DYNREGEL |
QDQL | HERSTELLER | QDQL | HERSTELLER | LFA1 | Vendor Master (General Section) | LIFNR |
QDQL | HERSTELLER | QDQL | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
QDQL | KUNNR | QDQL | KUNNR | KNA1 | General Data in Customer Master | KUNNR |
QDQL | KUNNR | QDQL | MANDT | KNA1 | General Data in Customer Master | MANDT |
QDQL | LIFNR | QDQL | LIFNR | LFA1 | Vendor Master (General Section) | LIFNR |
QDQL | LIFNR | QDQL | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
QDQL | MANDT | QDQL | MANDT | T000 | Clients | MANDT |
QDQL | MATNR | QDQL | MATNR | MARA | General Material Data | MATNR |
QDQL | MATNR | QDQL | MANDT | MARA | General Material Data | MANDT |
QDQL | PLNNR | QDQL | PLNTY | PLKO | Task list - header | PLNTY |
QDQL | PLNNR | * | PLKO | Task list - header | ZAEHL | |
QDQL | PLNNR | QDQL | PLNAL | PLKO | Task list - header | PLNAL |
QDQL | PLNNR | QDQL | PLNNR | PLKO | Task list - header | PLNNR |
QDQL | PLNNR | QDQL | MANDT | PLKO | Task list - header | MANDT |
QDQL | PLNTY | QDQL | MANDT | TCA01 | Task list types | MANDT |
QDQL | PLNTY | QDQL | PLNTY | TCA01 | Task list types | PLNTY |
QDQL | PRSTUFENAE | QDQL | MANDT | QDPS | Inspection stages for a dynamic modification rule | MANDT |
QDQL | PRSTUFENAE | QDQL | DYNREGEL | QDPS | Inspection stages for a dynamic modification rule | DYNREGEL |
QDQL | PRSTUFENAE | QDQL | PRSTUFENAE | QDPS | Inspection stages for a dynamic modification rule | PRSTUFE |
QDQL | PRUEFART | QDQL | MANDT | TQ30 | Inspection types | MANDT |
QDQL | PRUEFART | QDQL | PRUEFART | TQ30 | Inspection types | ART |
QDQL | STICHPRVER | QDQL | STICHPRVER | QDSV | Sampling procedure | STICHPRVER |
QDQL | STICHPRVER | QDQL | MANDT | QDSV | Sampling procedure | MANDT |
QDQL | VPLTY | QDQL | VPLTY | TCA01 | Task list types | PLNTY |
QDQL | VPLTY | QDQL | MANDT | TCA01 | Task list types | MANDT |
QDQL | WERKS | QDQL | MANDT | T001W | Plants/Branches | MANDT |
QDQL | WERKS | QDQL | WERKS | T001W | Plants/Branches | WERKS |