define string in where

[Former Member]

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]

Hi,

In Where Condition ,You can specify the In parameter like

Where t_kna1-field = l_comapre.

Regards,

Shiva Kumar

[Former Member]

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.