topic Re: optional parameters on selection screen in Application Development and Automation Discussions

optional parameters on selection screen

Former Member — Tue, 28 Aug 2007 10:32:32 GMT

hi all,

in my program i have used 4 optional select options on selection screen.

these 4 parameters are used to fetch records from 4 different tables using an inner join.

the problem is if any one of these 4 is left blank by the user,then query fetches no record.

so whats the solution,do i have to query databese multiple times using if not initial condition or what??

Thanks

JozsefSzikszai — Tue, 28 Aug 2007 10:36:04 GMT

hi kunal,

do you join 4 tables into one select, using the 4 select-options from the selection screen in the where clause?

if the answer if yes, than make the select options mandatory on the selection screen, otherwise pls. clarify what exactly you are doing.

thanks

former_member253923 — Tue, 28 Aug 2007 10:36:26 GMT

If field values are blank make it as "*" in your at selection event

varma_narayana — Tue, 28 Aug 2007 10:36:53 GMT

Hii

Incase of the SELECT-OPTIONS : when they are not filled all the records are fetched .

Incase of the PARAMETERS : when they are not filled it will compare with the INITIAL VALUE like SPACE or 0. So it may not return data.

In ur Question you mentioned both..

Post the code if u dont get a solution from the Above explaination.

<b>Reward if Helpful..</b>

Former Member — Tue, 28 Aug 2007 10:38:55 GMT

oh well i know THAT problem

if you have a parameter optional, and leave it blank it´s of initial value then.

That means your select looks for the records which have initial state in THAT field.

most probably that is NOT what you want.

One way around this is not to use parameters, but Select options.

Look at the sap-help on select options, there is some addon statement, with which you can make Select options look like a parameter.

Former Member — Tue, 28 Aug 2007 10:39:33 GMT

Hi,

You need to use IN operator for the select query then if you left blank then it will pick all the records from the table,

if you want check before the select whether the select-option is initial or not then use the IF NOT INITIAL

Regards

Sudheer