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

Bookmark Details - Where are they stored?

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

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Mar 30, 2004 at 08:04 AM

    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

    Add comment
    10|10000 characters needed characters exceeded