SAP ABAP Table QDQLSEL (Table for quality level selection)

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	INTTAB	Structure
Structure	QDQLSEL	Table Relationship Diagram
Short Description	Table for quality level selection

Delivery and Maintenance

Pool/cluster
Delivery Class
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	.INCLUDE	☐				0	0	Quality level
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
4	MATNR	☐	QMATNRQL	MATNR	CHAR	18	0	Material Number	MARA
5	PLNTY	☐	QPLNTYQL	PLNTY	CHAR	1	0	Task List Type	TCA01
6	PLNNR	☐	QPLNNRQL	PLNNR	CHAR	8	0	Key for Task List Group	PLKO
7	PLNAL	☐	QPLNALQL	ALTNR	CHAR	2	0	Group Counter
8	PLNFL	☐	QPLNFLQL	PLNFOLGE	CHAR	6	0	Sequence of Operations Within a Plan
9	PLNKN	☐	QPLNKNQL	KNTNR	NUMC	8	0	Number of Task List Node
10	ZAEHLERQL	☐	QZAEHLERQL	QDYNANZ4	INT4	10	0	Sequential Counter for Different Quality Levels
11	LIFNR	☐	QELIFNQL	LIFNR	CHAR	10	0	Vendor Account Number	LFA1
12	HERSTELLER	☐	QHERSTQL	LIFNR	CHAR	10	0	Manufacturer Account Number	LFA1
13	KUNNR	☐	QEKUNNQL	KUNNR	CHAR	10	0	Customer Account Number	KNA1
14	PRUEFART	☐	QPART	QPART	CHAR	8	0	Inspection Type	TQ30
15	VORNR	☐	QVORNRD	VORNR	CHAR	4	0	Operation Number in the Quality Level
16	MERKNR	☐	QMERKNRD	QMERKNRP	NUMC	4	0	Characteristic Number in the Quality Level
17	VPLTY	☐	VPLNTY	PLNTY	CHAR	1	0	Type of the referenced task list	TCA01
18	VPLNR	☐	VPLNNR	PLNNR	CHAR	8	0	Group of the referenced task list
19	VPLAL	☐	VPLNAL	ALTNR	CHAR	2	0	Group counter of the referenced task list
20	VPLFL	☐	VPLBFL	PLNFOLGE	CHAR	6	0	Referenced sequence in routing
21	VPLNKN	☐	PLNKN	KNTNR	NUMC	8	0	Number of the task list node
22	AENDLOSA	☐	QAENDLOSA	QAENDERER	CHAR	12	0	User who Last Changed the Quality Level
23	AENDLOSM	☐	QAENDLOSM	QAENDERER	CHAR	12	0	User who Manually Changed the Quality Level
24	AEDATLOSA	☐	QAEDATLOSA	DATUM	DATS	8	0	Change Date of the Quality Level
25	AEDATLOSM	☐	QAEDATLOSM	DATUM	DATS	8	0	Change Date (Manual) of the Quality Level
26	AEZEILOSA	☐	QAEZEILOSA	QZEIT	TIMS	6	0	Change Time of Q-Level
27	AEZEILOSM	☐	QAEZEILOSM	QZEIT	TIMS	6	0	Change Time (Manual) of Q-Level
28	PRUEFLOS	☐	QPLOSQL	NUMC12	NUMC	12	0	Number of the Last Inspection Lot with Usage Decision
29	BWLOS	☐	QBWLOS	QBEWERTUNG	CHAR	1	0	Valuation (Usage Decision) of the Last Inspection Lot
30	BWLOSDYN	☐	QBWLOSDYN	QBEWERTUNG	CHAR	1	0	Dynamic Modification Valuation of the Last Inspection Lot
31	STICHPRVER	☐	QSTPRVER	QSTPRVER	CHAR	8	0	Sampling Procedure	QDSV
32	DYNREGEL	☐	QDYNREGEL	QDYNREGEL	CHAR	3	0	Dynamic Modification Rule	QDDR
33	PRSTUFENAE	☐	QPRSTNAE	QPRSTUFE	NUMC	4	0	Inspection Stage for Next Inspection	QDPS
34	ANZLOSEOVE	☐	QANZLOSOVE	QDYNANZ2	INT2	5	0	Number of Inspection Lots Without Usage Decision
35	ANZPRAEN	☐	QANZPRAEN	QDYNANZ2	INT2	5	0	Number of Inspections Since Inspection Stage Change
36	ANZNIOAEN	☐	QANZNIOAEN	QDYNANZ2	INT2	5	0	Number of Not-OK Inspections (Rejections) Since Stage Change
37	DBEWERTG	☐	QDDBEWERTG	QEEBEWERTG	CHAR	1	0	Dynamic Modification Valuation (Accept/Reject) of Char.
38	MBEWERTG	☐	QDMBEWERTG	QEEBEWERTG	CHAR	1	0	Valuation of the Characteristic from Results Recording
39	PLOSOVE	☐	QPLOSQL1	NUMC12	NUMC	12	0	Number of Last Inspection Lot Without Usage Decision
40	DATLPRUEF	☐	QDATLPRUEF	DATUM	DATS	8	0	Date of Last Inspection
41	ANZPRSTOP	☐	QANZPRSTOP	QDYNANZ2	INT2	5	0	No. of Cancelled Inspections per Char. Since Last Inspection
42	DELDATUM	☐	QDELDAT	DATUM	DATS	8	0	Deletion Date of the Quality Level
43	RESDATUM	☐	QRESDAT	DATUM	DATS	8	0	Reset Date of Quality Level
44	PLANTXT	☐	PLANTEXT	TEXT40	CHAR	40	0	Task list description
45	DYNHTXT	☐	QTXTDYNE	QTXT8	CHAR	8	0	Dynamic Modification Level
46	DYNHEAD	☐	QDYNHEAD	QDYNHEAD	CHAR	1	0	Level at Which Dynamic Modification Parameters Are Defined	*
47	TXTMERK	☐	QTXTMERK40	QTXT40	CHAR	40	0	Characteristic, 40 Characters
48	TXTSTNAE	☐	QTXTSTNAE	QKURZTEXT	CHAR	40	0	Text Field: Next Stage
49	TXTMAT	☐	QTXTMAT	QKURZTEXT	CHAR	40	0	Material short text
50	TXTLIEF	☐	QTXTLIEF	QKURZTEXT	CHAR	40	0	Name of Vendor
51	TXTHERST	☐	QTXTHERST	QKURZTEXT	CHAR	40	0	Name of Manufacturer
52	TXTKUNDE	☐	QTXTKUNDE	QKURZTEXT	CHAR	40	0	Customer Name
53	TXTDYNR	☐	QTXTDYNR	QKURZTEXT	CHAR	40	0	Text Field: Dynamic Modification Rule
54	TXTVEBW	☐	QTXTVEBW	QTXT12	CHAR	12	0	Text Field: Usage Decision Valuation
55	TXTDYNBW	☐	QTXTDYNBW	QTXT12	CHAR	12	0	Text Field: Dynamic Modification Valuation
56	TXTPART	☐	QTXTPART	QKURZTEXT	CHAR	40	0	Inspection Type

Foreign Keys

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

History

Last changed by/on	SAP	20041209
SAP Release Created in