New SQL syntax and ABAP editor highlighting

[jrgkraus]

Hello to all,

today I read about then new SQL syntax that came with ABAP 740 SP08. Playing around with it, I noticed that the editor seems to detect a syntax error here:

Nevertheless, the syntax is OK. Is this a known issue?

[raphael_almeida]

Hi Jorg!

The error is in how you position the mt_tvuvs data structure, the correct is it is before or after the "FROM"

BR,

Raphael Pacheco.

[jrgkraus]

Hello Raphael,

the new SQL syntax recommends to put the INTO statement at the end. See http://scn.sap.com/community/abap/blog/2014/10/08/abap-news-for-740-sp08--open-sql for further explanations.

[raphael_almeida]

Really, for me also is marked as syntax error, but I can successfully activate the program.

I have on my system the SAP_ABA component 740 0012.

*Stranger things*

[retired_member]

Yes, the INTO should be the last clause now ...

Syntax coloring in the WB is done by SAP GUI. You need a recent one. Same for ADT. As soon as my tool buddies learn, that there is a new syntax, they adjust the coloring.

Imagine how it looks when I start testing new things ...

[jrgkraus]

I just installed 740 patch 9 - still not working. So the "recent one" you mentioned is not yet released, i guess?

[retired_member]

I have

   SAP Logon für Windows

   740 Final Release

   7400.3.9.1125

   1676784

and ...

Unfortunately the coloring guy is in vacation, so I cannot ask him, if there's a connection with a kernel patch.

But I'll ask the Open SQL guy ...

[vonglan]

I have the same syntax highlighting color problem for INTO in the new SQL syntax. Both in SAPGUI and in Eclipse, and it also concerns PACKAGE SIZE:

Release etc for me:

Backend: 740 SP 10

SAPGUI:

(I did not create a ticket, because I assumed someone at SAP must have already noticed this.)

Would be nice to have this solved.

Thanks,

Edo

[SuhaSaha]

Unfortunately the coloring guy is in vacation

the INTO should be the last clause now ...

But the "stricter" SQL-syntax check doesn't check it, does it? I have been using the "new" SQL-syntax for quite sometime but the compiler never complained to me about the position of the INTO-clause

[retired_member]

But the "stricter" SQL-syntax check doesn't check it, does it?

It should.

See Strict Mode 7.50.

If you fulfill one of the requirements for the strict mode listed there and it doesn't, we have another error, either in the kernel or the documentation (maybe some conditions were removed but the documentation was not informed ...).

[SuhaSaha]

Hi Horst,

I forgot to mention that i'm working on ABAP740 SP12. I guess in this release the position of the INTO-clause is not "strictly" checked.

BR,

Suhas

[retired_member]

No, 't came too late in that release.

[retired_member]

Well then, after asking around, the issue is known but wasn't published.

Because of your discussion entry, we have SAP Note 2359360 now (translation pending) that says:

It (in fact) is a Kernel error that is resolved with Kernel 745.

Cheers

Horst

PS: seems that SCN is evolving into a kind of ABAP hotline (and I'm the hotliner ) ...