Space occupied by tables.

[Former Member]

Hi everybody,

I want to know some info regarding the memory space occupied by each and every individual table. DB02 transaction gives me the entire staticstics and not the statistics of space used by each and every individual table. is there any transaction or any other location n SAP where i can find this info?? i also need to know when a table was used last.. for example if i am using a select statement on a table i want to know the time and date when it happened. is there any transaction or any place where these info gets stored??? please let me know as quickly as possible.

Thanks in Advance.

Best Regards,

Venkat.

[Former Member]

Hi everybody,

I want to know some info regarding the memory space occupied by each and every individual table. DB02 transaction gives me the entire staticstics and not the statistics of space used by each and every individual table. is there any transaction or any other location n SAP where i can find this info?? i also need to know when a table was used last.. for example if i am using a select statement on a table i want to know the time and date when it happened. is there any transaction or any place where these info gets stored??? please let me know as quickly as possible.

Thanks in Advance.

Best Regards,

Venkat.

[sourabhshah]

hi,

Hopefuly this will help.for more info take f4 on dd* these tables have info about all ddic objects.

DD02ALL Table Parameters for ALLBASE

DD02DB2 DB2/390: Table Parameters

DD02DB6 Table Parameters for DB2 Version 2

DD02INF Table Parameters for INFORMIX, Version 6

DD02L SAP tables

DD02MSS Table Parameters for Microsoft SQL Server

DD02ORA Table parameters for ORACLE, version 6

DD02SYB Storage Parameters for Tables in SYBASE

DD02T R/3 DD: SAP table texts

DD03L Table Fields

Regards,

Sourabh