Best mean to push Sales Order data out of SAP?
Currently we are trying to push Sales Order data out of SAP into another layer through a BAPI. We are fetching ALL orders that were created within a given date range.
Our custom BAPI is using standard BAPI BAPISDORDER_GETDETAILEDLIST to retrieve most of the data but we have to run other validations and add descriptions and so, therefore coding is needed.
The execution times, for 6,700 Orders (Header, Item and Partners data included), is taking around 1 hour, needless to say it's taking a lot of time, I think there could be better approaches to achieve what we are trying to do, we've thought about running the process as a background job and then place the results into text files on the server and also IDocs.
All suggestions are welcome.
Thanks a lot.