topic Dynamic SQL Statement with table name in Application Development and Automation Discussions

Dynamic SQL Statement with table name

Former Member — Fri, 27 Feb 2009 09:04:51 GMT

Dear all

i like to have a SQL statement with a dynamic tablename. Is this possible? If yes, how?

should be something like "select * from <mytablename>"

Thank you

Herbert

Former Member — Fri, 27 Feb 2009 09:07:01 GMT

Hi,

It's possible.

Ex;

w_tabname = 'MARA'.

select * from (w_tabname) into table ...

Former Member — Fri, 27 Feb 2009 09:07:19 GMT

Hi,

U can try like this,

select * from zcostfreq

where (where_tab).

endselect.

regards,

Neelima.

Former Member — Fri, 27 Feb 2009 09:08:59 GMT

You can have dynamic statement .

select * from (sname)

into table

Former Member — Fri, 27 Feb 2009 09:11:42 GMT

Yes this is possible. use the below reference code for this.

data: g_tablename type w_tabname,

gv_dref TYPE REF TO data.

FIELD-SYMBOLS: <g_itab> TYPE STANDARD TABLE.

gv_tabname = p_tablename (take table name form selection screen or as per ur requirement)

CREATE DATA gv_dref TYPE TABLE OF (g_tabname).

ASSIGN gv_dref->* TO <g_itab>.

now use the below select query to fetch the data

SELECT * FROM (gv_tabname) INTO TABLE <g_itab>.

Hope this will help