Skip to Content
author's profile photo
Former Member

Determine Data Size of InfoObject

Hi, InfoObject maintenance allows you to specify the data class size of the infoObject.

Example: 3 = < 25meg

4 = > 160 Meg

Does anyone know how to determine this size? Is it determined by one specific table or a combination of the the various master data tables?

Any opinions or experiences are greatly appreciated!

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • author's profile photo
    Former Member
    Posted on Jul 14, 2004 at 01:47 AM

    The procedure is as follows (assuming the backend is Oracle):

    Check the data class in the infoobject (Extras --> Maintain Db storage parameters --> note the data class).

    Check the tablespace assigned to the data class (SE16 TAORA --> note the tablespace)

    Go to DB02 transaction --> Click on the current sizes --> double click on the tablespace --> in object name give the <infoobject name without 0 in case of std delivered> eg: for 0PROFIT_CTR give PROFIT_CTR

    This should give you a list of all the tables and indices with the current sizes. you can also check the growth over a period of time.

    The above procedure should work in most of the cases except the cases where the infoobject refers to different table for text (say for example 0FISCPER refers to T009C for text)

    If the Data class is not populated the you need to find the tablespace by hit and trial method (though usually the tablespace would be PSAPDW2 I think!!)

    Hope this helps

    Thanks,

    Gopal

    Add comment
    10|10000 characters needed characters exceeded