topic string operations in SELECT WHERE clause in Application Development and Automation Discussions

string operations in SELECT WHERE clause

Former Member — Mon, 21 Nov 2005 14:12:03 GMT

Hi,

PARAMETERS: P_MAKTX TYPE MAKT-MAKTX.

Lets say the user inputs "Pump". I want the program to search the text "pump" in all makt-maktx and display the result.

Could someone tell me how to write the select statement.

SELECT * from MAKT into table IT_MAKT where MAKTX ??? P_MAKTX.

Please advise.

Regards,

Shobhit

Re: string operations in SELECT WHERE clause

Former Member — Mon, 21 Nov 2005 14:16:06 GMT

Hi Shobit,

use the like addition,

PARAMETERS srch_str(20) TYPE c.

CONCATENATE '%' srch_str '%' INTO srch_str.

DATA text_tab TYPE TABLE OF doktl.

SELECT *

FROM doktl

INTO TABLE text_tab

WHERE doktext LIKE srch_str.

In your case it would be

CONCATENATE '%' P_MAKTX '%' INTO P_MAKTX.

SELECT * from MAKT into table IT_MAKT where MAKTX like P_MAKTX.

regards,

Ravi

Message was edited by: Ravi Kanth Talagana

Re: string operations in SELECT WHERE clause

RichHeilman — Mon, 21 Nov 2005 14:20:04 GMT

Try this....

This is an example for using the parameter. You could use a select-option instead.



report zrich_0001
       no standard page heading.


data: imakt type table of makt with header line.

parameters: p_maktx type makt-maktx.


ranges: r_maktx for imakt-maktx.

r_maktx-sign = 'I'.
r_maktx-option = 'CP'.
concatenate '*' p_maktx '*' into r_maktx-low.
condense r_maktx-low.
append r_maktx.

select * into corresponding fields of table imakt
         from makt
              where maktx in r_maktx
                and spras = sy-langu.

loop at imakt.
  write:/ imakt-matnr, imakt-maktx.

endloop.

Regards,

Rich Heilman

Re: string operations in SELECT WHERE clause

RichHeilman — Mon, 21 Nov 2005 14:20:12 GMT

Duplicate

Regards,

Rich Heilman

Re: string operations in SELECT WHERE clause

Former Member — Mon, 21 Nov 2005 19:09:59 GMT

Just remember that this is case sensitive, so instead, use the MAKTG field which has the uppercase equivalent description. You can change your user input also into uppercase and use the code that others mentioned here.

Srinivas

Re: string operations in SELECT WHERE clause

RichHeilman — Mon, 21 Nov 2005 19:11:42 GMT

Please make sure to award points for helpful answers and if you problem is solved, mark you post as solved. Thanks.

Regards,

Rich Heilman