Skip to Content
Jan 08, 2004 at 02:00 PM

Performance downloading data to Excel


Hi experts.

I have programmed a nice ABAP program, that is used to extract all materials

in our system and write them to a Excel Sheet. Why have I prgrammed my own ABAP??

Because the Excel sheet consists of three tabs. And a lot of macroes.

The second tab holds the materials. The first tab, the user is able to create the data needed to

make reservations (via MB21)

That meens that I have also programmed a ABAP program that reads the Excel data.

So far so good.

The problem is PERFORMANCE!! When I am writing the Material Master data to the

excel, via Call Methods, it takes a VERY LONG TIME to write about 8000 rows!!

Does anyone have any good idea to speed up this process??

Best regards

And have a nice day