topic Re: Select statements in Application Development and Automation Discussions

Select statements

Former Member — Thu, 22 Nov 2007 19:10:30 GMT

when I give in source code of function module the below statements:

SELECT vbeln bsark vtweg spart vdatu

FROM vbak

INTO TABLE itab WHERE

erdat IN s_erdat AND

vkorg IN s_vkorg AND

vtweg IN s_vtweg AND

bsark IN s_bsark AND

spart IN s_spart.

it shows the following error.

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

Plz suggest what to do.

Plz reply it's urgent.

Re: Select statements

Former Member — Thu, 22 Nov 2007 19:12:06 GMT

Remember this is for report selction screen not FM

SELECT vbeln bsark vtweg spart vdatu

FROM vbak

<b>INTO CORRESPONDING FIELDS OF TABLE itab WHERE</b>

erdat IN s_erdat AND

vkorg IN s_vkorg AND

vtweg IN s_vtweg AND

bsark IN s_bsark AND

spart IN s_spart.

in FM you can use IN statement if you have table of selection otherwise you will have to use EQ instead of IN depending on the BR.

Cheers

Re: Select statements

Former Member — Thu, 22 Nov 2007 19:16:50 GMT

S_ERDAT is not declared as either a select-option or range table. How did you declare it?

Rob

Re: Select statements

Former Member — Thu, 22 Nov 2007 19:17:31 GMT

Hi Ajay

are you using this select query in Function module.If yes,then I guess you need to change the select query.IN operator is generally used with select-options.try

SELECT vbeln bsark vtweg spart vdatu

FROM vbak

INTO TABLE itab WHERE

erdat eq s_erdat AND

vkorg eq s_vkorg AND

vtweg eq s_vtweg AND

bsark eq s_bsark AND

spart eq s_spart.

Re: Select statements

Former Member — Thu, 22 Nov 2007 19:20:34 GMT

For FM you can use

FOR ALL ENTRIES IN

statement.