topic Re: wild car in internal table loop in Application Development and Automation Discussions

wild car in internal table loop

Former Member — Fri, 23 Jul 2010 19:22:18 GMT

Hi,

This is for NW 7.0 EHP1 on Oracle.

Can I use wild card search criteria like '%ABC%' in internal table loop as shown below.

LOOP AT where itab1-objname LIKE '%ABC%'.

END.

The above is just sample and it is not a correct statement as it gives me syntax error. I cannot use LIKE in loop.

Is there is any other smart idea about it.

I hope my question is clear.

Your <<removed>> responce will be greatly appreciated.

Regards,

Sume

Edited by: Rob Burbank on Jul 23, 2010 3:41 PM

RichHeilman — Fri, 23 Jul 2010 19:24:05 GMT

You can't use LIKE, but try CP(contains pattern).

LOOP AT itab where objname CP '*ABC*'. 
ENDLOOP.

Regards,

Rich Heilman

Edited by: Rich Heilman on Jul 23, 2010 4:52 PM

Former Member — Fri, 23 Jul 2010 20:15:22 GMT

It seems like my logic is sorted out with CP. Thank you for the help.

I still could not use LIKE in loop at. I will be curious how you can use it in internal table.

Please let me know.

Regards,

point awarded.

RichHeilman — Fri, 23 Jul 2010 20:52:49 GMT

Sorry, I meant you CAN'T use LIKE.

Regards,

Rich Heilman

luis_quispe — Fri, 23 Jul 2010 21:05:22 GMT

Hi,

You can create a range variable and fill it with:

data: v_rango type range of campo with header line.

v_rango-sign = 'I'.

v_rango-option = 'CP'.

v_rango-low = 'ABC'.

v_rango append.

For performance you have to create the internal table index (WITH KEY)

LOOP AT itab WHERE IN v_rango field

regards

Lquispe