Implementation Question - Master Data

[Former Member]

Dear Gurus,

I have a quick question....

Which is the right way to upload Master Data (GL/ Cust/ Vend) into SAP 6.0?

eCATT OR LSMW

Thanks.

regards,

Raj

[Former Member · Accepted solution]

Hi Raj,

LSMW is the clearer way for Master data. ( It's based on Std program so more secure ! Moreover all cases ( errors ) will be handled in the Batch-input recording)

Hope this helps,

Erwan

[Former Member · Accepted solution]

Hi Erwan,

Thanks for the reply...

If we have to use LSMW to import MD into SAP how do we know which fields have to be imported.

Can you let me know the process?

Thanks.

regards,

Raj

[Former Member · Accepted solution]

Fields which have to be imported are those needed in the system ( some are mandatory and some depends on what and how you handle your MD )

I think functionnal people know which fields are necessary.

In the LSMW tool, you can map the field in input whith the corresponding field in SAP and eventually create rules, ...

LSMW is a powerful tool, and this is difficult to give more explanation on it here,...

You can check SAP Help :

<a href="http://help.sap.com/saphelp_erp2005/helpdata/en/e1/c6d30210e6cf4eac7b054a73f8fb1d/frameset.htm">http://help.sap.com/saphelp_erp2005/helpdata/en/e1/c6d30210e6cf4eac7b054a73f8fb1d/frameset.htm</a>

Hope this helps,

Erwan

[Former Member · Accepted solution]

Dear Raj,

You would need to identify the fields that you want to populate and map to the corresponding fields of legacy system. For some of the fields you may want to use constant value or some kind of logic.

You would then prepare layout that should be given to data extraction team (that extracts data from legacy system).

You would define a structure and mapping in LSMW accordingly. You have option to use constant values as well.

Visit the following link:

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

Hope this will help.

Regards,

Naveen.