Deletion of workbooks/queries from roles/favorites

[Former Member]

Hi

I have written a program to delete ZZ queries (and workbboks too if they have workbboks attached). it works fine. But i find them in my favorites/roles.

I want to delete them from there too. can anyone please guide me a function module or the table name where the relation between query and favorites is maintained??

I did look for it and cudnt find any. Would appreciate if someone can throw some light on this.

thanks

Prakash

[Former Member · Accepted solution]

SMEN_BUFFI table stores 'favorites'.

And SMEN_BUFFC table also.

Message was edited by: Ajay Das

[Former Member]

Have you tried transaction RSZDELETE. This does this. (The program is COMPONENT_REORG).

[Former Member]

Hi Prakash,

Have you checked note 385219?

I suppose the relation between query and workbook you have already.

FM RSBB_WORKBOOK_AGR_GET checks if a workbook has favorites or roles attached.

Hope this helps.

Kind regards

Klaus

[Former Member]

Hi Folks

Thanks for your prompt response.

I found a FM RSZ_DB_COMP_REORG. I have borrowed some code from here. My report is done.

Thanks

Regards

Prakash