topic Re: MB1C Upload in Application Development and Automation Discussions

MB1C Upload

Former Member — Thu, 29 Jul 2010 12:06:49 GMT

Hi ,

I have to upload more than 1 millons record in MB1C T-Code.

I want to know the better way to upload LSMW , BAPI Or Idoc.?

Please explain me.

Thanks,

Shankar

Re: MB1C Upload

Former Member — Thu, 29 Jul 2010 12:19:59 GMT

you can use BAPI - BAPI_GOODSMVT_CREATE.

Please read function module documetation for more details

Regards,

Rahul

Re: MB1C Upload

Former Member — Thu, 29 Jul 2010 12:30:01 GMT

Hi,

Use BAPI_GOODSMVT_CREATE.

Call this fucntion module in loop and populate data for each material document. Refresh the BAPI itabs after each call and do remeber to wait after commit so that the locks get release.

Thanks,

Re: MB1C Upload

Former Member — Thu, 29 Jul 2010 12:50:42 GMT

I like to dissent.

1 million records is a lot of stuff.

Keep in mind that you cannot load all the records in one go (most likely not). I would use LSMW with BAPI Bus2017 (MB_CREATE_GOODS_MOVEMENT) or possibly even a Batch-Input. Why LSMW? Because LSMW stores your data in several stages - you load them, they get stored on the application-server as the .READ file. Then you convert them according to your rules and the results get stored in the .CONV file. This has several advantages: if you experience a delay between load and convert or between convert and execute, you wouldn't have to do all from scratch again, you can re-start to proceed where you previously left off ... with the dataload you have at hand this is no small gain ...

... why even possibly BDC - because I can create BDC-sessions in a size that is likely to be of no performance-thread to the system and can then decide how many to process in parallel ... I have only package-sized protocolls to read (in case of errors) ... etc.

Re: MB1C Upload

Former Member — Thu, 29 Jul 2010 13:06:47 GMT

Moderator message - Please search before asking - post locked Rob