select-options in SELECT query - syntax error

[madhu_reddy22]

Hi all,

I get the error below when I try to use the select options in a SELECT query . Please help me.

"The IN operator with "SO_AWART" is followed neither by an internal

table nor by a value list."

The code i have used(Logical database PNP is used):

TABLES: pernr,

catsdb.

INCLUDE ztime_cwtr_top. " global Data

INCLUDE ztime_cwtr_f01.

SELECTION-SCREEN BEGIN OF BLOCK B1 WITH FRAME.

SELECT-OPTIONS SO_AWART FOR CATSDB-AWART.

PARAMETERS P_THRES TYPE I.

SELECTION-SCREEN END OF BLOCK B1.

• Get data from CATSDB table. Workdates within the date interval are considered.

SELECT pernr workdate awart catsquantity beguz enduz status

FROM catsdb

INTO TABLE it_catsdb

WHERE pernr = pernr-pernr AND

workdate GE pn-begda AND

workdate LE pn-endda AND

status IN ('20', '30') AND

awart IN so_awart .

• awart IN ('1100', '1137', '1138', '1139', '1140',

• '1147', '1148', '1149', '1157', '2003' ).

when I give the values directly i do not get any syntax error, but when I use select options in the where condition I get the syntax error.

I have tried different options like using only the select-options in the where condition.

Thanks in advance.....

Madhu

[Former Member]

Hi madhu,

Use NO INTERVALS for AWART as follows.

SELECT-OPTIONS SO_AWART FOR CATSDB-AWART NO INTERVALS.

Hope your query works now.

Regards,

Anand.

[GauthamV]

hi,

you remove in operator for status and replace with =.

[Former Member]

Include CATSDB in tables statement.

Thanks

Kiran

[madhu_reddy22]

Solved.

Code with syntax error:

include z...top .

include z...fo1.

select-options: xxxxxxx

Code with no syntax error:

select-options: xxxxxxx

include z...top .

include z...fo1.

Thanks for all your help,

Madhu