uploading material master

[Former Member]

Dear Sap Gurus

We are going to upload the material master which is the good method to upload the material master please send the documentation . my email is todkari_prakash@yahoo.co.in.Thanks in advance.

Regards

Prakash

[Former Member]

Thanks a lot

[Former Member]

Hi Prakash,

For uploading the Material master : LSMW is the best method to migrate the data from legacy system to SAP system. (This is preferred method for SAP Functional Consultants)

the T.Code itself is LSMW

And it is very easy to use, just follow the steps like...

First create a Flat file /Template for material master (using MS Excel sheet) with different fields (with Mandatory and or other fields, which you want to upload into SAP system) then

For Material master : (create Material master as an Object)

1. Create object that is material master,

2. Create Sub Project

3. Create Project

And then Execute

then choose the method (like batch input, etc, whichever is relevent)

and enter the required fields in it, and then execute..

And then you will FIND some steps (indicated with Radio Button)

If you complete all the steps...likewise you can upload the data...

the method is user friendly,

Hope you will have an idea about that,

Regards,

Srinivas.K

[Former Member]

Sugesting you to go through the first thread of this forum.

Regards,

Manish

[Former Member]

Dear Prakash,

You can use LSMW Tool.

It has the following Options:

1. Direct Input

2. Batch Input

3. BAPI

4. IDOC

For information regarding LSMW steps visit the following link:

/people/hema.rao/blog/2006/09/14/lsmw--step-by-step

http://help.sap.com/bp_blv1500/BL_US/html/dataconv_lsmw.htm

BDC/BAPI steps:

1. Fetch the data (Download from Desktop or Read from Application Sever).

2. Massage Data as per SAP Format.

3. Validate data (Move invalid data to internal table so that you can display the same)

4. Pass valid data

5. Move error data to internal table

If you are using BAPI the error records would be moved to BAPIRET2 or BPIRETURN.

If you are using BDC:

a. Session Method : You would need to process the session. Messages can be displayed with session analysis.

b. Call Transaction : You would need to populate the error messages by using a table with structure BDCMSGCOLL.

You could also develop a custom program using BDC or BAPI.

Visit the following link:

Where you would find more information regarding BDC and LSMW.

Regards,

Naveen.