topic Re: Table size in Application Development and Automation Discussions

Table size

volker_ruehl2 — Tue, 28 Feb 2006 17:55:30 GMT

Hi,

I want to calculate the table size correctly. I found out about two possibilities.

First multiply the number of rows with the total ABAP table width.

Second look into db02 with the table name.

Unfortunately these two calculations don't match each other, as I have about double the size within db02 than I calculated previously. Can someone explain me this, or is there another good transaction or possibilitity to calculate the exact table size on the database?

Re: Table size

former_member181966 — Tue, 28 Feb 2006 18:17:53 GMT

Checkout the FM`S in SE37

/BKC/RFC_GET_TABLE_SIZE

/SDF/INF_TOP_TABLES

/SDF/MSS_TEXT_IMAGE_FIELDS

GET_TABLE_SIZE_DB4

GET_TABLE_SIZE_DB6

MSS_GET_DB_SIZE_DETAILS

MSS_GET_SCHEMA_SIZE_INFO

MSS_GET_TABLE_SIZE_INFO

SFMSS_SIZE

GET_TABLE_SIZE_MSS

Pl also award the points .

Thanks

Re: Table size

volker_ruehl2 — Tue, 28 Feb 2006 19:51:00 GMT

When you look into se16 you just get the number of rows for this client, while db02 shows the table size over all clients. Therefore the tables size didn't match my calculations.