topic Re: select query in Application Development and Automation Discussions

select query

Former Member — Fri, 29 Aug 2008 10:04:50 GMT

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

Re: select query

GauthamV — Fri, 29 Aug 2008 10:06:23 GMT

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

Re: select query

Former Member — Fri, 29 Aug 2008 10:06:38 GMT

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.

Re: select query

Former Member — Fri, 29 Aug 2008 10:06:52 GMT

Hi,

Could you please paste your code?

Re: select query

Former Member — Fri, 29 Aug 2008 10:07:41 GMT

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.

Re: select query

kesavadas_thekkillath — Fri, 29 Aug 2008 10:07:43 GMT

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

select-options

or give EQ in where clause

Re: select query

Former Member — Fri, 29 Aug 2008 10:08:25 GMT

HI ,

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

Re: select query

SuhaSaha — Fri, 29 Aug 2008 10:08:53 GMT

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

Re: select query

Former Member — Fri, 29 Aug 2008 10:09:17 GMT

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.

Re: select query

Former Member — Fri, 29 Aug 2008 10:09:35 GMT

Hello

If s_bugjah is declared as parameter, you must use

EQ S_BUGJAH in select statement.

Re: select query

Former Member — Fri, 29 Aug 2008 10:10:50 GMT

Hi,

If you have declared the parameter using key word

PARAMETERS, then use = in the WHERE condition

SELECT-OPTIONS, then use IN in the WHERE condition

Regards,

Kunjal