The SAP Fan Club Forums

by **garp_was_here** » Fri Oct 31, 2003 10:11 am

Hello Experts,

quick question:

Is there a tool available that allows to downlad SAP data into an Excel file?

We are looking for a tool that is able to download material data / BOM data into an excel sheet from material tables.

A function to explicity map in what column what data element should be stored would be great to have.

If somebody knows a tool that can do that, please let me know.
Also other quick solutions (no in deep abap coding) are welcome.

Thanks in advance,
Garp

by **YYZ_SAP** » Fri Oct 31, 2003 4:20 pm

Hello,

Did you search the internet for this? You should be able to find something (good). I just started Google with a search term including SAP and I got a number of hits, including http://www.solonde.com. I have never used the tool, but according to the website their product is powerfull.

Trust this helps.
Regards,
Jan Pel

by **Parr** » Wed Nov 05, 2003 9:23 am

Txshuttle and table pro :roll:

by **garp_was_here** » Wed Nov 05, 2003 10:50 am

Thanks for the tool recommendations. However, it seems that the tools are just able to dump the data to a file/DB.

Are there options to change column order before writing it to a file or write the data to column 9 of the excel sheet.

So as you see for us would it really be imported to determine the output format before creating the file.

From the product description this feature seems not to be provided by both tools. Please correct me if I am wrong.

Best regards,
Garp

by **Guest** » Thu Nov 06, 2003 2:13 pm

BW and BEX will do this

by **Gordan** » Mon Dec 08, 2003 5:20 am

Hello,

Did you consider TCode: SQVI - Quick Viewer.
Make report and download it to csv file.
Upload that in excel.

In excel you cannot view structured data in more than two dimensions.
If you have multiple items in one master record they will be showed in excel as multiple lines.

Gordan

by **Guest** » Fri Dec 19, 2003 9:41 am

We use a product called ERP2 from Quadrate.

http://www.quadrate.co.uk

by **Tomk** » Tue Feb 24, 2004 12:55 pm

X-sheet will do this, using the built in analysis, use an sql query to get the data from the table you need then, you can move, hide columns as you please then export to xls, html, xml, csv. Free trial

http://www.development-x.com

by **iggy** » Wed Feb 25, 2004 10:00 am

Hi,

StreamServe can do this quite easily either in a push or pull scenario from SAP. When we talked to them a while back I believe they had customers using their product for just what you desire.

Regards,

Iggy

by **bhsap** » Mon Mar 29, 2004 3:32 am

If you have a transaction from which you can extract some values Txshuttle may help you.
Let's say you want to extract a series of data from a list of materials.
You ask TxShuttle for displaying the material information on various views and for extracting different fields to specific Excel column.
You can map it exactly to the structure you need.
Et voilÃƒÂ :wink:

http://www.adar.fr/Winshuttle

by **Hello** » Mon Mar 29, 2004 4:11 pm

USE SE16

by **puke** » Tue Mar 30, 2004 11:10 am

Try http://www.saprfc.de There is an example readtable.xls --> http://saprfc.de/rfcs/readtable.xls

If you are familiar with vba you can easily change the coding matching your needs

by **movsb** » Wed Mar 31, 2004 5:24 am

XLR3 Data Extractor does just that! http://users.belgacom.net/xlr3dex

by **Guest** » Wed May 26, 2004 11:17 pm

Hi,

Mps do exactly what you need.

Try it at http://www.mpshp.com/mpsdemo2.zip

Regards,

Moises

The SAP Fan Club Forums

Tool to download SAP R/3 data into excel?

Tool to download SAP R/3 data into excel?

Tool to download SAP R/3 data into excel?

Replay

X-Sheet

SAP R/3 to Excel

TxShuttle maybe the solution

Re: Tool to download SAP R/3 data into excel?

Who is online