topic Re: dynamic where condition in loop statement in Application Development and Automation Discussions

dynamic where condition in loop statement

Former Member — Tue, 15 Jan 2008 13:25:14 GMT

loop at itab where (condi).

......

endloop.

can i have a dynamic where clause for a loop statement and HOW?

Re: dynamic where condition in loop statement

Former Member — Tue, 15 Jan 2008 13:35:32 GMT

what do you mean by dynamic where clause?

Re: dynamic where condition in loop statement

Former Member — Tue, 15 Jan 2008 13:42:48 GMT

Hi,

Try like this.

TYPES: cond(72) TYPE C.

DATA: condtab TYPE TABLE OF cond.

APPEND 'CARRID = ' 'LH' ' AND' TO condtab.

APPEND 'CITYTO = ' 'NEW YORK' ' .' TO condtab.

loop at itab where (condtab).

......

endloop.

otherwise u can use the FM 'RH_DYNAMIC_WHERE_BUILD' for building the dynamic where clause.

Rewards points if helpful.

Regards,

Srinivas Ch

Re: dynamic where condition in loop statement

JozsefSzikszai — Tue, 15 Jan 2008 13:44:21 GMT

Re: dynamic where condition in loop statement

RichHeilman — Tue, 15 Jan 2008 13:44:25 GMT

Taken directly from F1 help.

Addition 3

... WHERE log_exp

Effect

WHERE can be specified with all table-types. After WHERE, you can specify any logical expression log_exp in which the first operand of any singular comparison is a component of the internal table. For this reason, all logical expressions are possible except for IS ASSIGNED, IS REQUESTED and IS SUPPLIED. Dynamic specification of a component through bracketed character-type data objects is not possible. Loops at sorted tables must have compatible operands of the logical expression. All rows are read for which the logical expression is true.

Regards,.

Rich Heilman

Re: dynamic where condition in loop statement

former_member182354 — Tue, 15 Jan 2008 14:12:05 GMT

Hi mate your question is your answer. You can have a syntax like what u specified.

loop at Itab where rec1 = 'xyz'.

endloop.

So what this loop does is ..It will loop only records where the rec1 is 'XYZ'.

Regards,

Raghav