DTP rountine with Multiple Single Values

[former_member783348]

Hi,

I want to build a routine in DTP to use sql statement to search the database table get required update document numbers and to set filter for fields document number.

How could I pass the internal table value in I_t_range? I saw the example input the value range in I_t_range. But my sql statement output is multiple rows, I try to saved the output in internal table, but I don't know how could I pass the internal table in I_t_range in order to filter multiple Single Values from source system.

[Abhishek_Hazra]

When you talk about DTP routine & l_t_range, it is ABAP, where are you using the sql? And where have you created your internal table?

[former_member783348]

Hi Abhishek,

I create internal table and sql in DTP routine.

Below is the code I am using to get reverse doc. number range in BW DSO and filter data source in range,

I want to modify the code to filter data source with multiple value, I am not sure this change is feasible or not.

form c_BELNR
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 = 'BELNR'.
l_idx = sy-tabix.
*....
DATA:
ZREV_DOC_MIN TYPE C length 10,
ZREV_DOC_MAX TYPE C length 10.

SELECT distinct MIN( REV_DOC ),MAX( REV_DOC )
INTO ( @ZREV_DOC_MIN, @ZREV_DOC_MAX ) FROM /BIC/AZFI_GL_142
WHERE ( DATE_FMTIME = @sy-datum ) AND ISREVERSAL = 'X'.

l_t_range-low = ZREV_DOC_MIN.
l_t_range-high = ZREV_DOC_MAX.
l_t_range-fieldname = 'BELNR'.
l_t_range-iobjnm = '0AC_DOC_NO'.
l_t_range-sign = 'I'.
l_t_range-option = 'BT'.
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.

[Abhishek_Hazra]

You mean open sql, since the codes are still in ABAP? And yes it is possible to pass multiple values in the DTP filter. I have mentioned in answer.

[Abhishek_Hazra · Accepted solution]

Hi jackylai,

Yes, from your given code snippet, let's assume the internal table where you have all the filter entries is : lt_temp (with necessary work area/field symbol declaration). You just have to add a loop to assign the values one by one in the filter range table at the end of the code like below :

LOOP AT lt_temp INTO l_temp .

l_t_range-fieldname = 'BELNR'.
l_t_range-sign = 'I'.
l_t_range-option = 'EQ'.
l_t_range-low = l_temp-BELNR.

APPEND l_t_range.

This will work as you want 🙂

Best Regards,
Abhi

[former_member783348 · Accepted solution]

Hi Abhishek,

Thank you so much.