The IN operator with "v_vkbur" is followed neither by an internal table nor by a value list

[former_member260061]

vkbur eq v_vkbur is working (for specific sale office) 

Basically I need to select all entries of  Sale office(vkbur) in one company code p_bukrs1.

can any one help?

[former_member288351]

Hi khurram nagi,

I think you have to create range table of vkbur for using IN operator in select query.

For example:

data: t_vkbur type range of vbak-vkbur,

       w_vkbur like line of t_vkbur.

***Fill t_vkbur for one company code.

and then use vkbur IN t_vkbur in select query

regards

vikas pandey

[Ashg1402]

Hi,

What is the declaration type for v_vkbur.?

Declare that as a range .

[former_member260061]

parameters: v_vkbur type  vbak-vkbur modif id sc1.

[former_member196331]

That is the reason In is not working.

parameters: v_vkbur type  vbak-vkbur modif id sc1.

you have to write like.

select-options: v_vkbur type vbak-vkbur.

[former_member196331]

May i know v_vkbur  is parameter or Select:options:

Elese

At data declaration;

RANGES: v_vkbur  FOR vbak-VKBUR..

After all declarations.

*** Initialization

INITIALIZATION.

   REFRESH R_RANGE.

   R_RANGE-OPTION = 'EQ'.

   R_RANGE-SIGN   = 'I'.

   R_RANGE-LOW    = '1000'. "Which value you want to pick

   APPEND R_RANGE.

   CLEAR R_RANGE.

   R_RANGE-OPTION = 'EQ'.

   R_RANGE-SIGN   = 'I'.

   R_RANGE-LOW    = '2000'. "Which value you want to pick

   APPEND R_RANGE.

   CLEAR R_RANGE.

Now write the coding part.

from vbak into correnspoinding fields of table tbloard

where  bukrs_vf eq p_bukrs1

kunnr in s_kunnr1 and vkbur in v_vkbur.

Hope you understood.

[former_member260061]

i have used

select option

select-options : v_vkbur for  vbak-vkbur modif id sc1.

instead of :

parameters: v_vkbur type  vbak-vkbur modif id sc1.

then i have used IN operator instead of Equal Operator

vkbur in v_vkbur

its working now.

regard

khurram Nagi