Tables that provide information on infoproviders

[Former Member]

HI ,

I need a table in BW/BI system which must have details of the infoproviders

1) How often they are loaded ?

2) whether been used in reports?

It is OK if the information is spread across multiple tables

Thanks

[Former Member]

Hi

For Infoobjects

InfoObject

RSDIOBJ Directory of all InfoObjects

RSDIOBJT Texts of InfoObjects

RSDIOBJ Directory of all InfoObjects

RSDIOBJT Texts of InfoObjects

RSDATRNAV Navigation Attributes

RSDATRNAVT Navigation Attributes

RSDBCHATR Master Data Attributes

RSDCHABAS Basic Characteristics (for Characteristics,Time Characteristics, and Units)

RSDCHA

Characteristics Catalog

RSDDPA

Data Package Characteristic

RSDIOBJCMP

Dependencies of InfoObjects

RSKYF

Key Figures

RSDTIM

Time Characteristics

RSDUNI

Units

For InfoCube

RSDCUBE Directory of InfoCubes

RSDCUBET Texts on InfoCubes

RSDCUBEIOBJ Objects per InfoCube (where-used list)

RSDDIME Directory of Dimensions

RSDDIMET Texts on Dimensions

RSDDIMEIOBJ InfoObjects for each Dimension (Where-Used List)

RSDCUBEMULTI InfoCubes involved in a MultiCube

RSDICMULTIIOBJ MultiProvider: Selection/Identification of InfoObjects

RSDICHAPRO Characteristic Properties Specific to an InfoCube

RSDIKYFPRO Flag Properties Specific to an InfoCube

RSDICVALIOBJ InfoObjects of the Stock Validity Table for the InfoCube

ODS Object

RSDODSO Directory of all ODS Objects

RSDODSOT Texts of all ODS Objects

RSDODSOIOBJ InfoObjects of ODS Objects ODSOATRNAV Navigation Attributes for ODS Object

RSDODSOTABL Directory of all ODS Object Tables

Hope this helps

Regard

Shilpa

[Former Member]

You can use the technical content for the information you need.

RSDCUBE

RSDCUBEIOBJ

RSDCUBELOC

RSDCUBEMULTI

RSDDSTAT

RSDDSTATAGGR

RSDDSTATAGGRDEF

RSDDSTATBCACT

RSDDSTATCOND

RSDDSTATDELE

RSDDSTATDETLEV

RSDDSTATDETLEVT

RSDDSTATDM

RSDDSTATDTP

RSDDSTATEVDATA

RSDDSTATEVENTS

RSDDSTATEVENTST

RSDDSTATEXTRACT

RSDDSTATHANDLTP

RSDDSTATHANDLTP

RSDDSTATHEADER

RSDDSTATINFO

RSDDSTATLOG

RSDDSTATOBJLEVEL

RSDDSTATSTEPTP

RSDDSTATSTEPTPT

[Former Member]

Hi,

Install BW/BI Statistics, we will get the info. you want.

check these links:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/50f95b21-7fb8-2910-0c81-f6935d4c...

http://help.sap.com/saphelp_nw04s/helpdata/en/8c/131e3b9f10b904e10000000a114084/content.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/43/15c54048035a39e10000000a422035/frameset.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/e3/e60138fede083de10000009b38f8cf/frameset.htm

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/90080703-4331-2a10-cd98-9c1e95ac...

REDDY