topic LSMW TOOL in Application Development and Automation Discussions

LSMW TOOL

Former Member — Tue, 05 Jan 2010 21:53:57 GMT

respected gurus,

please help on the below,

1. As per my knowledge LSMW tool which is used for uploading data from legacy system to SAP R/3 but i have a doubt , how we upload figure ( Values ) like with the use of excel sheet or any other way? the process is same for all sub modules like GL, AR,AP,AA etc. for upload data ? please tell.

2. we have an column in GL master called "Trading partner". what states that what is the use of that column.

3. any difference between LSMW and BDC?

thanks in advance

satya

Re: LSMW TOOL

kishore709 — Wed, 06 Jan 2010 03:06:40 GMT

Hi satya,

1. LSMW need to upload Note pad (You need to convert from Excel to Note pad.)

- The same process for all sub modules like Vendor Master/ GL Master/ Customer Master/Cost center .....

2. What is Trading Partners?

In Business Terms Trading partner is your business partner within Group with whom you are doing business.In order to identify Inter Company transactions Trading partner field is used. You need to define all the Group Companies as company in SAP and all the defined Companies will be available for selection in Trading partner field. Trading partner can be defaulted in GL, Customer or Vendor Master. If you need you can populate trading partner at Document level too by doing settings in Document Type Master in T Code OBA7

3. There is no much differance between LSMW and BDC both are uploading toos.

Check the below link for differance

http://wiki.sdn.sap.com/wiki/display/ABAP/DebuggingLSMWandDifferencebetweenLSMWand+BDC

Hope it clear.

regards,

Kishore K

Re: LSMW TOOL

Former Member — Wed, 06 Jan 2010 04:32:23 GMT

Dear Satya,

As per my knowledge for tranding patner we have to maintain the table name VBUND in the excel sheet column.

Regards

Srinu