BW/4HANA table for DTP filter settings

[Jan_van_Ansem]

Hi all,

In older BW systems, it was quite easy to check DTP filter settings in tables directly in SE16 (RSBKDATAPAKSEL).
That table seems no longer in use in BW/4HANA. Does anyone know what table to look at?

I can find a table which gives me the filter settings of a request (RSPMDATASELECTION) - but I want to see the selections on DTP's without having to run it first.

Thanks for your help,

Jan.

[roland_szajko]

This information is stored in a hashed format, which cannot be read simply by SE16 or by an SQL statement.

You can use the program RSBK_DTP_PROPERTIES, which can list DTP-s with filters. For "fix" filters it will display the set filters, however it obviously cannot determine the routine and OLAP variable filters.

To get the filter for specific requests, an ABAP program should be written which instantiates the request and then lists it's specific filter values with which it was loaded. You can do it for example like this:

data: lr_request TYPE REF TO CL_RSBK_REQUEST,
      lr_proxy type ref to CL_RSBK_REQUEST_PROXY,
      l_tsn TYPE RSPM_REQUEST_TSN,
      lth_range TYPE RSBK_TH_RANGE.

l_tsn = <whatever TSN you want to use>.

TRY.
CALL METHOD cl_rsbk_request=>create_from_db
  EXPORTING
*    i_requid      =
*    i_process_tsn =
    i_request_tsn = l_tsn
  RECEIVING
    r_r_request   = lr_request.
 CATCH cx_rs_not_found .
ENDTRY.

TRY.
CALL METHOD lr_request->get_obj_ref_proxy
  RECEIVING
    r_r_request_proxy = lr_proxy.
 CATCH cx_rs_not_found .
ENDTRY.

CALL METHOD lr_proxy->if_rsbk_request_admintab_view~get_th_range
*  EXPORTING
*    i_get_src_reqs = RS_C_FALSE
  RECEIVING
    r_th_range     = lth_range.<br>

With the program RSBK_DTP_SHOW_FILTER you can display the filter criteria for a single DTP. This will also execute the filter routine and provide it's current result.

[MartinMaruskin]

Hi Roland, I found another program called RSBK_DTP_SHOW_FILTER. Seems that one is able to even show REQTSN values to determine a list of requests that will be extracted from the source. To me it seem that this program simulates running the DTP. Tus I assume also OLAP variables can be shown in this case. Is my understanding correct?

thanks!

m./

[roland_szajko]

I have not tested that, but the simulation evaluates all filters, so it should also show the result of an OLAP variable.