topic Re: Question Regarding Data Migration? in Application Development and Automation Discussions

Question Regarding Data Migration?

Former Member — Sat, 24 Oct 2009 14:44:43 GMT

HI every body,

I have to migrate some data regarding Materials like transaction MM01. Is it possible to migrate data without using BAPI.

Are BAPI's are that much important in Data Migration? We can't do with LSMW and BDC ?

Please Help me

Re: Question Regarding Data Migration?

Sandra_Rossi — Sat, 24 Oct 2009 20:10:12 GMT

It's a matter of performance. For example, it'll take 5 hours with BAPI but 50 hours with batch input (I just say that batch input is much slower than BAPI, not that there is a ratio of 1 to 10 which in fact would depend on many parameters) Please read the threads on that topic, and revert to us if you have any more precise question.

Re: Question Regarding Data Migration?

Former Member — Sun, 25 Oct 2009 14:22:16 GMT

Hi Sandra Rossi,

Actually in a an iinteraction with another ABAP consultant , he just said that MM01 transaction's data can not be transferred through BDC, I told it is possible but i never done with the same that's why i just kept silent.

Could u just tell me what are basic differances for BAPI and BDC.

Re: Question Regarding Data Migration?

Sandra_Rossi — Sun, 25 Oct 2009 14:41:37 GMT

Just make a recording in SHDB and you'll see whether it works or not (I don't know for MM01; there are some technical restrictions to use batch input).

For the differences, first [search the forum with words "difference bapi bdc"|http://www.sdn.sap.com/irj/scn/advancedsearch?query=differencebapibdc]

Re: Question Regarding Data Migration?

Former Member — Mon, 26 Oct 2009 10:46:34 GMT

Hi ,

Basically bapi updates directly to the table , so can say it directly updates the data base,

where as ur BDC will go to the database through screens , so each time u r screen accesion time is saved, and this time incraeses depending upon ur no. of tabs of the transaction , no of times u call the screen for ur no of recpords etc,

So use of bapi is alwys firts and bettre.

For material craete or cange u can use the bapi,

BAPI_MATERIAL_SAVEDATA

If u r transfering data from one system to other using rfc , u can get the data firts using rfc to internal table nad then u can segregate that to the coresponindg table of bapi.

or else if ur using direct xls u can upolod the xls fiel first then put the data in corrosponding bapi sturcture or table.

If u need some more info u r welcome.

Rajendra

Re: Question Regarding Data Migration?

Former Member — Mon, 26 Oct 2009 11:45:36 GMT

Thank u.

Actually till Ididn't worked on BAPI so little bit confusion. Actually I use to migrate every thing through transactions only. So it would be time saving with BAPI.

Re: Question Regarding Data Migration?

Sandra_Rossi — Mon, 26 Oct 2009 13:45:15 GMT

next time, search the forum. Note that you may be banned in extreme cases if you don't respect forum rules