SAP Table RSTC_BIRS_DM_DETAILED_EX

Extract structure detailed BI Runtime statistic data (DM)

RSTC_BIRS_DM_DETAILED_EX (Extract structure detailed BI Runtime statistic data (DM)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link RSTC_BIRS_DM_DETAILED_EX to other SAP tables.

RSTC_BIRS_DM_DETAILED_EX table fields

Field Data element Checktable Datatype Length Decimals
STEPUID UUID in compressed form SYSUUID_25 CHAR 25 0
HANDLEID Internal ID of a Query Runtime Object RSSTA_HANDLEID NUMC 4 0
HANDLETP Internal Type of Query Runtime Object RSSTA_HANDLETP CHAR 4 0
UNAME User Name UNAME CHAR 12 0
UTIME BW Statistics Time RSDDSTATTIME TIMS 6 0
CALDAY BW Statistics: Day RSDDSTATDAY DATS 8 0
OBJNAME OLAP Statistik Object Name (QueryID, TemplateID,...) RSSTA_OBJNAME CHAR 30 0
DMUID UUID in compressed form SYSUUID_25 CHAR 25 0
ACCESSCNT DM Statistics: DM Access Counter RSSTA_ACCESSCNT NUMC 10 0
ACCESSTP Type of Data Read Access (Non-Cumulative or Delta) RSSTA_ACCESSTP CHAR 1 0
NULL Delta Query/Query on Cumulative Key Figures
N Query on Non-Cumulative Key Figures
INFOPROV InfoCube RSINFOCUBE CHAR 30 0
PARTPROV InfoCube RSINFOCUBE CHAR 30 0
AGGREGATE InfoCube RSINFOCUBE CHAR 30 0
TABLTP Single-Character Indicator CHAR1 CHAR 1 0
CLUSTER_ACCESS Cluster Access (Multiple PartProviders at once) RSDDSTAT_CLUSTER CHAR 1 0
NULL False
X True
TIMEDMPREP Runtime RSDDKRUNTIME DEC 21 6
TIMEDMPOST Runtime RSDDKRUNTIME DEC 21 6
TIMEREAD Runtime RSDDKRUNTIME DEC 21 6
TIMESID Runtime RSDDKRUNTIME DEC 21 6
TIMENAVATTR Runtime RSDDKRUNTIME DEC 21 6
TIMEHIERARCHY Runtime RSDDKRUNTIME DEC 21 6
DBSEL INT4 10 0
DBTRANS INT4 10 0
WP_ID Work process ID BTCWPPID INT4 10 0
PROCESSCNT INT4 10 0
SLOTNR INT4 10 0
STARTTIME UTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun) TZNTSTMPL DEC 21 7
LOGSYS Source System RSDLOGSYS CHAR 10 0
INFOPROV_TYPE TLOGO type for BW Admin Cockpit RSTCTLOGO CHAR 4 0
IOBJ InfoObject
ISFS DataSource (3.x)
RSDS DataSource
CUBE InfoCube
AGGR Aggreagates
ODSO DataStore Object
ELEM Query
DEST Open Hub Destination
ISET InfoSet
MPRO MultiProvider
QVIW Query View
XLWB Workbook
ITEM Web Item
BITM BEx Web Item
TMPL Web Template
BTMP BEx Web Template
COPR CompositeProvider
AINX Analytic Index
PARTPROV_TYPE TLOGO type for BW Admin Cockpit RSTCTLOGO CHAR 4 0
IOBJ InfoObject
ISFS DataSource (3.x)
RSDS DataSource
CUBE InfoCube
AGGR Aggreagates
ODSO DataStore Object
ELEM Query
DEST Open Hub Destination
ISET InfoSet
MPRO MultiProvider
QVIW Query View
XLWB Workbook
ITEM Web Item
BITM BEx Web Item
TMPL Web Template
BTMP BEx Web Template
COPR CompositeProvider
AINX Analytic Index
OBJECT_TYPE TLOGO type for BW Admin Cockpit RSTCTLOGO CHAR 4 0
IOBJ InfoObject
ISFS DataSource (3.x)
RSDS DataSource
CUBE InfoCube
AGGR Aggreagates
ODSO DataStore Object
ELEM Query
DEST Open Hub Destination
ISET InfoSet
MPRO MultiProvider
QVIW Query View
XLWB Workbook
ITEM Web Item
BITM BEx Web Item
TMPL Web Template
BTMP BEx Web Template
COPR CompositeProvider
AINX Analytic Index
HOUR_SLOT Time slot TIME_SLOT NUMC 2 0
CACHE_DM_FLAG BW Access flag-DB/Cache/BWA RSTC_ACCESS_FLAG NUMC 2 0
01 BWA access
02 Cache Read
03 DB Acess