topic Re: Select statment in Application Development and Automation Discussions

Select statment

Former Member — Wed, 13 Sep 2006 04:27:48 GMT

Hi All..

I have 4 fields in Selection screen.

No one is mandatory.

User wishes to select the details from a table by giving inputs in the selection screen.

I have coded as..

select * from ZTABLE into corresponding fields of table itab

where zreqno = s_reqno-low

or zdate in s_date

or zreqby = s_reqnam-low

or zapprname = s_appnam-low.

System is not able to fetch correct records from Table with given inputs...

What will be the right code..????

Re: Select statment

Former Member — Wed, 13 Sep 2006 04:29:23 GMT

select * from ZTABLE into corresponding fields of table itab
where zreqno in s_reqno
or zdate in s_date
or zreqby in s_reqnam
or zapprname in s_appnam.

Re: Select statment

Former Member — Wed, 13 Sep 2006 04:30:30 GMT

put like this

select * from ZTABLE into corresponding fields of table itab
where zreqno in  s_reqno.
or zdate in s_date
or zreqby in s_reqnam.
or zapprname in  s_appnam.

but check the performamce.

Regards

Prabhu

Re: Select statment

dani_mn — Wed, 13 Sep 2006 04:30:41 GMT

HI,

try this.

<b>select * from ZTABLE into corresponding fields of table itab
where zreqno in s_reqno
or zdate in s_date
or zreqby in s_reqnam
or zapprname in s_appnam.</b>

Regards,

Re: Select statment

former_member184495 — Wed, 13 Sep 2006 05:07:39 GMT

hi,

i think in this case,

you better define

*------

initialization.

s_reqno-low = <least value>

s_reqnam-low = <least value>

s_appnam-low = <least value>

*---and now continue with your select statement.

cheers,

Aditya.