How can I get DTP filter values of a DTP request as filter value for another DTP?

[yj]

Dear all,

Currently we convert our system in preparation to BW/4.

In a data flow we have the following szenario: We load data per infopackage from the source system with a custom routine for the time frame. We have two infopackages with different time frames. In the next level of the data flow, we load the data from the PSA table per DTP in an ADSO. In this DTP, we determine which infopackage was used and take the filter values from this infopackage to get the same time frame as filter in this DTP. The reason is, that we need to delete the old data within the same time frame first before loading the new data.

Now the question is, how we can make the same szenario  with a DTP instead of an infopackage. How can we get the filter values of the DTP request? I had a look at the known DTP tables, but I cannot find the information.

Thanks,
Yvonne

[roland_szajko · Accepted solution]

Hi Yvonne

You can do it like this:

      TRY.
          l_r_rsbk_request = cl_rsbk_request=>create_from_db( i_requid = requid ).
        CATCH cx_rs_not_found.
  ....
      ENDTRY.
      TRY.
          l_th_range = l_r_rsbk_request->get_th_range( i_for_ui = rs_c_false ).
        CATCH cx_rs_not_found.

br

Roland

[yj · Accepted solution]

Hi Roland,

Thank you.
Then we have to determine the correct request ID before, haven't we?

Regards,
Yvonne

[roland_szajko · Accepted solution]

Yes. In order to get the filter of a specific request, you must know the request.

But I'm surprised that you ask this, since you asked the question: "How can we get the filter values of the DTP request?", which implies, that you already have a specific request (or requests) for which you want to get this information.

[yj · Accepted solution]

Yes, that's correct. We get the request ID from table RSPMREQUEST - or do you have another idea?

[roland_szajko · Accepted solution]

Yes, you can get the requests of a specific ADSO from rspmrequest.