topic Re: Select options in Application Development and Automation Discussions

Select options

Former Member — Fri, 06 Jul 2007 08:55:53 GMT

Hi ALL,

select lfart,lfdat,....

from likp

into..

where

lfart in s_lfart

and lfdat in s_lfdat

and..

when ever i select "=" option throgh multiple selection for a select option field(lfart) on selection screen.then the abov select query is failing since s_lfart is not initial.hw can i resolve it (even though i have used between in select query ).

hw to write the abv query when "=" is selected on the selection screen for that field.

Thanks&Regards,

Padma.

Re: Select options

seshatalpasai_madala — Fri, 06 Jul 2007 08:59:04 GMT

Hi,

In that case you can think of using FOR ALL ENTRIES and then use check the values agisnt LOW OR HIGH.

select lfart,lfdat,....

from likp

into..

for all entries in s_lfart

where

( lfart = s_lfart-low or lfart = s_lfart-high )

and lfdat in s_lfdat

and..

Regards,

Sesh

Re: Select options

Former Member — Fri, 06 Jul 2007 08:59:52 GMT

Hi,

u can't use "=" when u are using select-options..... this is used when parameters is being used insted select-options.....

regards,

shardul shah

Re: Select options

Former Member — Fri, 06 Jul 2007 09:00:09 GMT

Hi Padma,

You cannot use "=" while using Select option because, select option holds multiple values and you shall be trying to check a single value against many values.

if you would like to use "=" you should be checking it agains a single value out of Select option. i.e. either with S_LFDAT-HIGH / S_LFDAT-LOW. or use in between them.

Reward points if this helps.

Kiran

Re: Select options

Former Member — Fri, 06 Jul 2007 09:00:10 GMT

When you declare Parameters then only you can use '=' in the where condition

parameters:p_lfart like likp-lfart.

select....from likp...into table itab where lfart = p_lfart.

When you declare SELECT-OPTIONS then only you can use 'IN' in the where condition

select-options:s_lfart for likp-lfart.

select....from likp...into table itab where lfart IN s_lfart.

Reward points for useful Answers

Regards

Anji

Re: Select options

Former Member — Fri, 06 Jul 2007 09:01:15 GMT

select lfart,lfdat,....

from likp

into..

where

lfart eq s_lfart-low

and lfdat in s_lfdat

and..

Re: Select options

Former Member — Fri, 06 Jul 2007 09:06:42 GMT

HI.

refer this code.

select lfart,lfdat,....

from likp

into..

where

lfart EQ s_lfart

and lfdat EQ s_lfdat.

Reward all helpfull answers.

Regards.

Jay

Re: Select options

Former Member — Fri, 06 Jul 2007 09:07:37 GMT

hi anji,

i have declare lfart as select-option on selection screen.when i click on for multiple selection arrow button in that i will select "=" as option .that mean i have selected the "=" as value in option field of select-option table(sign,option,low,high).then i have to correct the selcet query.

Thanks&Regards,

Padma.

Re: Select options

Former Member — Fri, 06 Jul 2007 09:09:15 GMT

hi,

you can't use '=' option while working with SELECT-OPTIONS.

you get that('=') option only when you provide the s_field-LOW value for the select-option input field in that case system performs all the iptions like EQ('=') , GT, LT ...except BT..

regards,

Ashok reddy