SELECT QUERY

[Former Member]

Hi All,

I am wring a simple report in which i am trying to write a select query like:

SELECTION-SCREEN: BEGIN OF BLOCK b1 WITH FRAME TITLE text-001.

SELECT-OPTIONS: s_plant FOR viqmel-iwerk OBLIGATORY,

s_date FOR viqmel-zzpm_rs_arr_date.

SELECTION-SCREEN END OF BLOCK b1.

SELECT qmnum

iwerk

ltrmn

zzpm_rs_arr_date

zzpm_rs_arr_time

tplnr

FROM viqmel

INTO TABLE it_final

WHERE IWERK IN s_plant.

But its showing me an error as :

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

Kindly suggest me what could be a problem?

Thanks!!

Jaten Sangal

[Former Member]

Hi

Strange message

But I don't know what you have written before the select-options: your code seems to be ok

Max

[Former Member]

Hi,

The statement

TABLES: viqmel

is missing...

Another preferred option (to avoid using a tables statement):

DATA: g_iwerk TYPE iwerk.
SELECT-OPTIONS: s_plant FOR g_iwerk.

Kr,

m.

[Former Member]

I corrected myself.