SAP ABAP View RSDDSTAT_OLAP (OLAP + Front End Part of Statistic)

Hierarchy

☛ SAP_BW (Software Component) SAP Business Warehouse
   ⤷ BW-BEX-OT (Application Component) OLAP Technology
     ⤷ RSDD_STAT (Package) BW Statistics

Basic Data

View Type	D	Database View
Database View	RSDDSTAT_OLAP
Short Description	OLAP + Front End Part of Statistic
Root table	RSDDSTATHEADER	BW Statistics (OLAP), Information by Runtime Object

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	RSDDSTATHEADER	RSDDSTATHEADER
2	RSDDSTATINFO
3	RSDDSTATEVDATA

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	RSDDSTATHEADER	STEPUID	JL	EQ				0	0
2	RSDDSTATINFO	STEPUID	JR	EQ			AND	0	0
3	RSDDSTATHEADER	STEPUID	JL	EQ				0	0
4	RSDDSTATEVDATA	STEPUID	JR	EQ			AND	0	0
5	RSDDSTATHEADER	HANDLEID	JL	EQ				0	0
6	RSDDSTATEVDATA	HANDLEID	JR	EQ			AND	0	0
7	RSDDSTATHEADER	HANDLETP	JL	EQ				0	0
8	RSDDSTATEVDATA	HANDLETP	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	SESSIONUID	RSDDSTATHEADER	SESSIONUID		☐	SYSUUID_25	☐	UUID in compressed form
2	STEPUID	RSDDSTATINFO	STEPUID		☐	SYSUUID_25	☐	UUID in compressed form
3	HANDLEID	RSDDSTATHEADER	HANDLEID		☐	RSSTA_HANDLEID	☐	Internal ID of a Query Runtime Object
4	HANDLETP	RSDDSTATHEADER	HANDLETP		☐	RSSTA_HANDLETP	☐	Internal Type of Query Runtime Object
5	EVENTID	RSDDSTATEVDATA	EVENTID		☐	RSSTA_EVENTN	☐	OLAP Statistics Event (Type NUMC9)
6	UNAME	RSDDSTATINFO	UNAME		☐	UNAME	☐	User Name
7	STEPTP	RSDDSTATINFO	STEPTP		☐	RSSTA_STEPTP	☐	OLAP Statistics: Step Type (ODBO, BEX, ...)
8	STEPCNT	RSDDSTATINFO	STEPCNT		☐	RSSTA_STEPCNT	☐	Counter of the (Navigation) Step during Query Execution
9	UTIME	RSDDSTATINFO	UTIME		☐	RSDDSTATTIME	☐	BW Statistics Time
10	CALDAY	RSDDSTATINFO	CALDAY		☐	RSDDSTATDAY	☐	BW Statistics: Day
11	RUNTIME	RSDDSTATINFO	RUNTIME		☐	RSDDKRUNTIME	☐	Runtime
12	INFOPROV	RSDDSTATHEADER	INFOPROV		☐	RSINFOPROV	☐	InfoProvider
13	OBJNAME	RSDDSTATHEADER	OBJNAME		☐	RSSTA_OBJNAME	☐	OLAP Statistik Object Name (QueryID, TemplateID,...)
14	OBJPROP	RSDDSTATHEADER	OBJPROP		☐	RSSTA_OBJPROP	☐	Properties of the Statistic Object (Query, Template,...)
15	STATLEVEL	RSDDSTATHEADER	STATLEVEL		☐	RSSTA_STATLEVEL	☐	Detail Level of OLAP Statistics Recording
16	EVTIME	RSDDSTATEVDATA	EVTIME		☐	RSDDKRUNTIME	☐	Runtime
17	EVCOUNT	RSDDSTATEVDATA	EVCOUNT		☐	RSDDSTATCOUNT	☐	BW Statistics: Number
18	EVENTIDCNT	RSDDSTATEVDATA	EVENTIDCNT		☐	RSSTA_EVENTIDCNT	☐	Counter for Statistic Event Calls
19	STARTTIME	RSDDSTATINFO	STARTTIME		☐	TZNTSTMPL	☐	UTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun)

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

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