on 03-02-2008 1:31 AM
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!
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.