topic This query returns no values in Application Development and Automation Discussions

This query returns no values

Former Member — Wed, 22 Aug 2007 06:21:00 GMT

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.

varma_narayana — Wed, 22 Aug 2007 06:22:27 GMT

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 — Wed, 22 Aug 2007 06:25:40 GMT

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 — Wed, 22 Aug 2007 06:26:59 GMT

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.