SAP ABAP Table ENT5790 (Generated Table for View)

Basic Data

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

Delivery and Maintenance

Pool/cluster	PLMK
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
2	PLNTY	☑	PLNTY	PLNTY	CHAR	1	0	Task List Type
3	PLNNR	☑	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
4	PLNKN	☑	PLNKN	KNTNR	NUMC	8	0	Number of the task list node
5	KZEINSTELL	☑	QKZEINSTMK	QKZEINSTMK	CHAR	1	0	Characteristic Type
6	MERKNR	☑	QMERKNRP	QMERKNRP	NUMC	4	0	Inspection Characteristic Number
7	ZAEHL	☑	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
8	GUELTIGAB	☐	DATUV	DATUM	DATS	8	0	Valid-From Date
9	SERNV	☐	TECHV	TECHS	CHAR	12	0	Technical status from
10	LOEKZ	☐	LKENZ	XFELD	CHAR	1	0	Deletion Indicator
11	PARKZ	☐	PARKZ	XFELD	CHAR	1	0	Indicator: inactive changes
12	AENDERGNR	☐	AENNR	AENNR	CHAR	12	0	Change Number
13	AENDERER	☐	QAENDERER	QAENDERER	CHAR	12	0	Name of User who Most Recently Changed the Data Record
14	AENDERDAT	☐	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	QMTB_WERKS	☐	Q_METH_PLANT	WERKS	CHAR	4	0	Plant for Inspection Method	T001W
17	PMETHODE	☐	QPMETHODE	QPMETHODE	CHAR	8	0	Inspection Method	QMTB
18	PMTVERSION	☐	QVERSNRPM	QVERSNR	CHAR	6	0	Version Number of the Inspection Method
19	QPMK_REF	☐	QKZ_REF	QKZ	CHAR	1	0	Reference to Master Insp. Characteristic in Task List
20	QPMK_ZAEHL	☐	QZAEHLER	QZAEHLER	CHAR	4	0	Plant for the Master Inspection Characteristic
21	VERWMERKM	☐	QMERKNR	QMERKNR	CHAR	8	0	Master Inspection Characteristics	QPMK
22	MKVERSION	☐	QVERSNRMK	QVERSNR	CHAR	6	0	Version Number of the Master Inspection Characteristic
23	MKVERSDAT	☐	QVERSDAT	DATUM	DATS	8	0	Key Date for Version Selection
24	MERKGEW	☐	QMERKGEW	QMERKKLAS	CHAR	2	0	Weighting of the Characteristic	TQ17A
25	PROBENR	☐	QPROBEPL	QPROBEPL	NUMC	3	0	Partial Sample No. for Inspection Charac. in Task List
26	PRUEFQUALI	☐	QPRQUALIF	QPRQUALIF	CHAR	5	0	Inspector Qualification	TQ11
27	TOLERANZSL	☐	QTOLERANZ	QTOLERANZ	CHAR	4	0	Tolerance Key	TQ29
28	KURZTEXT	☐	QTXT_CHA	QKURZTEXT	CHAR	40	0	Short Text for Inspection Characteristic
29	LTEXTKZ	☐	QLTEXTKZ	QKZ	CHAR	1	0	Inspection Characteristic Long Text Exists
30	LTEXTSPR	☐	SPRAS	SPRAS	LANG	1	0	Language Key
31	LTEXTEKZ	☐	QKZPRZIEH	QKZWSP	CHAR	1	0	Physical-Sample-Drawing Text Exists
32	LTXTENTSPR	☐	SPRAS	SPRAS	LANG	1	0	Language Key
33	STELLEN	☐	QSTELLEN	QSTELLEN	INT1	3	0	Number of Places to the Right of a Decimal Point (Accuracy)
34	MASSEINHSW	☐	QMASSEH	MEINS	UNIT	3	0	Unit of Measurement, in Which Quantitative Data Is Stored	T006
35	SOLLWERT	☐	QSOLLWERTE	QSOLLWERTE	FLTP	16	16	Target Value for a Quantitative Characteristic
36	SOLLWNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
37	TOLERANZOB	☐	QTOLOB	QSOLLWERTE	FLTP	16	16	Upper Specification Limit
38	TOLOBNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
39	TOLERANZUN	☐	QTOLUN	QSOLLWERTE	FLTP	16	16	Lower Tolerance Limit
40	TOLUNNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
41	KLASANZAHL	☐	QKLASSZAHL	QKLASSZAHL	INT1	3	0	Number of Value Classes for Inspection Results
42	KLASBREITE	☐	QKLASSBR	QSOLLWERTE	FLTP	16	16	Class Width
43	KLASBRNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
44	KLASMITTE	☐	QKLASSMIT	QSOLLWERTE	FLTP	16	16	Class Midpoint
45	KLASMINI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
46	GRENZEOB1	☐	QGRENZOB1	QSOLLWERTE	FLTP	16	16	First Upper Specification Limit
47	GRENZOB1NI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
48	GRENZEUN1	☐	QGRENZUN1	QSOLLWERTE	FLTP	16	16	First Lower Specification Limit
49	GRENZUN1NI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
50	GRENZEOB2	☐	QGRENZOB2	QSOLLWERTE	FLTP	16	16	Second Upper Specification Limit
51	GRENZOB2NI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
52	GRENZEUN2	☐	QGRENZUN2	QSOLLWERTE	FLTP	16	16	Second Lower Specification Limit
53	GRENZUN2NI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
54	PLAUSIOBEN	☐	QPLAUSIOB	QSOLLWERTE	FLTP	16	16	Upper Plausibility Limit
55	PLAUSIOBNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
56	PLAUSIUNTE	☐	QPLAUSIUN	QSOLLWERTE	FLTP	16	16	Lower Plausibility Limit
57	PLAUSIUNNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
58	TOLERWEIOB	☐	QTOLWOB	QSOLLWERTE	FLTP	16	16	Change to Upper Specification Limit
59	TOLWOBNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
60	TOLERWEIUN	☐	QTOLWUN	QSOLLWERTE	FLTP	16	16	Change to Lower Specification Limit
61	TOLWUNNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
62	TOLERWAB	☐	QTOLWAB	DATUM	DATS	8	0	Date from Which the Tolerance Change Is Valid
63	TOLERWBIS	☐	QTOLWBIS	DATUM	DATS	8	0	Date Until Which the Tolerance Change Is Valid
64	STICHPRVER	☐	QSTICHVERF	QSTPRVER	CHAR	8	0	Sampling Procedure in Inspection Characteristic
65	FAKPLANME	☐	QUMREN	QUMRENFAK	FLTP	16	16	Factor for Converting MatUnitOfMeasure to SampUnitOfMeasure
66	FAKPROBME	☐	QUMRENPME	QUMRENFAK	FLTP	16	16	Factor for Converting SampUnitOfMeasure to MatUnitOfMeasure
67	PROBEMGEH	☐	QPROBME	MEINS	UNIT	3	0	Sample Unit of Measure	T006
68	PRUEFEINH	☐	QPROBEFAK	QPROBEFAK	DEC	5	2	Sample Quantity Factor for Sample(Mult. Sample Unit of Msr.)
69	DYNKRIT	☐	QDYNSTRING	QDYNSTRING	CHAR	10	0	String for Dynamic Modification Criteria (Database Relevant)
70	FORMELSL	☐	QFORMELSL	QFORMELSL	CHAR	1	0	Check and Calculate Formula in QM
71	FORMEL1	☐	QFORMEL	QFORMEL	CHAR	60	0	Formula Field
72	FORMEL2	☐	QFORMEL	QFORMEL	CHAR	60	0	Formula Field
73	CODEGR9U	☐	QCODEGRPU	QCODEGRP	CHAR	8	0	Defect Code Group for Rejection at Lower Tolerance
74	CODE9U	☐	QCODEU	QCODE	CHAR	4	0	Defect Code for Rejection at Lower Specification Limit
75	CODEVR9U	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
76	CODEGR9O	☐	QCODEGRPO	QCODEGRP	CHAR	8	0	Defect Code Group for Rejection at Upper Tolerance
77	CODE9O	☐	QCODEO	QCODE	CHAR	4	0	Defect Code for Rejection at Upper Specification Limit
78	CODEVR9O	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
79	DUMMY10	☐	QTXT10	QTXT10	CHAR	10	0	Text Line for Additional Information
80	DUMMY20	☐	QTXT20	QTXT20	CHAR	20	0	Text Line for Additional Information
81	DUMMY40	☐	QTXT40	QTXT40	CHAR	40	0	Text Line for Additional Information
82	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	ENT5790	EEANTVERF	TQ72	ANTVERF	REF	C	CN
2	ENT5790	MASSEINHSW	T006	MSEHI	REF	C	CN
3	ENT5790	MERKGEW	TQ17A	MERKKLASSE	REF	C	CN
4	ENT5790	PMETHODE	QMTB	PMTNR
5	ENT5790	PROBEMGEH	T006	MSEHI	REF	C	N
6	ENT5790	PRUEFQUALI	TQ11	PRFQL	REF	C	CN
7	ENT5790	QMTB_WERKS	T001W	WERKS	REF	C	N
8	ENT5790	TOLERANZSL	TQ29	TOLERANZSL	REF	C	CN
9	ENT5790	VERWMERKM	QPMK	MKMNR

History

Last changed by/on	SAP	20130529
SAP Release Created in