Tables in BW

Thought it may be of some use if I make a list of useful BW tables


v_rszglobv = variables
/BIC/F (cubename) is the fact table of a content cube
/BIC/D (cubename) P is the package dimension of a content cube
/BIC/D(cubename) U is the unit dimension of a content cube
/BIC/D(cubename) T is the time dimension of a content cube
/BIC/D(cubename) <1-9>, A,B,C,D  is the userdefined dimension of a content cube
/BIC/M (InfoObject name) master data of object
/BIC/T (InfoObject name) text data of object
/BIC/H (InfoObject name) hierarchy data of object
/BIC/S(InfoObject name) SID table of the object.

/BIC/P(InfoObject name) Time-independent Master Data
/BIC/Q(InfoObject name) Time-dependent Master Data
/BIC/X(InfoObject name) table to link SID with SIDs for Time-independent Navigational Attributes
/BIC/Y(InfoObject name) table to link SID with SIDs for Time-dependent Navigational Attributes

/BIC/H(InfoObject name) Hierarchy Tables
/BIC/K(InfoObject name) Hierarchy SID Tables
/BIC/I(InfoObject name) SID Hierarchy Structure
/BIC/J(InfoObject name) Hierarchy Interval Tables

you can replace the BIC with BI0 for business content object and cubes

RSDIOBJ - index of all InfoObjects
RSSELDONE - Monitor: Selections for executed request
RSREQDONE - Monitor: Saving of the QM entries, state of the uploads, all info about the upload via request number, field: RNR

ODS Table names
1.New data: /BIC/A (ODS NAME)40
2.Active data: /BIC/A (ODS NAME)00
3.Change log: /BIC/B ( NUMBERS)

RSRREPDIR which is the table containing all your reports.
RSTSODS - table that contain relation between "ODS Name" and PSA Table.
TBDLS - Logical system customization, when you run TA: BDLS
EDP21 - Partner Profile, when you run TA: WE20
RSBASIDOC - Assignment of source systems to BIW systems incl. IDoc type
In V_COMPDIR_COMPIC you can also see all your reports. The advantage is that you can see the name/text of the query, not only the technical id.

RSDCUBEIOBJ Objects per InfoCube (where-used list)
RSDODSOATRNAV InfoObject in ODS (navigational attributes)
RSDODSOIOBJ InfoObject in ODS
RSDIOBJT InfoObject texts
RSDIOBJ Directory of all InfoObjects
RSDKYF Key figures
RSDBCHATR Master data attributes
RSBBSQUERYDIR BW: Directory of the Query Sender
RSBBSQUERY BW: Query Receiver
RSBBSQUERYT BW: Texts for Query Receiver
TQOP Compare Operators for View Maintenance Query
TQOPT Compare operators for view maintenance query (texts)
TQLOT Logical operators for view maintenance query (texts)
ROMSDIOBJ BIW: Assignment of master data attributes to InfoObjects
RODCHA BIW: InfoObjects / characteristics
RODIOBJCMP BIW: InfoObjects / compounding
RODKYF BIW: Key figures
ROAPPLT BIW: Name of the application components
RSUICDONE BIW: Selection table for user-selection update ICs
RODTIM BIW: Time characteristics
RODUNI BIW: Units
RSIST InfoSource texts
RSIS InfoSource (transaction data)
RSISOSMAP Mapping Between InfoSources and OLTP Sources
RSOSFIELDMAP Mapping Between OLTP Source Fields and InfoObjects
RSUPDDAT Update rules key figures
RSUPDKEY Update rule: Key per key figure
RSUPDROUT Update rules - ABAP routine - check table
RSRWBINDEXT Titles of binary objects (Excel workbooks) in InfoCatalog
RSRWORKBOOK 'Where-used list' for reports in workbooks
RSDDIME Dimensions directory
RSDDIMEIOBJ InfoObjects per dimension (where-used list)
RSDDIMET Dimension Texts
RSZCOMPDIR Directory of reporting components
RSZELTATTR Attribute selection per dimension element
RSZELTDIR Directory of the reporting component elements
RSZELTTXT Texts of reporting component elements
RSZELTXREF Directory of query element references
RSZGLOBV Global Variables in Reporting
RSDCUBET Texts for the InfoCubes
SMEN_BUFFC-Table for Storing Favorites.