Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Oct 15, 2015 at 03:57 PM

    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


    DB02.PNG (52.2 kB)
    ST14.PNG (23.8 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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.

  • Oct 16, 2015 at 11:50 AM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 16, 2015 at 11:59 AM

    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

    Add comment
    10|10000 characters needed characters exceeded