topic Re: select like string in parameter in Application Development and Automation Discussions

select like string in parameter

Former Member — Mon, 21 Mar 2011 06:10:30 GMT

Hi All

i want to fetch data

as per vendor name

from lfa1

according to input given by user in parameter

if user doesnt remember full name of vendor.

SELECT-OPTIONS comcode FOR wa_vendet-bukrs OBLIGATORY.

PARAMETERS venname LIKE wa_vendet-name1.

select----

WHERE a_{bukrs IN comcode AND b}name1 LIKE venname.

Re: select like string in parameter

Former Member — Mon, 21 Mar 2011 06:20:54 GMT

You can write you Select as -

Get your Parameter value in a variable of type c.

Also, you will have to prefix and suffix '%' to the search string.

CONCATENATE '%' P_VALUE '%' INTO L_TMP.

So your Select query becomes

select----

WHERE a_{bukrs IN comcode AND b}name1 LIKE L_TMP.

Regards,

Rupesh

Re: select like string in parameter

Former Member — Mon, 21 Mar 2011 06:23:18 GMT

Hi,

here is a sample for searching name1 and street in LFA1 :

report  zsbabl_lfa1.
                                                                                types: begin of xl,
         lifnr     type lfa1-lifnr,
         name1     type lfa1-name1,
         stras     type lfa1-stras,
       end   of xl.
                                                                                data:  xsl type xl.
                                                                                parameters: xp_name1          type  lfa1-name1 default 'In*'.
parameters: xp_stras          type  lfa1-stras default '*Se*'.
                                                                                start-of-selection.
                                                                                translate  xp_name1        to  upper case.
     translate  xp_name1     using  '*%'.
     translate  xp_stras        to  upper case.
     translate  xp_stras     using  '*%'.
                                                                                EXEC SQL                     PERFORMING  list.
       SELECT LIFNR, NAME1, STRAS
                              INTO  :xsl
                              FROM  LFA1
       WHERE  UPPER( NAME1 )  LIKE  :xp_name1
       AND    UPPER( STRAS )  LIKE  :xp_stras
     ENDEXEC.
                                                                                END-OF-SELECTION.

FORM list.
                                                                                WRITE:                   /1  xsl-lifnr,
                                    xsl-name1,
                                    xsl-stras.
                                                                                ENDFORM.

We needed this not knowing the names are written in upper and lower case combinations.

The mixed search in only possible in native SQL UPPER CASE search.

Regards,

Klaus

____________________________________________________________________________________________________________________________________

Edited by: Klaus Babl on Mar 21, 2011 7:24 AM

Re: select like string in parameter

Former Member — Mon, 21 Mar 2011 06:39:08 GMT

Just a suggestion, why not make sure the vendor name is valid before you do any selection? Parameter with input help maybe.