SELECT query using SELECT-OPTIONS.

[Former Member]

Hi,

Scenario:

One main program and an include.

The SELECT-OPTIONS is declared in the main program and the SELECT query is being fired in the Include.

Declaration in the main program:

DATA:

gw_linv_tab TYPE linv.

SELECT-OPTIONS :

s_lgnum FOR gw_linv_tab-lgnum OBLIGATORY.

Inside Include:

SELECT lgnum

FROM t300

INTO TABLE lt_t300

WHERE lgnum IN s_lgnum.

Syntax error:

The IN operator with "S_LGNUM" is followed neither by an internal table

nor by a value list.

Can anybody please suggest what is that I am missing?

I have tried the same scenario in a test program and it works perfectly fine there.

Please help me to figure out the problem.

Regards

s@k

[former_member329859]

Hi,

Try to pass ur select option field in the anather globle defined field and write down that field in the where condition.

Bye

Gaurav

[Former Member]

Hi ..

Tried the same.. Didn't get any error..

Please make sure that your TOP include (Include where SELECT-OPTIONS declared) is active..

Nag

[Former Member]

Hi

Make shure tht ur select option statment should be above the include program.

Example.

Select- options<>.

Include<> and write the code in ur include statement.

Regards

Rasheed

[Former Member]

Hi Rasheed,

Thanks a lot..:) it solved the problem.

Regards

s@k