SAP ABAP Table RSTC_BIRS_OLAP_DETAILED_EX (Extract structure detailed 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_DETAILED_EX	Table Relationship Diagram
Short Description	Extract structure detailed 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	.INCLUDE	☐				0	0	Generated Table for View
2	SESSIONUID	☐	SYSUUID_25	SYSUUID_25	CHAR	25	0	UUID in compressed form
3	STEPUID	☐	SYSUUID_25	SYSUUID_25	CHAR	25	0	UUID in compressed form
4	HANDLEID	☐	RSSTA_HANDLEID	RSSTA_HANDLEID	NUMC	4	0	Internal ID of a Query Runtime Object
5	HANDLETP	☐	RSSTA_HANDLETP	RSSTA_HANDLETP	CHAR	4	0	Internal Type of Query Runtime Object
6	EVENTID	☐	RSSTA_EVENTN	RSSTA_EVENTN	NUMC	9	0	OLAP Statistics Event (Type NUMC9)
7	UNAME	☐	UNAME	UNAME	CHAR	12	0	User Name
8	STEPTP	☐	RSSTA_STEPTP	RSSTA_STEPTP	CHAR	4	0	OLAP Statistics: Step Type (ODBO, BEX, ...)
9	STEPCNT	☐	RSSTA_STEPCNT	RSSTA_STEPCNT	NUMC	4	0	Counter of the (Navigation) Step during Query Execution
10	UTIME	☐	RSDDSTATTIME	TIME	TIMS	6	0	BW Statistics Time
11	CALDAY	☐	RSDDSTATDAY	DATUM	DATS	8	0	BW Statistics: Day
12	RUNTIME	☐	RSDDKRUNTIME	RSDDKRUNTIME	DEC	21	6	Runtime
13	INFOPROV	☐	RSINFOPROV	RSINFOPROV	CHAR	30	0	InfoProvider
14	OBJNAME	☐	RSSTA_OBJNAME	RSSTA_OBJNAME	CHAR	30	0	OLAP Statistik Object Name (QueryID, TemplateID,...)
15	OBJPROP	☐	RSSTA_OBJPROP	RSSTA_OBJPROP	CHAR	10	0	Properties of the Statistic Object (Query, Template,...)
16	STATLEVEL	☐	RSSTA_STATLEVEL	RSSTA_STATLEVEL	NUMC	1	0	Detail Level of OLAP Statistics Recording
17	EVTIME	☐	RSDDKRUNTIME	RSDDKRUNTIME	DEC	21	6	Runtime
18	EVCOUNT	☐	RSDDSTATCOUNT		DEC	15	0	BW Statistics: Number
19	EVENTIDCNT	☐	RSSTA_EVENTIDCNT	RSSTA_EVENTIDCNT	INT4	10	0	Counter for Statistic Event Calls
20	STARTTIME	☐	TZNTSTMPL	TZNTSTMPL	DEC	21	7	UTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun)
21	LOGSYS	☐	RSDLOGSYS	LOGSYS	CHAR	10	0	Source System	*
22	INFOPROV_TYPE	☐	RSTCTLOGO	RSTCTLOGO	CHAR	4	0	TLOGO type for BW Admin Cockpit
23	OBJECT_TYPE	☐	RSTCTLOGO	RSTCTLOGO	CHAR	4	0	TLOGO type for BW Admin Cockpit
24	HOUR_SLOT	☐	TIME_SLOT	TIME_SLOT	NUMC	2	0	Time slot

History

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