cancel
Showing results for 
Search instead for 
Did you mean: 

find out filled and empty tables

Former Member
0 Kudos

Hello,

I have a query.
 

If I need to know the fill and empty tables in SAP how can I found it without going into the table.

Kindly suggest.

Best Regards.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Raheel,

You can use the program RSTABLESIZE for this.  Please enter * as input value in the input field table name. This program will list all tables with their sizes and record count.  you can sort the output based on field " Number of Lines"  to find the tables with zero records.

Please run this report in background mode to avoid timeout issues.

Thanks.

Former Member
0 Kudos

Thanks guys.

hope the solution is helpful for me.

Answers (1)

Answers (1)

former_member183424
Active Contributor
0 Kudos

You can run a table analysis from t-code TAANA

Go to TAANA, press F8 (execute), then enter the table name and give Analysis Variant = DEFAULT

Then press enter. You will get the result for number of entries of the table without going into the table.


For more details read the documentation Table Analysis - SAP Library


Former Member
0 Kudos

Thanks Dev.

Actually i have multiple (approx 30K) tables in which i need to know that if they are empty or filled. TAANA can execute one table at a time, can we have any other method for that??
I mean can we do it in more faster way?


Kindly suggest.


Best Regards

former_member183424
Active Contributor
0 Kudos

You can find the number of entries by using the statement 'select count'.

Have a look into the similar discussion

If you have the MaxDB, then you can also find this by using t-code DB50.