Skip to Content
author's profile photo
Former Member

find out filled and empty tables

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    author's profile photo
    Former Member
    Sep 12, 2014 at 10:26 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 12, 2014 at 05:44 AM

    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



    dev.jpg (70.5 kB)
    Add comment
    10|10000 characters needed characters exceeded