topic Re: define string in where in Application Development and Automation Discussions

define string in where

Former Member — Tue, 27 May 2008 05:54:20 GMT

hi all,

how can i define this i am getting error.i have concatenated the condition in l_compare.

data: l_compare type string.

LOOP AT t_kna1_2 WHERE (l_compare) .

endloop.

Former Member — Tue, 27 May 2008 05:58:17 GMT

Hi,

In Where Condition ,You can specify the In parameter like

Where t_kna1-field = l_comapre.

Regards,

Shiva Kumar

Former Member — Tue, 27 May 2008 06:09:05 GMT

I think you cannot do that for loop, but thats possible for select query.

DATA: BEGIN OF t_data OCCURS 10,

matkl LIKE mara-matkl,

END OF t_data.

DATA: w_where TYPE string.

MOVE 'MATKL = ''AAA''' TO w_where.

SELECT MATKL

FROM MARA

INTO TABLE T_DATA

WHERE (W_WHERE).

Above query works. But

LOOP AT t_data WHERE (w_where).

ENDLOOP.

doesnot work.