Skip to Content
Former Member
Former Member
March 3, 2014 1 minute read

Simple way of finding list of PSA tables and Size in BW system

Follow RSS feed
0 Likes 2,803 Views 11 Comments

Most of the times, we would like to know complete information about PSA tables to perform system cleaning and to keep space available for system performance as part or System Maintenance.

1)  First we need to find list of PSA tables available in BW system. To achieve this we need to go to DB02 Tcode first and select “Tables and Indexes” as shown given below.

1 - Tables and Indexes.png

2) Provide input as shown given below and hit enter.

2 - proivde input.png

3) You will get the information as shown given below.

3 - List of tables.png

4) Now perform sorting on size in descending order. Here we will get to know the PSA tables according to their size.

4 - Table sizes in sorting order.png

5) Now based on the table name, we can find the data source information.

Please go to SE11, provide PSA table name for which you want to find the Data Source Name as shown given below.

5 - Data Source Name.png

With this information, we can find the PSA table sizes and their data source names to take action further to keep system clean.

Hope this will help you.

Regards,

Ravi K Chandragiri

Assigned tags

Related Blogs

    Related Questions

      11 Comments
      You must be Logged on to comment or reply to a post.