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
NULL Not valuated
A Accepted (OK)
R Rejected (not OK)
BWLOSDYN Dynamic Modification Valuation of the Last Inspection Lot QBWLOSDYN CHAR 1 0
NULL Not valuated
A Accepted (OK)
R Rejected (not OK)
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
NULL No valuation
A Accepted
R Rejected
F Failed
MBEWERTG Valuation of the Characteristic from Results Recording QDMBEWERTG CHAR 1 0
NULL No valuation
A Accepted
R Rejected
F Failed
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