SAP ABAP Table RSTC_BIRS_OLAP_AGGR_EX (Extract structure aggregated BI Query Runtime statistic data)

Hierarchy

☛ SAP_BW (Software Component) SAP Business Warehouse
   ⤷ BW-WHM (Application Component) Warehouse Management
     ⤷ RSTCT (Package) BW Technical Content (Technology)

Basic Data

Table Category	INTTAB	Structure
Structure	RSTC_BIRS_OLAP_AGGR_EX	Table Relationship Diagram
Short Description	Extract structure aggregated BI Query Runtime statistic 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	SESSIONUID	☐	SYSUUID_25	SYSUUID_25	CHAR	25	0	UUID in compressed form
2	STEPUID	☐	SYSUUID_25	SYSUUID_25	CHAR	25	0	UUID in compressed form
3	UNAME	☐	UNAME	UNAME	CHAR	12	0	User Name
4	STEPTP	☐	RSSTA_STEPTP	RSSTA_STEPTP	CHAR	4	0	OLAP Statistics: Step Type (ODBO, BEX, ...)
5	STEPCNT	☐	RSSTA_STEPCNT	RSSTA_STEPCNT	NUMC	4	0	Counter of the (Navigation) Step during Query Execution
6	HANDLEID	☐	RSSTA_HANDLEID	RSSTA_HANDLEID	NUMC	4	0	Internal ID of a Query Runtime Object
7	UTIME	☐	RSDDSTATTIME	TIME	TIMS	6	0	BW Statistics Time
8	CALDAY	☐	RSDDSTATDAY	DATUM	DATS	8	0	BW Statistics: Day
9	RUNTIME	☐	RSDDKRUNTIME	RSDDKRUNTIME	DEC	21	6	Runtime
10	INFOPROV	☐	RSINFOPROV	RSINFOPROV	CHAR	30	0	InfoProvider
11	OBJPROP	☐	RSSTA_OBJPROP	RSSTA_OBJPROP	CHAR	10	0	Properties of the Statistic Object (Query, Template,...)
12	STATLEVEL	☐	RSSTA_STATLEVEL	RSSTA_STATLEVEL	NUMC	1	0	Detail Level of OLAP Statistics Recording
13	STARTTIME	☐	TZNTSTMPL	TZNTSTMPL	DEC	21	7	UTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun)
14	INFOPROV_TYPE	☐	RSTCTLOGO	RSTCTLOGO	CHAR	4	0	TLOGO type for BW Admin Cockpit
15	LOGSYS	☐	RSDLOGSYS	LOGSYS	CHAR	10	0	Source System	*
16	OBJECT	☐	BWOBJECT	BWOBJECT	CHAR	40	0	BW Object
17	OBJECT_TYPE	☐	RSTCTLOGO	RSTCTLOGO	CHAR	4	0	TLOGO type for BW Admin Cockpit
18	SUB_OBJECT	☐	BWOBJECT	BWOBJECT	CHAR	40	0	BW Object
19	SUB_OBJECT_TYPE	☐	RSTCTLOGO	RSTCTLOGO	CHAR	4	0	TLOGO type for BW Admin Cockpit
20	TIME_FE	☐	STATISTIC_TIME	RSDDKRUNTIME	DEC	21	6	Time monitored during statistic
21	TIME_OLAP	☐	STATISTIC_TIME	RSDDKRUNTIME	DEC	21	6	Time monitored during statistic
22	TIME_DM	☐	STATISTIC_TIME	RSDDKRUNTIME	DEC	21	6	Time monitored during statistic
23	TIME_PLAN	☐	STATISTIC_TIME	RSDDKRUNTIME	DEC	21	6	Time monitored during statistic
24	TIME_NOTASSIGNED	☐	STATISTIC_TIME	RSDDKRUNTIME	DEC	21	6	Time monitored during statistic
25	TIME_OVERALL	☐	STATISTIC_TIME	RSDDKRUNTIME	DEC	21	6	Time monitored during statistic
26	HOUR_SLOT	☐	TIME_SLOT	TIME_SLOT	NUMC	2	0	Time slot
27	RUNTIME_CATEGORY	☐	RSDDSTATCOUNT		DEC	15	0	BW Statistics: Number
28	QUERY_COUNTER	☐	OBJECT_COUNTER	OBJECT_COUNTER	INT4	10	0	Counter for objects (always set to 1, aggregated later)
29	TEMPLATE_COUNTER	☐	OBJECT_COUNTER	OBJECT_COUNTER	INT4	10	0	Counter for objects (always set to 1, aggregated later)
30	DBTRANS	☐	STATISTIC_TIME	RSDDKRUNTIME	DEC	21	6	Time monitored during statistic
31	DBSEL	☐	STATISTIC_TIME	RSDDKRUNTIME	DEC	21	6	Time monitored during statistic
32	CACHE_DM_FLAG	☐	RSTC_ACCESS_FLAG	RSTC_ACCESS_FLAG	NUMC	2	0	BW Access flag-DB/Cache/BWA

History

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