topic Material Master Data upload approach in Application Development and Automation Discussions

Material Master Data upload approach

Former Member — Sat, 09 May 2009 03:12:08 GMT

Hi,

I have a requirement to upload material master data into D.B

1. Which is the best option to use - BDC/LSMW/BAPI(Program)/Direct upload program!

2. Based on Material types fields to be uploaded will change as per sample sheet,

Can we make use of single sheet With all fields in it(By removing common fields for all Mat.Types)!

Will BAPI - BAPI_MATERIAL_SAVEDATA useful for both MM01/MM02!

What is the better approach for the same!

Thanks,

Deep.

Re: Material Master Data upload approach

Former Member — Sat, 09 May 2009 05:15:28 GMT

Hi deep.

Greetings.

As per my experince you should go for BDCs. I have prepared all the BDCs of material master for different views. And most important is that you can easily track the errors in Data-upload.

Good luck.

Prashant Tiwari

Re: Material Master Data upload approach

Former Member — Sat, 09 May 2009 07:49:18 GMT

Hi,

You can use direct input method.

The program RMDATIND is to be used to upload the material master data.

Alternatively you can also use BAPI method.

Uploading via BDC will take a lot of time and the BDC for material master is quite cumbersome.

Regards,

Ankur Parab

Re: Material Master Data upload approach

Former Member — Mon, 11 May 2009 07:10:05 GMT

Hi,

better to use BDC session method ,compare to the lsmw .

in session method automatically error log created.

Regards,

Madhu

Re: Material Master Data upload approach

Former Member — Mon, 11 May 2009 10:16:13 GMT

Hi,

Go for BAPI, check the below link for more datail.

[link1|]

[link2|http://sap-img.com/abap/bapi-to-copy-materials-from-one-plant-to-another.htm]

Thanks,

Asit Purbey.

Re: Material Master Data upload approach

Former Member — Mon, 11 May 2009 15:03:33 GMT

you can use LSMW BAPI method, this method creates the inbound IDOC's , if it is error in data it will clearly disply the log with status 51. its very easy method....

Re: Material Master Data upload approach

Former Member — Tue, 12 May 2009 04:55:44 GMT

Hi,

I have 2 queations in addition to above.

1. If i write a program using above BAPI for material master data. Then will it be better approach than LSMW with BAPI?

In this case user will trigger Z tcode & he will select input file from desktop & execute & report log will be shown in the output with successful & unsuccessful materials.

2. I have to upload material master data. Now i have got sample files for Basic, Plant & Sales organization specific.

If i have single excel file (All fields in one single sheet/line) which covers all unique fields of material master related to diff Basic, Plant & Sales organization specific data & also for all diffrent material types will that be fine (or) it usually required seperate excel sheets for diffrent kinds of data!

Please clarify about above 2 issues!

Thanks in advance.

Thanks,

Deep.

Edited by: Deep on May 12, 2009 6:56 AM