Skip to Content
-1

How to Increasing the performance of High-Volume load data test from SAP ECC to Google Spreadsheet

Aug 24, 2017 at 02:47 PM

185

avatar image
Former Member

Hello Experts,

I performed a load volume test for 100k records of sales order details sync from SAP ECC system to Google Spreadsheet, it is taking around 40 minutes.

Thanks,

M Raveendranad.

ABAP Development
SAP NetWeaver | sap sales order
Answers Answers and Comments
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
Comment
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sort by:
avatar image
Mike Pokraka Answered Aug 24, 2017 at 09:30 PM
5

Let me get this straight, you want to improve your ABAP report to send data faster across the internet?

I'm sorry to disappoint you, but the internet is not like a water pipe where you can increase the pressure to make water flow faster.

Unless your program is really really really bad, the slowest part is almost certainly outside of SAP. Write your data to an internal table and then compare the times. The difference is how much time the network and google take up.

Show 3 Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
Sandra Rossi
Aug 25, 2017 at 06:22 AM

And if the issue is about the "the time bound limit, While Scheduling a Foreground job", then do it in background, there's no timeout (and you could also do it in parallel background jobs if you want).

2
Jelena Perfiljeva
Aug 25, 2017 at 05:32 PM

Well said. I'm also very curious why on earth would anyone need to send thousands of records from SAP to Google spreadsheet to begin with...

1
Bartosz Jarkowski
Jelena Perfiljeva
Aug 25, 2017 at 06:44 PM

Backup :-)

0
Comment
Further commenting has been locked.