topic Re: Problem while using LIKE statement in my BAPI in Application Development and Automation Discussions

Problem while using LIKE statement in my BAPI

Former Member — Tue, 12 Feb 2008 10:03:01 GMT

Hi,

Hello every body have a problem in using LIKE statement. I have written a BAPI to get the items according to the search criteria. Please advice, how can i pass my text to the select statement. At present i am passing the description like PIPE% from the front end.

SELECT * FROM TABLE WHERE DESCRIPTION LIKE DESCRIPTION.

I don't want to pass the description like PIPE% and the percentage symbol should be taken care in the back end.

Please help!

Kind Regards,

Rao (rao.busi@yahoo.com)

Re: Problem while using LIKE statement in my BAPI

Former Member — Tue, 12 Feb 2008 10:09:55 GMT

Hey this code is workinf fine. Check the same once.

DATA:

T_spfli TYPE TABLE OF spfli,

DESC TYPE SPFLI-CITYFROM VALUE 'NEW%'.

SELECT *

FROM spfli

INTO TABLE T_spfli

WHERE CITYFROM LIKE DESC.

Re: Problem while using LIKE statement in my BAPI

Former Member — Tue, 12 Feb 2008 10:27:59 GMT

Hi Jyothi,

Thanks. Please note that the search text will be passing from the front end, i.e. from portal. we never know what could the description. so we can't hard code the description like 'New'.

Please can you advice me, how can i pass the description to the select query.

Thanx,

Rao