topic Select statement with wildcard dynamically in Application Development and Automation Discussions

Select statement with wildcard dynamically

Former Member — Thu, 15 Nov 2012 06:00:00 GMT

Hi all,

i need to fetch data with wildcards dynamically. pls help.

   SELECT * FROM z_ppc_kat INTO TABLE lt_ppc_kat
              WHERE qmart = 'QI' AND
                    qkatart = '8' AND
                    qcodegrp LIKE 'Q%'.

but the value of Q in the above statement is static, but in my requirement this value is dynamic.

pls help, how can we usage wildcars dynamically.

Best Regards,

Venkat

Re: Select statement with wildcard dynamically

Former Member — Thu, 15 Nov 2012 06:07:32 GMT

pretty simple solution.

data : v_matnr type string.

material is selected from database using this dynamic variable v_matnr.

use concatenate statement --> add "%" sign at the end of concatination.

see snipppet:

CLEAR V_MATNR.
    CONCATENATE IT_DATATAB-MATNR(11) '%'
    INTO V_MATNR.
    CONDENSE V_MATNR. "use condense to removce extra spaces.
    SELECT SINGLE MATNR
     FROM MARA INTO IT_DATATAB-REF
     WHERE MATNR LIKE V_MATNR.

revert back if problem noit solved.

Re: Select statement with wildcard dynamically

Former Member — Thu, 15 Nov 2012 06:14:51 GMT

Hi Abhishek,

it works. thanks.

Best Regards,

Venkat