From the HANA Studio, open the SQL console. Execute the following command,
SELECT SCHEMA_NAME,TABLE_NAME,DISK_SIZE FROM PUBLIC.M_TABLE_PERSISTENCE_STATISTICS ORDER BY DISK_SIZE DESC
The result as below screenshot. The max rows will determine how many tables to be listed. You can put to any number to list all possible tables.
If you are looking for 1 table size, use the filter function.
Enter the table name and press Execute. You will get the output table size.
Alternatively, use SAPGUI to determine the table size. Execute transaction code DB02. Double click on Table/Views under the Diagnostics.
The table size as below,
Note
You can add multiple filters which mean you can look up for different schema, table and size.
