topic Re: A doubt regarding Select-Options in Application Development and Automation Discussions

A doubt regarding Select-Options

Former Member — Wed, 30 Apr 2008 04:15:02 GMT

Dear Friends,

Kindly clarify whether can we use comparision operators for a field belonging to select-options.

Following is the scenario:

In my selection-screen I have posting date in select-options as s_budat.

In the Select statement I have to pickup all those documents whose clearing date is less than the range in s_budat or in other words less than s_budat-low.

I have written it as following at present

where budat <= s_budat.

shall it give me the desired result?

Pls suggest.

Regards,

Alok.

Re: A doubt regarding Select-Options

Former Member — Wed, 30 Apr 2008 04:18:23 GMT

Hi,

select-options s_budat for budat no-intervals.

in initialization event populate like below

initialization .

s_budat-option = LT.

s_budat-sign = 'I'.

append s_budat.

select ........ where budat in s_budat.

Re: A doubt regarding Select-Options

Former Member — Wed, 30 Apr 2008 04:18:31 GMT

use like this

budat <= s_budat-low.

Re: A doubt regarding Select-Options

uwe_schieferstein — Wed, 30 Apr 2008 04:19:01 GMT

Hello Alok

A date can be inside or outside a range but not not less than a range.

In your case you should use a simple parameter:


PARAMETERS:
  p_budat        TYPE d.

START-OF-SELECTION.

  SELECT * FROM ....
    WHERE ( budat < p_budat ).
...

Regards

Uwe

Re: A doubt regarding Select-Options

Former Member — Wed, 30 Apr 2008 04:19:06 GMT

Deffinately it will work.See the following code for example :


Select-Options s_budat for budat.

Start-Of-Selection.

Select * from XYZ into table ITAB where budat <= s_budat-low.

*ITAB is u r internal table

*XYZ is a DB table from where u have data.

Thats it,it will work for sure.

Reward if found helpful.

Re: A doubt regarding Select-Options

Former Member — Wed, 30 Apr 2008 04:19:33 GMT

Hello Alok-

Select-option is an internal table you cannot compare with EQ or <> keywords this type of comparision is possible with parameters.So first pull all the records by IN keyword and later delete the records as per your requirement.

Cheers,

~Srini.....

Re: A doubt regarding Select-Options

prasanth_kasturi — Wed, 30 Apr 2008 04:20:43 GMT

hi,

use like this

in select options use no intervals edition

select-options s_budat for budat no-intervals.

in initialization event populate like below

initialization .

s_budat-option = LT.

s_budat-sign = 'I'.

append s_budat.

select ........ where budat in s_budat.

regards

prasanth