Bookmark Details - Where are they stored?

[Former Member]

I have been trying to get to the table(s) where all the BW Bookmark information is located.

After several attempts on OSS I know that, while running RSRT, I can see the details (via debug) for the specific bookmark I'm working with.

OSS was great in terms of telling me what class/method to debug. They also said that they didn't have more information about where all the Bookmarks are stored.

Anyone tried to get this information?

We'd like to do an inventory of the 13,000 bookmarks that we have in our system, which would allow us to get more of a feel for what variables and columns people are using....not just the "header" info.

I am familar with the n_sx_request "deep structure" as well as the RSZM* bookmark tables.

Thanks for the help.

Bill Gerlach

gerlacwr@apci.com

[Former Member]

Hi,

As far as I know, if you create a bookmark

basically a view is created in the background.

Bookmark data is stored in

(Cluster-)Table RSZWOBJ (Relid = BM)

You can get the data with:

data: i_bookmark TYPE RSZWBOOKMARK.

data: i_sx_bookmark TYPE RSZW_SX_BOOKMARK .

CALL METHOD CL_RSZ_WWW_DB_INTERFACE=>GET_BOOKMARK

EXPORTING

I_BOOKMARKID = '3O44HOR9X5KJOX9C9JOMZCD6O'

I_OBJVERS = RS_C_OBJVERS-ACTIVE

IMPORTING

E_S_BOOKMARK = i_bookmark

E_SX_BOOKMARK = i_sx_bookmark.

in i_sx_bookmark-DP_LIST youl find the

dataprovider (View).

e.g. 3T9Z8AK475LWCJD3F2B5MKZ40

Then use following method to get the view information:

data: s_view TYPE RSZWVIEW.

data: s_view_txt TYPE RSZWOBJTXT.

data: sx_view TYPE RRX1_SX_VIEW.

CALL METHOD CL_RSZ_WWW_DB_INTERFACE=>GET_VIEW

EXPORTING

I_VIEWID = '3T9Z8AK475LWCJD3F2B5MKZ40'

I_OBJVERS = RS_C_OBJVERS-ACTIVE

I_LANGU = SY-LANGU

IMPORTING

E_S_VIEW = s_view

E_S_VIEW_TXT = s_view_txt

E_SX_VIEW = sx_view.

you'll find information about variables etc in

sx_view.

Kind Regards,

Alican