Master Data Download

Former Member · ‎2004 Jan 10

Hello Guys,

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

without writing ABAP.

Regards

Ajay

TMNielsen · ‎2004 Jan 15

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

dirk_feeken · ‎2004 Jan 15

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

Former Member · ‎2007 Jul 18

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

Former Member · ‎2007 Jul 18

Hi ajay,

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

Than you have data in EXCEL.

Regards, Dieter