SAP ABAP Table WLBWEXPQRY (BW Workload: Reporting - InfoCube Level (Detailed Display))

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-MON (Application Component) Monitoring
     ⤷ SAPWL_FRONTEND (Package) SAP: Workload Display, Enjoy & OO Version - ST03N

Basic Data

Table Category	INTTAB	Structure
Structure	WLBWEXPQRY	Table Relationship Diagram
Short Description	BW Workload: Reporting - InfoCube Level (Detailed Display)

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	TEMPLATE	☐	WLBWTEMPL	WLBWCHAR40	CHAR	40	0	Description of Web Template or Workbook
2	INFOCUBE	☐	WLBWINFOCB	RSINFOCUBE	CHAR	30	0	InfoCube Name
3	IPROVTYPE	☐	WLBWIPTYPE	WLBWCHAR5	CHAR	5	0	BI Workload: InfoProvider Type
4	QUERYID	☐	WLBWQRYID	RSINFOCUBE	CHAR	30	0	Name of Query
5	NAVSTEP	☐	WLBWNAVSTP	WLBWDEC15	DEC	15	0	Number of Navigation Steps
6	TIMETOTAL	☐	WLBWTIMTOT	WLBWTIME15	DEC	15	1	Total Runtime (s)
7	AVTOTNAVST	☐	WLBWAVTOTS	WLBWTIME15	DEC	15	1	Average Total Runtime per Navigation Step (s)
8	MEDTOTAL	☐	WLBWMETOTS	WLBWTIME15	DEC	15	1	Median of Total Runtime (s)
9	TIMEOLAP	☐	WLBWTIMOL	WLBWTIME15	DEC	15	1	OLAP Runtime (s)
10	PCTTIMOLAP	☐	WLBWPTIMOL	WLBWPCENT1	DEC	5	2	Share of Total Runtime that is OLAP Runtime (%)
11	AVOLPNAVST	☐	WLBWAVOLPS	WLBWTIME15	DEC	15	1	Average OLAP Runtime per Navigation Step (s)
12	TIMEDB	☐	WLBWTIMDB	WLBWTIME15	DEC	15	1	Database Runtime (s)
13	PCTTIMEDB	☐	WLBWPTIMDB	WLBWPCENT1	DEC	5	2	Share of Total Runtime that is Database Runtime (%)
14	AVDBNAVST	☐	WLBWAVDBS	WLBWTIME15	DEC	15	1	Average Database Runtime per Navigation Step (s)
15	TIMECLIENT	☐	WLBWTIMCL	WLBWTIME15	DEC	15	1	Frontend Runtime (s)
16	PCTTIMECLI	☐	WLBWPTIMCL	WLBWPCENT1	DEC	5	2	Share of Total Runtime that is Frontend Runtime (%)
17	AVCLINAVST	☐	WLBWAVCLIS	WLBWTIME15	DEC	15	1	Average Frontend Runtime per Navigation Step (s)
18	TIMEPLAN	☐	WLBWTIMPLN	WLBWTIME15	DEC	15	1	Runtime of the Planning Function (s)
19	PCTTIMPLAN	☐	WLBWPTIMPL	WLBWPCENT1	DEC	5	2	Proportion of Total Runtime for Planning Functions (%)
20	AVPLNNAVST	☐	WLBWAVPLN	WLBWTIME15	DEC	15	1	Average Planning Runtime per Navigation Step (s)
21	TIME_NA	☐	WLBWTIMNA	WLBWTIME15	DEC	15	1	Unassigned Runtime (s)
22	PCTTIMNA	☐	WLBWPTIMNA	WLBWPCENT1	DEC	5	2	Proportion of Total Runtime that is Unassigned Time (%)
23	AVNANAVST	☐	WLBWAVNA	WLBWTIME15	DEC	15	1	Average Unassigned Time per Navigation Step (s)
24	DBSEL	☐	WLBWDBSEL	WLBWDEC15	DEC	15	0	Number of records selected
25	DBTRANS	☐	WLBWDBTRNS	WLBWDEC15	DEC	15	0	Number of Transferred Records
26	DBTRANSSEL	☐	WLBWTRSEL	WLBWRATIO1	DEC	15	1	Ratio of Selected to Transferred Records
27	DBTIMSEL	☐	WLBWDBTSEL	WLBWRATIO1	DEC	15	1	Database Runtime per Selected Record (ms)
28	DISPLEVEL1	☐	WLBWDSPLVL	WLBWINT4	INT4	10	0	Display level
29	DISPLEVEL2	☐	WLBWDSPLVL	WLBWINT4	INT4	10	0	Display level
30	OLAPCACHE	☐	WLBWCACHE	WLBWCHAR5	CHAR	5	0	Usage of OLAP Cache
31	LINECOLOR	☐	WLBILINECOL		CHAR	4	0	BI Workload: Color Specification

History

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