Bookmarks on a Query ID

[Former Member]

Is there a way to get Bookmarks based on a Query ID, I have gone thru all the RSZ Tables and I see there is no way to get Bookmark and Query Relation information.I have read in previous threds that there can be custom program to get this Information. Please le t me know if there is any custom program or any function module to get this Inforamtion.

Thanks,

Sam.

[Former Member · Accepted solution]

Hi Sam,

If you are ready to do some manual work on this...there is a way...!!!

Goto the class: CL_RSZ_WWW_DB_INTERFACE->open a method and click "execute"

Search for a method called: GET_VIEWIDS_IN_BOOKMARKS -> execute

Open another 2 sessions and goto se11: enter tables RSZWBOOMARK and RSZWVIEW.

Give your bookmark ID in bookmark table and get its timestamp.

In the above class, give this timestamp and execute WITH DEBUGGING....

Get into the method:

CALL METHOD CL_RSZ_WWW_DB_INTERFACE=>GET_VIEWIDS_IN_BOOKMARKS

using the F5 key...

Do F6 (line by line executijn) until you come up to the line

l_s_id_objvers-objid = l_bookmarkid.

Replace the value of l_s_id_objvers-objid in abap debugger with you BOOMARK ID(since internally somethign goes wrong to pick up your correct bookmarkid) and execute line by line until you reach APPEND l_s_attribute-name TO r_t_viewid.

The value you get in : l_s_attribute-name will finally have the VIEW ID for your bookmark.

Internally all the bookamrks are stored as Query views !!!

Use this ID in your another SE11 session table RSZWVIEW -> your ID.

The field COMPID gives you the query name exactly !!!

I hope this will be helpful to you...I can aslo write a report but I'am not a developer at your place:-)

Go ahead and have fun:-)

Cheers,

Emmanuel.

[Former Member · Accepted solution]

I will run this steps and I will write up an ABAP program if this logic works. Thank you for spending time on this.

Really Apprecciate and Will Assign you points.

Thanks,

Srikanth

[Former Member]

Thank you for the reply. I have looked at the program and it only gives the Bookmarks and User details for a particular bookmark.

My requirement is that i need to get all the Bookmarks based on a Query ID or if given a Bookmark i should be able to identify the Query from which the Bookmark is created.

[Former Member]

That program can do both your requirements. If you run the program and leave all the entry field blank, except for the Time of Attachment To field (set to current date), the program will now list all bookmarks created in the system. To get a list of all the bookmarks on a specific report filter the Object Name column to the report. If your query is embedded in a template the bookmark will be against the template. If you want to find a report from a bookmark just get the bookmark ID from the bex portfolio prompt then use the find functionality in the program on the Bookmark column to find it.

Josh

[Former Member]

Thank you for the Reply.

In the Report(RSWR_BOOKMARK_REORG) Object Name is displayed and we can the Filter based on an Object name.My issue is our queries use the standard web Template and have the same Template for all the Bookmarks.

In our case we have Object Name ( 0ANALYSIS_PATTERN) for all the Bookmarks, so i have no way to say what query is running behind, I can understand that the report will help if the queries are assigned to a Web Template,

[Former Member]

Hi Sam

Try transaction SE38 , program RSWR_BOOKMARK_REORG

Hope this Helps

Josh