topic Re: Syntax error in ABAP SELECT statement - OFFSET is invalid ( due to grammar) in Application Development and Automation Discussions

Syntax error in ABAP SELECT statement - OFFSET is invalid ( due to grammar)

mitko1994 — Tue, 10 Oct 2023 14:32:04 GMT

Hello,

I have the following SELECT statement in a program that is used productively.

SELECT (lv_header_line) FROM (i_view) WHERE (lv_where) 
ORDER BY (lv_header_line) INTO CORRESPONDING FIELDS OF TABLE @<gt_data>
OFFSET @( lv_skip_pkg_cnt  * pkg_size ) UP TO @pkg_size ROWS.

Today I wanted to make a modification to the code, and was surpised to see that the initial source code

which is currently active, doesn't compile.

It throws a syntax error:

"OFFSET" is invalid here (due to grammar). contains an invalid character or it is a

I'm not sure what is causing it now, because the same syntax was correct a few months ago and allowed me to activate the program.

This syntax error is also now present in the rest of the BW systems in the landscape when I execute a check on the code.

Any ideas how to resolve it?

Thanks,

Dimitar

Re: Syntax error in ABAP SELECT statement - OFFSET is invalid ( due to grammar)

Sandra_Rossi — Tue, 10 Oct 2023 15:30:19 GMT

Formatting issue (<BR> everywhere). Best formatting:

SELECT (lv_header_line)
FROM (i_view)
WHERE (lv_where)
ORDER BY (lv_header_line) 
INTO CORRESPONDING FIELDS OF TABLE @<gt_data>
OFFSET @( lv_skip_pkg_cnt  * pkg_size ) 
UP TO @pkg_size ROWS.

Re: Syntax error in ABAP SELECT statement - OFFSET is invalid ( due to grammar)

mitko1994 — Tue, 10 Oct 2023 15:44:07 GMT

sandra.rossi, thanks for following up. I tried copying your suggested formatting of the statement without success. I had also tried that prior to posting the question here but forgot to mention it. Pretty printer didn't help either.

Re: Syntax error in ABAP SELECT statement - OFFSET is invalid ( due to grammar)

Sandra_Rossi — Tue, 10 Oct 2023 17:09:07 GMT

Use unformatted paste (Ctrl+Shift+V)

Re: Syntax error in ABAP SELECT statement - OFFSET is invalid ( due to grammar)

mitko1994 — Tue, 10 Oct 2023 17:59:13 GMT

sandra.rossi, (Ctrl+Shift+V) doesn't do anything in ADT nor in the GUI ABAP editor.

Re: Syntax error in ABAP SELECT statement - OFFSET is invalid ( due to grammar)

Sandra_Rossi — Wed, 11 Oct 2023 06:48:38 GMT

Please use the COMMENT button for comments, asking for complements, adding details, replying to a comment or a proposed solution or to the OP question, etc., ANSWER is only to propose a solution, dixit SAP text at the right of the answer area.

Re: Syntax error in ABAP SELECT statement - OFFSET is invalid ( due to grammar)

Sandra_Rossi — Wed, 11 Oct 2023 06:49:02 GMT

In SAP forum, use unformatted paste (Ctrl+Shift+V)

Re: Syntax error in ABAP SELECT statement - OFFSET is invalid ( due to grammar)

abo — Wed, 11 Oct 2023 06:53:38 GMT

When the GUI editor is in edit mode, copypasting will give these artifacts. Switching to display mode before copying fixes the issue.

Re: Syntax error in ABAP SELECT statement - OFFSET is invalid ( due to grammar)

mitko1994 — Wed, 11 Oct 2023 07:00:53 GMT

I fixed it

Re: Syntax error in ABAP SELECT statement - OFFSET is invalid ( due to grammar)

Sandra_Rossi — Wed, 11 Oct 2023 14:52:58 GMT

This code compiles in ABAP version 7.57. If it doesn't compile on your system, it means you are using an old version.

FIELD-SYMBOLS <gt_data> TYPE table.
DATA(lv_header_line) = ``.
DATA(i_view) = ``.
DATA(lv_where) = ``.
DATA(lv_skip_pkg_cnt) = 0.
DATA(pkg_size) = 0.

SELECT (lv_header_line)
    FROM (i_view)
    WHERE (lv_where)
    ORDER BY (lv_header_line)
    INTO CORRESPONDING FIELDS OF TABLE @<gt_data>
    OFFSET @( lv_skip_pkg_cnt  * pkg_size )
    UP TO @pkg_size ROWS.

Re: Syntax error in ABAP SELECT statement - OFFSET is invalid ( due to grammar)

mitko1994 — Wed, 11 Oct 2023 15:04:29 GMT

Yes, that's true. We don't have 757 installed, but why did the code compile in the first place? I have this code active and running across the landscape.

Re: Syntax error in ABAP SELECT statement - OFFSET is invalid ( due to grammar)

Sandra_Rossi — Wed, 11 Oct 2023 17:47:29 GMT

How come ?

Re: Syntax error in ABAP SELECT statement - OFFSET is invalid ( due to grammar)

mitko1994 — Thu, 12 Oct 2023 05:52:22 GMT

This was referring to the formatting issue you pointed out initially. I still have the syntax error.

Re: Syntax error in ABAP SELECT statement - OFFSET is invalid ( due to grammar)

Sandra_Rossi — Thu, 12 Oct 2023 13:01:54 GMT

It's difficult to help if you just say you "don't have ABAP 7.57".

If you want to know why the code compiled in the first place, there could be many reasons, SAP notes, kernel, activation forced, etc., but nobody can say without details, so better ask SAP Support to connect to your system.

Re: Syntax error in ABAP SELECT statement - OFFSET is invalid ( due to grammar)

Sandra_Rossi — Thu, 12 Oct 2023 13:03:40 GMT

Be careful when choosing between Answer and Comment ("I fixed it" is not a solution for your question). Moderators would like you to choose carefully to avoid intervening.

Re: Syntax error in ABAP SELECT statement - OFFSET is invalid ( due to grammar)

Evaristo — Thu, 27 Jun 2024 16:15:20 GMT

Hello

I'm having the same problem.
SAP 740 SP24

Just trying to do this simple example:

SELECT FROM demo_expressions
           FIELDS id, num1 AS number, numlong1 AS result
           ORDER BY id, num1
           INTO TABLE @DATA(itab)
           OFFSET @o
           UP TO @n ROWS.

When try to activate I have this error message:
"OFFSET" is invalid here (due to grammar). 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.

If any one knows something please share.

Re: Syntax error in ABAP SELECT statement - OFFSET is invalid ( due to grammar)

Sandra_Rossi — Thu, 27 Jun 2024 18:22:17 GMT

OFFSET is not supported in ABAP 7.40. See the ABAP 7.40 documentation.

Re: Syntax error in ABAP SELECT statement - OFFSET is invalid ( due to grammar)

Evaristo — Fri, 28 Jun 2024 07:15:23 GMT

Hi Sandra
Thank you for your answer.
Yes, I did. I was in doubt how this is can be true.
Just confirmed.
Thank you.

Re: Syntax error in ABAP SELECT statement - OFFSET is invalid ( due to grammar)

RaymondGiuseppi — Fri, 28 Jun 2024 11:25:06 GMT

In the version 7.51 release documentation : New Addition OFFSET in SELECT