Below tables are relevant with respect to query elements.
RSRREPDIR – Directory of all reports
RSZCOMPDIR – Directory of reporting components
RSZELTDIR – Directory of the reporting component elements
RSZELTTXT – Texts of reporting component elements
RSZELTXREF – Directory of query element references
RSZOPRATXT – Texts of the formula operators
RSZCOMPIC – Assignment reusable component to Info Cube
RSZSELECT – Selection properties of an element
RSZCALC – Definition of a formula element
RSZGLOBV – Global variables in reporting
RSZELTPROP – Element properties (settings)
Analysis on these tables can be done via ANALYZE_RSZ_TABLES program in SE38.
It might be wise to clean up especially in large BW systems to increase performance of generating query elements like variable screen in Bex Web/Analyzer.
