topic ABAP : DDIC in Application Development and Automation Discussions

ABAP : DDIC

Former Member — Thu, 13 Mar 2008 11:58:02 GMT

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.

Re: ABAP : DDIC

Former Member — Thu, 13 Mar 2008 12:15:40 GMT

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

Re: ABAP : DDIC

Former Member — Thu, 13 Mar 2008 12:18:13 GMT

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

Re: ABAP : DDIC

Former Member — Thu, 13 Mar 2008 12:30:53 GMT

Hi,

DD02L gives the list of all tables.

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

Regards

Sandipan

Re: ABAP : DDIC

Former Member — Thu, 13 Mar 2008 12:31:21 GMT

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