Application Development and Automation 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: 
Read only

Huge Data upload

Former Member
0 Kudos
202

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
Read only

naimesh_patel
Active Contributor
0 Kudos
171

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

Regards,

Naimesh Patel

Read only

Former Member
0 Kudos
171

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.

Read only

Former Member
0 Kudos
171

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.

Read only

Former Member
0 Kudos
171

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