Skip to Content
avatar image
Former Member

This query returns no values

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Aug 22, 2007 at 06: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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 22, 2007 at 06: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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 22, 2007 at 06: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.

    Add comment
    10|10000 characters needed characters exceeded