Skip to Content
0
Former Member
Sep 10, 2009 at 08:11 AM

ABAP/4 Open SQL statement with WHERE ... LIKE and pattern too long

801 Views

Dear All,

I am getting an error "ABAP/4 Open SQL statement with WHERE ... LIKE and pattern too long" while executing the following statement:

CLEAR LS_RANGE.

LS_RANGE-SIGN = 'I'

+LS_RANGE-OPTION = 'CP' +

LS_RANGE-LOW = 'S_ADMI_FCD'

LS_RANGE-HIGH = 'S_ADMI_FCD'

COLLECT LS_RANGE INTO LT_RANGE.

SELECT *

FROM UST12

INTO CORRESPONDING FIELDS OF TABLE LT_OBJECT_VALUES

WHERE FIELD IN LT_RANGE

AND AKTPS = 'A'.

For options like BT(Between), EQ(Equal) in range table, this above query is executing without dump. But for option CP, it simply dumps & in dump what i found is, it is concatenating the value in low & high.

Does anyone have any idea regarding open sql using range tables.

Thanks,

Bhupinder