SAP ABAP Table V_QDQLQEM (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_QDQLQEM	Table Relationship Diagram
Short Description	Generated Table for View

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	MANDANT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	WERK	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
3	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
4	KUNNR	☑	QKUNWE	KUNNR	CHAR	10	0	Customer (Ship-To Party)	KNA1
5	LIFNR	☑	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
6	HERSTELLER	☑	QLIFNR	LIFNR	CHAR	10	0	Number of Manufacturer	LFA1
7	PLNTY	☑	PLNTY	PLNTY	CHAR	1	0	Task List Type	TCA01
8	PLNNR	☑	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
9	PLNAL	☑	PLNAL	ALTNR	CHAR	2	0	Group Counter
10	PLNFL	☑	PLNFOLGE	PLNFOLGE	CHAR	6	0	Sequence
11	PLNKN	☑	PLNKN	KNTNR	NUMC	8	0	Number of the task list node
12	ENSTEHDAT	☑	QENTST	DATUM	DATS	8	0	Date of Lot Creation
13	ENTSTEZEIT	☑	QENTSTZEIT	QZEIT	TIMS	6	0	Time of Lot Creation
14	PRUEFLOS	☑	QPLOS	QPLOS	NUMC	12	0	Inspection Lot Number
15	OBJNR	☑	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
16	AUFPL	☑	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
17	VORGLFNR	☑	QLFNKN	KNTNR	NUMC	8	0	Current Node Number from Order Counter APLZL
18	VORNR	☑	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
19	MERKNR	☑	QMERKNRP	QMERKNRP	NUMC	4	0	Inspection Characteristic Number
20	DYNMERKREF	☑	QMERKDYN	QMERKNRP	NUMC	4	0	Characteristic (in Plan) whose Q-Level Will Be Copied
21	ZAEHLERQL	☑	QZAEHLERQL	QDYNANZ4	INT4	10	0	Sequential Counter for Different Quality Levels
22	PROBENR	☑	QPROBENR	QPROBENR	NUMC	6	0	Sample Number
23	KZSKIPLOT	☐	QKZSKIPLOT	QKZ	CHAR	1	0	Lot Skipped
24	KZDYNERF	☐	QKZDYNERF	QKZ	CHAR	1	0	Dynamic Modification Is Carried Out
25	DYNHEAD	☐	QDYNHEAD	QDYNHEAD	CHAR	1	0	Level at Which Dynamic Modification Parameters Are Defined	TQ39A
26	PRSTUFE1	☐	QPRSTUFE	QPRSTUFE	NUMC	4	0	Inspection Stage	QDPS
27	PRSCHAERF1	☐	QPRSCHAERF	QPRSCHAERF	NUMC	3	0	Inspection Severity	QDEP
28	DYNREGEL1	☐	QDYNREGEL	QDYNREGEL	CHAR	3	0	Dynamic Modification Rule	QDDR
29	ERSTELLDAT	☐	QDATUMERST	DATUM	DATS	8	0	Date on Which the Data Record Was Created
30	PRSTUFE	☐	QPRSTUFE	QPRSTUFE	NUMC	4	0	Inspection Stage	QDPS
31	PRSCHAERFE	☐	QPRSCHAERF	QPRSCHAERF	NUMC	3	0	Inspection Severity	QDEP
32	DYNKRIT	☐	QDYNSTRING	QDYNSTRING	CHAR	10	0	String for Dynamic Modification Criteria (Database Relevant)
33	QDYNREGEL	☐	QDYNREGEL	QDYNREGEL	CHAR	3	0	Dynamic Modification Rule	QDDR
34	SATZSTATUS	☐	QSTATUS	QSTATUS	CHAR	1	0	Specification Record Status	TQ76
35	ART	☐	QPART	QPART	CHAR	8	0	Inspection Type	TQ30
36	HERKUNFT	☐	QHERK	QHERK	CHAR	2	0	Inspection Lot Origin	TQ31
37	DYN	☐	QDYN	QKZ	CHAR	1	0	Skips Allowed
38	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
39	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
40	KTEXTMAT	☐	QKTEXTOBJ	QKURZTEXT	CHAR	40	0	Short Text for Inspection Object
41	LOSMENGE	☐	QLOSMENGE	QMENGEPLOS	QUAN	13	3	Inspection Lot Quantity
42	MENGENEINH	☐	QLOSMENGEH	MEINS	UNIT	3	0	Base Unit of Measure for The Inspection Lot Quantity	T006
43	GESSTICHPR	☐	QGESTICH	QMENGEPLOS	QUAN	13	3	Sample Size
44	EINHPROBE	☐	QPROBEMGEH	MEINS	UNIT	3	0	Base Unit of Measure for the Sample Unit	T006
45	LMENGEIST	☐	QLMENGEIST	QMENGEPLOS	QUAN	13	3	Actual Lot Quantity
46	KURZTEXT	☐	QMKKURZTXT	QKURZTEXT	CHAR	40	0	Short Text for the Inspection Characteristic
47	STICHPRVER	☐	QSTICHVERF	QSTPRVER	CHAR	8	0	Sampling Procedure in Inspection Characteristic	QDSV
48	PROBEMGEH	☐	QPROBME	MEINS	UNIT	3	0	Sample Unit of Measure	T006
49	SOLLSTPUMF	☐	QGESUMF	QANZAHL4	INT4	10	0	Sample Size that Has to Be Inspected for a Characteristic
50	PRUEFUMF	☐	QPRUEFUMF	QMENGEPLOS	QUAN	13	3	Quantity to Be Inspected
51	STAT01	☐	QSTAT01	QKZ	CHAR	1	0	Inspection Lot is Created Automatically
52	STAT02	☐	QKZQALT	QKZ	CHAR	1	0	Partial Lots Exist
53	STAT04	☐	QUSER_EXIT	QKZ	CHAR	1	0	Data Record Was Changed Using Customer Exit
54	STAT05	☐	QKZQALSKNT	QKZQALSKNT	CHAR	1	0	Account Assignment Key: Inspection Lot
55	STAT06	☐	QKZPRFKOST	QKZ	CHAR	1	0	Record Appraisal Costs in Individual QM Order
56	STAT07	☐	QKZFERTPRF	QKZ	CHAR	1	0	Inspection with Inspection Points
57	STAT08	☐	QAUTO_VE	QKZ	CHAR	1	0	Automatic Usage Decision Planned
58	STAT09	☐	QABNAHMPRF	BSTYP	CHAR	1	0	Source Inspection
59	STAT14	☐	QSTAT14	QKZ	CHAR	1	0	Completion of Short-Term Inspection
60	STAT19	☐	QSTAT19	QKZ	CHAR	1	0	Documentation Required for Inspection Lot
61	STAT21	☐	QSTAT21	QKZ	CHAR	1	0	Enter Sample Manually
62	STAT22	☐	QSPEZUEBER	QKZ	CHAR	1	0	Inspect with Material Specification
63	STAT27	☐	QSTAT27	QKZ	CHAR	1	0	Inspection Lot is an R/2 Inspection Lot
64	STAT28	☐	QSTAT28	QKZ	CHAR	1	0	Select Characteristics Manually
65	STAT31	☐	QSTAT31	QKZ	CHAR	1	0	Trigger Sample Calculation Manually
66	STAT34	☐	QSTAT34	QKZ	CHAR	1	0	Stock Postings Completed
67	STAT35	☐	QSTAT35	QKZ	CHAR	1	0	Usage Decision Has Been Made
68	STAT45	☐	QSTAT45	QKZ	CHAR	1	0	Material as Dynamic Modification Criterion
69	STAT46	☐	QSTAT46	QKZ	CHAR	1	0	Vendor as Dynamic Modification Criterion
70	STAT47	☐	QSTAT47	QKZ	CHAR	1	0	Manufacturer as Dynamic Modification Criterion
71	STAT48	☐	QSTAT48	QKZ	CHAR	1	0	Customer as Dynamic Modification Criterion
72	STAT49	☐	QSTAT49	QKZ	CHAR	1	0	Machine as Dynamic Modification Criterion
73	STAT50	☐	QSTAT50	QKZ	CHAR	1	0	Project as Dynamic Modification Criterion
74	STPRVER	☐	QSTPRVER	QSTPRVER	CHAR	8	0	Sampling Procedure	QDSV
75	LS_KDMAT	☐	KDMAT	IDNEX	CHAR	35	0	Material belonging to the customer
76	ANZGEB	☐	QANZGEB	QGEBPLOS	QUAN	6	3	QM - No. of Containers
77	GEBEH	☐	QGEBEH	MEINS	UNIT	3	0	Lot Container	T006
78	STAT44	☐	QDYNTIME	QDYNTIME	CHAR	1	0	Time of Dynamic Modification in Inspection Lot

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_QDQLQEM	ART	TQ30	ART	KEY	1	CN
2	V_QDQLQEM	CHARG	MCH1	CHARG	REF	C	CN
3	V_QDQLQEM	DYNHEAD	TQ39A	DYNLEVEL	REF	C	CN
4	V_QDQLQEM	DYNREGEL1	QDDR	DYNREGEL	REF	C	CN
5	V_QDQLQEM	EINHPROBE	T006	MSEHI	REF	C	CN
6	V_QDQLQEM	GEBEH	T006	MSEHI	REF	C	CN
7	V_QDQLQEM	HERKUNFT	TQ31	HERKUNFT	KEY	1	CN
8	V_QDQLQEM	HERSTELLER	LFA1	LIFNR	REF	C	CN
9	V_QDQLQEM	KUNNR	KNA1	KUNNR	REF	C	CN
10	V_QDQLQEM	LIFNR	LFA1	LIFNR	REF	C	CN
11	V_QDQLQEM	MANDANT	T000	MANDT	KEY	1	CN
12	V_QDQLQEM	MATNR	MARA	MATNR	REF	C	CN
13	V_QDQLQEM	MENGENEINH	T006	MSEHI	REF	C	CN
14	V_QDQLQEM	OBJNR	ONR00	OBJNR	KEY	1	C
15	V_QDQLQEM	PLNTY	TCA01	PLNTY	REF	C	CN
16	V_QDQLQEM	PROBEMGEH	T006	MSEHI	REF	C	N
17	V_QDQLQEM	PRSCHAERF1	QDEP	PRSCHAERFE	REF	C	CN
18	V_QDQLQEM	PRSCHAERFE	QDEP	PRSCHAERFE	REF	C	CN
19	V_QDQLQEM	PRSTUFE	QDPS	PRSTUFE	REF	C	CN
20	V_QDQLQEM	PRSTUFE1	QDPS	PRSTUFE	REF	C	CN
21	V_QDQLQEM	QDYNREGEL	QDDR	DYNREGEL	REF	C	CN
22	V_QDQLQEM	SATZSTATUS	TQ76	STATUS	REF	C	CN
23	V_QDQLQEM	STICHPRVER	QDSV	STICHPRVER	REF	C	CN
24	V_QDQLQEM	STPRVER	QDSV	STICHPRVER	REF	C	CN
25	V_QDQLQEM	WERK	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in