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

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

Regards,

Ravi

[Former Member]

Hello,

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

Vasanth

[Former Member]

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

[Former Member]

Hi all,

Thanks a lot.

[Former Member]

Hi alik,

Parameters: Tab_name TYPE DD02L-TABNAME.

SELECT * FROM (Tab_name) INTO TABLE ITAB where ____

Regards

Sudheer

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

[Former Member]

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

Reward if this solves ur query.