Select from DB Tables with String

alejiandro_sensejl — Fri, 18 Jan 2008 08:16:52 GMT

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! *

Re: Select from DB Tables with String

alejiandro_sensejl — Thu, 07 Feb 2008 10:32:06 GMT

By now solved via an index table.

topic Select from DB Tables with String in Application Development and Automation Discussions

Select from DB Tables with String

Re: Select from DB Tables with String