Select statment

[Former Member]

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..????

[Former Member]

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.

[Former Member]

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

[dani_mn]

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,

[former_member184495]

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.