Skip to Content
0
Former Member
Dec 27, 2007 at 11:25 AM

Problem in Dynamic where clause

317 Views

Hi,

I am having an issue with using dynamic where clause in a select statement.

The query that i want to emulate is:

SELECT * FROM (p_table)

INTO TABLE <dyn_table>

WHERE spras IN s_field1.

(s_field1 is a select-option)

I am trying to write a query like

SELECT * FROM (p_table)

INTO TABLE <dyn_table>

WHERE (ITAB).

ITAB is an internal table with the text 'spras IN s_field1' already present.

when i run the report, the query with the dynamic where clause gives a dump.

However, if i modify the contents of ITAB to have the text 'spras = 'EN'', the query executes successfully.

Can anyone please let me know how to write a dynamic where clause for select-options???

Cheers,

Raghav.