TOP 100 PSA/Changelog table list in BW on HANA

[shanthi_bhaskar]

I would like to share code snippet for identifying the Top 100 Changelog/PSA table list along with size it's consuming. This would be very helpful for house keeping activities.

SELECT

1. M."TABLE_NAME",D."DDTEXT" as TABLE_DESC,

SUM(M."MEMORY_SIZE_IN_TOTAL") as DBSIZE,

CAST(sum(M."MEMORY_SIZE_IN_TOTAL" / 1073741824.0) AS DECIMAL(10, 2)) AS DBSIZE_DB

FROM M_CS_TABLES M

INNER JOIN SAPDP1."DD02T" D

ON M."TABLE_NAME" = D."TABNAME"

WHERE TABLE_NAME like '/BIC/B%00'

GROUP BY M."TABLE_NAME", D."DDTEXT"

ORDER BY  DBSIZE DESC

LIMIT 100

We can alter list by changing the LIMIT value

Modified the SQL which would show the descriptions of the PSA or Changelog table name...I intentionally didn't give the output of mine.

Thanks,

Shanthi Bhaskar