SAP ABAP Table WLBWEXPREP (BW Workload: All Data)

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	WLBWEXPREP	Table Relationship Diagram
Short Description	BW Workload: All Data

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	INFOCUBE	☐	WLBWINFOCB	RSINFOCUBE	CHAR	30	0	InfoCube Name
2	IPROVTYPE	☐	WLBWIPTYPE	WLBWCHAR5	CHAR	5	0	BI Workload: InfoProvider Type
3	QUERYID	☐	WLBWQRYID	RSINFOCUBE	CHAR	30	0	Name of Query
4	TEMPLATE	☐	WLBWTEMPL	WLBWCHAR40	CHAR	40	0	Description of Web Template or Workbook
5	NRQUERY	☐	WLBWQRYNR	WLBWDEC15	DEC	15	0	Number of Queries
6	NAVSTEP	☐	WLBWNAVSTP	WLBWDEC15	DEC	15	0	Number of Navigation Steps
7	NRSESSIONS	☐	WLBWSESSNR	WLBWDEC15	DEC	15	0	Number of Web Template Sessions
8	TIMEOLAPIN	☐	WLBWTIMOLI	WLBWTIME15	DEC	15	1	Initialization Time (s)
9	PCTTIMOLIN	☐	WLBWPTIOLI	WLBWPCENT1	DEC	5	2	Share of Total Runtime that is Initialization Time (%)
10	AVOLPINNVS	☐	WLBWAVOLIN	WLBWTIME15	DEC	15	1	Average Initialization Time per Navigation Step (s)
11	MEDOLPINIT	☐	WLBWMEOLIN	WLBWTIME15	DEC	15	1	Median of OLAPINIT Runtime
12	TIMEOLAP	☐	WLBWTIMOL	WLBWTIME15	DEC	15	1	OLAP Runtime (s)
13	PCTTIMOLAP	☐	WLBWPTIMOL	WLBWPCENT1	DEC	5	2	Share of Total Runtime that is OLAP Runtime (%)
14	AVOLPNAVST	☐	WLBWAVOLPS	WLBWTIME15	DEC	15	1	Average OLAP Runtime per Navigation Step (s)
15	MEDOLAP	☐	WLBWMEOLPS	WLBWTIME15	DEC	15	1	Median of OLAP Runtime (s)
16	TIMEDB	☐	WLBWTIMDB	WLBWTIME15	DEC	15	1	Database Runtime (s)
17	PCTTIMEDB	☐	WLBWPTIMDB	WLBWPCENT1	DEC	5	2	Share of Total Runtime that is Database Runtime (%)
18	AVDBNAVST	☐	WLBWAVDBS	WLBWTIME15	DEC	15	1	Average Database Runtime per Navigation Step (s)
19	MEDDB	☐	WLBWMEDBS	WLBWTIME15	DEC	15	1	Media of DB Runtime (s)
20	TIMECLIENT	☐	WLBWTIMCL	WLBWTIME15	DEC	15	1	Frontend Runtime (s)
21	PCTTIMECLI	☐	WLBWPTIMCL	WLBWPCENT1	DEC	5	2	Share of Total Runtime that is Frontend Runtime (%)
22	AVCLINAVST	☐	WLBWAVCLIS	WLBWTIME15	DEC	15	1	Average Frontend Runtime per Navigation Step (s)
23	MEDCLIENT	☐	WLBWMECLIS	WLBWTIME15	DEC	15	1	Median of Frontend Runtime (s)
24	TIMEMSTDAT	☐	WLBWTIMMDT	WLBWTIME15	DEC	15	1	Master Data Runtime (s)
25	PCTTIMMSDA	☐	WLBWPTIMDT	WLBWPCENT1	DEC	5	2	Share of Total Runtime that is Master Data Runtime (%)
26	AVMDTNAVST	☐	WLBWAVMDT	WLBWTIME15	DEC	15	1	Average Master Data Runtime per Navigation Step (s)
27	MEDMASTDAT	☐	WLBWMEMDT	WLBWTIME15	DEC	15	1	Median of Master Data Runtime (s)
28	TIMEPLAN	☐	WLBWTIMPLN	WLBWTIME15	DEC	15	1	Runtime of the Planning Function (s)
29	PCTTIMPLAN	☐	WLBWPTIMPL	WLBWPCENT1	DEC	5	2	Proportion of Total Runtime for Planning Functions (%)
30	AVPLNNAVST	☐	WLBWAVPLN	WLBWTIME15	DEC	15	1	Average Planning Runtime per Navigation Step (s)
31	TIME_NA	☐	WLBWTIMNA	WLBWTIME15	DEC	15	1	Unassigned Runtime (s)
32	PCTTIMNA	☐	WLBWPTIMNA	WLBWPCENT1	DEC	5	2	Proportion of Total Runtime that is Unassigned Time (%)
33	AVNANAVST	☐	WLBWAVNA	WLBWTIME15	DEC	15	1	Average Unassigned Time per Navigation Step (s)
34	TIMETOTAL	☐	WLBWTIMTOT	WLBWTIME15	DEC	15	1	Total Runtime (s)
35	AVTOTNAVST	☐	WLBWAVTOTS	WLBWTIME15	DEC	15	1	Average Total Runtime per Navigation Step (s)
36	AVGTOTREQ	☐	WLBWAVTOTR	WLBWTIME15	DEC	15	1	Average Total Runtime per Request (s)
37	MEDTOTAL	☐	WLBWMETOTS	WLBWTIME15	DEC	15	1	Median of Total Runtime (s)
38	DBSEL	☐	WLBWDBSEL	WLBWDEC15	DEC	15	0	Number of records selected
39	DBTRANS	☐	WLBWDBTRNS	WLBWDEC15	DEC	15	0	Number of Transferred Records
40	DBTRANSSEL	☐	WLBWTRSEL	WLBWRATIO1	DEC	15	1	Ratio of Selected to Transferred Records
41	DBTIMSEL	☐	WLBWDBTSEL	WLBWRATIO1	DEC	15	1	Database Runtime per Selected Record (ms)
42	NUMCELLS	☐	WLBWNRCELL	WLBWDEC15	DEC	15	0	Number of Cells
43	NUMCELTRNS	☐	WLBWNRCLTR	WLBWRATIO1	DEC	15	1	Number of Cells per Number of Transferred Records
44	NUMRANGES	☐	WLBWNRRNG	WLBWDEC15	DEC	15	0	Number Formatted
45	NUMRANGCEL	☐	WLBWRNGCEL	WLBWRATIO1	DEC	15	1	Ratio of Formattings to Number of Cells
46	ODBOTOTAL	☐	WLBWODBTOT	WLBWTIME15	DEC	15	1	Total Runtime Using ODBO Interface
47	ODBOT	☐	WLBWODBT	WLBWTIME15	DEC	15	1	ODBO Time
48	ODBOTINIT	☐	WLBWODBTIN	WLBWTIME15	DEC	15	1	Initialization of the ODBO Interface
49	ODBOTPREPAXES	☐	WLBWODBPAX	WLBWTIME15	DEC	15	1	ODBO: Preparing the Axes
50	ODBONCALLS	☐	WLBWODBCAL	WLBWDEC15	DEC	15	0	Number of Calls of the ODBO Interface
51	WEBTTEMPPREP	☐	WLBWWEBPRP	WLBWTIME15	DEC	15	1	Time for Preparing WEB Templates
52	WEBTRENDER	☐	WLBWWEBRND	WLBWTIME15	DEC	15	1	Time for Rendering All Items
53	TIMEFRONTPROC	☐	WLBWFRNTPR	WLBWTIME15	DEC	15	1	Procssing Time in EXCEL Front End
54	DISPLEVEL1	☐	WLBWDSPLVL	WLBWINT4	INT4	10	0	Display level
55	DISPLEVEL2	☐	WLBWDSPLVL	WLBWINT4	INT4	10	0	Display level
56	AGGRLEVEL	☐	WLBWAGLVL	WLBWCHAR1	CHAR	10	0	Aggregation Level
57	QTIMECATEG	☐	WLBWRTCAT	WLBWDEC15	DEC	15	0	Validity Period Category
58	QNAVSTEP	☐	WLBWNAVSTP	WLBWDEC15	DEC	15	0	Number of Navigation Steps
59	QTIMETOTAL	☐	WLBWQTIMTL	WLBWTIME15	DEC	15	1	Total Query Runtime
60	EXPIMEMEAN	☐	WLBWQTIMEX	WLBWTIME15	DEC	15	1	Average Query Runtime (s)
61	QTIMEMEAN	☐	WLBWQTIMMN	WLBWRUNTIM	DEC	21	6	Average Query Runtime
62	COMPONENT	☐	WLBWCOMP	WLBWCHAR1	CHAR	10	0	Hitlist Component
63	FRONTEND	☐	WLBWFRONT	WLBWCHAR1	CHAR	10	0	Front End Type
64	OLAPCACHE	☐	WLBWCACHE	WLBWCHAR5	CHAR	5	0	Usage of OLAP Cache
65	STATLEVEL	☐	WLBWSTATLV	WLBWCHAR5	CHAR	5	0	Statistics Level: OLAP Statistics
66	BWSYSID	☐	WLBISYSID		CHAR	12	0	BI System Identifier
67	AGGRCUBE	☐	WLBWAGRCB	RSINFOCUBE	CHAR	30	0	Aggregate Name
68	NRAGGR	☐	WLBWNRAGR	WLBWDEC15	DEC	15	0	Number of Aggregates
69	AGGRTOTAL	☐	WLBWAGRTOT	WLBWCHAR1	CHAR	10	0	Indicator for Totalled Aggregates
70	CHANGEMODE	☐	WLBWMODE	WLBWFLAG	CHAR	1	0	Change Mode
71	TIMEROLL	☐	WLBWTIROL	WLBWTIME15	DEC	15	1	Rollup Time (s)
72	PCTTIROLL	☐	WLBWPCTRL	WLBWPCENT1	DEC	5	2	Share of Total Runtime that is Rollup Time (%)
73	AVGTIROLL	☐	WLBWAVGRL	WLBWTIME15	DEC	15	1	Average Rollup Time per Aggregate (s)
74	RECROLL	☐	WLBWRECRL	WLBWDEC15	DEC	15	0	Number of Added Records in Rollup
75	NRAGRROLL	☐	WLBWNRRL	WLBWDEC15	DEC	15	0	Number of Aggregates in Rollup
76	TIMENEW	☐	WLBWTINEW	WLBWTIME15	DEC	15	1	Rebuild Time (s)
77	PCTTINEW	☐	WLBWPCTNW	WLBWPCENT1	DEC	5	2	Share of Total Runtime that is Rebuild Time (%)
78	AVGTINEW	☐	WLBWAVGNW	WLBWTIME15	DEC	15	1	Average Rebuild Time per Aggregate (s)
79	RECNEW	☐	WLBWRECNW	WLBWDEC15	DEC	15	0	Number of Inserted Records in Rebuild
80	NRAGRNEW	☐	WLBWNRNW	WLBWDEC15	DEC	15	0	Number of Aggregates in Rebuild
81	TIMEDELTA	☐	WLBWTIDEL	WLBWTIME15	DEC	15	1	Delta Time (s)
82	PCTTIDELTA	☐	WLBWPCTDL	WLBWPCENT1	DEC	5	2	Share of Total Runtime that is Delta Time (%)
83	AVGTIDELTA	☐	WLBWAVGDL	WLBWTIME15	DEC	15	1	Average Delta Time per Aggregate (s)
84	RECDELTA	☐	WLBWRECDL	WLBWDEC15	DEC	15	0	Number of Added Records in Delta
85	NRAGRDELTA	☐	WLBWNRDL	WLBWDEC15	DEC	15	0	Number of Aggregates in Delta
86	AGRTIMTOT	☐	WLBWTIMTOT	WLBWTIME15	DEC	15	1	Total Runtime (s)
87	AGAVTIMTOT	☐	WLBWAGAVTO	WLBWTIME15	DEC	15	1	Average Total Runtime per Aggregate (s)
88	TIMEREAD	☐	WLBWTIMRD	WLBWTIME15	DEC	15	1	Read Time (s)
89	PCTTIMREAD	☐	WLBWPCTRD	WLBWPCENT1	DEC	5	2	Share of Total Runtime that is Read Time (%)
90	AVGTIMREAD	☐	WLBWAVTIRD	WLBWTIME15	DEC	15	1	Average Read Time per Aggregate (s)
91	TIMEINSERT	☐	WLBWTIMINS	WLBWTIME15	DEC	15	1	Add Time (s)
92	PCTTIMINST	☐	WLBWPCTINS	WLBWPCENT1	DEC	5	2	Share of Total Runtime that is Add Time (%)
93	AVGTIMINST	☐	WLBWAVTIIN	WLBWTIME15	DEC	15	1	Average Add Time per Aggregate (s)
94	TIMEINDEX	☐	WLBWTIMIND	WLBWTIME15	DEC	15	1	Index Time (s)
95	PCTTIMINDX	☐	WLBWPCTIDX	WLBWPCENT1	DEC	5	2	Share of Total Runtime that is Index Time (%)
96	AVGTIMINDX	☐	WLBWAVTIND	WLBWTIME15	DEC	15	1	Average Index Time per Aggregate (s)
97	TIMEDBANLY	☐	WLBWTIMDBY	WLBWTIME15	DEC	15	1	Analysis Time (s)
98	PCTTIMANLY	☐	WLBWPCTALY	WLBWPCENT1	DEC	5	2	Share of Total Runtime that is Analysis Time (%)
99	AVGTIMANLY	☐	WLBWAVTIAN	WLBWTIME15	DEC	15	1	Average Analysis Time per Aggregate (s)
100	TIMECONDNS	☐	WLBWTIMCND	WLBWTIME15	DEC	15	1	Aggregation Time (s)
101	PCTTIMCOND	☐	WLBWPCTCND	WLBWPCENT1	DEC	5	2	Share of Total Runtime that is Summarization Time (%)
102	AVGTIMCOND	☐	WLBWAVTICD	WLBWTIME15	DEC	15	1	Average Aggregation Time per Aggregate (s)
103	REC_READ	☐	WLBWRECRD	WLBWDEC15	DEC	15	0	Number of records read
104	AVGRECREAD	☐	WLBWAVRCRD	WLBWDEC15	DEC	15	0	Average Number of Read Records / Aggregate
105	AVGRDTIREC	☐	WLBWAVTIRC	WLBWTIME15	DEC	15	1	Average Read Time / Read Record (ms)
106	REC_INSERT	☐	WLBWRECINS	WLBWDEC15	DEC	15	0	Number of Inserted Records
107	AVGRECINS	☐	WLBWAVRINS	WLBWDEC15	DEC	15	0	Average Number of Records Added / Aggregate
108	AVGINSTIRC	☐	WLBWAVRCIN	WLBWTIME15	DEC	15	1	Average Add Time / Added Record (ms)
109	NRRECREINS	☐	WLBWREINS	WLBWRATIO1	DEC	15	1	Number of Read Records / Number of Added Records
110	STARTTIME	☐	TZNTSTMPL	TZNTSTMPL	DEC	21	7	UTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun)
111	CALDAY	☐	WLBICALDAY	DATS	DATS	8	0	BI Workload: Start Date
112	UTIME	☐	WLBIUTIME	UZEIT	TIMS	6	0	BI Workload: Start Time
113	UNAME	☐	WLBWNAME	WLBWCHR12	CHAR	12	0	User Name
114	STATUID	☐	WLBWUID25	WLBWID25	CHAR	25	0	UUID in Compressed Form
115	INFOSOURCE	☐	WLBWINFOSC	RSINFOCUBE	CHAR	30	0	Name of Infosource
116	NRISOURCES	☐	WLBWNRISRC	WLBWINT4	INT4	10	0	Number of Different InfoSources
117	TARGET	☐	WLBWTARGET	RSINFOCUBE	CHAR	30	0	Name of Upload Target Object
118	NRTARGETS	☐	WLBWNRTGT	WLBWINT4	INT4	10	0	Number of Different Target Objects
119	NRREQUESTS	☐	WLBWNRREQ	WLBWINT4	INT4	10	0	Number of Upload Requests
120	REQUESTID	☐	WLBWREQID	WLBWCHR12	CHAR	12	0	Request ID
121	ACTION	☐	WLBWUPLACT	WLBWNUMC3	NUMC	3	0	Upload Action Type
122	UPLD_PARAL	☐	WLBWPARFLG	WLBWCHAR3	CHAR	3	0	No. of Parallel Upload Processes to Different Target Objects
123	RECREADPH	☐	WLBWRCRDPH	WLBWDEC15	DEC	15	0	Total Number of Records Read per Hour
124	RECWRITPH	☐	WLBWRCWRPH	WLBWDEC15	DEC	15	0	Total Number of Records Written per Hour
125	TIMSOURCE	☐	WLBWTIMSRC	WLBWTIME15	DEC	15	1	Total Runtime in Source System (s)
126	TIMSOURC3	☐	WLBWTIME3	WLBWDEC21	DEC	21	3	Runtime (DEC 21.3)
127	PCTTIMSRC	☐	WLBWPTISRC	WLBWPCENT1	DEC	5	2	Share of Total Runtime that is Runtime in Source System (%)
128	AVGTIMSRC	☐	WLBWAVGSRC	WLBWTIME15	DEC	15	1	Average Runtime in Source System / Request (s)
129	NRRCRDSRC	☐	WLBWNRRDSC	WLBWDEC15	DEC	15	0	Number of Records Read in Source System
130	AVRCRDSRC	☐	WLBWAVRDSC	WLBWRATIO1	DEC	15	1	Average Number of Records Read in Source System / Request
131	NRCRDSCPH	☐	WLBWRCSCPH	WLBWDEC15	DEC	15	0	Number of Records Read in Source System per Hour
132	TIMRDSCMS	☐	WLBWTRSCMS	WLBWTIME15	DEC	15	1	Runtime for Reading a Record in Source System (ms)
133	TIMTRANSF	☐	WLBWTIMTRF	WLBWTIME15	DEC	15	1	Total Runtime for Transfer Rules (s)
134	TIMTRANS3	☐	WLBWTIME3	WLBWDEC21	DEC	21	3	Runtime (DEC 21.3)
135	PCTTIMTRF	☐	WLBWPTITRF	WLBWPCENT1	DEC	5	2	Share of Total Runtime that Is Transfer Runtime (%)
136	AVGTIMTRF	☐	WLBWAVGTRF	WLBWTIME15	DEC	15	1	Average Runtime of Transfer Rules (s)
137	NRRCRDTRF	☐	WLBWNRRDTF	WLBWDEC15	DEC	15	0	Number of Transferred Records
138	AVRCRDTRF	☐	WLBWAVRDTF	WLBWRATIO1	DEC	15	1	Average Number of Records Transferred / Request
139	NRCRDTFPH	☐	WLBWRCTFPH	WLBWDEC15	DEC	15	0	Number of Records Transferred per Hour
140	TIMRDTFMS	☐	WLBWTRTFMS	WLBWTIME15	DEC	15	1	Runtime for Transferring a Record (ms)
141	TIMEPSA	☐	WLBWTIMPSA	WLBWTIME15	DEC	15	1	Runtime in PSA (s)
142	TIMEPSA3	☐	WLBWTIME3	WLBWDEC21	DEC	21	3	Runtime (DEC 21.3)
143	PCTTIMPSA	☐	WLBWPTIPSA	WLBWPCENT1	DEC	5	2	Share of Total Runtime that Is PSA Runtime (%)
144	AVGTIMPSA	☐	WLBWAVGPSA	WLBWTIME15	DEC	15	1	Average PSA Runtime (s)
145	NRRCRDPSA	☐	WLBWNRRDPS	WLBWDEC15	DEC	15	0	Number of Records in PSA
146	AVRCRDPSA	☐	WLBWAVRDPS	WLBWRATIO1	DEC	15	1	Average Number of Records in PSA
147	NRCRDPSPH	☐	WLBWRCPSPH	WLBWDEC15	DEC	15	0	Number of PSA Records per Hour
148	TIMRDPSMS	☐	WLBWTRPSMS	WLBWTIME15	DEC	15	1	Runtime of a PSA Record (ms)
149	TIMUPDATE	☐	WLBWTIMUPD	WLBWTIME15	DEC	15	1	Total Runtime for Update Rules (s)
150	TIMUPDAT3	☐	WLBWTIME3	WLBWDEC21	DEC	21	3	Runtime (DEC 21.3)
151	PCTTIMUPD	☐	WLBWPTIUPD	WLBWPCENT1	DEC	5	2	Share of Total Runtime that Is Update Runtime (%)
152	AVGTIMUPD	☐	WLBWAVGUPD	WLBWTIME15	DEC	15	1	Average Runtime of Update Rules (s)
153	NRRCRDUPD	☐	WLBWNRRDUP	WLBWDEC15	DEC	15	0	Number of Records with Update Rules
154	AVRCRDUPD	☐	WLBWAVRDUP	WLBWRATIO1	DEC	15	1	Average Number of Records with Update Rules / Request
155	NRCRDUPPH	☐	WLBWRCUPPH	WLBWDEC15	DEC	15	0	Number of Records with Update Rules per Hour
156	TIMRDUPMS	☐	WLBWTRUPMS	WLBWTIME15	DEC	15	1	Runtime for Updating a Record (ms)
157	TIMTARGET	☐	WLBWTIMTGT	WLBWTIME15	DEC	15	1	Total Runtime of Actions for Target Object (s)
158	TIMTARGT3	☐	WLBWTIME3	WLBWDEC21	DEC	21	3	Runtime (DEC 21.3)
159	PCTTIMTGT	☐	WLBWPTITGT	WLBWPCENT1	DEC	5	2	Share of Runtime for Target Object Actions (%)
160	AVGTIMTGT	☐	WLBWAVGTGT	WLBWTIME15	DEC	15	1	Average Runtime for Target Object Actions (s)
161	NRRCRDTGT	☐	WLBWNRRDTG	WLBWDEC15	DEC	15	0	Number of Records Written for Target Object Actions
162	AVRCRDTGT	☐	WLBWAVRDTG	WLBWRATIO1	DEC	15	1	Average Number of Records Written for Target Object Actions
163	NRCRDTGPH	☐	WLBWRCTGPH	WLBWDEC15	DEC	15	0	Number of Records Written for Target Object Actions / hour
164	TIMRDTGMS	☐	WLBWTRTGMS	WLBWTIME15	DEC	15	1	Runtime for Writing a Record for Target Objects (ms)
165	LOGSYS	☐	WLBWLOGSYS	RSINFOCUBE	CHAR	30	0	Logical Name of the Source System
166	IPAKID	☐	WLBWIPAKID	WLBWCHAR1	CHAR	10	0	Request ID (Data Packet)
167	MANUAL	☐	WLBWMANUAL	WLBWFLAG	CHAR	1	0	Manual
168	TFMETHOD	☐	WLBWTFMETH	WLBWFLAG	CHAR	1	0	Transfer Method

History

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