topic Re: Multiple values in selection screen in Application Development and Automation Discussions

Multiple values in selection screen

Former Member — Tue, 01 Aug 2006 07:42:08 GMT

Hi all,

I have got the vendor parameter in the selection screen. If multiple values are entered using the dynamic selection icon in the selection screen, its not working ..plz help..

select-options : s_lifnr for lfa1-lifnr.

*- To select the open items data from BSIS.

select belnr blart budat xblnr dmbtr sgtxt rebzg shkzg qbshb lifnr

from bsik

into corresponding fields of table it_bsik

where bukrs eq p_bukrs and

gjahr eq p_gjahr and

budat in s_budat and

gsber eq p_gsber and lifnr in s_lifnr.

Re: Multiple values in selection screen

naimesh_patel — Tue, 01 Aug 2006 07:45:17 GMT

Hello,

It seems your code is correct. You don't get the requried vendor from the bsik because of other inputs. Remove other inputs and then check.

Regards,

Naimesh

Re: Multiple values in selection screen

Former Member — Tue, 01 Aug 2006 07:48:47 GMT

before the select check if any values exist in S_LIFNR, if they exists then the problem may be bcoz of the other parameters in where condition

remove all all the other parameters in select except s_lifnr and checkout

Message was edited by: Chandrasekhar Jagarlamudi

Re: Multiple values in selection screen

Former Member — Tue, 01 Aug 2006 08:07:54 GMT

Thanks for the reply...but Im getting the output list if Im these multiple vendors separately....So there is definitely some data for these vendors...

Should I incorporate something else in this program?

Re: Multiple values in selection screen

Former Member — Tue, 01 Aug 2006 08:14:52 GMT

Hi,

think u need to check actual selecect query that is getting fired.

to do that.

run the program in dedugging mode.

stop at the select query.

start new transaction STO5.

activate sql trace.

again go back to program and execute the select query.

back to st05

deactivate sql trace.

see the actual select query that is fired.

from this u will be able to point out the error in select query or data mismatch.

try for all the query ; which u have mentioned.

Mark Helpful Answers

Re: Multiple values in selection screen

Former Member — Tue, 01 Aug 2006 08:20:52 GMT

Hi Sushma,

One last try, use BT instead on IN in your select query.

Regards:-

Santosh

Re: Multiple values in selection screen

Former Member — Tue, 01 Aug 2006 08:23:53 GMT

It was working fine.....There was no problem at all.