Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.