SAP ABAP Table WLBIDTP_ALL (BI Workload: All Data for DTP Runtime Statistics)

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	WLBIDTP_ALL	Table Relationship Diagram
Short Description	BI Workload: All Data for DTP Runtime Statistics

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	SRC	☐	WLBISRC	RSINFOCUBE	CHAR	30	0	Name of the Data Source for a Data Transfer Process
2	SRCSYSTEM	☐	WLBISRCSYS	WLBWCHAR1	CHAR	10	0	Source System Connection
3	SRCTP	☐	WLBISRCTYP	WLBIDTPSRCTYP	CHAR	6	0	Type of Source Object of a Data Transfer Process
4	NRSOURCES	☐	WLBINRSRC	WLBWINT4	INT4	10	0	Number of Different Source Objects
5	TGT	☐	WLBITGT	RSINFOCUBE	CHAR	30	0	Name of the Data Target for a Data Transfer Process
6	TGTTP	☐	WLBITGTTYP	WLBIDTPTGTTYP	CHAR	6	0	Type of Target Object for a Data Transfer Process
7	NRTARGETS	☐	WLBWNRTGT	WLBWINT4	INT4	10	0	Number of Different Target Objects
8	NRREQUESTS	☐	WLBINUMREQ	WLBWINT4	INT4	10	0	Number of Executed DTP Requests
9	TIMETOTAL	☐	WLBIDTPTTOT	WLBWTIME15	DEC	15	1	Total Runtime of All DTPs (s)
10	TIMETOTAVG	☐	WLBIDTPTAVG	WLBWTIME15	DEC	15	1	Average Total Runtime per DTP Request (s)
11	MEDTTOTAL	☐	WLBIMEDTOT	WLBWTIME15	DEC	15	1	Median of Total Runtime (s)
12	TIMETOTCUM	☐	WLBIDTPTCUM	WLBWTIME15	DEC	15	1	Cumulated Total Runtime of All DTP Data Packets (s)
13	TIMETCMAVG	☐	WLBIDTPCAVG	WLBWTIME15	DEC	15	1	Average Total Runtime for All DTP Packets (s)
14	TIMESRC	☐	WLBITIMSRC	WLBWTIME15	DEC	15	1	Total Runtme of DTP Extraction in Source System (s)
15	TIMESRCPCT	☐	WLBITSRCPCT	WLBWPCENT1	DEC	5	2	Share of Total Runtime that is Runtime in Source System (%)
16	TIMESRCAVG	☐	WLBITSRCAVG	WLBWTIME15	DEC	15	1	Average Runtime in Source System / Request (s)
17	RECS_MAX	☐	WLBIRCSMAX	WLBWSIZE	DEC	21	0	Maximum Number of Processed Records in a Data Packet
18	SIZE_MAX	☐	WLBISIZMAX	WLBWSIZE	DEC	21	0	Maximum Size of Processed Records in a Data Packet [Bytes]
19	RECSSRC	☐	WLBIRCSSRC	WLBWSIZE	DEC	21	0	Number of Extracted Records in Source System
20	RECSSRCAVG	☐	WLBIRSRCAVG	WLBWRATIO1	DEC	15	1	Average No. of Extracted Records in Source System / Request
21	SIZESRC	☐	WLBISIZSRC	WLBWSIZE	DEC	21	0	Size of Extracted Packets from Source System (Bytes)
22	SIZESRCAVG	☐	WLBISSRCAVG	WLBWRATIO1	DEC	15	1	Average Size of Packets in Source System / Request [Bytes]
23	TIMEERRF	☐	WLBITIMERF	WLBWTIME15	DEC	15	1	Total Runtime for DTP Error Handling (s)
24	TIMEERFPCT	☐	WLBITERFPCT	WLBWPCENT1	DEC	5	2	Share of Total Runtime That Is Error Filter Runtime (%)
25	TIMEERFAVG	☐	WLBITERFAVG	WLBWTIME15	DEC	15	1	Average Runtime in Error Filter / Request (s)
26	RECSERRF_S	☐	WLBIRCSERFS	WLBWSIZE	DEC	21	0	Total Number of Records in Error Filter at Start Time
27	RCSERFSAVG	☐	WLBIRERFSAVG	WLBWRATIO1	DEC	15	1	Average No. of Recs in Error Filter at Start Time / Request
28	RECSERRF_F	☐	WLBIRCSERFF	WLBWSIZE	DEC	21	0	Total Number of Records in Error Filter at End Time
29	RCSERFFAVG	☐	WLBIRERFFAVG	WLBWRATIO1	DEC	15	1	Average Number of Records in Error Filter at End / Request
30	SIZEERRF_S	☐	WLBISIZERFS	WLBWSIZE	DEC	21	0	Size of the Packets in Error Filter at Start Time (Bytes)
31	SIZERFSAVG	☐	WLBISERFSAVG	WLBWRATIO1	DEC	15	1	Avg. Size of Packets in Error Filter/Request [Bytes] - Start
32	SIZEERRF_F	☐	WLBISIZERFF	WLBWSIZE	DEC	21	0	Size of Packets in Error Filter at End Time (Bytes)
33	SIZERFFAVG	☐	WLBISERFFAVG	WLBWRATIO1	DEC	15	1	Avg. Size of Packets in Error Filter / Request [Bytes] - End
34	TIMETRFN	☐	WLBITIMTRF	WLBWTIME15	DEC	15	1	Total Runtime for All DTP Transformations (s)
35	TIMETRFPCT	☐	WLBITTRFPCT	WLBWPCENT1	DEC	5	2	Share of Total Runtime That Is Transformation Time (%)
36	TIMETRFAVG	☐	WLBITTRFAVG	WLBWTIME15	DEC	15	1	Average Runtime in Transformation / Request (s)
37	RECSTRFN_S	☐	WLBIRCSTRFS	WLBWSIZE	DEC	21	0	Total Number of Transformed Records at Start Time
38	RCSTRFSAVG	☐	WLBIRTRFSAVG	WLBWRATIO1	DEC	15	1	Avg. No. of Records in Transformation / Request (Start Time)
39	RECSTRFN_F	☐	WLBIRCSTRFF	WLBWSIZE	DEC	21	0	Total Number of Transformed Records at End Time
40	RCSTRFFAVG	☐	WLBIRTRFFAVG	WLBWRATIO1	DEC	15	1	Avg. No. of Records in Transformation at End Time / Request
41	SIZETRFN_S	☐	WLBISIZTRFS	WLBWSIZE	DEC	21	0	Size of the Transformed Packets at Start Time (Bytes)
42	SIZTRFSAVG	☐	WLBISTRFSAVG	WLBWRATIO1	DEC	15	1	Avg.Sz. of Packets in Transformation / Request [Bytes]-Start
43	SIZETRFN_F	☐	WLBISIZTRFF	WLBWSIZE	DEC	21	0	Size of the Transformed Packets at End Time (Bytes)
44	SIZTRFFAVG	☐	WLBISTRFFAVG	WLBWRATIO1	DEC	15	1	Avg. Size of Packets in Transformation / Request [Bytes]-End
45	TIMETGT	☐	WLBITIMTGT	WLBWTIME15	DEC	15	1	Total Runtime for Storing in Target Object (s)
46	TIMETGTPCT	☐	WLBITTGTPCT	WLBWPCENT1	DEC	5	2	Share of Total Runtime that Is Target Object Time (%)
47	TIMETGTAVG	☐	WLBITTGTAVG	WLBWTIME15	DEC	15	1	Average Runtime for Target Object / Request (s)
48	RECSTGT_S	☐	WLBIRCSTGTS	WLBWSIZE	DEC	21	0	Number of Stored Records in Target Object at Start Time
49	RCSTGTSAVG	☐	WLBIRTGTSAVG	WLBWRATIO1	DEC	15	1	Avg. No. of Recs for Target Object at Start Time / Request
50	RECSTGT_F	☐	WLBIRCSTGTF	WLBWSIZE	DEC	21	0	Number of Stored Records in Target Object at End Time
51	RCSTGTFAVG	☐	WLBIRTGTFAVG	WLBWRATIO1	DEC	15	1	Avg. No. of Records for Target Object at End Time / Request
52	SIZETGT_S	☐	WLBISIZTGTS	WLBWSIZE	DEC	21	0	Size of the Stored Packets in Target Object (Bytes)
53	SIZTGTSAVG	☐	WLBISTGTSAVG	WLBWRATIO1	DEC	15	1	Avg.Packet Sz.for Writing to Target Object / Request [Bytes]
54	NUMPACKAGE	☐	WLBINUMPACK	WLBWDEC15	DEC	15	0	Total Number of Data Packets
55	AVGPACKAGE	☐	WLBIAVGPACK	WLBWRATIO1	DEC	15	1	Average Number of Data Packets / Request
56	NUMTRFN	☐	WLBINUMTRF	WLBWINT4	INT4	10	0	Number of DTP Transformations
57	AVGTRFN	☐	WLBIAVGTRF	WLBWRATIO1	DEC	15	1	Average Number of Transformations / Request
58	TSTMP_START	☐	TZNTSTMPL	TZNTSTMPL	DEC	21	7	UTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun)
59	REQUID	☐	WLBWREQID	WLBWCHR12	CHAR	12	0	Request ID
60	REQUEST	☐	WLBIDTPREQ	RSINFOCUBE	CHAR	30	0	DTP Request ID
61	LOGSYS	☐	WLBWLOGSYS	RSINFOCUBE	CHAR	30	0	Logical Name of the Source System
62	DTP	☐	WLBIDTPNAM	RSINFOCUBE	CHAR	30	0	Data Transfer Process ID
63	UNAME	☐	WLBWNAME	WLBWCHR12	CHAR	12	0	User Name
64	USTATE	☐	WLBIUSTATE	WLBIDTPSTATE	CHAR	1	0	User-Defined Processing Status for a DTP Request
65	TSTATE	☐	WLBITSTATE	WLBIDTPSTATE	CHAR	1	0	Technical Processing Status for a DTP Request
66	TARGETSTATE	☐	WLBITGTSTT	WLBWFLAG	CHAR	1	0	Target Status of DTP Request
67	PROCESSMODE	☐	WLBIPMODE	WLBIDTPPMODE	CHAR	1	0	DTP Processing Mode
68	RECSSRCPH	☐	WLBIRCSSRCPH	WLBWDEC15	DEC	15	0	Throughput: Number of Records Read in Source System per Hour
69	RECSERFPH	☐	WLBIRCSERFPH	WLBWDEC15	DEC	15	0	Throughput: Number of Records in Error Filter per Hour
70	RECSTRFPH	☐	WLBIRCSTRFPH	WLBWDEC15	DEC	15	0	Throughput: Number of Transformed Records per Hour
71	RECSTGTPH	☐	WLBIRCSTGTPH	WLBWDEC15	DEC	15	0	Throughput: Number of Records Written to Target Object / h

History

Last changed by/on	SAP	20070813
SAP Release Created in	700