topic Re: Master Data Download in Application Development and Automation Discussions

Master Data Download

Former Member — Sat, 10 Jan 2004 20:31:35 GMT

Hello Guys,

Is there any standard way to download crictical master data into excel

without writing ABAP.

Regards

Ajay

Re: Master Data Download

TMNielsen — Thu, 15 Jan 2004 09:47:20 GMT

Hello Ajay

Why not use ABAP ? - it's part of the best programming environment in the world.

You could also download data via SE16, but there you will miss the link between tables like the connection between MARA and MARC.

You could also create an ABAP Query, but thats one of the worst tools in the world.

You may also have access to tools that can dump the data directly from the database.

Why not use ABAP ? - it's part of the best programming environment in the world.

Best regards

Thomas

Re: Master Data Download

dirk_feeken — Thu, 15 Jan 2004 13:13:43 GMT

I don't know if there's a download as text/xml/whatever file you can directly mport to Excel. Should be mentioned in the R/3 documentation. But if you just want to try to avoid ABAP (perfect topic for this forum) you can also use the other way around: Write with Visual Basic an Excel macro which connects via RFC (use the DCOM connector libraries) and call the necessary BAPIs to get the data.

Dirk

Re: Master Data Download

Former Member — Wed, 18 Jul 2007 08:24:38 GMT

Hi,

Can I ask where you found the SAP DCOM connector? I cannot seem to find it anywhere on the internet

If you could help me / send the dcom files to me I would be much apprecaited

Thanks

stu

Re: Master Data Download

Former Member — Wed, 18 Jul 2007 08:29:28 GMT

Hi ajay,

take SE16N with your tabel and use excel-inplace as ALV-Layout.

Than you have data in EXCEL.

Regards, Dieter