topic Re: error in using select option in Application Development and Automation Discussions

error in using select option

Former Member — Thu, 28 Oct 2010 12:59:22 GMT

hi,

i have used some fields in import in se37. I want that fields to be a select-options. so i gave associated type as selopt.

but when i write a select query in source code it shows an error

the IN operation with 'BSTYP' is followed neither by an internal table nor by a value list.

SELECT ebeln bukrs lifnr aedat FROM ekko INTO CORRESPONDING FIELDS OF TABLE i_ekko WHERE bstyp IN bstyp

AND

lifnr IN lifnr AND ekorg IN ekorg

AND bukrs IN bukrs AND aedat IN aedat.

pls tell me a solution

Former Member — Thu, 28 Oct 2010 13:01:43 GMT

Hi,

Please see SCN Rules before posting.

With Regards,

Sumodh.P

Former Member — Fri, 29 Oct 2010 07:53:52 GMT

Hi,

tables: ekpo.

ranges: bstyp for ekpo-bstyp.

bstyp-sign = 'I'.

bstyp-option = 'EQ'

bstyp-low = 'X'.

append bstyp.'

bstyp-low = 'Y'.

append bstyp.'

By Jan

Former Member — Fri, 29 Oct 2010 10:06:39 GMT

Hi,

Instead declare all your Import fields in Tables .

This works.

Regards,

Srini.