SAP ABAP Table ENT5791 (Generated Table for View)

Basic Data

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

Delivery and Maintenance

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

Components


	Field	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	ZUORDNR	QZUORDNR	QZUORDNR	NUMC	4	0	Number for Dependent Characteristic Specifications
8	ZAEHL	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
9	GUELTIGAB	DATUV	DATUM	DATS	8	0	Valid-From Date
10	SERNV	TECHV	TECHS	CHAR	12	0	Technical status from
11	MATNR	QMATNR_D	MATNR	CHAR	18	0	Material Number of the Dependent Characteristic Specs	MARA
12	WERKS	WERKS_D	WERKS	CHAR	4	0	Plant
13	PLNAL	PLNAL	ALTNR	CHAR	2	0	Group Counter
14	DATUV	CIM_DATE	DATUM	DATS	8	0	Valid-from date
15	ZKRIZ	DZKRIZ	ZKRIZ	NUMC	7	0	Counter for additional criteria
16	LOEKZ	LKENZ	XFELD	CHAR	1	0	Deletion Indicator
17	PARKZ	PARKZ	XFELD	CHAR	1	0	Indicator: inactive changes
18	AENDERGNR	AENNR	AENNR	CHAR	12	0	Change Number
19	AENDERER	QAENDERER	QAENDERER	CHAR	12	0	Name of User who Most Recently Changed the Data Record
20	AENDERDAT	QDATUMAEND	DATUM	DATS	8	0	Date on Which Data Record Was Changed
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	DATUV	DATUM	DATS	8	0	Valid-From Date
52	TOLERWBIS	DATUB	DATUM	DATS	8	0	Valid-to date
53	CODEGR9U	QCODEGRPU	QCODEGRP	CHAR	8	0	Defect Code Group for Rejection at Lower Tolerance
54	CODE9U	QCODEU	QCODE	CHAR	4	0	Defect Code for Rejection at Lower Specification Limit
55	CODEVR9U	QVERSNR	QVERSNR	CHAR	6	0	Version Number
56	CODEGR9O	QCODEGRPO	QCODEGRP	CHAR	8	0	Defect Code Group for Rejection at Upper Tolerance
57	CODE9O	QCODEO	QCODE	CHAR	4	0	Defect Code for Rejection at Upper Specification Limit
58	CODEVR9O	QVERSNR	QVERSNR	CHAR	6	0	Version Number
59	KATAB1	QKTTAB	QKTTAB	CHAR	1	0	Catalog Entry Is a Selected Set
60	KATALGART1	QKATAUSW	QKATART	CHAR	1	0	Catalog Type of Assigned Code Group or Selected Set	TQ15
61	AUSWMENGE1	QCGRAUSW	QCGRAUSW	CHAR	8	0	Assigned Code Group or Selected Set
62	ERSTELLER	ANNAM	USNAM	CHAR	12	0	User Who Created Record
63	ERSTELLDAT	ANDAT	DATUM	DATS	8	0	Date Record Created on
64	AUSWMGWRK1	QWERKAUSW	WERKS	CHAR	4	0	Plant of the Assigned Selected Set	T001W
65	AUSWVERS1	QVERSNR	QVERSNR	CHAR	6	0	Version Number
66	AUSWDAT1	QVERSDAT	DATUM	DATS	8	0	Key Date for Version Selection
67	KATAB2	QKTTAB	QKTTAB	CHAR	1	0	Catalog Entry Is a Selected Set
68	KATALGART2	QKATAUSW	QKATART	CHAR	1	0	Catalog Type of Assigned Code Group or Selected Set	TQ15
69	AUSWMENGE2	QCGRAUSW	QCGRAUSW	CHAR	8	0	Assigned Code Group or Selected Set
70	AUSWMGWRK2	QWERKAUSW	WERKS	CHAR	4	0	Plant of the Assigned Selected Set	T001W
71	AUSWVERS2	QVERSNR	QVERSNR	CHAR	6	0	Version Number
72	AUSWDAT2	QVERSDAT	DATUM	DATS	8	0	Key Date for Version Selection
73	KATAB3	QKTTAB	QKTTAB	CHAR	1	0	Catalog Entry Is a Selected Set
74	KATALGART3	QKATAUSW	QKATART	CHAR	1	0	Catalog Type of Assigned Code Group or Selected Set	TQ15
75	AUSWMENGE3	QCGRAUSW	QCGRAUSW	CHAR	8	0	Assigned Code Group or Selected Set
76	AUSWMGWRK3	QWERKAUSW	WERKS	CHAR	4	0	Plant of the Assigned Selected Set	T001W
77	AUSWVERS3	QVERSNR	QVERSNR	CHAR	6	0	Version Number
78	AUSWDAT3	QVERSDAT	DATUM	DATS	8	0	Key Date for Version Selection
79	KATAB4	QKTTAB	QKTTAB	CHAR	1	0	Catalog Entry Is a Selected Set
80	KATALGART4	QKATAUSW	QKATART	CHAR	1	0	Catalog Type of Assigned Code Group or Selected Set	TQ15
81	AUSWMENGE4	QCGRAUSW	QCGRAUSW	CHAR	8	0	Assigned Code Group or Selected Set
82	AUSWMGWRK4	QWERKAUSW	WERKS	CHAR	4	0	Plant of the Assigned Selected Set	T001W
83	AUSWVERS4	QVERSNR	QVERSNR	CHAR	6	0	Version Number
84	AUSWDAT4	QVERSDAT	DATUM	DATS	8	0	Key Date for Version Selection
85	KATAB5	QKTTAB	QKTTAB	CHAR	1	0	Catalog Entry Is a Selected Set
86	KATALGART5	QKATAUSW	QKATART	CHAR	1	0	Catalog Type of Assigned Code Group or Selected Set	TQ15
87	AUSWMENGE5	QCGRAUSW	QCGRAUSW	CHAR	8	0	Assigned Code Group or Selected Set
88	AUSWMGWRK5	QWERKAUSW	WERKS	CHAR	4	0	Plant of the Assigned Selected Set	T001W
89	AUSWVERS5	QVERSNR	QVERSNR	CHAR	6	0	Version Number
90	AUSWDAT5	QVERSDAT	DATUM	DATS	8	0	Key Date for Version Selection
91	DUMMY10	QTXT10	QTXT10	CHAR	10	0	Text Line for Additional Information
92	DUMMY20	QTXT20	QTXT20	CHAR	20	0	Text Line for Additional Information
93	DUMMY40	QTXT40	QTXT40	CHAR	40	0	Text Line for Additional Information

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right

1	ENT5791	AUSWMGWRK1	T001W	WERKS	REF	C	CN
2	ENT5791	AUSWMGWRK2	T001W	WERKS	REF	C	CN
3	ENT5791	AUSWMGWRK3	T001W	WERKS	REF	C	CN
4	ENT5791	AUSWMGWRK4	T001W	WERKS	REF	C	CN
5	ENT5791	AUSWMGWRK5	T001W	WERKS	REF	C	CN
6	ENT5791	KATALGART1	TQ15	KATALOGART	REF	C	N
7	ENT5791	KATALGART2	TQ15	KATALOGART	REF	C	N
8	ENT5791	KATALGART3	TQ15	KATALOGART	REF	C	N
9	ENT5791	KATALGART4	TQ15	KATALOGART	REF	C	N
10	ENT5791	KATALGART5	TQ15	KATALOGART	REF	C	N
11	ENT5791	MASSEINHSW	T006	MSEHI	REF	C	CN
12	ENT5791	MATNR	MARA	MATNR	REF	C	N
13	ENT5791	TOLERANZSL	TQ29	TOLERANZSL	REF	C	CN