topic Re: How to use a table name in the select statement using a variable? in Application Development and Automation Discussions

How to use a table name in the select statement using a variable?

Former Member — Thu, 22 Feb 2007 12:56:38 GMT

Hi Everybody,

I got a internal table which has a field or a variable that gets me some tables names. Now I need to retrieve the data from all these tables in that field dynamically at runtime. So could you suggest me a way out to use the select query which uses this variable as a table ?

Regards,

Mallik.

Re: How to use a table name in the select statement using a variable?

Former Member — Thu, 22 Feb 2007 12:58:38 GMT

select * from (v_table_name) into table itab where ....

Regards,

Ravi

Re: How to use a table name in the select statement using a variable?

Former Member — Thu, 22 Feb 2007 12:59:40 GMT

Hello,

LV_TABNAME = 'MARA'.
Select * from ( LV_TABNAME ) ....

Vasanth

Re: How to use a table name in the select statement using a variable?

Former Member — Thu, 22 Feb 2007 13:03:17 GMT

Hi Malli,

Dynamic values to the SELECT query are passed with in brackets.

DATA V_TABNAME TYPE DD02L-TABNAME.

V_TABNAME = 'VBAK'.

SELECT * FROM (V_TABNAME) INTO TABLE ITAB.

Thanks,

Vinay

Re: How to use a table name in the select statement using a variable?

Former Member — Thu, 22 Feb 2007 13:06:34 GMT

Hi all,

Thanks a lot.

Re: How to use a table name in the select statement using a variable?

Former Member — Thu, 22 Feb 2007 13:07:04 GMT

Hi alik,

Parameters: Tab_name TYPE DD02L-TABNAME.

SELECT * FROM (Tab_name) INTO TABLE ITAB where ____

Regards

Sudheer

Re: How to use a table name in the select statement using a variable?

Former Member — Fri, 23 Feb 2007 10:49:46 GMT

Hi all,

Actually i need some more clarification. How to use the same select statement, if i've to use the tabname in the where clause too?

for ex : select * from (tab_name) where....?

Can we do inner join on such select statements? If so how?

Thanks & Regards,

Mallik.

Re: How to use a table name in the select statement using a variable?

Former Member — Fri, 23 Feb 2007 11:22:39 GMT

tables: mara.
DATA  TABNAME(10).
SELECT-options: s_matnr FOR MARA-matnr.
TABNAME = 'MARA'.
SELECT * INTO TABLE ITAB FROM (TABNAME)
 WHERE matnr IN s_matnr.

Re: How to use a table name in the select statement using a variable?

Former Member — Fri, 23 Feb 2007 11:40:15 GMT

Hi judith,

Thanks for the reply, But can we use inner join or for all entries in such select statements which use variable in place of table name? if so how?

Best Regards,

Mallik

Re: How to use a table name in the select statement using a variable?

Former Member — Fri, 23 Feb 2007 11:42:49 GMT

I tried and it gave an error, I gues no.

Reward if this solves ur query.