TOP 100 PSA/Changelog table list in BW on HANA
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.
- 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
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.