Table containing table names for DSO

[#1]

Hi Experts,

I am in urgent need for documenting all table names for info providers (cube & DSO's)

I came to know that using tcode- LISTSCHEMA. I can get fact table name of infocube by specifying infocube name in selection.

Please let me know is there any tcode or table which contains all table names fort DSO along with DSO name or by specifying DSO name.

In Table DD02L, a getting list of all table names but I am unable to find DSO names.

Please suggest any tcode similar to LISTSCHEMA to get required table names for DSO.

Thanks in advance!!

Regards,

Saravanan

[Former Member]

Hi All,

Thanks for input, there are more than 100 DSO's, So it will take more time to check manage of each DSO and get the details.

I meant for activation table and change log table name.

~Ravichandra,

My expectation is similar to tcode LISTSCHEMA which is for infocubes. I need for DSO's.

[Former Member]

Hi Saravanan,

As Ravi said you can just collect DSO names from table RSDODSO. Once these name you received you can put a excel formula to create other table-names as said by Ravi's logic.

active table :/bic/a<dso_name>00.

activation queue table : /bic/<dso_name>40.

Now for change log go to table RSTSODS and put below selection to get change log table names and execute.

[Former Member]

Thanks All,

From one of the SDN thread, I found below process to get details..

Hi,

Please follow the steps as :

Double Click on the DSO/Cube>Extras>Information Log Status-->Dictionary/DB status

This will give u the list of table names.

[Former Member]

Hi Saravanan,

I'm afraid there aren't any t-code / table which stores the relevant tables of a DSO.

You can find those details since barely 3 tables for a DSO, as mentioned by the experts above.

Br,

H

[Former Member]

Hi Saravanan,

DSO we has only 3 tables so we can directly get table names. No need to check for any t-code or table.

Regards,

Ganesh

[Former Member]

Hi

You can get the fact table technical name by /bic/f<infocube_technical_name> for fact table and for the e-fact table it is /bic/e<infocube_technical_name>.

for dso:

---------

active table :/bic/a<dso_name>00.

activation queue table : /bic/<dso_name>40.

changelog table it is : /bic/b<10 digit random number>.

Is it what you are expecting . If it is not your requirement please elaborate your question.

Regards,

RaviChandra