topic Re: SELECT query using SELECT-OPTIONS. in Application Development and Automation Discussions

SELECT query using SELECT-OPTIONS.

Former Member — Thu, 10 Dec 2009 04:53:54 GMT

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

Re: SELECT query using SELECT-OPTIONS.

former_member329859 — Thu, 10 Dec 2009 04:59:16 GMT

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

Re: SELECT query using SELECT-OPTIONS.

Former Member — Thu, 10 Dec 2009 05:02:36 GMT

Hi ..

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

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

Nag

Re: SELECT query using SELECT-OPTIONS.

Former Member — Thu, 10 Dec 2009 05:05:27 GMT

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

Re: SELECT query using SELECT-OPTIONS.

Former Member — Thu, 10 Dec 2009 05:07:58 GMT

Hi Rasheed,

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

Regards

s@k