This website is not affiliated with, sponsored by, or approved by SAP AG.

Tool to download SAP R/3 data into excel?

Third Party products such as GuiXT, BMC Patrol, Vertex, Ixos etc...

Moderators: Snowy, thx4allthefish

Tool to download SAP R/3 data into excel?

Postby 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
garp_was_here
 
Posts: 152
Joined: Fri Jan 24, 2003 10:52 am

Tool to download SAP R/3 data into excel?

Postby 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
YYZ_SAP
 
Posts: 1861
Joined: Thu May 08, 2003 11:44 am
Location: YYZ

Replay

Postby Parr » Wed Nov 05, 2003 9:23 am

Txshuttle and table pro :roll:
Parr
 

Postby 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
garp_was_here
 
Posts: 152
Joined: Fri Jan 24, 2003 10:52 am

Postby Guest » Thu Nov 06, 2003 2:13 pm

BW and BEX will do this
Guest
 
Posts: 865
Joined: Mon Oct 21, 2002 5:13 pm

Postby 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
Gordan
 
Posts: 415
Joined: Fri Jul 25, 2003 2:59 am
Location: Tuly Idiot Club Branch Office

Postby Guest » Fri Dec 19, 2003 9:41 am

We use a product called ERP2 from Quadrate.

http://www.quadrate.co.uk
Guest
 

X-Sheet

Postby 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
Tomk
 

SAP R/3 to Excel

Postby 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
iggy
 

TxShuttle maybe the solution

Postby 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
bhsap
 
Posts: 9
Joined: Mon Mar 29, 2004 3:24 am

Postby Hello » Mon Mar 29, 2004 4:11 pm

USE SE16
Hello
 

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

Postby 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
puke
 

Postby movsb » Wed Mar 31, 2004 5:24 am

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

Postby 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
Guest
 


Return to Third Party Products

Who is online

Users browsing this forum: No registered users and 2 guests





This website is not affiliated with, sponsored by, or approved by SAP AG.