Bookmarks in BW 7.x - how to read RSWR_DATA

[Former Member]

Hi,

I am trying to find out what selections were stored together with the bookmarks created by the end users. The web reporting we are using is done in BEx 7.x.  I do not want to execute each of the bookmarks separately (there is about 1000 of them). I would like to find the information in the tables.

There is a table with bookmarks RSWR_DATA, it contains XDATA field, which might contain information I need, but it is stored as X-String.

So I found a static method that allows me to convert X-String to String CL_BCS_CONVERT=>XSTRING_TO_STRING.

The problem is that when I am trying to display RSWR_DATA-XDATA in SE16, only part of the long X-String is displayed, so I do not have the complete X-String ready to be copied.

Is there any way to get the complete X-String, so that I could see its contents in a format that is easy to read?

Or maybe there is another way that would give me the possibility to check what is behind the bookmarks?

Best regards,

Leszek

[former_member186696 · Accepted solution]

Hello Leszek,

You have to create a program to do what you want.

Please, refer my code. This could help you:

*&---------------------------------------------------------------------*

*& Report  ZPFM_TEST

*&

*&---------------------------------------------------------------------*

*&

*&

*&---------------------------------------------------------------------*

report zpfm_test.

  parameters p_id     type rswr_data_id.

  data lv_rawdata   type xstring.

  data lv_string    type string.

  select single xdata from rswr_data into lv_rawdata

      where id = p_id.

  lv_string = cl_bcs_convert=>xstring_to_string( iv_xstr = lv_rawdata

  iv_cp = '1101' ).

  write lv_string.

The write has a limmitation of 72 char, but you can see the content (if you want) on debug mode.
Just set a break point in the end of this code and check the structure lv_string

I hope it helps.

Kind regards,

Edward John

[Former Member · Accepted solution]

Hi John,

Thanks for the code. I've been thinking about this option too, but the problem is that I need it on the production system and I would like to avoid transporting this ABAP there.

Any other option to do that w/o having to involve the change management process?

Best regards,

Leszek