topic Re: Syntax error in Application Development and Automation Discussions

Syntax error

Former Member — Thu, 18 Oct 2007 19:58:42 GMT

Hi All,

I have got an issue, I have written the folowing code and getting this error"Incorrect expression "+" in logical condition."

select ebeln eindt into table it_eket

from eket

for all entries in it_ekpo

where ebeln = it_ekpo-ebeln and

eindt <= syst-datum + 5 .

Can you please help me out....

Rajeev

Re: Syntax error

Former Member — Thu, 18 Oct 2007 20:01:28 GMT

Hi,

You have to declare a variable for the date and use that date in your select statement

data: v_date type sydatum.

v_date = sy-datum + 5.

select ebeln eindt into table it_eket

from eket

for all entries in it_ekpo

where ebeln = it_ekpo-ebeln and

eindt <= v_date .

Thanks

naren

Re: Syntax error

Former Member — Thu, 18 Oct 2007 20:01:46 GMT

Hi,

Please try this.


data: wa_eindt like sy-datum.

wa_eindt = sy-datum + 5.

select ebeln eindt into table it_eket
from eket
for all entries in it_ekpo
where ebeln = it_ekpo-ebeln and
eindt <= wa_eindt.

Regards,

Ferry Lianto

Re: Syntax error

Former Member — Thu, 18 Oct 2007 20:01:49 GMT

You cannot use offsets in a WHERE. You'll have to move the value you want into a separate variable.

Rob

Re: Syntax error

RichHeilman — Thu, 18 Oct 2007 20:02:40 GMT

Yea, you can't do that in a SELECT statement. here is a work around.

data: datum type sy-datum.

datum = sy-datum + 5.

select ebeln eindt into table it_eket
from eket
for all entries in it_ekpo
where ebeln = it_ekpo-ebeln and
eindt <= datum.

Regards,

RIch Heilman

Re: Syntax error

Former Member — Thu, 18 Oct 2007 20:03:33 GMT

>>eindt <= syst-datum + 5 .

Try this

this statement wont work. Declare another field as datum

datum1 = syst-datum + 5.

select ebeln eindt into table it_eket
from eket
for all entries in it_ekpo
where ebeln = it_ekpo-ebeln and
eindt <= datum1 .

Regards

Aneesh

Re: Syntax error

Former Member — Thu, 18 Oct 2007 20:04:09 GMT

What are you trying to get with this statement? Are you looking at current date plus 5 days or are you taking the offset of eindt from the 5th position?

I think you want to read all records with eindt less than or equal to current date plus 5 days. Declare another variable of type date and do the calculation before the select statement as below.

data: l_eindt like eket-eindt.

l_eindt = sy-datum + 5.

select ebeln eindt into table it_eket

from eket

for all entries in it_ekpo

where ebeln = it_ekpo-ebeln and

eindt <= l_eindt .

Another suggestion is that you should use EBELP (line item number) also in your internal tables, otherwise you may get incorrect values.

Re: Syntax error

Former Member — Thu, 18 Oct 2007 20:06:27 GMT

Hi you can not use logical expression in this way into select statement....

store the value of the date in temporary variable and then use it..

data : tempdate like syst-datum.

tempdate = syst-datum + 5.

select ebeln eindt into table it_eket

from eket

for all entries in it_ekpo

where ebeln = it_ekpo-ebeln and

eindt <= tempdate.

Thanks & Regards

ilesh 24x7