This query returns no values

[Former Member]

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.

[Former Member]

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]

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]

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]

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.