SAP ABAP Table ENT5747 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	ENT5747	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	ERSTELLER	ANNAM	USNAM	CHAR	12	0	User Who Created Record
20	ERSTELLDAT	ANDAT	DATUM	DATS	8	0	Date Record Created on
21	AENDERER	QAENDERER	QAENDERER	CHAR	12	0	Name of User who Most Recently Changed the Data Record
22	AENDERDAT	QDATUMAEND	DATUM	DATS	8	0	Date on Which Data Record Was Changed
23	TOLERANZSL	QTOLERANZ	QTOLERANZ	CHAR	4	0	Tolerance Key	TQ29
24	STELLEN	QSTELLEN	QSTELLEN	INT1	3	0	Number of Places to the Right of a Decimal Point (Accuracy)
25	MASSEINHSW	QMASSEH	MEINS	UNIT	3	0	Unit of Measurement, in Which Quantitative Data Is Stored	T006
26	SOLLWERT	QSOLLWERTE	QSOLLWERTE	FLTP	16	16	Target Value for a Quantitative Characteristic
27	SOLLWNI	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
28	TOLERANZOB	QTOLOB	QSOLLWERTE	FLTP	16	16	Upper Specification Limit
29	TOLOBNI	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
30	TOLERANZUN	QTOLUN	QSOLLWERTE	FLTP	16	16	Lower Tolerance Limit
31	TOLUNNI	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
32	KLASANZAHL	QKLASSZAHL	QKLASSZAHL	INT1	3	0	Number of Value Classes for Inspection Results
33	KLASBREITE	QKLASSBR	QSOLLWERTE	FLTP	16	16	Class Width
34	KLASBRNI	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
35	KLASMITTE	QKLASSMIT	QSOLLWERTE	FLTP	16	16	Class Midpoint
36	KLASMINI	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
37	GRENZEOB1	QGRENZOB1	QSOLLWERTE	FLTP	16	16	First Upper Specification Limit
38	GRENZOB1NI	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
39	GRENZEUN1	QGRENZUN1	QSOLLWERTE	FLTP	16	16	First Lower Specification Limit
40	GRENZUN1NI	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
41	GRENZEOB2	QGRENZOB2	QSOLLWERTE	FLTP	16	16	Second Upper Specification Limit
42	GRENZOB2NI	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
43	GRENZEUN2	QGRENZUN2	QSOLLWERTE	FLTP	16	16	Second Lower Specification Limit
44	GRENZUN2NI	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
45	PLAUSIOBEN	QPLAUSIOB	QSOLLWERTE	FLTP	16	16	Upper Plausibility Limit
46	PLAUSIOBNI	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
47	PLAUSIUNTE	QPLAUSIUN	QSOLLWERTE	FLTP	16	16	Lower Plausibility Limit
48	PLAUSIUNNI	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
49	TOLERWEIOB	QTOLWOB	QSOLLWERTE	FLTP	16	16	Change to Upper Specification Limit
50	TOLWOBNI	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
51	TOLERWEIUN	QTOLWUN	QSOLLWERTE	FLTP	16	16	Change to Lower Specification Limit
52	TOLWUNNI	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
53	TOLERWAB	DATUV	DATUM	DATS	8	0	Valid-From Date
54	TOLERWBIS	DATUB	DATUM	DATS	8	0	Valid-to date
55	CODEGR9U	QCODEGRPU	QCODEGRP	CHAR	8	0	Defect Code Group for Rejection at Lower Tolerance
56	CODE9U	QCODEU	QCODE	CHAR	4	0	Defect Code for Rejection at Lower Specification Limit
57	CODEVR9U	QVERSNR	QVERSNR	CHAR	6	0	Version Number
58	CODEGR9O	QCODEGRPO	QCODEGRP	CHAR	8	0	Defect Code Group for Rejection at Upper Tolerance
59	CODE9O	QCODEO	QCODE	CHAR	4	0	Defect Code for Rejection at Upper Specification Limit
60	CODEVR9O	QVERSNR	QVERSNR	CHAR	6	0	Version Number
61	KATAB1	QKTTAB	QKTTAB	CHAR	1	0	Catalog Entry Is a Selected Set
62	KATALGART1	QKATAUSW	QKATART	CHAR	1	0	Catalog Type of Assigned Code Group or Selected Set	TQ15
63	AUSWMENGE1	QCGRAUSW	QCGRAUSW	CHAR	8	0	Assigned Code Group or Selected Set
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	ENT5747	AUSWMGWRK1	T001W	WERKS	REF	C	CN
2	ENT5747	AUSWMGWRK2	T001W	WERKS	REF	C	CN
3	ENT5747	AUSWMGWRK3	T001W	WERKS	REF	C	CN
4	ENT5747	AUSWMGWRK4	T001W	WERKS	REF	C	CN
5	ENT5747	AUSWMGWRK5	T001W	WERKS	REF	C	CN
6	ENT5747	KATALGART1	TQ15	KATALOGART	REF	C	N
7	ENT5747	KATALGART2	TQ15	KATALOGART	REF	C	N
8	ENT5747	KATALGART3	TQ15	KATALOGART	REF	C	N
9	ENT5747	KATALGART4	TQ15	KATALOGART	REF	C	N
10	ENT5747	KATALGART5	TQ15	KATALOGART	REF	C	N
11	ENT5747	MASSEINHSW	T006	MSEHI	REF	C	CN
12	ENT5747	MATNR	MARA	MATNR	REF	C	N
13	ENT5747	TOLERANZSL	TQ29	TOLERANZSL	REF	C	CN