topic Re: select-options in Application Development and Automation Discussions

select-options

Former Member — Tue, 20 Sep 2005 21:23:41 GMT

Hi,

Can anybody tell me how to do the program using select-options or parameters for following scenario.

I want to search for all Vendor name's which starts with A or any alphabet using select-options and parameters dynamically. Please provide me code also.

I have written something like this : -

<b>select-options name for lfa1-name1.

select * from lfa1 where name1 in name.

write : /lfa1-lifnr, lfa1-name1.

endselect</b>.

In the selection screen (In select-options) if i enter something like a% (low range) and h% (high range). It is not displaying any names.

I don't know whether the code given by me correct or wrong. Please help me.

Thanks,

Sriram.

Re: select-options

Former Member — Tue, 20 Sep 2005 21:38:56 GMT

On the selection screen enter a. Press the right arrow beside this and enter b below the first entry.

LFA1-NAME1 is case sensitive. It would be better to select against LFA1-MCOD1, which is LFA1-NAME1 shortened from 35 to 25 characters and translated to upper case.

Rob

Message was edited by: Rob Burbank

Re: select-options

Former Member — Tue, 20 Sep 2005 22:13:50 GMT

Sriram,

I see that the SELECT statement you have coded has IN keyword instead of LIKE.

Try entering a% and then do a SELECT * from lfa1 where lifne like name.

Hope this helps. If not get back to me I will give you another solution.

Re: select-options

Former Member — Tue, 20 Sep 2005 22:19:35 GMT

Name1 is a text field and the reason why it is failing is that the text should match exactly, if you entered some name in the selection screen. Also check if the domain of lfa-name1 is case-sensitive or not. If it is case sensitive, then you should match the case also.

Srinivas

Re: select-options

Former Member — Wed, 21 Sep 2005 03:41:36 GMT

Hi Sri,

I thonk Rob is right, lfa1-name1 is case sensitive so you must enter the values in accordance with the values in the DB.

Instead of this you may use translate command to chnage the case of entered values in lfa1-name1 to upper case this will give flexibility to user to enter in any case.

Hope this wil sort out the problem.

Cheers

Amit

Re: select-options

Former Member — Wed, 21 Sep 2005 04:25:03 GMT

hi,

try with this

define one ranges r1 like lfa1-name1

data : l1 type c,

l2 type c.

r1[] = name[].

loop at r1.

l1 = r1-low+0(1).

l2 = r1-high+0(1).

if l1 <> 'a'

r1-low = ''.

endif.

if l2 <> 'a'

r1-high = ''.

endif.

if r1-low = '' and r1-high = ''.

delete r1.

else

modify r1.

endif.

endloop.

select * from lfa1 where name1 in r1

cheers,

sasi

Re: select-options

jayanthi_jayaraman — Wed, 21 Sep 2005 04:57:58 GMT

Hi,

Check this.It also discusses similar issue.

Kindly reward points by clicking the star on the left of reply,if it is useful.

Re: select-options

Former Member — Wed, 21 Sep 2005 19:11:30 GMT

Hi Rob,

Thanks very much, my problem was solved.

Thanks,

Sriram.

Re: select-options

Former Member — Wed, 21 Sep 2005 19:26:52 GMT

You're welcome Sriram. Glad to help.

Rob

Re: select-options

Former Member — Tue, 21 Oct 2008 02:26:56 GMT

Hi,

The field contains value "Sap" and I entered "sap" in the parameter. It's not displaying the result.