topic Re: Using functions in Open SQL in Application Development and Automation Discussions

Using functions in Open SQL

oppenheim_jm — Fri, 28 Jul 2023 10:30:21 GMT

Hi ABAP experts,

What is the issue here? How do I use Open SQL functions without this error?
Message 249 ( is invalid here (due to grammar).

Re: Using functions in Open SQL

Sandra_Rossi — Fri, 28 Jul 2023 11:16:03 GMT

LENGTH( ... ) is only supported since ABAP 7.50

Re: Using functions in Open SQL

oppenheim_jm — Fri, 28 Jul 2023 11:17:53 GMT

Thanks sandra.rossi , are there any functions we can use below 7.5?

Re: Using functions in Open SQL

Sandra_Rossi — Fri, 28 Jul 2023 12:49:42 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: Using functions in Open SQL

Sandra_Rossi — Fri, 28 Jul 2023 12:56:44 GMT

LENGTH( ... ) is only supported since ABAP 7.50

Anything not supported can probably be done with Native SQL (SQL sent directly to the database, by using e.g. ADBC, deprecated EXEC SQL, etc.) but of course .

You can also try workarounds. I don't know your exact context, maybe you can replace LENGTH( ZZZ ) = 1 with ZZZ LIKE '_' (first character = any character an rest of characters = blank)