topic Re: Is it possible to dynamically replace a comparison operator? in Application Development and Automation Discussions

Is it possible to dynamically replace a comparison operator?

Former Member — Thu, 06 Aug 2009 10:04:36 GMT

Hi folks,

Is it possible to change a comparison operator dynamically? For example:

IF A = B.

then w_operator = '>' .

else.

w_operator = '<'.

Select * From ZTABLE where DATE w_operator SY-DATUM.

Your help is greatly appreciated.

Re: Is it possible to dynamically replace a comparison operator?

Former Member — Thu, 06 Aug 2009 10:17:16 GMT

Hi,

Well am not sure if that is possible , anyway u can use the normal method as i dont see any harm in using it performance wise.



if A = B.
Select * From ZTABLE where DATE  > SY-DATUM. 
else.
Select * From ZTABLE where DATE  < SY-DATUM. 
endif.

Regards,

Vik

Re: Is it possible to dynamically replace a comparison operator?

sridhar_meesala — Thu, 06 Aug 2009 10:20:14 GMT

Hi,

Insted you can write your query directly like this:

IF A = B. 
 Select * 
 From ZTABLE 
 where DATE GT SY-DATUM.  
ELSE. 
Select * 
 From ZTABLE 
 where DATE LT SY-DATUM. 
ENDIF.

Thanks,

Sri.

Re: Is it possible to dynamically replace a comparison operator?

Former Member — Thu, 06 Aug 2009 10:28:15 GMT

Hello friends,

Thanks for your replies, However, there is far more involved than I have written in my example. I tried to give a very simplified pseudo code. My objective is exactly the opposite of the suggested solutions so far. That is to say, I'd like to avoid repeating the same SELECT statement twice lest a minor difference.

Thanks for your input. Am still listening.

Re: Is it possible to dynamically replace a comparison operator?

kesavadas_thekkillath — Thu, 06 Aug 2009 10:34:39 GMT


TABLES:mara.

DATA:w_operator TYPE c.
DATA:a TYPE i,b TYPE i.
DATA:LT TYPE C VALUE '<',GT TYPE C VALUE '>'.

TYPES:BEGIN OF ty_where,
      where_clause TYPE char255,
    END OF ty_where.

DATA:it_where TYPE TABLE OF ty_where,
     wa_where TYPE ty_where.

a = b = 1.

IF a = b.
  w_operator = GT .
ELSE.
  w_operator = LT.
ENDIF.

CONCATENATE 'DATE' w_operator sy-datum INTO wa_where-where_clause SEPARATED BY space..
APPEND wa_where TO it_where.


SELECT SINGLE * FROM mara   WHERE (it_where).

Edited by: Keshu Thekkillam on Aug 6, 2009 4:14 PM

Re: Is it possible to dynamically replace a comparison operator?

RaymondGiuseppi — Thu, 06 Aug 2009 10:47:49 GMT

Use a RANGE and an IN operator, like

DATA r_date TYPE RANGE OF syst-datum WITH HEADER LINE.

REFRESH r_date.
CLEAR r_date.
r_date-sign = 'I'.
IF A = B.
  r_date-option = 'GT'.
ELSE.
  r_date-option = 'LT'.
ENDIF.
r_date-low = sy-datum.
APPEND r_date.

SELECT * FROM ztable WHERE date IN r_date.

Regards,

Raymond