select query

[Former Member]

Hi a small doubt actally i have entered a field in the selection screen as parameters ie) s_bugjah LIKE t009b-bdatj .I have to use this value s_bugjah in the select stmt for where codn but its showing an error "The IN operator with "S_BUGJAH" is followed neither by an internal

table nor by a value list."please help to correct this error

[GauthamV]

hi,

u have to use in only for select options.

use this.

ex: bukrs eq p_bukrs.

Edited by: gautham chakraverthi on Aug 29, 2008 3:38 PM

[Former Member]

You will have to use SELECT-OPTIONS not PARAMETERS for this requirement. The IN condition only works for select-options in the select query.

Declare it as,

SELECT-OPTIONS: s_bugjah FOR t009b-bugjah.

[Former Member]

Hi,

Could you please paste your code?

[SuhaSaha]

Hello,

Plz try this:

SELECT-OPTIONS: S_BUGJAH FOR t009b-bugjah.

Use this in the select stmt with IN.

BR,

Suhas

Edited by: Suhas Saha on Aug 29, 2008 12:09 PM

[Former Member]

If ur declaring a parameter ie:

parameters s_bugjah LIKE t009b-bdatj.

then u shoul go for = rather than IN in the where condition.

If ur using IN it must be a select-option.

[kesavadas_thekkillath]

when 'IN' statement then donot declare as parameters gor for

select-options

or give EQ in where clause

[Former Member]

HI ,

U cannot use IN for parameter statement > if U want to use then declare it as select-options :s_bugjah FOR t009b-bdatj .

[Former Member]

Hi Saranya,

Just check your select statement and in the where condition when you are checking the field CODN put the sign '=' instead of 'IN'. The issue will be solved. For example :

parameters :
  s_bugjah LIKE t009b-bdatj.

select <field names>
    from t009b
    into itab
 where codn = s_bugjah.

Regards,

Swapna.

[Former Member]

Hello

If s_bugjah is declared as parameter, you must use

EQ S_BUGJAH in select statement.

[Former Member]

Hi,

If you have declared the parameter using key word

PARAMETERS, then use = in the WHERE condition

or

SELECT-OPTIONS, then use IN in the WHERE condition

Regards,

Kunjal