What is TC/table to get list of tables with no of records it contents ?

[Former Member]

Dear all,

I want to get list of tables with total no. of records it contents .

e.g.

Table MARA , in SE11 we can get no .of records 80,000

Table MSEG , in SE11 we can get no .of records 1,50,000...

Table AUFM , in SE11 we can get no .of records 70,000

.....................

How to find ? I there any TC or Table ?

[former_member204746]

at DB level, if Oracle:

select count (*) from sapr3.MARA;

[Former Member]

Pl' give table name in which all table names with total no. of records r stored ..........

[former_member204746]

Sorry, but no table contains this information. you must run SQL requests on every single table to get that information.

[Former Member]

Hai,

I guess the possible way to write a sript at DB level to output all the DB tables and no.of records inside it.

You can get some readymade scripts, but use it at your own risk.

Regards,

Yoganand.V