topic Re : Open sql query. in Application Development and Automation Discussions

Re : Open sql query.

former_member226225 — Sat, 25 Jul 2015 05:38:18 GMT

Hi Folks,

I am currently listening the open sap videos for the abap on hana week3 .in that i wrote abap query modified with the enhancement of the sql statement

but my statement is showing syntax errors.

Please find the below query.

SELECT carrid

connid

fldate

price

currency

FROM sflight

INTO TABLE lt_sflight.

IF sy-subrc IS INITIAL.

DESCRIBE TABLE lt_sflight LINES sy-tfill.

WRITE : / sy-tfill.

ENDIF.

SELECT carrid,

connid,

fldate,

price,

currency

from sflight

into table @data(lt_sflight).

From the above query i am getting the below error.

"," is not allowed here since it contains an invalid character or it is

a keyword. (It might be possible to escape it using "!"). Or a space is

missing or there is one space too many.

I am using EHP7 with sp04 ides server.

Thanks in advance.

Regards,

Raghunadh Kodali.

Re: Re : Open sql query.

former_member226225 — Sat, 25 Jul 2015 06:16:34 GMT

Hi Folks.

I got the solution.

from the help.sap.com

In Open SQL, all operands in lists can now be separated by commas and this is also the recommended way of separating them from Release 7.40, SP05. Until now, comma-separated lists could only be used when single target fields were specified in parentheses after INTO in SELECT and when data objects were specified in parentheses after WHERE. Comma-separated lists are now also possible in Unicode programs where the program attribute fixed point arithmetic is activated:

ABAP Keyword Documentation

Thanks & Regards,

Raghunadh Kodali.

Re: Re : Open sql query.

jasmin_gruschke — Mon, 27 Jul 2015 09:16:07 GMT

Hi Raghundadh,
so the solution is, that the statement you wrote is not possible in SP5... but in SP8 it's perfectly fine for the syntax check, right?
Cheers,
Jasmin

Re: Re : Open sql query.

former_member226225 — Wed, 29 Jul 2015 07:03:39 GMT

Hi Jasmin,

I am currently working in a SP08 system and the syntax is working perfectly .

Thanks & Regards,

Raghunadh Kodali.