SAP ABAP Table ENT5739 (Generated Table for View)

Basic Data

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

Delivery and Maintenance

Pool/cluster	QPMK
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	ZAEHLER	☑	QZAEHLER	QZAEHLER	CHAR	4	0	Plant for the Master Inspection Characteristic
3	MKMNR	☑	QMERKNR	QMERKNR	CHAR	8	0	Master Inspection Characteristics
4	VERSION	☑	QVERSNRMK	QVERSNR	CHAR	6	0	Version Number of the Master Inspection Characteristic
5	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
6	GUELTIGAB	☐	DATUV	DATUM	DATS	8	0	Valid-From Date
7	SORTFELD	☐	QSORTFELD	CHAR40	CHAR	40	0	Search Field
8	LOEKZ	☐	QLOESCHKZ	QLOESCHKZ	CHAR	1	0	Status of Master Record
9	LSPER	☐	QVERW	QKZ	CHAR	1	0	Data Record is Being Used
10	KONSISTENT	☐	QVOLLST	QVOLLST	CHAR	1	0	Copy Model/Reference Characteristic
11	AUTOR	☐	QERSTELLER	QAENDERER	CHAR	12	0	Name of User Who Created the Data Record
12	DATES	☐	QDATUMERST	DATUM	DATS	8	0	Date on Which the Data Record Was Created
13	AEAUT	☐	QAENDERER	QAENDERER	CHAR	12	0	Name of User who Most Recently Changed the Data Record
14	DATAE	☐	QDATUMAEND	DATUM	DATS	8	0	Date on Which Data Record Was Changed
15	STEUERKZ	☐	QMKCONTROL	QMKCONTROL	CHAR	30	0	Cntrl Indicator String for Insp. Char./Master Insp. Char.
16	MERKGEW	☐	QMERKGEW	QMERKKLAS	CHAR	2	0	Weighting of the Characteristic	TQ17A
17	PRFQL	☐	QPRQUALIF	QPRQUALIF	CHAR	5	0	Inspector Qualification	TQ11
18	DUMMY10	☐	QTXT10	QTXT10	CHAR	10	0	Text Line for Additional Information
19	DUMMY20	☐	QTXT20	QTXT20	CHAR	20	0	Text Line for Additional Information
20	DUMMY40	☐	QTXT40	QTXT40	CHAR	40	0	Text Line for Additional Information
21	TOLERANZSL	☐	QTOLERANZ	QTOLERANZ	CHAR	4	0	Tolerance Key	TQ29
22	STELLEN	☐	QSTELLEN	QSTELLEN	INT1	3	0	Number of Places to the Right of a Decimal Point (Accuracy)
23	MASSEINHSW	☐	QMASSEH	MEINS	UNIT	3	0	Unit of Measurement, in Which Quantitative Data Is Stored	T006
24	SOLLWERT	☐	QSOLLWERTE	QSOLLWERTE	FLTP	16	16	Target Value for a Quantitative Characteristic
25	SOLLWNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
26	TOLERANZOB	☐	QTOLOB	QSOLLWERTE	FLTP	16	16	Upper Specification Limit
27	TOLOBNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
28	TOLERANZUN	☐	QTOLUN	QSOLLWERTE	FLTP	16	16	Lower Tolerance Limit
29	TOLUNNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
30	KLASANZAHL	☐	QKLASSZAHL	QKLASSZAHL	INT1	3	0	Number of Value Classes for Inspection Results
31	KLASBREITE	☐	QKLASSBR	QSOLLWERTE	FLTP	16	16	Class Width
32	KLASBRNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
33	KLASMITTE	☐	QKLASSMIT	QSOLLWERTE	FLTP	16	16	Class Midpoint
34	KLASMINI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
35	GRENZEOB1	☐	QGRENZOB1	QSOLLWERTE	FLTP	16	16	First Upper Specification Limit
36	GRENZOB1NI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
37	GRENZEUN1	☐	QGRENZUN1	QSOLLWERTE	FLTP	16	16	First Lower Specification Limit
38	GRENZUN1NI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
39	GRENZEOB2	☐	QGRENZOB2	QSOLLWERTE	FLTP	16	16	Second Upper Specification Limit
40	GRENZOB2NI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
41	GRENZEUN2	☐	QGRENZUN2	QSOLLWERTE	FLTP	16	16	Second Lower Specification Limit
42	GRENZUN2NI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
43	PLAUSIOBEN	☐	QPLAUSIOB	QSOLLWERTE	FLTP	16	16	Upper Plausibility Limit
44	PLAUSIOBNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
45	PLAUSIUNTE	☐	QPLAUSIUN	QSOLLWERTE	FLTP	16	16	Lower Plausibility Limit
46	PLAUSIUNNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
47	TOLERWEIOB	☐	QTOLWOB	QSOLLWERTE	FLTP	16	16	Change to Upper Specification Limit
48	TOLWOBNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
49	TOLERWEIUN	☐	QTOLWUN	QSOLLWERTE	FLTP	16	16	Change to Lower Specification Limit
50	TOLWUNNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
51	TOLERWAB	☐	QTOLWAB	DATUM	DATS	8	0	Date from Which the Tolerance Change Is Valid
52	TOLERWBIS	☐	QTOLWBIS	DATUM	DATS	8	0	Date Until Which the Tolerance Change Is Valid
53	CODEGR9U	☐	QCODEGRPU	QCODEGRP	CHAR	8	0	Defect Code Group for Rejection at Lower Tolerance	QPGR
54	CODE9U	☐	QCODEU	QCODE	CHAR	4	0	Defect Code for Rejection at Lower Specification Limit	QPCD
55	CODEVR9U	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
56	CODEGR9O	☐	QCODEGRPO	QCODEGRP	CHAR	8	0	Defect Code Group for Rejection at Upper Tolerance	QPGR
57	CODE9O	☐	QCODEO	QCODE	CHAR	4	0	Defect Code for Rejection at Upper Specification Limit	QPCD
58	CODEVR9O	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
59	EEANTVERF	☐	QEANTVERF	QEANTVERF	CHAR	2	0	Fraction Calculation	TQ72

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ENT5739	CODE9O	QPCD	CODE	REF	C	CN
2	ENT5739	CODE9U	QPCD	CODE	REF	C	CN
3	ENT5739	CODEGR9O	QPGR	CODEGRUPPE	REF	C	CN
4	ENT5739	CODEGR9U	QPGR	CODEGRUPPE	REF	C	CN
5	ENT5739	EEANTVERF	TQ72	ANTVERF	REF	C	CN
6	ENT5739	MANDT	T000	MANDT	KEY	1	CN
7	ENT5739	MASSEINHSW	T006	MSEHI	REF	C	CN
8	ENT5739	MERKGEW	TQ17A	MERKKLASSE	REF	C	CN
9	ENT5739	PRFQL	TQ11	PRFQL	REF	C	CN
10	ENT5739	TOLERANZSL	TQ29	TOLERANZSL	REF	C	CN
11	ENT5739	WERKS	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in