topic Re: many selection paramters in Application Development and Automation Discussions

many selection paramters

Former Member — Wed, 09 May 2007 17:20:25 GMT

I have a selection screen where i have 5 select options. only 2 are obligatory. I need to get data from tables vbrk vbrp kna1 and some more.

my question is how to write the where condition, when joining these tables as the non-obligatory selections May or May not have data ( or 1-2 might have them )

thanks

Re: many selection paramters

Former Member — Wed, 09 May 2007 17:27:17 GMT

if the selection parameters are select-options, u dont have to worry about that.

system will automatically take care of it...

sample..

where

vbeln in s_vbeln and

kunnr in s_kunnr.

if s_kunnr is blank..it will select for all kunnr, else, for the specified kunnr s only

Re: many selection paramters

Former Member — Wed, 09 May 2007 17:35:37 GMT

thanks for ur quick reply.

so according to u the following code should work ?

SELECT *

FROM vbrk

INNER JOIN vbrp ON vbrk_{vbeln = vbrp}vbeln

INNER JOIN kna1 ON vbrk_{kunag = kna1}kunnr

INTO corresponding fields of TABLE itab

WHERE

vbrk_{vbeln in p_vbeln and vbrk}kunag in p_kunag and vbrp_{matnr in p_matnr and vbrp}augru_auft in p_augru and vbrk~fkdat in P_fkdat

i had one more question , one of the select options is date , so i need to get reports genrated within the 2 dates . how do i write it .

thanks again

Re: many selection paramters

RichHeilman — Wed, 09 May 2007 17:51:17 GMT

Simply add that to the SELECT statement WHERE clause.

Just like you have this data field.

and vbrk~fkdat in P_fkdat

Regards,

RIch Heilman

Re: many selection paramters

Former Member — Wed, 09 May 2007 18:16:58 GMT

Hi,

I think you should use s_fkdat.

Declare s_fkdat in selection screen like,

SELECT-OPTIONS: S_FKDAT FOR VBRK-FKDAT.

So that you can get data in the date range specified.

Thanks,

Veni.

Re: many selection paramters

Former Member — Wed, 09 May 2007 22:53:05 GMT

thank you all for ur quick replies . i have given points for all. closing this thread.