Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

This query returns no values

Former Member
0 Kudos

Hi,

The below query gives no returns.

Could anyone give the reasons behind this.

select pernr ansal into corresponding fields of table t_0008

from PA0008

where pernr eq s_pernr.

Even the EE entered is also fine and has its data in the table PA0008.

Please give reply ASAP.

Thanks,

Binay.

3 REPLIES 3

varma_narayana
Active Contributor
0 Kudos

Hi..

For SELECT-OPTIONS you have to Compare using IN not EQ..

Then it works .. See the Code...

select pernr ansal into corresponding fields of table t_0008

from PA0008

<b>where pernr IN s_pernr.</b>

Reward if Helpful.

Former Member
0 Kudos

hI Binay

if u dont give any value in parameter it will take no value

use select option as narayana mentioned

and close this thread

Former Member
0 Kudos

hi,

which one you used parameter or select-options.

for parameter ur code is correct .

select pernr ansal into corresponding fields of table t_0008

from PA0008

where pernr eq s_pernr.

for select-option if u used an input parameter then change as

select pernr ansal into corresponding fields of table t_0008

from PA0008

where pernr IN s_pernr.

if helpful reward some points.

with regards,

Suresh Aluri.