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.