SAP ABAP Table ENT5711 (Generated Table for View)

Basic Data

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

Delivery and Maintenance

Pool/cluster	QAMV
Delivery Class
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

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	PRUEFLOS	☑	QPLOS	QPLOS	NUMC	12	0	Inspection Lot Number	QALS
3	VORGLFNR	☑	QLFNKN	KNTNR	NUMC	8	0	Current Node Number from Order Counter APLZL
4	MERKNR	☑	QMERKNRP	QMERKNRP	NUMC	4	0	Inspection Characteristic Number
5	ERSTELLER	☐	QERSTELLER	QAENDERER	CHAR	12	0	Name of User Who Created the Data Record
6	ERSTELLDAT	☐	QDATUMERST	DATUM	DATS	8	0	Date on Which the Data Record Was Created
7	AENDERER	☐	QAENDERER	QAENDERER	CHAR	12	0	Name of User who Most Recently Changed the Data Record
8	AENDERDAT	☐	QDATUMAEND	DATUM	DATS	8	0	Date on Which Data Record Was Changed
9	PHYSPROBE	☐	QPHYSPROBE	QPROBENR	NUMC	6	0	Number of the Partial Sample
10	SATZSTATUS	☐	QSTATUS	QSTATUS	CHAR	1	0	Specification Record Status	TQ76
11	STEUERKZ	☐	QMKCONTROL	QMKCONTROL	CHAR	30	0	Cntrl Indicator String for Insp. Char./Master Insp. Char.
12	TSTICHPRKZ	☐	QTSTICHPRO	QKZUMFS	CHAR	1	0	Partial Samples Possible
13	NOINPUTKZ	☐	QNOINPUT	QKZ	CHAR	1	0	Results Are Calculated Internally
14	NIPLANMKKZ	☐	QNIPLANMK	QKZ	CHAR	1	0	Unplanned Characteristic
15	QMTB_WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
16	PMETHODE	☐	QPMETHODE	QPMETHODE	CHAR	8	0	Inspection Method	QMTB
17	PMTVERSION	☐	QVERSNRPM	QVERSNR	CHAR	6	0	Version Number of the Inspection Method
18	QPMK_WERKS	☐	QZAEHLER	QZAEHLER	CHAR	4	0	Plant for the Master Inspection Characteristic
19	VERWMERKM	☐	QMERKNR	QMERKNR	CHAR	8	0	Master Inspection Characteristics	QPMK
20	MKVERSION	☐	QVERSNRMK	QVERSNR	CHAR	6	0	Version Number of the Master Inspection Characteristic
21	MERKGEW	☐	QMERKGEW	QMERKKLAS	CHAR	2	0	Weighting of the Characteristic	TQ17A
22	KURZTEXT	☐	QMKKURZTXT	QKURZTEXT	CHAR	40	0	Short Text for the Inspection Characteristic
23	LTEXTKZ	☐	QLTEXTKZ	QKZ	CHAR	1	0	Inspection Characteristic Long Text Exists
24	LTEXTSPR	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
25	LTEXTEKZ	☐	QKZPRZIEH	QKZWSP	CHAR	1	0	Physical-Sample-Drawing Text Exists
26	LTXTENTSPR	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
27	PRUEFQUALI	☐	QPRQUALIF	QPRQUALIF	CHAR	5	0	Inspector Qualification	TQ11
28	FORMEL1	☐	QFORMEL	QFORMEL	CHAR	60	0	Formula Field
29	FORMEL2	☐	QFORMEL	QFORMEL	CHAR	60	0	Formula Field
30	DUMMY10	☐	QTXT10	QTXT10	CHAR	10	0	Text Line for Additional Information
31	DUMMY20	☐	QTXT20	QTXT20	CHAR	20	0	Text Line for Additional Information
32	DUMMY40	☐	QTXT40	QTXT40	CHAR	40	0	Text Line for Additional Information
33	CODEGR9U	☐	QCODEGRPU	QCODEGRP	CHAR	8	0	Defect Code Group for Rejection at Lower Tolerance
34	CODE9U	☐	QCODEU	QCODE	CHAR	4	0	Defect Code for Rejection at Lower Specification Limit
35	CODEGR9O	☐	QCODEGRPO	QCODEGRP	CHAR	8	0	Defect Code Group for Rejection at Upper Tolerance
36	CODEVR9U	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
37	CODE9O	☐	QCODEO	QCODE	CHAR	4	0	Defect Code for Rejection at Upper Specification Limit
38	CODEVR9O	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
39	STELLEN	☐	QSTELLEN	QSTELLEN	INT1	3	0	Number of Places to the Right of a Decimal Point (Accuracy)
40	MASSEINHSW	☐	QMASSEH	MEINS	UNIT	3	0	Unit of Measurement, in Which Quantitative Data Is Stored	T006
41	SOLLWERT	☐	QSOLLWERTE	QSOLLWERTE	FLTP	16	16	Target Value for a Quantitative Characteristic
42	SOLLWNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
43	TOLERANZOB	☐	QTOLOB	QSOLLWERTE	FLTP	16	16	Upper Specification Limit
44	TOLOBNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
45	TOLERANZUN	☐	QTOLUN	QSOLLWERTE	FLTP	16	16	Lower Tolerance Limit
46	TOLUNNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
47	GRENZEOB1	☐	QGRENZOB1	QSOLLWERTE	FLTP	16	16	First Upper Specification Limit
48	GRENZOB1NI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
49	TOLERWKZ	☐	QTOLERWKZ	QKZ	CHAR	1	0	Tolerance Change Is Active
50	GRENZEUN1	☐	QGRENZUN1	QSOLLWERTE	FLTP	16	16	First Lower Specification Limit
51	GRENZUN1NI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
52	GRENZEOB2	☐	QGRENZOB2	QSOLLWERTE	FLTP	16	16	Second Upper Specification Limit
53	GRENZOB2NI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
54	GRENZUN2NI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
55	PLAUSIOBEN	☐	QPLAUSIOB	QSOLLWERTE	FLTP	16	16	Upper Plausibility Limit
56	GRENZEUN2	☐	QGRENZUN2	QSOLLWERTE	FLTP	16	16	Second Lower Specification Limit
57	PLAUSIOBNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
58	PLAUSIUNTE	☐	QPLAUSIUN	QSOLLWERTE	FLTP	16	16	Lower Plausibility Limit
59	PLAUSIUNNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
60	KLASANZAHL	☐	QKLASSZAHL	QKLASSZAHL	INT1	3	0	Number of Value Classes for Inspection Results
61	KLASBREITE	☐	QKLASSBR	QSOLLWERTE	FLTP	16	16	Class Width
62	KLASBRNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
63	KLASMITTE	☐	QKLASSMIT	QSOLLWERTE	FLTP	16	16	Class Midpoint
64	KLASMINI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
65	STICHPRVER	☐	QSTICHVERF	QSTPRVER	CHAR	8	0	Sampling Procedure in Inspection Characteristic	QDSV
66	FAKPLANME	☐	QUMREN	QUMRENFAK	FLTP	16	16	Factor for Converting MatUnitOfMeasure to SampUnitOfMeasure
67	FAKPROBME	☐	QUMRENPME	QUMRENFAK	FLTP	16	16	Factor for Converting SampUnitOfMeasure to MatUnitOfMeasure
68	ANTVERF	☐	QEANTVERF	QEANTVERF	CHAR	2	0	Fraction Calculation	TQ72
69	BEWREGEL	☐	QBEWERT	QKEY1	CHAR	2	0	Valuation Rule	QDFM
70	PROBMGFAK	☐	QPROBEFAK	QPROBEFAK	DEC	5	2	Sample Quantity Factor for Sample(Mult. Sample Unit of Msr.)
71	PROBEMGEH	☐	QPROBME	MEINS	UNIT	3	0	Sample Unit of Measure	T006
72	SOLLSTPUMF	☐	QGESUMF	QANZAHL4	INT4	10	0	Sample Size that Has to Be Inspected for a Characteristic
73	PRUEFUMF	☐	QPRUEFUMF	QMENGEPLOS	QUAN	13	3	Quantity to Be Inspected
74	MENGENEINH	☐	QPROBEMGEH	MEINS	UNIT	3	0	Base Unit of Measure for the Sample Unit	T006
75	HPZ	☐	QHPZ	QKZ	CHAR	1	0	100% Inspection
76	SOLLSTPANZ	☐	QSOSTPANZ	QANZAHL2	INT2	5	0	Number of Planned Partial Samples
77	ANTEILKZ	☐	QANTEILKZ	QKZ	CHAR	1	0	Take Share Estimate into Account
78	RUECKMELNR	☐	QRUECKNR	QRUECKNR	NUMC	8	0	Confirmation Number for Inspection Characteristic
79	KZEINSTELL	☐	QKZEINSTMK	QKZEINSTMK	CHAR	1	0	Characteristic Type
80	ZAEHL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ENT5711	ANTVERF	TQ72	ANTVERF	REF	C	CN
2	ENT5711	BEWREGEL	QDFM	FBKEY	REF	C	N
3	ENT5711	LTEXTSPR	T002	SPRAS	REF	C	N
4	ENT5711	LTXTENTSPR	T002	SPRAS	REF	C	N
5	ENT5711	MANDANT	T000	MANDT	KEY	1	CN
6	ENT5711	MASSEINHSW	T006	MSEHI	REF	C	N
7	ENT5711	MENGENEINH	T006	MSEHI	REF	C	N
8	ENT5711	MERKGEW	TQ17A	MERKKLASSE	REF	C	N
9	ENT5711	PMETHODE	QMTB	PMTNR	REF	C	CN
10	ENT5711	PROBEMGEH	T006	MSEHI	REF	C	N
11	ENT5711	PRUEFLOS	QALS	PRUEFLOS	KEY	1	CN
12	ENT5711	PRUEFQUALI	TQ11	PRFQL	REF	C	N
13	ENT5711	QMTB_WERKS	T001W	WERKS	REF	C	N
14	ENT5711	SATZSTATUS	TQ76	STATUS	REF	C	CN
15	ENT5711	STICHPRVER	QDSV	STICHPRVER	REF	C	CN
16	ENT5711	VERWMERKM	QPMK	MKMNR	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in