topic Read table, table name in variable in Application Development and Automation Discussions

Read table, table name in variable

Former Member — Tue, 22 Jul 2008 20:32:04 GMT

Hi all,

I am try trying to do the following.

Select statement to get the table name --> store in tname (variable).

Now, I have to do a select to read the data in this table (table name is in tname variable) based on some conditions

How do I do this?

1st step

Select ME_TECH from RSAC into tname

where NAME = 'PLANT'

and DATEFROM <= ldate

and DATETO >= ldate.

2nd step??

..........................................?

Thanks,

Anirudh.

Re: Read table, table name in variable

Former Member — Tue, 22 Jul 2008 20:38:14 GMT

Use Field Symbols

Re: Read table, table name in variable

Former Member — Tue, 22 Jul 2008 20:39:03 GMT

Please elaborate.

Re: Read table, table name in variable

Former Member — Tue, 22 Jul 2008 20:40:24 GMT

Hi,

Select * from (Tname) into corresponding fields of table ITAB1.

Note: the braces are close, there is no space between the brackets and the word.

Regards,

Subramanian

Edited by: Subramanian PL on Jul 22, 2008 1:41 PM

Re: Read table, table name in variable

Former Member — Tue, 22 Jul 2008 20:41:30 GMT

Hi,

Please search in SDN with the keyword..Dynamic internal table..I am sure you will get lot of posts on this..which discuss about populating the data from a table name which is dynamic..

Thanks

Naren

Re: Read table, table name in variable

Former Member — Tue, 22 Jul 2008 20:50:26 GMT

report ztest.

parameters: p_table type dd02l-tabname.

field-symbols: <fs> type standard table." of (p_table).


select * from (p_table)
into table <fs>
up to 20 rows.

There is another way using CL_ALV_TABLE_CREATE, for this you have to pass the fieldcatalog.

it return the internal table reference. using that you can proceed.

Re: Read table, table name in variable

Former Member — Wed, 23 Jul 2008 03:28:26 GMT

Hi,

When u want to fetch the data in a variable use select single stmt.

select single ME_TECH from <tablename>

into <variable name>

where <conditions>

Sharin.