DATA BASE TABLES

[Former Member]

Hi All,

I Have some records (say 10,000) in my Data Base table.

I need to find <b><u>How much size that table occupies in the database.</u></b>

ALL The Best,

Mahesh.

[Former Member]

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 .

[Former Member]

Go to SE11. Enter the table name and Choose Display.

Go to Utilities -> Runtime Object -> Display

Under Header of active runtime object the fourth column i.e Table length gives you the maximum size of a single record of the table.

Note this is the maximumsize and not the actual size a record would occupy in the database.

-Kiran

*Please reward useful answers

[Former Member]

Hai Mahesh

Check the following F.M

GET_TABLE_SIZE_INFO_DB2

GET_TABLE_SIZE_DB2

GET_TABLE_SIZE_DB4

GET_TABLE_SIZE_ADA

GET_TABLE_SIZE_INF

GET_TABLE_SIZE_DB6

GET_TABLE_SIZE_MSS

GET_TABLE_SIZE_ORA

GET_TABLESIZE_ORA_OLD

GET_TABLE_SIZE_ALL

Thanks & regards

Sreenivasulu P

Message was edited by: Sreenivasulu Ponnadi

[Former Member]

Hi Mahesh,

U can use this FM : <b>DB_GET_TABLE_SIZE</b> which will give u the size in KB.

If it helps, please do reward.