topic Re: Extracting Multiple Table Data Dynamically..Table is an Input parameter in Application Development and Automation Discussions

Extracting Multiple Table Data Dynamically..Table is an Input parameter

Former Member — Fri, 29 May 2009 19:35:19 GMT

Hi All

Can any one update the Program/design of extracting multiple table data as a list or to an excel sheet

For eg:- Mutliple Tables are entered in selection screen and upon executing the output should be to an excel sheet sequenctially according to the table names entered in the selection screen

Awaiting for your update

Regards

Shiva

Edited by: shivakumar bandari on May 29, 2009 9:35 PM

Re: Extracting Multiple Table Data Dynamically..Table is an Input parameter

naimesh_patel — Fri, 29 May 2009 21:14:09 GMT

You can try by creating the program this way:

1) Use the RTTS to create dynamic internal table at run time. Check this: [Create Dynamic Internal table|http://help-abap.blogspot.com/2008/09/dynamic-internal-table-creation.html]

2) Select the data into the dynamic internal table from the database table

3) Use the GUI_DOWNLOAD to download this data as excel into specified directory.

Regards,

Naimes Patel

Re: Extracting Multiple Table Data Dynamically..Table is an Input parameter

Former Member — Sat, 30 May 2009 23:00:58 GMT

HI Naimes

Thanks for youe reply

your second step says to select data from 'table' here tables are dynamic in nature I mean they are an input parameters..how can I write select on a table..

I can get the table existence from DD02L table and pass the retrieved tables to FM Get_Component_List to get the fields existing for the particular table,

But I cannot pass the dynamic table value to select query to retrieve the data..Please update me if you have anything on retrieving data from dynamically inputted value

Can I do this

Select * from <dyntable>

Any suggestions will be appreciated

thank you