SAP ABAP Table WLBIDTPSYS (BI Workload: DTP Runtime Statistics - Source System)

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	WLBIDTPSYS	Table Relationship Diagram
Short Description	BI Workload: DTP Runtime Statistics - Source System

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	SRCSYSTEM	☐	WLBISRCSYS	WLBWCHAR1	CHAR	10	0	Source System Connection
2	NRSOURCES	☐	WLBINRSRC	WLBWINT4	INT4	10	0	Number of Different Source Objects
3	NRTARGETS	☐	WLBWNRTGT	WLBWINT4	INT4	10	0	Number of Different Target Objects
4	NRREQUESTS	☐	WLBINUMREQ	WLBWINT4	INT4	10	0	Number of Executed DTP Requests
5	NUMPACKAGE	☐	WLBINUMPACK	WLBWDEC15	DEC	15	0	Total Number of Data Packets
6	AVGPACKAGE	☐	WLBIAVGPACK	WLBWRATIO1	DEC	15	1	Average Number of Data Packets / Request
7	TIMETOTAL	☐	WLBIDTPTTOT	WLBWTIME15	DEC	15	1	Total Runtime of All DTPs (s)
8	TIMETOTAVG	☐	WLBIDTPTAVG	WLBWTIME15	DEC	15	1	Average Total Runtime per DTP Request (s)
9	MEDTTOTAL	☐	WLBIMEDTOT	WLBWTIME15	DEC	15	1	Median of Total Runtime (s)
10	TIMETOTCUM	☐	WLBIDTPTCUM	WLBWTIME15	DEC	15	1	Cumulated Total Runtime of All DTP Data Packets (s)
11	TIMETCMAVG	☐	WLBIDTPCAVG	WLBWTIME15	DEC	15	1	Average Total Runtime for All DTP Packets (s)
12	RECS_MAX	☐	WLBIRCSMAX	WLBWSIZE	DEC	21	0	Maximum Number of Processed Records in a Data Packet
13	SIZE_MAX	☐	WLBISIZMAX	WLBWSIZE	DEC	21	0	Maximum Size of Processed Records in a Data Packet [Bytes]
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	RECSSRC	☐	WLBIRCSSRC	WLBWSIZE	DEC	21	0	Number of Extracted Records in Source System
18	RECSSRCAVG	☐	WLBIRSRCAVG	WLBWRATIO1	DEC	15	1	Average No. of Extracted Records in Source System / Request
19	SIZESRC	☐	WLBISIZSRC	WLBWSIZE	DEC	21	0	Size of Extracted Packets from Source System (Bytes)
20	SIZESRCAVG	☐	WLBISSRCAVG	WLBWRATIO1	DEC	15	1	Average Size of Packets in Source System / Request [Bytes]
21	TIMEERRF	☐	WLBITIMERF	WLBWTIME15	DEC	15	1	Total Runtime for DTP Error Handling (s)
22	TIMEERFPCT	☐	WLBITERFPCT	WLBWPCENT1	DEC	5	2	Share of Total Runtime That Is Error Filter Runtime (%)
23	TIMEERFAVG	☐	WLBITERFAVG	WLBWTIME15	DEC	15	1	Average Runtime in Error Filter / Request (s)
24	RECSERRF_S	☐	WLBIRCSERFS	WLBWSIZE	DEC	21	0	Total Number of Records in Error Filter at Start Time
25	RCSERFSAVG	☐	WLBIRERFSAVG	WLBWRATIO1	DEC	15	1	Average No. of Recs in Error Filter at Start Time / Request
26	RECSERRF_F	☐	WLBIRCSERFF	WLBWSIZE	DEC	21	0	Total Number of Records in Error Filter at End Time
27	RCSERFFAVG	☐	WLBIRERFFAVG	WLBWRATIO1	DEC	15	1	Average Number of Records in Error Filter at End / Request
28	SIZEERRF_S	☐	WLBISIZERFS	WLBWSIZE	DEC	21	0	Size of the Packets in Error Filter at Start Time (Bytes)
29	SIZERFSAVG	☐	WLBISERFSAVG	WLBWRATIO1	DEC	15	1	Avg. Size of Packets in Error Filter/Request [Bytes] - Start
30	SIZEERRF_F	☐	WLBISIZERFF	WLBWSIZE	DEC	21	0	Size of Packets in Error Filter at End Time (Bytes)
31	SIZERFFAVG	☐	WLBISERFFAVG	WLBWRATIO1	DEC	15	1	Avg. Size of Packets in Error Filter / Request [Bytes] - End
32	TIMETRFN	☐	WLBITIMTRF	WLBWTIME15	DEC	15	1	Total Runtime for All DTP Transformations (s)
33	TIMETRFPCT	☐	WLBITTRFPCT	WLBWPCENT1	DEC	5	2	Share of Total Runtime That Is Transformation Time (%)
34	TIMETRFAVG	☐	WLBITTRFAVG	WLBWTIME15	DEC	15	1	Average Runtime in Transformation / Request (s)
35	RECSTRFN_S	☐	WLBIRCSTRFS	WLBWSIZE	DEC	21	0	Total Number of Transformed Records at Start Time
36	RCSTRFSAVG	☐	WLBIRTRFSAVG	WLBWRATIO1	DEC	15	1	Avg. No. of Records in Transformation / Request (Start Time)
37	RECSTRFN_F	☐	WLBIRCSTRFF	WLBWSIZE	DEC	21	0	Total Number of Transformed Records at End Time
38	RCSTRFFAVG	☐	WLBIRTRFFAVG	WLBWRATIO1	DEC	15	1	Avg. No. of Records in Transformation at End Time / Request
39	SIZETRFN_S	☐	WLBISIZTRFS	WLBWSIZE	DEC	21	0	Size of the Transformed Packets at Start Time (Bytes)
40	SIZTRFSAVG	☐	WLBISTRFSAVG	WLBWRATIO1	DEC	15	1	Avg.Sz. of Packets in Transformation / Request [Bytes]-Start
41	SIZETRFN_F	☐	WLBISIZTRFF	WLBWSIZE	DEC	21	0	Size of the Transformed Packets at End Time (Bytes)
42	SIZTRFFAVG	☐	WLBISTRFFAVG	WLBWRATIO1	DEC	15	1	Avg. Size of Packets in Transformation / Request [Bytes]-End
43	NUMTRFN	☐	WLBINUMTRF	WLBWINT4	INT4	10	0	Number of DTP Transformations
44	AVGTRFN	☐	WLBIAVGTRF	WLBWRATIO1	DEC	15	1	Average Number of Transformations / Request
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	TSTMP_START	☐	TZNTSTMPL	TZNTSTMPL	DEC	21	7	UTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun)
55	REQUID	☐	WLBWREQID	WLBWCHR12	CHAR	12	0	Request ID
56	REQUEST	☐	WLBIDTPREQ	RSINFOCUBE	CHAR	30	0	DTP Request ID
57	LOGSYS	☐	WLBWLOGSYS	RSINFOCUBE	CHAR	30	0	Logical Name of the Source System
58	DTP	☐	WLBIDTPNAM	RSINFOCUBE	CHAR	30	0	Data Transfer Process ID
59	UNAME	☐	WLBWNAME	WLBWCHR12	CHAR	12	0	User Name
60	USTATE	☐	WLBIUSTATE	WLBIDTPSTATE	CHAR	1	0	User-Defined Processing Status for a DTP Request
61	TSTATE	☐	WLBITSTATE	WLBIDTPSTATE	CHAR	1	0	Technical Processing Status for a DTP Request
62	TARGETSTATE	☐	WLBITGTSTT	WLBWFLAG	CHAR	1	0	Target Status of DTP Request
63	PROCESSMODE	☐	WLBIPMODE	WLBIDTPPMODE	CHAR	1	0	DTP Processing Mode
64	LINECOLOR	☐	WLBILINECOL		CHAR	4	0	BI Workload: Color Specification

History

Last changed by/on	SAP	20080418
SAP Release Created in