ABAP : DDIC

[Former Member]

Hi,

I would like to know if there is any system table which stores the transparent table name and the no. of entries present in it. I basically want to list the large volume tables for performance related issues.

[Former Member]

Hi,

I would like to know if there is any system table which stores the transparent table name and the no. of entries present in it. I basically want to list the large volume tables for performance related issues.

[Former Member]

hey,

you can get all the table names from the table :DD02L

then one by one pass the table names in the function module TABLECOUNT which will return you the number of entries in that table

rest all processing you can do according to your requirement

[Former Member]

i dnt think so there is any database table that has the name as well the number of entries of table.

you have to write a simple abap code for that and your query is solved.

hope it will help

[Former Member]

Hi,

DD02L gives the list of all tables.

Fm Table count returns the no. Of records In a Table.

Regards

Sandipan

[Former Member]

DD02L is the table name.

The function module TABLECOUNT has the no of entries in table.

If you want to know all the field in a table dd03l.

Thanks

Swarna