topic Re: Select where % in Application Development and Automation Discussions

Select where %

Former Member — Thu, 07 Jun 2007 06:39:53 GMT

Hi All,

Why is the below statment not fetching any data?

SELECT * FROM t012k INTO TABLE gt_t012k WHERE bankn EQ '%15%'.

Data is present in the table T012k having bankn = %15%.

Thanks,

Rakesh.

Re: Select where %

Former Member — Thu, 07 Jun 2007 06:45:33 GMT

hi rakesh,

instead of where u can use where bankn like here.

regards,

seshu.

Re: Select where %

Former Member — Thu, 07 Jun 2007 06:49:04 GMT

Hi rakesh,

Change code as below.

SELECT * FROM t012k INTO TABLE gt_t012k WHERE bankn LIKE '%15%'.

Regards,

Atish

Re: Select where %

former_member186741 — Thu, 07 Jun 2007 06:49:20 GMT

Do you actually mean that the bankn = '%15%' or is it LIKE it?

If like then you need to code:

SELECT * FROM t012k INTO TABLE gt_t012k WHERE bankn like '%15%'.

Re: Select where %

Former Member — Thu, 07 Jun 2007 06:49:49 GMT

Hi,

You need to write the Select like below

SELECT * FROM t012k INTO TABLE gt_t012k WHERE bankn LIKE '%15%'.

Regards

Sudheer

Re: Select where %

Former Member — Thu, 07 Jun 2007 06:50:57 GMT

How can i use LIKE % while selecting FOR ALL ENTRIES?

Re: Select where %

Former Member — Thu, 07 Jun 2007 06:52:12 GMT

Hi Rakesh,

yes you can use it. Just use it as you use EQ NE, etc.

Regards,

Atish

Re: Select where %

former_member186741 — Thu, 07 Jun 2007 06:52:38 GMT

LIKE is valid .....show us your full sql and someone will advise you how to edit it.

Re: Select where %

Former Member — Thu, 07 Jun 2007 06:52:42 GMT

hi rakesh,

try this,

SELECT * FROM t012k INTO TABLE gt_t012k for all entries in <itab> WHERE bankn LIKE '%15%'.

regards,

seshu.

Re: Select where %

Former Member — Thu, 07 Jun 2007 06:54:03 GMT

hi rakesh

please post the way you have defined the internal table.

if you are using the select statement. then try specifying into corresponding fields of table gt_t012k.

try using a key check also with it. like BUKRS or HBKID or HKTID.

and use like also.

Re: Select where %

Former Member — Thu, 07 Jun 2007 06:55:42 GMT

SELECT * FROM t012k INTO TABLE gt_t012k FOR ALL ENTRIES IN gt_checks2

WHERE bankn LiKE gt_checks2-bankn.

The error am getting is THE addittion FOR ALL ENTRIES cannot be used in the where condition BETWEEN LIKE and IN

Re: Select where %

Former Member — Thu, 07 Jun 2007 07:10:37 GMT

Hi,

why don't you use operator CS for searching substrings:

SELECT * FROM t012k INTO TABLE gt_t012k

FOR ALL ENTRIES IN gt_checks2

WHERE bankn CS gt_checks2-bankn.

Of course gt_checks2-bankn should not contain the % for substring escaping.

Regards,

Sebastian

Re: Select where %

former_member186741 — Fri, 08 Jun 2007 00:13:05 GMT

OK Rakesh I see your problem now. I did not realise that 'like' was not valid if you have a 'for all entries' clause (CP is also not valid).

If all your entries in the table have the % wildcards you can use this code to convert it to a range and then use the adjusted sql:

ranges r_bankn for t012k-bankn.

r_bankn-SIGN = 'I'.

r_bankn-option = 'CP'.

loop at gt_checks2.

R_BANKN-LOW = gt_checks2-BANKN.

REPLACE ALL OCCURRENCES OF '%'

IN R_BANKN-LOW WITH '*'.

append r_bankn.

endloop.

SELECT * FROM t012k INTO TABLE gt_t012k

WHERE bankn IN R_BANKN.