topic Re: Like Condition in Loop at itab in Application Development and Automation Discussions

Like Condition in Loop at itab

muhammad_sohail — Fri, 04 Dec 2009 06:24:36 GMT

Dear Experts,

I want to use the like condition in loop at itab, It is not possible to use like condition in loop at itab, then how I can accomplish my task?

Example:

*LOOP AT itab where field1 like '5%'.*               " It is not possible
  SELECT 
       --- 
   FROM 
       ---
   INTO CORRESPONDING FIELDS OF itab2
   WHERE 
       ---
    APPEND: itab2.
    CLEAR: itab2.
  ENDSELECT.
ENDLOOP.

Thanks and Regards,

Sohail

Re: Like Condition in Loop at itab

Former Member — Fri, 04 Dec 2009 06:29:10 GMT

TRY WITH THE FOLLOWING


LOOP AT ITAB WHERE FIELD1 CP '5%'. " U CAN ALSO USE CS ( CONTAINS STRING ) , CP IS CONTAINS PATTERN

SELECT 
       --- 
   FROM 
       ---
   INTO CORRESPONDING FIELDS OF itab2
   WHERE 
       ---
    APPEND: itab2.
    CLEAR: itab2.
  ENDSELECT.


ENDLOOP.

Re: Like Condition in Loop at itab

Former Member — Fri, 04 Dec 2009 06:33:01 GMT

Hello

Try this:


LOOP AT itab where field1(1) EQ '5'. " It is  possible
  SELECT 
       --- 
   FROM 
       ---
   INTO CORRESPONDING FIELDS OF itab2
   WHERE 
       ---
    APPEND: itab2.
    CLEAR: itab2.
  ENDSELECT.
ENDLOOP.

Re: Like Condition in Loop at itab

former_member156446 — Fri, 04 Dec 2009 06:36:21 GMT

try like this :

data: it_itab1 type standard table of selopt,
          s_itab1 type selopt.

s_itab1-sign = 'I'.
s_itab1-options = 'BT'.
s_itab1-low = '5*'. " later if your requirement changes its, just another append away to do that...
append w_itab1 to it_itab1.
clear w_itab1.

LOOP AT itab where field1 in it_itab1.

Re: Like Condition in Loop at itab

muhammad_sohail — Fri, 04 Dec 2009 07:00:55 GMT

Very Helpful Answers from You guys, But I solve the problem with another field Condition.

Thanks you Very Much.