LOOP AT internal table with WHERE clause

[Former Member]

Hi @ll

I have the bellow statement and I need the LIKE but from syntax point of view this is not allowed. How can I find a field with a proximate content.

LOOP AT itab_report_test WHERE sdata LIKE 'It works good, change'.

Thanks for your help in advance

/Kamran

[Former Member]

Hi @ll

I have the bellow statement and I need the LIKE but from syntax point of view this is not allowed. How can I find a field with a proximate content.

LOOP AT itab_report_test WHERE sdata LIKE 'It works good, change'.

Thanks for your help in advance

/Kamran

[Former Member]

Try with %

LOOP AT itab_report_test WHERE sdata LIKE '%It works good, change%'.

Otherwise..

LOOP AT yourtable.
  CHECK yourtable-sdata CS 'It works good, change'
*  process
ENDLOOP.

Edited by: Paul Chapman on Apr 23, 2008 6:17 PM

[Former Member]

Hi,

when I write this

LOOP AT itab_report_test WHERE sdata LIKE '%It works good, change%'.

it then says

Relational operator "LIKE" is not supported.

Regards

[Former Member]

Then you will need to try the 2nd option I provided.

loop..
  check field CS 'xxxx'.
*  process
endloop.

[Former Member]

Thanks it helped.

/Kam

[Former Member]

hi check this..

loop at itab where sdata like '*'.

endloop.

regards,

venkat.

[Former Member]

Hi,

LIKE operator is not allowed in LOOP statement.

do like this..

Loop at itab.

find first occurrence of 'Its works good, change' in itab-sdat.

if sy-subrc = 0.

do ut thing.......

endif.

endloop.

Regards

Syed A

[Former Member]

Hello,

Instead of

LOOP AT itab_report_test WHERE sdata LIKE 'It works good'

Try something like :

LOOP AT itab_report_test WHERE sdata CS 'It works good'.

Regards

Greg Kern