SAP Release Upgrade: Syntax Error SAPSQL_PARSER_TODO_WARNING

[Former Member]

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]

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]

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]

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]

Hi Devendra I used the same solution. Thank you.