cancel
Showing results for 
Search instead for 
Did you mean: 

Show largest tables in SAP

Former Member
0 Kudos

Hello,

I would like to extract 25 largest tables from SAP (not logging on to DB). How can I get a list of these tables? Using which options from DB02 can this info be extracted? Please guide.

Regards,

Atul Lotlikar.

Accepted Solutions (1)

Accepted Solutions (1)

former_member204746
Active Contributor
0 Kudos

tcode: DB02OLD

click on "Detailed Analysis"

"Object type" TABLE

"Size / kbyte >" 1000000 (1 million)

click on "Green check"

under the KBytes colum, click on the first entry.

Press F8

There ya go, you have the biggest tables in your database.

note that this does not include indexes and does not summarize partitioned tables.

Answers (1)

Answers (1)

hemanth2
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Atul,

Another way to get this is to login to your server and run the ABAP report ->RSORA085

This will give you a complete analysis of your database with the size of the tables , everything...

regards,

hemanth

former_member204746
Active Contributor
0 Kudos

report RSORA085 is very interesting, but unfortunately, it does not provide top tables in order.