Skip to Content
author's profile photo Former Member
Former Member

Deletion of workbooks/queries from roles/favorites

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 05, 2006 at 09:21 PM

    SMEN_BUFFI table stores 'favorites'.

    And SMEN_BUFFC table also.

    Message was edited by: Ajay Das

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 06, 2006 at 07:11 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 08, 2006 at 01:47 AM

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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.