Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Huge Data upload

Former Member
0 Kudos

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.

4 REPLIES 4

naimesh_patel
Active Contributor
0 Kudos

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

Regards,

Naimesh Patel

Former Member
0 Kudos

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
0 Kudos

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
0 Kudos

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