Query Mass Move to a Sepcific Folder

[Former Member]

Hi Folks,

we allow users to create queries direcly in production. From time to time we run statistics reports to identify queries no longer used e.g. no executions last 3 months.

We now would like to move all those queries to a "To be deleted Query Folder".

Doing this manually is quite tedious therefore we are wondering if anyone had figured out where the folder references are stored and if they can be changed with a simple ABAP.

Can an ABAP then also execute a deletion of a query? (which would then be the next step...)

All replies really appreciated.

Best regards,

Axel

[Former Member]

Hi Axel,

Did you ever get solution for this?

Thanks

[Former Member]

No. But we came up with the approach to create a copy of the queries we think that can be deleted via transaction rszc. Delete all needed -> if complains restore from the copy.

[Former Member]

Any one out there?

[former_member182470]

Hi Axel,

Your Requirement is very interesting. Unfortunately I am not knowledged in ABAP. To get better responsess, raise this question in ABAP Development forum.

Regards,

Suman