topic Re: SAP Release Upgrade: Syntax Error SAPSQL_PARSER_TODO_WARNING in Application Development and Automation Discussions

SAP Release Upgrade: Syntax Error SAPSQL_PARSER_TODO_WARNING

Former Member — Mon, 23 Jun 2014 14:05:27 GMT

After SAP Release Upgrade I am encountering a runtime error SAPSQL_PARSER_TODO_WARNING during IDOC processing in BD87.

Error analysis

The compiler returned a warning about the terminated OpenSQL command

with the following text:

"You can only read out of the LRAW or LCHR field SDATA using its prepending

length field"

The dump is triggered after the execution of this SELECT statement:

SELECT docnum

segnam

sdata

FROM edid4

INTO CORRESPONDING FIELDS OF TABLE is_edid4

WHERE docnum EQ w_cntrl-docnum.

Former Member — Mon, 14 Jul 2014 05:44:04 GMT

Could anyone find any solution for this?

I am getting same dump for below query.

SELECT SINGLE extrow srvpos ktext1 meins

INTO (lwa_final-extrow, lwa_final-srvpos, lwa_final-ktext1, lwa_final-planned_menge )

FROM esll

WHERE packno EQ lwa_esll-sub_packno.

What is wrong with this query?

Posting on this thread, because could not find any other thread with similar dump.

Former Member — Mon, 14 Jul 2014 05:55:03 GMT

Sorry, I got it fixed. I was putting MEINS into MENGE.

So, my error is not similar to your error. But there is definitely some problem with your SQL query.

Check the data types of corresponding fields. It might have been mixed up.

former_member467220 — Fri, 01 Aug 2014 00:52:21 GMT

You need to write the select query to DTINT2 read as well when reading SDATA because SDATA has LCHR data type.

SELECT docnum

segnam

DTINT2

sdata

FROM edid4

INTO CORRESPONDING FIELDS OF TABLE is_edid4

WHERE docnum EQ w_cntrl-docnum.

Former Member — Fri, 01 Aug 2014 03:16:52 GMT

Hi Devendra I used the same solution. Thank you.