BW table

[Former Member]

Hi,

Is there any way to find out the table in which all the BW active objects(ODS , Cube, Infoobjects etc) gets stored.

Thanks , Jeetu

[Former Member]

Hi...........

U can also check in Metadata Repository..................RSA1 >> Metadata Repository >> there click what u want to see..........Infocubes,ODS ,Infoobjects,Query..........whatever...........it will display u all the BW active objects........Tcode >> RSOMDR

U can also check the table DD02L..........it contains list of all tables.......

Regards,

Debjani.....

[Former Member]

Hi,

I am not sure about way of finding tables but see below list it may help,

*Standard InfoCUBE Tables 😘

/BI0/F -- Fact Table(Before Compression)

/BI0/E -- Fact Table(After Compression)

/BI0/P -- Dimension Table - Data Package

/BI0/T -- Dimension Table - Time

/BI0/U -- Dimension Table - Unit

/BI0/1, 2, 3, .......A,B,C,D : -- Dimension Tables

*BW Tables:*

BTCEVTJOB -- To check List of jobs waiting for events

ROOSOURCE -- Control parameters for Datasource

ROOSFIELD -- Control parameters for Datasource

ROOSPRMSC -- Control parameters for Datasource

ROOSPRMSF -- Control parameters for Datasource

RSOLTPSOURCE -- Replicate Table for OLTP source in BW

RSDMDELTA -- Datamart Delta Management

RSSDLINITSEL, RSSDLINITDEL-- Last valid Initialization to an OLTP Source

RSUPDINFO -- Infocube to Infosource correlation

RSUPDDAT -- Update rules key figures

RSUPDENQ -- Removal of locks in the update rules

RSUPDFORM -- BW: Update Rules - Formulas - Checking Table

RSUPDINFO -- Update info (status and program)

RSUPDKEY -- Update rule: Key per key figure

RSUPDROUT -- Update rules - ABAP routine - check table

RSUPDSIMULD -- Table for saving simulation data update

RSUPDSIMULH -- Table for saving simulation data header information

RSDCUBEIOBJ -- Infoobjects per Infocube

RSIS -- Infosouce Info

RSUPDINFO -- Update Rules Info

RSTS -- Transfer Rules Info

RSKSFIELD -- Communication Structure fields

RSALLOWEDCHAR -- Special Characters Table(T Code : RSKC, To maintain)

RSDLPSEL -- Selection Table for fields scheduler(Infpak's)

RSDLPIO -- Log data packet no

RSMONICTAB -- Monitor, Data Targets(Infocube/ODS) Table, request related info

RSTSODS -- Operational data store for Transfer structure

RSZELTDIR -- Query Elements

RSZGLOBV -- BEx Variables

RXSELTXREF, RSCOMPDIR -- Reports/query relavent tables

RSCUSTV -- Query settings

RSDIOBJ -- Infoobjects

RSLDPSEL -- Selection table for fields scheduler(Info pak list)

RSMONIPTAB -- InfoPackage for the monitor

RSRWORKBOOK -- Workbooks & related query genunid's

RSRREPDIR -- Contains Genuin id, Rep Name, author, etc...

RSRINDEXT -- Workbook ID & Name

RSREQDONE -- Monitor: Saving of the QM entries

RSSELDONE -- Monitor : Selection for exected requests

RSLDTDONE -- Texts on the requeasted infopacks & groups

RSUICDONE -- BIW: Selection table for user-selection update Infocubes's

RSSDBATCH -- Table for Batch run scheduler

RSLDPDEL -- Selection table for deleting with full update scheduler

RSADMINSV -- RS Administration

RSSDLINIT -- Last Valid Initializations to an OLTP Source

BTCEVTJOB --To check event status(scheduled or not)

VARI -- ABAP Variant related Table

VARIDESC -- Selection Variants: Description

SMQ1 -- QRFC Monitor(Out Bound)

SM13 -- Update Records status

Queries

RSZELTDIR Directory of the reporting component elements

RSZELTTXT Texts of reporting component elements

RSZELTXREF Directory of query element references

RSRREPDIR Directory of all reports (Query GENUNIID)

RSZCOMPDIR Directory of reporting components

Workbooks

RSRWBINDEX List of binary large objects (Excel workbooks)

RSRWBINDEXT Titles of binary objects (Excel workbooks)

RSRWBSTORE Storage for binary large objects (Excel workbooks)

RSRWBTEMPLATE Assignment of Excel workbooks as personal templates

RSRWORKBOOK 'Where-used list' for reports in workbooks

Web templates

RSZWOBJ Storage of the Web Objects

RSZWOBJTXT Texts for Templates/Items/Views

RSZWOBJXREF Structure of the BW Objects in a Template

RSZWTEMPLATE Header Table for BW HTML Templates

Regards,

Satya

Edited by: satya on Jan 15, 2009 8:26 AM

[Former Member]

They're really not stored in one table, but a series of tables. Here are some to get you started:

* cubes
rsdcube

* DSOs
rsdodso

* InfoObjects
rsdiobj