Skip to Content
0
Former Member
Nov 27, 2006 at 11:45 AM

Dynamic Select

34 Views

Hi All

I need to pass internal tables to a select query dynamically. The database table from which i am selecting remains the same but the internal tables are subjected to change. Since I am using for all entries addition, the interpreter refuses to recognize the structure of the internal table on which i am using for all entries.

The code i tried to work with is as follows, but it throws a syntax error, saying "the structure of <fs_tab2> is unknown, there is no component matwa".

form sel_kotd001 using value(fp_tab1)

value(fp_tab2).

field-symbols:<fs_tab1> type standard table,

<fs_tab2> type standard table.

assign fp_tab1 to <fs_tab1>.

assign fp_tab2 to <fs_tab2>.

SELECT knumh

matwa

FROM kotd001

INTO TABLE <fs_tab1>

FOR ALL ENTRIES IN <fs_tab2>

WHERE matwa EQ <fs_tab2>-matwa.

endform.

any help in this regard will be appreciated

thanks

Sudhir