Skip to Content
0
Jul 08, 2016 at 05:51 AM

Long string not allowed in WHERE clause

1023 Views

hi,

in my program on Netweaver 7.02 I'm using a SELECT with a WHERE clause on a long string :

SELECT * INTO TABLE it_edid4

FROM edid4

FOR ALL ENTRIES IN it_edidc

WHERE docnum = it_edidc-docnum

AND segnam = 'E1RDID'

AND sdata LIKE 'HEADER HEADER_DATA WA_HEADER_DATA-BILLNO%'.

This works great on NW702.

But now we are upgrading to NW740, and the statement is not allowed anymore :-(

Error message :

The field SDATA is a long string or a text and cannot be used in the WHERE condition.

Is there a good alternative to perform this select ?

Performance wise it's not good to first read all entries, loop over them and check the SDATA field.

gr

Hans