cancel
Showing results for 
Search instead for 
Did you mean: 

Table Size: Standard report?

patricia_roln
Explorer
0 Kudos

Hello,

I need to know the total size of a table and the partial size of that table in the different SAP clients of an instance. Do you know if there is a standard report to obtain this information? If not, how can I do this?

Thanks!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Your best bet would be to do a Select mandt, count(*) from tablename, group by mandt to see how many records are in each client. From there it is just a simple algebra problem.

Russell Hull

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi

As russel mentioned, please do mandt, and ount the number of records here. From there on you can calculate the total size numerically.

Thanks

Subbu

Former Member
0 Kudos

I do not know of any standard report for this. Measuring size by client is difficult since there are not separate tables for each client. You should be able to pull some size information from DB02.

Hope that helps.

J. Haynes

Denver, CO US