Table AQLDB is used for storing data of SAP Queries created via SQ01 queries. Cleaning this up can be tricky job.
Deletion of old query data
Deletion of old SAP query data is performed via program RSAQQLRE_MASS:
Background OSS note: 2336268 – SQ01: Reorganization of saved lists.
In case of inconsistencies, install program Z_INCONSISTENT_SAVED_LISTS from OSS note 2173291 – Saved List cannot be deleted by program RSAQQLRE.
Clean up of generated programs
Program RSAQDEL0 can be used to clean up generated query program data:
System queries, generated programs and obsolete programs can be cleaned up.
Background notes: