topic Best SAP interface alternative for massive data loading in Application Development and Automation Discussions

Best SAP interface alternative for massive data loading

eduardo_gironas — Thu, 17 Apr 2008 03:13:19 GMT

We have a non-SAP system which will load 400,000 invoices every month into a SAP ERP system according to next scenario:

1) An user executes a non-SAP program which will login to SAP and will generate invoices data and the same program will load them to SAP.

2) The non-SAP program will wait the results of the loading. If it went well, program will finish. If error occurred in one or more invoices during the loading, the non-SAP program will recover from SAP the error messages to show the user for taking corrective actions before attempting again.

Which one of the various SAP interfaces will help us to accomplish this scenario where the speed performance in loading is also an important fact to be considered ?

Many, many thanks for your help.

Re: Best SAP interface alternative for massive data loading

Former Member — Thu, 17 Apr 2008 06:55:54 GMT

Hi ,

For this Bulk Uploading always Custom RFC or BAPIs are Suggestable . Because

Using RFC u can reprocess the error records by creatin a errorfile and with the descriptions . But if u goto IDOC it is difficult to Process large number of Idoc incase of Error .

Rgds

Sree m

Re: Best SAP interface alternative for massive data loading

eduardo_gironas — Thu, 17 Apr 2008 13:40:27 GMT

Sree:

Thanks for your answer. And before closing this, I would like to know if the RFC/BAPIs are a very fast alternative in terms of massive data loading. In my attempt to investigate about SAP interfaces, some colleagues have experimented with a BAPI invoked from a non-SAP program that loads serial transactions of a bulk of materials with serial numbers (BAPI_GOODSMVT_CREATE) and the speed performance is not good comparing with the same process using a Batch Input, the problem with batch input is that it is unable to communicate to a non-SAP external program if the loading process had errors and the kind of error.

Should I think that I will not have the 2 thinks at the same time? i.e. speed performance and good error communications in the loading process?

Thank you again for your attention.