SAP ABAP Table DB6_VIEW_TIME_SPENT_DETAIL (Type for VIEW_DATA of CL_DB6_ACTION_TIME_SPENT2_D)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB6 (Application Component) DB2 Universal Database for UNIX / NT
     ⤷ STU6 (Package) DB6: Performance-Monitor (UNIX/Windows)

Basic Data

Table Category	INTTAB	Structure
Structure	DB6_VIEW_TIME_SPENT_DETAIL	Table Relationship Diagram
Short Description	Type for VIEW_DATA of CL_DB6_ACTION_TIME_SPENT2_D

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	SUMMARY	☐	DB6MON_TIMESPENT		STRU	0	0
2	SNAPSHOT_TIMESTAMP	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
3	TIME_PERIOD	☐			INT4	10	0
4	MEMBER	☐			INT4	10	0
5	SERVICE_SUPERCLASS_NAME	☐			CHAR	128	0
6	SERVICE_SUBCLASS_NAME	☐			CHAR	128	0
7	METRIC_NAME	☐			CHAR	128	0
8	PARENT_METRIC_NAME	☐			CHAR	128	0
9	PROC_TIME	☐			DEC	22	0
10	ELAPSED_TIME	☐			DEC	22	0
11	COUNT	☐			DEC	22	0
12	VOLUME	☐			DEC	22	0
13	HAS_VOLUME	☐			CHAR	1	0
14	PROC_TIME_AVG	☐			DEC	22	0
15	LEVEL_FROM	☐			INT2	5	0
16	LEVEL_TO	☐			INT2	5	0
17	METRIC_TYPE	☐			CHAR	1	0
18	INTVAL_ORDER	☐			INT4	10	0
19	TOTAL_ORDER	☐			INT4	10	0
20	INTVAL_PERCENTAGE	☐			DEC	4	1
21	TOTAL_PERCENTAGE	☐			DEC	4	1
22	WSCAVG_SERVICE_SUPERCLASS_NAME	☐			CHAR	128	0
23	WSCAVG_SERVICE_SUBCLASS_NAME	☐			CHAR	128	0
24	WSCAVG_PROC_TIME	☐			DEC	22	0
25	WSCAVG_ELAPSED_TIME	☐			DEC	22	0
26	WSCAVG_COUNT	☐			DEC	22	0
27	WSCAVG_VOLUME	☐			DEC	22	0
28	WSCAVG_PROC_TIME_AVG	☐			DEC	22	0
29	WMBAVG_MEMBER	☐			INT4	10	0
30	WMBAVG_PROC_TIME	☐			DEC	22	0
31	WMBAVG_ELAPSED_TIME	☐			DEC	22	0
32	WMBAVG_COUNT	☐			DEC	22	0
33	WMBAVG_VOLUME	☐			DEC	22	0
34	WMBAVG_PROC_TIME_AVG	☐			DEC	22	0
35	WSCTOT_SERVICE_SUPERCLASS_NAME	☐			CHAR	128	0
36	WSCTOT_SERVICE_SUBCLASS_NAME	☐			CHAR	128	0
37	WSCTOT_PROC_TIME	☐			DEC	22	0
38	WSCTOT_ELAPSED_TIME	☐			DEC	22	0
39	WSCTOT_COUNT	☐			DEC	22	0
40	WSCTOT_VOLUME	☐			DEC	22	0
41	WSCTOT_PROC_TIME_AVG	☐			DEC	22	0
42	WSCTOT_NOMINAL_PROC_TIME	☐			DEC	22	0
43	WMBTOT_MEMBER	☐			INT4	10	0
44	WMBTOT_PROC_TIME	☐			DEC	22	0
45	WMBTOT_ELAPSED_TIME	☐			DEC	22	0
46	WMBTOT_COUNT	☐			DEC	22	0
47	WMBTOT_VOLUME	☐			DEC	22	0
48	WMBTOT_PROC_TIME_AVG	☐			DEC	22	0
49	WMBTOT_NOMINAL_PROC_TIME	☐			DEC	22	0
50	WSCVOL_SERVICE_SUPERCLASS_NAME	☐			CHAR	128	0
51	WSCVOL_SERVICE_SUBCLASS_NAME	☐			CHAR	128	0
52	WSCVOL_PROC_TIME	☐			DEC	22	0
53	WSCVOL_ELAPSED_TIME	☐			DEC	22	0
54	WSCVOL_COUNT	☐			DEC	22	0
55	WSCVOL_VOLUME	☐			DEC	22	0
56	WSCVOL_PROC_TIME_AVG	☐			DEC	22	0
57	WSCVOL_NOMINAL_VOLUME	☐			DEC	22	0
58	WMBVOL_MEMBER	☐			INT4	10	0
59	WMBVOL_PROC_TIME	☐			DEC	22	0
60	WMBVOL_ELAPSED_TIME	☐			DEC	22	0
61	WMBVOL_COUNT	☐			DEC	22	0
62	WMBVOL_VOLUME	☐			DEC	22	0
63	WMBVOL_PROC_TIME_AVG	☐			DEC	22	0
64	WMBVOL_NOMINAL_VOLUME	☐			DEC	22	0
65	SERIES_LABEL	☐			STRG	0	0
66	TIMESTAMP_FROM	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
67	TIME_FMT_FROM	☐			STRG	0	0
68	TIME_FMT_TO	☐			STRG	0	0
69	DBH_COLLECT_MODE	☐			CHAR	1	0
70	REAL_HOST_NAME	☐			CHAR	60	0
71	KEEP_IN_TOP_N	☐			CHAR	1	0
72	INTERVAL	☐	DB6MON_TIMESPENT		STRU	0	0
73	SNAPSHOT_TIMESTAMP	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
74	TIME_PERIOD	☐			INT4	10	0
75	MEMBER	☐			INT4	10	0
76	SERVICE_SUPERCLASS_NAME	☐			CHAR	128	0
77	SERVICE_SUBCLASS_NAME	☐			CHAR	128	0
78	METRIC_NAME	☐			CHAR	128	0
79	PARENT_METRIC_NAME	☐			CHAR	128	0
80	PROC_TIME	☐			DEC	22	0
81	ELAPSED_TIME	☐			DEC	22	0
82	COUNT	☐			DEC	22	0
83	VOLUME	☐			DEC	22	0
84	HAS_VOLUME	☐			CHAR	1	0
85	PROC_TIME_AVG	☐			DEC	22	0
86	LEVEL_FROM	☐			INT2	5	0
87	LEVEL_TO	☐			INT2	5	0
88	METRIC_TYPE	☐			CHAR	1	0
89	INTVAL_ORDER	☐			INT4	10	0
90	TOTAL_ORDER	☐			INT4	10	0
91	INTVAL_PERCENTAGE	☐			DEC	4	1
92	TOTAL_PERCENTAGE	☐			DEC	4	1
93	WSCAVG_SERVICE_SUPERCLASS_NAME	☐			CHAR	128	0
94	WSCAVG_SERVICE_SUBCLASS_NAME	☐			CHAR	128	0
95	WSCAVG_PROC_TIME	☐			DEC	22	0
96	WSCAVG_ELAPSED_TIME	☐			DEC	22	0
97	WSCAVG_COUNT	☐			DEC	22	0
98	WSCAVG_VOLUME	☐			DEC	22	0
99	WSCAVG_PROC_TIME_AVG	☐			DEC	22	0
100	WMBAVG_MEMBER	☐			INT4	10	0
101	WMBAVG_PROC_TIME	☐			DEC	22	0
102	WMBAVG_ELAPSED_TIME	☐			DEC	22	0
103	WMBAVG_COUNT	☐			DEC	22	0
104	WMBAVG_VOLUME	☐			DEC	22	0
105	WMBAVG_PROC_TIME_AVG	☐			DEC	22	0
106	WSCTOT_SERVICE_SUPERCLASS_NAME	☐			CHAR	128	0
107	WSCTOT_SERVICE_SUBCLASS_NAME	☐			CHAR	128	0
108	WSCTOT_PROC_TIME	☐			DEC	22	0
109	WSCTOT_ELAPSED_TIME	☐			DEC	22	0
110	WSCTOT_COUNT	☐			DEC	22	0
111	WSCTOT_VOLUME	☐			DEC	22	0
112	WSCTOT_PROC_TIME_AVG	☐			DEC	22	0
113	WSCTOT_NOMINAL_PROC_TIME	☐			DEC	22	0
114	WMBTOT_MEMBER	☐			INT4	10	0
115	WMBTOT_PROC_TIME	☐			DEC	22	0
116	WMBTOT_ELAPSED_TIME	☐			DEC	22	0
117	WMBTOT_COUNT	☐			DEC	22	0
118	WMBTOT_VOLUME	☐			DEC	22	0
119	WMBTOT_PROC_TIME_AVG	☐			DEC	22	0
120	WMBTOT_NOMINAL_PROC_TIME	☐			DEC	22	0
121	WSCVOL_SERVICE_SUPERCLASS_NAME	☐			CHAR	128	0
122	WSCVOL_SERVICE_SUBCLASS_NAME	☐			CHAR	128	0
123	WSCVOL_PROC_TIME	☐			DEC	22	0
124	WSCVOL_ELAPSED_TIME	☐			DEC	22	0
125	WSCVOL_COUNT	☐			DEC	22	0
126	WSCVOL_VOLUME	☐			DEC	22	0
127	WSCVOL_PROC_TIME_AVG	☐			DEC	22	0
128	WSCVOL_NOMINAL_VOLUME	☐			DEC	22	0
129	WMBVOL_MEMBER	☐			INT4	10	0
130	WMBVOL_PROC_TIME	☐			DEC	22	0
131	WMBVOL_ELAPSED_TIME	☐			DEC	22	0
132	WMBVOL_COUNT	☐			DEC	22	0
133	WMBVOL_VOLUME	☐			DEC	22	0
134	WMBVOL_PROC_TIME_AVG	☐			DEC	22	0
135	WMBVOL_NOMINAL_VOLUME	☐			DEC	22	0
136	SERIES_LABEL	☐			STRG	0	0
137	TIMESTAMP_FROM	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
138	TIME_FMT_FROM	☐			STRG	0	0
139	TIME_FMT_TO	☐			STRG	0	0
140	DBH_COLLECT_MODE	☐			CHAR	1	0
141	REAL_HOST_NAME	☐			CHAR	60	0
142	KEEP_IN_TOP_N	☐			CHAR	1	0
143	VAR_OUTPUT	☐	DB6_VAR_LABEL_OUTPUT		STRU	0	0
144	TOTAL_PERCENTAGE	☐			DEC	4	1
145	LABEL_TOTAL_PERCENTAGE	☐			STRG	0	0
146	PROC_TIME	☐			DEC	22	0
147	LABEL_PROC_TIME	☐			STRG	0	0
148	WSCTOT_NOMINAL_PROC_TIME	☐			DEC	22	0
149	LABEL_WSCTOT_NOMINAL_PROC_TIME	☐			STRG	0	0
150	WMBTOT_NOMINAL_PROC_TIME	☐			DEC	22	0
151	LABEL_WMBTOT_NOMINAL_PROC_TIME	☐			STRG	0	0
152	COUNT	☐			DEC	22	0
153	LABEL_COUNT	☐			STRG	0	0
154	PROC_TIME_AVG	☐			DEC	22	0
155	LABEL_PROC_TIME_AVG	☐			STRG	0	0
156	ITVL_TOTAL_PERCENTAGE	☐			DEC	4	1
157	ITVL_LABEL_TOTAL_PERCENTAGE	☐			STRG	0	0
158	ITVL_PROC_TIME	☐			DEC	22	0
159	ITVL_LABEL_PROC_TIME	☐			STRG	0	0
160	ITVL_COUNT	☐			DEC	22	0
161	ITVL_LABEL_COUNT	☐			STRG	0	0
162	ITVL_PROC_TIME_AVG	☐			DEC	22	0
163	ITVL_LABEL_PROC_TIME_AVG	☐			STRG	0	0
164	TIME_FRAME_TITLE	☐			STRG	0	0
165	TIME_INTERVAL_TITLE	☐			STRG	0	0
166	COMPCTRL_ATTRIB	☐	DB6_TIME_SPENT_COMPCTRL		STRU	0	0
167	ADHOC_MODE	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
168	ADHOC_RUNNING	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
169	CURR_DISPLAY_TOP_N_ONLY	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
170	CURR_DRILLDOWN_SELECTION	☐			STRG	0	0
171	CURR_MEMBER_SELECTION	☐	DB6_WD_MEMBER_SELECTION		STRU	0	0
172	SELECTED_MEMBER	☐			INT4	10	0
173	MULTI_SELECTION	☐	DB6_WD_MEMBER_LIST		TTYP	0	0
174	SELECTED_GROUP	☐			STRG	0	0
175	CURR_METRIC_DETAIL_LEVEL	☐			INT4	10	0
176	CURR_METRIC_SELECTION	☐	DB6_WD_METRIC_SELECTION		STRU	0	0
177	SELECTED_METRIC	☐			STRG	0	0
178	MULTI_SELECTION	☐	DB6_WD_METRIC_TAB		TTYP	0	0
179	CURR_SC_SELECTION	☐	DB6_WD_SC_SELECTION		STRU	0	0
180	SELECTED_SC_NAME	☐			CHAR	128	0
181	SELECTED_PAR_SC_NAME	☐			CHAR	128	0
182	MULTI_SELECTION	☐	DB6_WD_SC_LIST		TTYP	0	0
183	CURR_TIMEFRAME_SELECTION	☐	DBA_WD_TIMESLIDER		STRU	0	0
184	FROM_DATE	☐	SYDATUM	SYDATS	DATS	8	0	System Date
185	FROM_TIME	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
186	TO_DATE	☐	SYDATUM	SYDATS	DATS	8	0	System Date
187	TO_TIME	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
188	TIME_FRAME	☐	DBA_LISTBOX_VALUE	DBA_LISTBOX_VALUE	CHAR	40	0	DBA Cockpit: Listbox Value
189	RANGETYPE	☐			INT4	10	0
190	TIME_ZONE	☐			STRG	0	0
191	GRANULARITY	☐			INT4	10	0
192	TIME_RANGE_READONLY	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
193	TIME_RANGE_HIDDEN	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
194	TIME_RANGE_DESCR	☐			STRG	0	0
195	CONFIRM_ENABLED	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
196	GRANULARITY_ENABLED	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
197	AGGREGATE	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
198	DBH_COLLECTOR_SET_UP	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
199	DRILLDOWN_SELECTION_CHANGED	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
200	LAST_DRILLDOWN_SELECTION	☐			STRG	0	0
201	PERCENTAGE_THRESHOLD	☐			FLTP	16	16
202	TIME_DIVISOR	☐			INT4	10	0
203	TIME_UNIT	☐			STRG	0	0
204	TIME_UNIT_AVG	☐			STRG	0	0
205	TOP_N_COUNT	☐			INT4	10	0
206	VOLUME_DIVISOR	☐			INT4	10	0
207	VOLUME_UNIT	☐			STRG	0	0
208	WLM_EVMON	☐	CL_DB6_WLM_EVMONS		REF	0	0
209	WLM_STATS_COLLECTOR	☐	CL_DB6_DBH_WLM_STATISTICS		REF	0	0
210	SEL_METRIC_NAME	☐			STRG	0	0
211	LABEL_WSCAVG_SUB_UNDER_SUPER	☐			STRG	0	0
212	LABEL_WSCAVG_SUB_UNDER_SUPER2	☐			STRG	0	0
213	LABEL_WSC_SUB_UNDER_SUPER	☐			STRG	0	0
214	LABEL_WMBTOT_MEMBER	☐			STRG	0	0
215	LABEL_WMBAVG_MEMBER	☐			STRG	0	0
216	LABEL_WMBAVG_MEMBER2	☐			STRG	0	0
217	SEL_OBJECT	☐	DB6MON_TIMESPENT		STRU	0	0
218	SNAPSHOT_TIMESTAMP	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
219	TIME_PERIOD	☐			INT4	10	0
220	MEMBER	☐			INT4	10	0
221	SERVICE_SUPERCLASS_NAME	☐			CHAR	128	0
222	SERVICE_SUBCLASS_NAME	☐			CHAR	128	0
223	METRIC_NAME	☐			CHAR	128	0
224	PARENT_METRIC_NAME	☐			CHAR	128	0
225	PROC_TIME	☐			DEC	22	0
226	ELAPSED_TIME	☐			DEC	22	0
227	COUNT	☐			DEC	22	0
228	VOLUME	☐			DEC	22	0
229	HAS_VOLUME	☐			CHAR	1	0
230	PROC_TIME_AVG	☐			DEC	22	0
231	LEVEL_FROM	☐			INT2	5	0
232	LEVEL_TO	☐			INT2	5	0
233	METRIC_TYPE	☐			CHAR	1	0
234	INTVAL_ORDER	☐			INT4	10	0
235	TOTAL_ORDER	☐			INT4	10	0
236	INTVAL_PERCENTAGE	☐			DEC	4	1
237	TOTAL_PERCENTAGE	☐			DEC	4	1
238	WSCAVG_SERVICE_SUPERCLASS_NAME	☐			CHAR	128	0
239	WSCAVG_SERVICE_SUBCLASS_NAME	☐			CHAR	128	0
240	WSCAVG_PROC_TIME	☐			DEC	22	0
241	WSCAVG_ELAPSED_TIME	☐			DEC	22	0
242	WSCAVG_COUNT	☐			DEC	22	0
243	WSCAVG_VOLUME	☐			DEC	22	0
244	WSCAVG_PROC_TIME_AVG	☐			DEC	22	0
245	WMBAVG_MEMBER	☐			INT4	10	0
246	WMBAVG_PROC_TIME	☐			DEC	22	0
247	WMBAVG_ELAPSED_TIME	☐			DEC	22	0
248	WMBAVG_COUNT	☐			DEC	22	0
249	WMBAVG_VOLUME	☐			DEC	22	0
250	WMBAVG_PROC_TIME_AVG	☐			DEC	22	0
251	WSCTOT_SERVICE_SUPERCLASS_NAME	☐			CHAR	128	0
252	WSCTOT_SERVICE_SUBCLASS_NAME	☐			CHAR	128	0
253	WSCTOT_PROC_TIME	☐			DEC	22	0
254	WSCTOT_ELAPSED_TIME	☐			DEC	22	0
255	WSCTOT_COUNT	☐			DEC	22	0
256	WSCTOT_VOLUME	☐			DEC	22	0
257	WSCTOT_PROC_TIME_AVG	☐			DEC	22	0
258	WSCTOT_NOMINAL_PROC_TIME	☐			DEC	22	0
259	WMBTOT_MEMBER	☐			INT4	10	0
260	WMBTOT_PROC_TIME	☐			DEC	22	0
261	WMBTOT_ELAPSED_TIME	☐			DEC	22	0
262	WMBTOT_COUNT	☐			DEC	22	0
263	WMBTOT_VOLUME	☐			DEC	22	0
264	WMBTOT_PROC_TIME_AVG	☐			DEC	22	0
265	WMBTOT_NOMINAL_PROC_TIME	☐			DEC	22	0
266	WSCVOL_SERVICE_SUPERCLASS_NAME	☐			CHAR	128	0
267	WSCVOL_SERVICE_SUBCLASS_NAME	☐			CHAR	128	0
268	WSCVOL_PROC_TIME	☐			DEC	22	0
269	WSCVOL_ELAPSED_TIME	☐			DEC	22	0
270	WSCVOL_COUNT	☐			DEC	22	0
271	WSCVOL_VOLUME	☐			DEC	22	0
272	WSCVOL_PROC_TIME_AVG	☐			DEC	22	0
273	WSCVOL_NOMINAL_VOLUME	☐			DEC	22	0
274	WMBVOL_MEMBER	☐			INT4	10	0
275	WMBVOL_PROC_TIME	☐			DEC	22	0
276	WMBVOL_ELAPSED_TIME	☐			DEC	22	0
277	WMBVOL_COUNT	☐			DEC	22	0
278	WMBVOL_VOLUME	☐			DEC	22	0
279	WMBVOL_PROC_TIME_AVG	☐			DEC	22	0
280	WMBVOL_NOMINAL_VOLUME	☐			DEC	22	0
281	SERIES_LABEL	☐			STRG	0	0
282	TIMESTAMP_FROM	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
283	TIME_FMT_FROM	☐			STRG	0	0
284	TIME_FMT_TO	☐			STRG	0	0
285	DBH_COLLECT_MODE	☐			CHAR	1	0
286	REAL_HOST_NAME	☐			CHAR	60	0
287	KEEP_IN_TOP_N	☐			CHAR	1	0
288	SHOW_VOLUMES	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
289	LABEL_SEL_METRIC	☐			STRG	0	0

History

Last changed by/on	SAP	20141013
SAP Release Created in	740