Skip to Content
0
Former Member
Jan 30, 2013 at 10:06 AM

Change of "Static Filter" in Variable Exit RSR00001

209 Views

Hello Sap Community and Gurus.

I've created BEx Query which determines the change of Usernames for some period.

Query receives user input as Date Interval, e.g. 20.12.2012 - 20.01.2013.

So, I've writed code in ZXRSRU01 which takes this interval, and calculates the set of appropriate User_IDs.

My Query has some specific with compound keys, and I want to generate report of such structure:

USER_ID DATE NAME ID1 Date1.1 Name1.1
Date1.2 Name1.2 ID2 Date2.1 Name2.1 Date2.2 Name2.2 ID3 Date3.1 Name3.1 Date3.2 Name3.2

So, we want to get 2 records for each User_ID.

And here I have problem. My Customer-Exit subroutine calculates this ID's set correctly...

And everything would be just fine, if it was I_STEP = 1 (this was confirmed practically).

But in this case Date Interval becomes "Static Filter" (perhaps, it is also a "Dynamic Filter, not sure about it)

And it NARROWS the results, throwing of half of records, like this.

USER_ID DATE NAME ID1

ID2

ID3

I've tried to delete this Filter by such code (Using it both in I_STEP=2 and in I_STEP=3 blocks)

LOOP AT i_t_var_range
INTO LOC_VAR_RANGE1
WHERE vnam = 'Z_DIZMBT'.

LOC_VAR_RANGE1-LOW = ''.
LOC_VAR_RANGE1-HIGH = ''.
MODIFY I_T_VAR_RANGE FROM LOC_VAR_RANGE1.

ENDLOOP..

Or this code:


WHEN ''

IF I_STEP = 3.

DELETE I_T_VAR_RANGE WHERE VNAM = 'Z_DIZMBT'

ENDIF.

And they successfully modify/delete the record from I_T_VAR_RANGE, but unfortunately, It doesn't help.

So, maybe I don't understand something about I_STEP=2 correct?

Can this Filter be modified with ABAP, or maybe desicion is somewhat other?

Thanks in advance.