topic Re: SELECT QUERY in Application Development and Automation Discussions

SELECT QUERY

Former Member — Wed, 12 Oct 2011 09:57:21 GMT

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 — Wed, 12 Oct 2011 10:02:49 GMT

Strange message

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

Max

Former Member — Wed, 12 Oct 2011 10:05:32 GMT

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,

Former Member — Wed, 12 Oct 2011 10:06:50 GMT

I corrected myself.