topic Re: Huge Data upload in Application Development and Automation Discussions

Huge Data upload

Former Member — Fri, 16 May 2008 17:41:45 GMT

Dear Experts,

I got a requirement from my client, having 40,00,000 of customers need to upload into SAP.

What is the best way to do?

According to my knowledge...

LSMW is slow,

BAPI is slow,

Call Traction is slow

Session method

I do not know about API

Could you please suggest me which is the best method to upload 40,00,000 records.

naimesh_patel — Fri, 16 May 2008 17:53:15 GMT

LSMW will create a Session. That session you can process with SM35 with background processing.

Regards,

Naimesh Patel

Former Member — Fri, 16 May 2008 17:53:22 GMT

Maybe Batch-Input?

[Managing Batch-Input Sessions|http://help.sap.com/saphelp_nw04/helpdata/en/69/c250274ba111d189750000e8322d00/frameset.htm]

[BDC or Batch Input Program tips and tricks|http://www.sap-img.com/bdc.htm]

Hope it helps!

Regards.

Former Member — Fri, 16 May 2008 17:59:15 GMT

Hi Kaki,

I think direct input is better one for your requirement,because

it is direct update of data into tables,

no need of screen validations

moreover direct input method is faster

LSMW is also faster , So you can use anything from LSMW and Direct Input. But I recommend direct input.

Reward points if useful.

Thanks & regards,

Khan.

Former Member — Fri, 16 May 2008 18:14:45 GMT

hi check this...

The Direct Input Method will be the fastest in any case of upload of DATa

and it is better if you use the standard Methods that are available instead of custom code.

By the way do you have the Data Migration Workbench in your system

Transaction - EMIGALL

That also provides the option of parallel processing with huge numbers.

regards,

venkat