topic Re: Download data from multiple table in Application Development and Automation Discussions

Download data from multiple table

Former Member — Fri, 03 Apr 2009 12:56:10 GMT

Hello,

I need to download data from multiple tables. I have tried with joins but they dont seem to be doing the correct thing, When the code runs it dosnt do anything. Additionaly that data that I am supose to download I need to insert it in an excel sheet. Is there an other way to download data from multiple tables with out using joins? Can someone provide some example codes or a good link. Thanks

Re: Download data from multiple table

Former Member — Fri, 03 Apr 2009 13:03:15 GMT

Alternative to select from multiple tables is to use For All Entries statement.

do something like this.

select field1
          field2
   from table1
into table itab1
where field1 in s_field1.

if not itab1[] is initial.
select field3
           field4
           field5
  from table2
into table itab2
for all entries in itab1
where field1 =itab1-field1
  and field2 in s_field2.
endif.

Use the function module GUI_DOWNLOAD to download the data to desktop as excel.

Regards,

Ravi