Is there any table or program to get Infocube table names and Size

[Former Member]

Just want to know is there any easy way to get all the existing  Infocube or Dso table names & size of those tables in BW system.

[karthik_vasudevan · Accepted solution]

Hi Suman

Tcode ST14 should help you get all the information that you need.

Got to St14. Choose Business Warehouse as option when prompted. It will give you the below screen with the information on when it was last updated.

Choose schedule job and choose the objects based on your requirement. It will be updated and give you the right information

The above Tcode will give the top 30 objects. If you need all objects, go to DB02

Double click on BW analysis as below. You will have the details in the right half. Choose the objects that you need and it will you the size details.

Have a good time!

Regards

Karthik

[Former Member · Accepted solution]

Thank you Karthik, but I didn't have access to those tcodes

[Former Member · Accepted solution]

Hi Suman,

As u said you dont have the Access for those Tcodes.

1.U just try to SE16

2.Enter * cube name or DSO name and Press F4

3.This will give u the dimension or fact table names for the cube.

4.For DSO it will give you the New,Active,Change Log tables.

[Former Member]

Hi Suman,

Please follow the steps below,

Go to transaction DB02. There in third table "Tables and indexes", you will find a tab for "Detailed Analysis". Just click on that and put a pattern to consider all the data targets in the system. The pattern can be like "Z*".

Thanks

Vivek

[former_member186445]

Click this link for the solution...

M.