Select Data in DTP Dynamically

Similarly to selecting parameters dynamically in the infopackage, as discussed in the previous post, we may need to select parameters dynamically in a DTP. In the post below I will review an example of how to make selections dynamically in the DTP. A practical application of this approach can be selection of records from a DSO by date range, say we want to select all records with Date From lower than [Today + 30 days] and Date To greater than [Today - 30 days].

In the Filter selections for the DTP we have to click on the “Routine create” button for the infoobject we want to use:

As DTP selections are stored as a range we have to populate fields of the table l_t_range with appropriate selection parameters.

For the object “Date From” the selection routine may look as follows (we select all records with the Date From before [Today + 30 days]):

form compute_RT_DATEF

  tables l_t_range structure rssdlrange

  using i_r_request type ref to IF_RSBK_REQUEST_ADMINTAB_VIEW

        i_fieldnm type RSFIELDNM

  changing p_subrc like sy-subrc.

*       Insert source code to current selection field

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

data: l_idx like sy-tabix.

          read table l_t_range with key

               fieldname = 'RT_DATEF'.

          l_idx = sy-tabix.

*....

DATA: cd TYPE D.

          cd = sy-datum.

          cd = cd + 30.

          l_t_range-fieldname = 'RT_DATEF'.

          l_t_range-sign = 'I'.

          l_t_range-option = 'LE'.

          l_t_range-low = cd.

          if l_idx <> 0.

            modify l_t_range index l_idx.

          else.

            append l_t_range.

          endif.

          p_subrc = 0.

*$*$ end of routine - insert your code only before this line         *-*

endform.