Where Is Table That Contains DTP Filter Entries?

[Former Member]

Hi,

I am trying to find the table where my "Filter" entries for a DTP are contained. I would like to use these entries in my start routine. In the old 3.5, the table was RSSELDONE, but I can't seem to find the NW04S version of this table.

Thanks for your help.

[Former Member · Accepted solution]

P-Dub:

To date I have not found a table that specifically contains the DTP filter entries. If you are looking for a way to access this information from a transformation though, you may reference following logic:

create an internal table (itab) of type RSBK_S_RANGE in the local portion of a start routine.

fill the internal table (itab) as follows:

itab[] = p_r_request->GET_TH_RANGE( ).

The selection criteria of the DTP will then be available within your transformation in the internal table itab.

All DTP attributes at run time can be accessed in this way. For a list of the methods available, look at the interface if_rsbk_request_admintab_view, know as p_r_request in the start routine.

==============Start Routine CODE Example - BEGIN==============

----

---

• Method start_routine

----

---

• Calculation of source package via start routine

----

---

• <-> source package

----

---

METHOD start_routine.

*=== Segments ===

FIELD-SYMBOLS:

<SOURCE_FIELDS> TYPE tys_SC_1.

DATA:

MONITOR_REC TYPE rstmonitor.

$$ begin of routine - insert your code only below this line -

... "insert your code here

DATA: i_dtpfilter type standard table of RSBK_S_RANGE

initial size 0.

break CONTDG.

i_dtpfilter[] = p_r_request->GET_TH_RANGE( ).

==============Start Routine CODE Example - END=================

Good luck,

The Dude

[Former Member]

Hi Ragini/Chetan,

Thanks for the quick response. It looks like RSBSKSELECT is the table that I need, but for some reason my table has 0 records. Are you guys experiencing the same thing?

FYI, I'm on SP11.

Thanks.

[Former Member]

Dont have system in front of me, may Ragini or some one can confirm pls.

Hope it Helps

Chetan

@CP..

[Former Member]

Hi P-Dub,

It is a simple search that you can do yourself. most of the BI Related tables you can search using SE80->Application Hier/Data base Tables->BW->BW-WHM->BW-WHM-DST-> There you can see tables related to Data Transfer.

Hope this helps.

Thanks,

Alex.

[Former Member]

Hi Alex,

Thanks for your hint. After reviewing the list, it still looks like RSBKSELECT is the would/should contain the entries that I need, but the table is empty.

Can anyone confirm if there are entries in this table if you have Filter Entries in your DTP?

Thanks, Paul

[Former Member]

Same here, No entries in the above said table though we have selections in DTP's

[Former Member]

Thanks Voodi

[Former Member]

You may wish to look at these tables

RSBKREQUEST DTP Request

RSBKREQUEST_V View of DTP Request

More insights-

RSBKBP Breakpoints

RSBKDATAINFO Information on DTP Runtime Buffers

RSBKDATAPAKID DTP: Status Table for Data Packages

RSBKDATAPAKSEL DTP: Data Package Selections

RSBKDTP BW: Data Transfer Process Header Data

RSBKDTPH DTP: Historic Versions

RSBKDTPSTAT Status Information on Data Transfer P

RSBKDTPT Texts on Data Transfer Processes

RSBKDTPTH Texts on Data Transfer Processes

RSBKPATH Properties Path

RSBKREQUEST DTP Request

RSBKREQUEST_V View of DTP Request

RSBKREQUESTRUN DTP Requests

RSBKSELECT Selections for DTP Request (Summary)

RSBKSUBSTEP Properties of Substeps in a DTP

Hope it Helps

Chetan

@CP..

[Former Member]

Check these tables:

RSBKDATAPAKSEL DTP: Data Package Selections

RSBKSELECT Selections for DTP Request (Summary)