Material Master Data upload approach

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

Hi,

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

in session method automatically error log created.

Regards,

Madhu

[Former Member]

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.

[Former Member]

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....

[Former Member]

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