Both of the methods are tested in Oracle database environment. Some of the steps may be the same as other databases.
Method 1
Execute transaction code DB02OLD. Click on Detailed analysis. A pop up box will appear. Put 1000000 on the Size/ kbyte > and check the Index-Type info.
Click on the first entry under KBytes and press F8. The screen will refresh to the highest size of the table.
Method 2
Execute transaction code DB02. At the left panel, double click on Overview under the Segments tab.
You will get the following screen on the right panel. Jump to Top Sizes tab and sort the following tab of Type to TABLE. You will get the list of largest table in the SAP system.
