SAP ABAP Table QDQL (Quality level)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ QM-QC-AQC (Application Component) Active Quality Control
     ⤷ QDSE (Package) QM sample determination

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	QDQL	Table Relationship Diagram
Short Description	Quality level

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
3	MATNR	☑	QMATNRQL	MATNR	CHAR	18	0	Material Number	MARA
4	PLNTY	☑	QPLNTYQL	PLNTY	CHAR	1	0	Task List Type	TCA01
5	PLNNR	☑	QPLNNRQL	PLNNR	CHAR	8	0	Key for Task List Group	PLKO
6	PLNAL	☑	QPLNALQL	ALTNR	CHAR	2	0	Group Counter
7	PLNFL	☑	QPLNFLQL	PLNFOLGE	CHAR	6	0	Sequence of Operations Within a Plan
8	PLNKN	☑	QPLNKNQL	KNTNR	NUMC	8	0	Number of Task List Node
9	ZAEHLERQL	☑	QZAEHLERQL	QDYNANZ4	INT4	10	0	Sequential Counter for Different Quality Levels
10	LIFNR	☐	QELIFNQL	LIFNR	CHAR	10	0	Vendor Account Number	LFA1
11	HERSTELLER	☐	QHERSTQL	LIFNR	CHAR	10	0	Manufacturer Account Number	LFA1
12	KUNNR	☐	QEKUNNQL	KUNNR	CHAR	10	0	Customer Account Number	KNA1
13	PRUEFART	☐	QPART	QPART	CHAR	8	0	Inspection Type	TQ30
14	VORNR	☐	QVORNRD	VORNR	CHAR	4	0	Operation Number in the Quality Level
15	MERKNR	☐	QMERKNRD	QMERKNRP	NUMC	4	0	Characteristic Number in the Quality Level
16	VPLTY	☐	VPLNTY	PLNTY	CHAR	1	0	Type of the referenced task list	TCA01
17	VPLNR	☐	VPLNNR	PLNNR	CHAR	8	0	Group of the referenced task list
18	VPLAL	☐	VPLNAL	ALTNR	CHAR	2	0	Group counter of the referenced task list
19	VPLFL	☐	VPLBFL	PLNFOLGE	CHAR	6	0	Referenced sequence in routing
20	VPLNKN	☐	PLNKN	KNTNR	NUMC	8	0	Number of the task list node
21	AENDLOSA	☐	QAENDLOSA	QAENDERER	CHAR	12	0	User who Last Changed the Quality Level
22	AENDLOSM	☐	QAENDLOSM	QAENDERER	CHAR	12	0	User who Manually Changed the Quality Level
23	AEDATLOSA	☐	QAEDATLOSA	DATUM	DATS	8	0	Change Date of the Quality Level
24	AEDATLOSM	☐	QAEDATLOSM	DATUM	DATS	8	0	Change Date (Manual) of the Quality Level
25	AEZEILOSA	☐	QAEZEILOSA	QZEIT	TIMS	6	0	Change Time of Q-Level
26	AEZEILOSM	☐	QAEZEILOSM	QZEIT	TIMS	6	0	Change Time (Manual) of Q-Level
27	PRUEFLOS	☐	QPLOSQL	NUMC12	NUMC	12	0	Number of the Last Inspection Lot with Usage Decision
28	BWLOS	☐	QBWLOS	QBEWERTUNG	CHAR	1	0	Valuation (Usage Decision) of the Last Inspection Lot
29	BWLOSDYN	☐	QBWLOSDYN	QBEWERTUNG	CHAR	1	0	Dynamic Modification Valuation of the Last Inspection Lot
30	STICHPRVER	☐	QSTPRVER	QSTPRVER	CHAR	8	0	Sampling Procedure	QDSV
31	DYNREGEL	☐	QDYNREGEL	QDYNREGEL	CHAR	3	0	Dynamic Modification Rule	QDDR
32	PRSTUFENAE	☐	QPRSTNAE	QPRSTUFE	NUMC	4	0	Inspection Stage for Next Inspection	QDPS
33	ANZLOSEOVE	☐	QANZLOSOVE	QDYNANZ2	INT2	5	0	Number of Inspection Lots Without Usage Decision
34	ANZPRAEN	☐	QANZPRAEN	QDYNANZ2	INT2	5	0	Number of Inspections Since Inspection Stage Change
35	ANZNIOAEN	☐	QANZNIOAEN	QDYNANZ2	INT2	5	0	Number of Not-OK Inspections (Rejections) Since Stage Change
36	DBEWERTG	☐	QDDBEWERTG	QEEBEWERTG	CHAR	1	0	Dynamic Modification Valuation (Accept/Reject) of Char.
37	MBEWERTG	☐	QDMBEWERTG	QEEBEWERTG	CHAR	1	0	Valuation of the Characteristic from Results Recording
38	PLOSOVE	☐	QPLOSQL1	NUMC12	NUMC	12	0	Number of Last Inspection Lot Without Usage Decision
39	DATLPRUEF	☐	QDATLPRUEF	DATUM	DATS	8	0	Date of Last Inspection
40	ANZPRSTOP	☐	QANZPRSTOP	QDYNANZ2	INT2	5	0	No. of Cancelled Inspections per Char. Since Last Inspection
41	DELDATUM	☐	QDELDAT	DATUM	DATS	8	0	Deletion Date of the Quality Level
42	RESDATUM	☐	QRESDAT	DATUM	DATS	8	0	Reset Date of Quality Level

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	QDQL	DYNREGEL	QDDR	DYNREGEL	REF	1	CN
2	QDQL	HERSTELLER	LFA1	LIFNR	REF	C	CN
3	QDQL	KUNNR	KNA1	KUNNR	REF	C	CN
4	QDQL	LIFNR	LFA1	LIFNR	REF	C	CN
5	QDQL	MANDT	T000	MANDT	KEY	1	CN
6	QDQL	MATNR	MARA	MATNR	KEY	1	CN
7	QDQL	PLNNR	PLKO	PLNNR	KEY	C	CN
8	QDQL	PLNTY	TCA01	PLNTY	KEY	1	CN
9	QDQL	PRSTUFENAE	QDPS	PRSTUFE	REF	1	CN
10	QDQL	PRUEFART	TQ30	ART	REF	C	CN
11	QDQL	STICHPRVER	QDSV	STICHPRVER	REF	C	CN
12	QDQL	VPLTY	TCA01	PLNTY	KEY	1	CN
13	QDQL	WERKS	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20020219
SAP Release Created in