SAP ABAP View V_QDQLQEM (View of QALS, AVFC; QAMV, QASV for dyn. mod. hist. (characs))

Hierarchy

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

Basic Data

View Type	D	Database View
Database View	V_QDQLQEM
Short Description	View of QALS, AVFC; QAMV, QASV for dyn. mod. hist. (characs)
Root table	QALS	Inspection lot record

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	QALS	QALS
2	AFVC
3	QAMV
4	QASV

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	AFVC	MANDT	JL	EQ				0	0
2	QALS	MANDANT	JR	EQ			AND	0	0
3	AFVC	AUFPL	JL	EQ				0	0
4	QALS	AUFPL	JR	EQ			AND	0	0
5	QAMV	MANDANT	JL	EQ				0	0
6	QALS	MANDANT	JR	EQ			AND	0	0
7	QAMV	PRUEFLOS	JL	EQ				0	0
8	QALS	PRUEFLOS	JR	EQ			AND	0	0
9	QAMV	VORGLFNR	JL	EQ				0	0
10	AFVC	APLZL	JR	EQ			AND	0	0
11	QASV	MANDANT	JL	EQ				0	0
12	QALS	MANDANT	JR	EQ			AND	0	0
13	QASV	PRUEFLOS	JL	EQ				0	0
14	QALS	PRUEFLOS	JR	EQ			AND	0	0
15	QASV	VORGLFNR	JL	EQ				0	0
16	QAMV	VORGLFNR	JR	EQ			AND	0	0
17	QASV	MERKNR	JL	EQ				0	0
18	QAMV	MERKNR	JR	EQ				0	0

View Fields

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

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in