topic Re: Loop with where statement containing * in Application Development and Automation Discussions

Loop with where statement containing *

Former Member — Wed, 13 Aug 2008 10:46:02 GMT

Hello experts,

I have this statement:

LOOP AT i_sorg WHERE q = quality

AND s = size

AND v = variant.

....

APPEND i_result.

ENDLOOP.

However for the size I need to give the user to enter wild cards "*"as well as ?. If the size contains "" the loop doesn't find the record. If I translate the "" in to "%" it doesn't run either so what should I do that the WHERE statement find the record.

Thanks

Re: Loop with where statement containing *

ThomasZloch — Wed, 13 Aug 2008 10:48:28 GMT

use the LIKE operator instead of "=" combined with the wild cards "%" and "_".

Thomas

Edit: operator CP with "*" and "+" should work as well.

Edited by: Thomas Zloch on Aug 13, 2008 12:51 PM

Re: Loop with where statement containing *

peter_ruiz2 — Wed, 13 Aug 2008 10:49:32 GMT

Hi,

using CP instead of the = sign.

regards,

Peter

Re: Loop with where statement containing *

Former Member — Wed, 13 Aug 2008 10:50:45 GMT

Hi,

Inside loop put check for the charecter '*' using FIND and use sy-subrc for your action.

Sudheer. A

Re: Loop with where statement containing *

Former Member — Wed, 13 Aug 2008 10:52:29 GMT

Hi,

Inside loop check fop the charecter '*' using FIND and then if sy-subrc = 0 then do your action.

Sudheer. A

Re: Loop with where statement containing *

Former Member — Wed, 13 Aug 2008 10:53:19 GMT

use LIKE instead of =.

Re: Loop with where statement containing *

former_member787646 — Wed, 13 Aug 2008 11:16:54 GMT

Hi,

Try this...

Data: vSize(10).

IF size = ''.

vSize = '*'.

ENDIF.

LOOP AT i_sorg WHERE q = quality AND s CP vSize AND v = variant.

....

APPEND i_result.

ENDLOOP.

Hope it helps.

Murthy