08-06-2010 6:27 AM
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
08-06-2010 6:34 AM
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]
06-09-2022 9:31 AM
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?
09-07-2010 12:37 PM