List of tables by no. of records

[gergt]

Hi,
I am running SAP R/3 v4.6C on Oracle/Wintel and I wish to do a listing of tables by no. of records (or at least the top 50). Transaction db02 is close (by size) but not quite and se16 allows for individual tables, but not, as far as I know, a report.
Any assistance would be appreciated.
Gerg

 

[hoinz]

Hi,
as far as I know there isn't an SAP report for this.
When I have to do tasks like this, I use Oracle's sqlplus.
Is this an option for you?
Or you may create your own report using native SQL.
hope this helps

 

[gergt]

Thanks, I'll give it a try
Gerg