08-22-2007 7:21 AM
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.
08-22-2007 7:22 AM
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.
08-22-2007 7:25 AM
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
08-22-2007 7:26 AM
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.