Select query using select options and parameters?

Former Member — Thu, 12 Jul 2012 19:04:16 GMT

I have a7 select option i/p fields(selection criteria) out of which one is mandatory

so i have written my query like

Select A B C D 
from LTAK
into table lt_ltak
whereBDATU in so_BDATUandBETYP in SO_BETYPandBENUM in SO_BENUMandBWLVS in SO_BWLVSandTANUM in SO_TANUM.

So according the query above if the user gives mandatory field(bdatu) and any other fields from LTAK table it will work...

now the 2nd query

select X Y Z
from LTAP
into table lt_ltap
for all entries in LTAK
where lgnum = LT_LTAK-LGNUM and NLTYP IN SO_NLTYP and GRETR IN SO_GRETR.

My questions: Is the 2nd query correct..

If the user provides NLTYP and BADTU only as i/p the will both query work? (assumption records are there for the i/p given)
If the user provides NLTYP and BADTU and GRETR only as i/p the will both query work? (assumption records are there for the i/p given)

Re: Select query using select options and parameters?

Former Member — Thu, 12 Jul 2012 19:08:24 GMT

Hi,

Yes both your queries will work. Are you facing any problems? Post your code here if you see any problems.

Regards,

Shravan