Select from DB Tables with String

[alejiandro_sensejl]

Hello Gurus,

I created following 'simple' DDIC Table:

CLNT MANDT CLNT 3 0 Client

ID ID NUMC 8 0 Object ID of Business Event Offered

DATE DATUM DATS 8 0 Date

STR (none*) STRING 0 String

• ... where field str has the predefined type string!

When I now want to search the string (I know it would be very slow, but that's ok in the first step, later on we create an index table or sth like that)

select * from ztas254_str_test

into table lt_str_test

where str like '%test%'.

on activation of the program I get the error

"The field "str" is a long string, so it cannot be used in, where on or having conditions."

How can I directly select/search the str field in from the table? Besides from the like condition I tried to search with a range and IN. But the same error occurs.

I'm testing on an ECC6.0 SP12.

If someone ever tried somethink like that please let me know!

Thanks in advance,

Alej

PS: * Points will be rewarded! *

[alejiandro_sensejl]

By now solved via an index table.