SAP table QDQL (Quality level)
SAP table QDQL has 9 primary key fields being MANDT,WERKS,MATNR,PLNTY,PLNNR,PLNAL,PLNFL,PLNKN,ZAEHLERQL.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| WERKS | Plant | CHAR | 4 | 0 | T001W | WERKS_D | |
| MATNR | Material Number | CHAR | 40 | 0 | MARA | QMATNRQL | |
| PLNTY | Task List Type | CHAR | 1 | 0 | TCA01 | QPLNTYQL | |
| PLNNR | Key for Task List Group | CHAR | 8 | 0 | PLKO | QPLNNRQL | |
| PLNAL | Group Counter | CHAR | 2 | 0 | QPLNALQL | ||
| PLNFL | Sequence of Operations Within a Plan | CHAR | 6 | 0 | QPLNFLQL | ||
| PLNKN | Number of Task List Node | NUMC | 8 | 0 | QPLNKNQL | ||
| ZAEHLERQL | Sequential Counter for Different Quality Levels | INT4 | 10 | 0 | QZAEHLERQL | ||
| LIFNR | Supplier Account Number | CHAR | 10 | 0 | LFA1 | QELIFNQL | |
| HERSTELLER | Manufacturer Account Number | CHAR | 10 | 0 | LFA1 | QHERSTQL | |
| KUNNR | Customer Account Number | CHAR | 10 | 0 | KNA1 | QEKUNNQL | |
| PRUEFART | Inspection Type | CHAR | 8 | 0 | TQ30 | QPART | |
| VORNR | Operation Number in the Quality Level | CHAR | 4 | 0 | QVORNRD | ||
| MERKNR | Characteristic Number in the Quality Level | NUMC | 4 | 0 | QMERKNRD | ||
| VPLTY | Type of the referenced task list | CHAR | 1 | 0 | TCA01 | VPLNTY | |
| VPLNR | Group of the referenced task list | CHAR | 8 | 0 | VPLNNR | ||
| VPLAL | Group counter of the referenced task list | CHAR | 2 | 0 | VPLNAL | ||
| VPLFL | Referenced sequence in routing | CHAR | 6 | 0 | VPLBFL | ||
| VPLNKN | Number of the Task List Node | NUMC | 8 | 0 | PLNKN | ||
| AENDLOSA | User who Last Changed the Quality Level | CHAR | 12 | 0 | QAENDLOSA | ||
| AENDLOSM | User who Manually Changed the Quality Level | CHAR | 12 | 0 | QAENDLOSM | ||
| AEDATLOSA | Change Date of the Quality Level | DATS | 8 | 0 | QAEDATLOSA | ||
| AEDATLOSM | Change Date (Manual) of the Quality Level | DATS | 8 | 0 | QAEDATLOSM | ||
| AEZEILOSA | Change Time of Q-Level | TIMS | 6 | 0 | QAEZEILOSA | ||
| AEZEILOSM | Change Time (Manual) of Q-Level | TIMS | 6 | 0 | QAEZEILOSM | ||
| PRUEFLOS | Number of the Last Inspection Lot with Usage Decision | NUMC | 12 | 0 | QPLOSQL | ||
| BWLOS | Valuation (Usage Decision) of the Last Inspection Lot | CHAR | 1 | 0 | QBWLOS | ||
| BWLOSDYN | Dynamic Modification Valuation of the Last Inspection Lot | CHAR | 1 | 0 | QBWLOSDYN | ||
| STICHPRVER | Sampling Procedure | CHAR | 8 | 0 | QDSV | QSTPRVER | |
| DYNREGEL | Dynamic Modification Rule | CHAR | 3 | 0 | QDDR | QDYNREGEL | |
| PRSTUFENAE | Inspection Stage for Next Inspection | NUMC | 4 | 0 | QDPS | QPRSTNAE | |
| ANZLOSEOVE | Number of Inspection Lots Without Usage Decision | INT2 | 5 | 0 | QANZLOSOVE | ||
| ANZPRAEN | Number of Inspections Since Inspection Stage Change | INT2 | 5 | 0 | QANZPRAEN | ||
| ANZNIOAEN | Number of Not-OK Inspections (Rejections) Since Stage Change | INT2 | 5 | 0 | QANZNIOAEN | ||
| DBEWERTG | Dynamic Modification Valuation (Accept/Reject) of Char. | CHAR | 1 | 0 | QDDBEWERTG | ||
| MBEWERTG | Valuation of the Characteristic from Results Recording | CHAR | 1 | 0 | QDMBEWERTG | ||
| PLOSOVE | Number of Last Inspection Lot Without Usage Decision | NUMC | 12 | 0 | QPLOSQL1 | ||
| DATLPRUEF | Date of Last Inspection | DATS | 8 | 0 | QDATLPRUEF | ||
| ANZPRSTOP | No. of Cancelled Inspections per Char. Since Last Inspection | INT2 | 5 | 0 | QANZPRSTOP | ||
| DELDATUM | Deletion Date of the Quality Level | DATS | 8 | 0 | QDELDAT | ||
| RESDATUM | Reset Date of Quality Level | DATS | 8 | 0 | QRESDAT | ||
| CHANGEDDATETIME | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | DEC | 15 | 0 | TZNTSTMPS |
QDQL foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 QDQL | DYNREGEL | QDDR | Dynamic modification rule (header) | MANDT |
| 1 QDQL | HERSTELLER | LFA1 | Supplier Master (General Section) | MANDT |
| 1 QDQL | HERSTELLER | LFA1 | Supplier Master (General Section) | LIFNR |
| 0 QDQL | KUNNR | KNA1 | General Data in Customer Master | MANDT |
| 0 QDQL | KUNNR | KNA1 | General Data in Customer Master | KUNNR |
| 1 QDQL | LIFNR | LFA1 | Supplier Master (General Section) | MANDT |
| 1 QDQL | LIFNR | LFA1 | Supplier Master (General Section) | LIFNR |
| 0 QDQL | MATNR | MARA | General Material Data | MANDT |
| 0 QDQL | MATNR | MARA | General Material Data | MATNR |
| 1 QDQL | PLNNR | PLKO | Task list - header | MANDT |
| 1 QDQL | PLNNR | PLKO | Task list - header | PLNNR |
| 1 QDQL | PLNNR | PLKO | Task list - header | PLNAL |
| 0 QDQL | PLNTY | TCA01 | Task list types | MANDT |
| 1 QDQL | PRSTUFENAE | QDPS | Inspection stages for a dynamic modification rule | MANDT |
| 1 QDQL | PRSTUFENAE | QDPS | Inspection stages for a dynamic modification rule | DYNREGEL |
| 1 QDQL | PRSTUFENAE | QDPS | Inspection stages for a dynamic modification rule | PRSTUFE |
| 0 QDQL | PRUEFART | TQ30 | Inspection types | MANDT |
| 0 QDQL | PRUEFART | TQ30 | Inspection types | ART |
| 1 QDQL | STICHPRVER | QDSV | Sampling procedure | MANDT |
| 0 QDQL | VPLTY | TCA01 | Task list types | MANDT |
| 1 QDQL | WERKS | T001W | Plants/Branches | MANDT |
| 1 QDQL | WERKS | T001W | Plants/Branches | WERKS |