SAP ABAP Table ORAEXPLAIN (Explain Plan for Oracle Statement)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-MON-TUN (Application Component) Performance Monitors (TCC)
     ⤷ STUN (Package) DBA: All the rest in English

Basic Data

Table Category	INTTAB	Structure
Structure	ORAEXPLAIN	Table Relationship Diagram
Short Description	Explain Plan for Oracle Statement

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	ANALY_ID	☐			CHAR	14	0
2	STMT_ID	☐			CHAR	2	0
3	.INCLUDE	☐				0	0	Additional Information for Hierarchy Nodes
4	.INCLUDE	☐				0	0	Description of a Hierarchy Node
5	ID	☐	SEU_ID	SEU_ID	NUMC	6	0	Internal: Node ID
6	TYPE	☐	SEU_TYPE	SEU_TYPE	CHAR	4	0	Node type
7	NAME	☐	SEU_NAME	SEU_NAME	CHAR	30	0	Object name
8	TLEVEL	☐	SEU_LEVEL	SEU_LEVEL	NUMC	2	0	Node level
9	LINK	☐	SEU_LINK	CHAR1	CHAR	1	0	Link ID
10	COMPRESS	☐	SEU_COMPR	CHAR1	CHAR	1	0	Internal: Compression ID
11	LEAF	☐	SEU_LEAF	CHAR1	CHAR	1	0	Internal: Page ID
12	TLOCK	☐	SEU_LOCK	CHAR1	CHAR	1	0	Internal: Selection ID
13	PARENT	☐	SEU_ID	SEU_ID	NUMC	6	0	Internal: Node ID
14	CHILD	☐	SEU_ID	SEU_ID	NUMC	6	0	Internal: Node ID
15	NEXT	☐	SEU_ID	SEU_ID	NUMC	6	0	Internal: Node ID
16	.INCLUDE	☐				0	0	General Hierarchy Display: Additional Attributes
17	NLENGTH	☐	SEU_NODELN	NUM2	NUMC	2	0	Output length of a hierarchy node
18	COLOR	☐	SEU_COLOR	NUM1	NUMC	1	0	Color display of a hierarchy node
19	INTENSIV	☐	SEU_INTENS	CHAR1	CHAR	1	0	Intensity of display
20	TEXT	☐	SEU_TEXT	SEU_TEXT	CHAR	75	0	Text/icon/symbol
21	TLENGTH	☐	SEU_NODELN	NUM2	NUMC	2	0	Output length of a hierarchy node
22	TCOLOR	☐	SEU_COLOR	NUM1	NUMC	1	0	Color display of a hierarchy node
23	TINTENSIV	☐	SEU_INTENS	CHAR1	CHAR	1	0	Intensity of display
24	TPOS	☐	SEU_POS	CHAR3	CHAR	3	0	Hierarchy display: Column position of a text
25	KIND	☐	SEU_KIND	CHAR1	CHAR	1	0	Text type (Space = Text, 'I' = 'Icon', 'S' = Symbol)
26	TEXT1	☐	SEU_TEXT	SEU_TEXT	CHAR	75	0	Text/icon/symbol
27	TLENGTH1	☐	SEU_NODELN	NUM2	NUMC	2	0	Output length of a hierarchy node
28	TCOLOR1	☐	SEU_COLOR	NUM1	NUMC	1	0	Color display of a hierarchy node
29	TINTENSIV1	☐	SEU_INTENS	CHAR1	CHAR	1	0	Intensity of display
30	TPOS1	☐	SEU_POS	CHAR3	CHAR	3	0	Hierarchy display: Column position of a text
31	KIND1	☐	SEU_KIND	CHAR1	CHAR	1	0	Text type (Space = Text, 'I' = 'Icon', 'S' = Symbol)
32	TEXT2	☐	SEU_TEXT	SEU_TEXT	CHAR	75	0	Text/icon/symbol
33	TLENGTH2	☐	SEU_NODELN	NUM2	NUMC	2	0	Output length of a hierarchy node
34	TCOLOR2	☐	SEU_COLOR	NUM1	NUMC	1	0	Color display of a hierarchy node
35	TINTENSIV2	☐	SEU_INTENS	CHAR1	CHAR	1	0	Intensity of display
36	TPOS2	☐	SEU_POS	CHAR3	CHAR	3	0	Hierarchy display: Column position of a text
37	KIND2	☐	SEU_KIND	CHAR1	CHAR	1	0	Text type (Space = Text, 'I' = 'Icon', 'S' = Symbol)
38	TEXT3	☐	SEU_TEXT	SEU_TEXT	CHAR	75	0	Text/icon/symbol
39	TLENGTH3	☐	SEU_NODELN	NUM2	NUMC	2	0	Output length of a hierarchy node
40	TCOLOR3	☐	SEU_COLOR	NUM1	NUMC	1	0	Color display of a hierarchy node
41	TINTENSIV3	☐	SEU_INTENS	CHAR1	CHAR	1	0	Intensity of display
42	TPOS3	☐	SEU_POS	CHAR3	CHAR	3	0	Hierarchy display: Column position of a text
43	KIND3	☐	SEU_KIND	CHAR1	CHAR	1	0	Text type (Space = Text, 'I' = 'Icon', 'S' = Symbol)
44	TEXT4	☐	SEU_TEXT	SEU_TEXT	CHAR	75	0	Text/icon/symbol
45	TLENGTH4	☐	SEU_NODELN	NUM2	NUMC	2	0	Output length of a hierarchy node
46	TCOLOR4	☐	SEU_COLOR	NUM1	NUMC	1	0	Color display of a hierarchy node
47	TINTENSIV4	☐	SEU_INTENS	CHAR1	CHAR	1	0	Intensity of display
48	TPOS4	☐	SEU_POS	CHAR3	CHAR	3	0	Hierarchy display: Column position of a text
49	KIND4	☐	SEU_KIND	CHAR1	CHAR	1	0	Text type (Space = Text, 'I' = 'Icon', 'S' = Symbol)
50	TEXT5	☐	SEU_TEXT	SEU_TEXT	CHAR	75	0	Text/icon/symbol
51	TLENGTH5	☐	SEU_NODELN	NUM2	NUMC	2	0	Output length of a hierarchy node
52	TCOLOR5	☐	SEU_COLOR	NUM1	NUMC	1	0	Color display of a hierarchy node
53	TINTENSIV5	☐	SEU_INTENS	CHAR1	CHAR	1	0	Intensity of display
54	TPOS5	☐	SEU_POS	CHAR3	CHAR	3	0	Hierarchy display: Column position of a text
55	KIND5	☐	SEU_KIND	CHAR1	CHAR	1	0	Text type (Space = Text, 'I' = 'Icon', 'S' = Symbol)
56	TEXT6	☐	SEU_TEXT	SEU_TEXT	CHAR	75	0	Text/icon/symbol
57	TLENGTH6	☐	SEU_NODELN	NUM2	NUMC	2	0	Output length of a hierarchy node
58	TCOLOR6	☐	SEU_COLOR	NUM1	NUMC	1	0	Color display of a hierarchy node
59	TINTENSIV6	☐	SEU_INTENS	CHAR1	CHAR	1	0	Intensity of display
60	TPOS6	☐	SEU_POS	CHAR3	CHAR	3	0	Hierarchy display: Column position of a text
61	KIND6	☐	SEU_KIND	CHAR1	CHAR	1	0	Text type (Space = Text, 'I' = 'Icon', 'S' = Symbol)
62	TEXT7	☐	SEU_TEXT	SEU_TEXT	CHAR	75	0	Text/icon/symbol
63	TLENGTH7	☐	SEU_NODELN	NUM2	NUMC	2	0	Output length of a hierarchy node
64	TCOLOR7	☐	SEU_COLOR	NUM1	NUMC	1	0	Color display of a hierarchy node
65	TINTENSIV7	☐	SEU_INTENS	CHAR1	CHAR	1	0	Intensity of display
66	TPOS7	☐	SEU_POS	CHAR3	CHAR	3	0	Hierarchy display: Column position of a text
67	KIND7	☐	SEU_KIND	CHAR1	CHAR	1	0	Text type (Space = Text, 'I' = 'Icon', 'S' = Symbol)
68	TEXT8	☐	SEU_TEXT	SEU_TEXT	CHAR	75	0	Text/icon/symbol
69	TLENGTH8	☐	SEU_NODELN	NUM2	NUMC	2	0	Output length of a hierarchy node
70	TCOLOR8	☐	SEU_COLOR	NUM1	NUMC	1	0	Color display of a hierarchy node
71	TINTENSIV8	☐	SEU_INTENS	CHAR1	CHAR	1	0	Intensity of display
72	TPOS8	☐	SEU_POS	CHAR3	CHAR	3	0	Hierarchy display: Column position of a text
73	KIND8	☐	SEU_KIND	CHAR1	CHAR	1	0	Text type (Space = Text, 'I' = 'Icon', 'S' = Symbol)
74	TEXT9	☐	SEU_TEXT	SEU_TEXT	CHAR	75	0	Text/icon/symbol
75	TLENGTH9	☐	SEU_NODELN	NUM2	NUMC	2	0	Output length of a hierarchy node
76	TCOLOR9	☐	SEU_COLOR	NUM1	NUMC	1	0	Color display of a hierarchy node
77	TINTENSIV9	☐	SEU_INTENS	CHAR1	CHAR	1	0	Intensity of display
78	TPOS9	☐	SEU_POS	CHAR3	CHAR	3	0	Hierarchy display: Column position of a text
79	KIND9	☐	SEU_KIND	CHAR1	CHAR	1	0	Text type (Space = Text, 'I' = 'Icon', 'S' = Symbol)
80	HIDE	☐	SEU_HIDE	SEU_TEXT	CHAR	75	0	Hide area of a hierarchy node
81	FORCE_PLUS	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
82	HOTSPOT	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
83	HOTSPOT1	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
84	HOTSPOT2	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
85	HOTSPOT3	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
86	HOTSPOT4	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
87	HOTSPOT5	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
88	HOTSPOT6	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
89	HOTSPOT7	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
90	HOTSPOT8	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
91	HOTSPOT9	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
92	INPUT	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
93	INPUT1	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
94	INPUT2	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
95	INPUT3	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
96	INPUT4	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
97	INPUT5	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
98	INPUT6	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
99	INPUT7	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
100	INPUT8	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
101	INPUT9	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
102	NODISPLAY	☐	NODISPLAY	CHAR1_X	CHAR	1	0	Flag: Nodes not displayed
103	MOREINFO	☐	MOREINFO	CHAR1_X	CHAR	1	0	Flage: Additional information about nodes exists
104	.INCLUDE	☐				0	0	Node Attributes for Tree Control
105	PROPFAW0	☐	PROPFAW	CHAR1_X	CHAR	1	0	Flag: Proportional font and automatic item width
106	PROPFAW	☐	PROPFAW	CHAR1_X	CHAR	1	0	Flag: Proportional font and automatic item width
107	PROPFAW1	☐	PROPFAW	CHAR1_X	CHAR	1	0	Flag: Proportional font and automatic item width
108	PROPFAW2	☐	PROPFAW	CHAR1_X	CHAR	1	0	Flag: Proportional font and automatic item width
109	PROPFAW3	☐	PROPFAW	CHAR1_X	CHAR	1	0	Flag: Proportional font and automatic item width
110	PROPFAW4	☐	PROPFAW	CHAR1_X	CHAR	1	0	Flag: Proportional font and automatic item width
111	PROPFAW5	☐	PROPFAW	CHAR1_X	CHAR	1	0	Flag: Proportional font and automatic item width
112	PROPFAW6	☐	PROPFAW	CHAR1_X	CHAR	1	0	Flag: Proportional font and automatic item width
113	PROPFAW7	☐	PROPFAW	CHAR1_X	CHAR	1	0	Flag: Proportional font and automatic item width
114	PROPFAW8	☐	PROPFAW	CHAR1_X	CHAR	1	0	Flag: Proportional font and automatic item width
115	PROPFAW9	☐	PROPFAW	CHAR1_X	CHAR	1	0	Flag: Proportional font and automatic item width
116	STYLE0	☐	CTLSTYLE	NUMC2	NUMC	2	0	Tree control style
117	STYLE	☐	CTLSTYLE	NUMC2	NUMC	2	0	Tree control style
118	STYLE1	☐	CTLSTYLE	NUMC2	NUMC	2	0	Tree control style
119	STYLE2	☐	CTLSTYLE	NUMC2	NUMC	2	0	Tree control style
120	STYLE3	☐	CTLSTYLE	NUMC2	NUMC	2	0	Tree control style
121	STYLE4	☐	CTLSTYLE	NUMC2	NUMC	2	0	Tree control style
122	STYLE5	☐	CTLSTYLE	NUMC2	NUMC	2	0	Tree control style
123	STYLE6	☐	CTLSTYLE	NUMC2	NUMC	2	0	Tree control style
124	STYLE7	☐	CTLSTYLE	NUMC2	NUMC	2	0	Tree control style
125	STYLE8	☐	CTLSTYLE	NUMC2	NUMC	2	0	Tree control style
126	STYLE9	☐	CTLSTYLE	NUMC2	NUMC	2	0	Tree control style
127	NODEICON	☐	TV_IMAGE	TV_IMAGE	CHAR	46	0	Tree Control: Icon / Image
128	LASTHTEXT	☐			CHAR	5	0

History

Last changed by/on	SAP	20130604
SAP Release Created in	50A