topic Re: Syntax error after upgrade in Application Development and Automation Discussions

Syntax error after upgrade

Former Member — Wed, 30 Nov 2011 14:02:49 GMT

Hello all,

We just upgraded to EH5, we have a custom program and in that program we have used the below statement that's resulting into the syntax error, although we don't get any syntax error in the non upgraded system:

UPDATE EDID4 SET SDATA = I_EDI_DD-SDATA.

and the syntax error that I am getting is : In the LRAW- or LCHR field SDATA you can only write a prepend length field.

I was just wondering if anyone of you have faced the similar issue.

Re: Syntax error after upgrade

Former Member — Wed, 30 Nov 2011 14:35:30 GMT

You need to update the field DTINT2 with the actual lenght of the the field I_EDI_DD-SDATA.

Try this:


Data: lv_dtint2 type EDI_DTINT2.

lv_dtin2 = strlen( I_EDI_DD-SDATA ).
UPDATE EDID4 SET DTINT2 = lv_dtint2
                                 SDATA = I_EDI_DD-SDATA.

Re: Syntax error after upgrade

ehab_hanna — Wed, 02 Sep 2015 20:08:33 GMT

You should avoid updating SAP standard table but anytime you want to update any database table;

make sure to add WHERE Clause otherwise you are updating the whole database table.

UPDATE ZEDID4 SET DTINT2 = lv_dtint2

SDATA = I_EDI_DD-SDATA WHERE .........