topic Re: Long String in Select-Where condition in Application Development and Automation Discussions

Long String in Select-Where condition

Former Member — Fri, 06 Aug 2010 05:27:31 GMT

Hello Guys,

I am new to ABAP. I want fetch some data from table DPR_OBJLINK. but when I write a following query,

 select external_id into lv_external_id from dpr_objlink
where object_key = lv_object_key

I got following error.

The Field Object_key is long string, so it can not be used in where, on and having conditions.

Any pointers??

Thanks & regards,

Prashant

Re: Long String in Select-Where condition

SuhaSaha — Fri, 06 Aug 2010 05:34:51 GMT

You cannot use table fields of type STRING in the WHERE clause. Read SAP documentation, it is documented there: [http://help.sap.com/abapdocu_70/en/ABAPWHERE.htm]

Re: Long String in Select-Where condition

Former Member — Tue, 07 Sep 2010 11:37:06 GMT

Checked condition using primary key external id

Re: Long String in Select-Where condition

su01 — Thu, 09 Jun 2022 08:31:52 GMT

This kind of is what the author of the question said. It is the problem.

ABAP Help:

Except for columns of type STRING, RAWSTRING, or GEOM_EWKB, or LCHR and LRAW, all columns of the data sources specified after FROM can usually be evaluated in the WHERE condition of a query.

But what is/are the way(s) to solve that?

Do we have to retrieve the field completely and process it in ABAP?

Do we have to use native SQL?