topic Re: lsmw in Application Development and Automation Discussions

lsmw

Former Member — Thu, 17 May 2007 11:23:10 GMT

Hi guys,

how to use excel file in lsmw.

what are the guidelines we have to follow.

Thanks in advance

Re: lsmw

Former Member — Thu, 17 May 2007 11:26:16 GMT

LSMW  Transaction Code

Enter Project Name => Module Name (Material Management)

Enter Subproject => Transaction Group (Master Data)

Enter Object Name => Transaction (Vendor Master)

Press Create / Change

Enter Projects Descriptions

Continue (F8)

Maintain Object Attributes

Execute (Ctrl+F8)

Press Display <> Changes button

Select Batch Input Recording (Radio Button)

Press Recordings – Overview button – (SHDB for Transaction Recording)

Press Create Recording

Enter Recording Name & Description

Enter Currently Using Transaction Code

Enter Needed Fields (Ex. Account Group for Vender Master)

Enter Values for All Uploading Field

Save

Press Default All Button

Maintain Source Structures

Press Display <> Changes button

Enter Source Structure Name & Description

Save

Maintain Source Fields

Press Display <> Changes button

Save

Enter Field Names & Length

Maintain Structure Relations

Press Display <> Changes button

Save

Maintain Field Mapping and Conversion Rules

Select or Auto set Fields to Real Fields

Save

Maintain Fixed Values, Translations, User-Defined Routines

Optional

Specify Files

Select Uploading File

Save

Assign Files

Press Display <> Changes button

Save

Read Data

Enter No of Transactions to View Data Summary

Display Read Data

Enter No of Transactions to View Data List

Convert Data

Optional

Display Converted Data

Optional

Create Batch Input Session

Run Batch Input Session

rEWARDS IF HELPFUL.

Re: lsmw

Former Member — Thu, 17 May 2007 11:28:37 GMT

Hi,

to use an excel file u need to save the excel file according to what u want to use as a separator between the fileds in the data. Whether a comma or space or a tab. While saving go to save as and specify the format u want and then in the step to specify the file in LSMW give the path of that file and again specify what separator you have used.

Reward if helpful.

Re: lsmw

Former Member — Thu, 17 May 2007 11:29:30 GMT

Hi,

It's not advisable to use the Excel file to upload the data .. u save the excel file as tab delimited file & upload.....

As per my knowledge , In LSMW , u cant upload data using excel file

Reward Points if it is Useful....

Thanks,

Manjunath MS

Re: lsmw

Former Member — Thu, 17 May 2007 11:38:12 GMT

hi,

there is no need to save your excel file into text or binary form

LSMW takes it directly

just specifiy the file name when it ask for file format

it should be text file. and code page is ASCII.

if this is not working on your side

then just do follow these steps,

1) save the Excel as *.csv with a delimiter e.g. semi-colon (';')

2) read the CSV-file as plain text file

3) split the line at the delimer (';')

just forgot to mention, do reward points if it helps.

Message was edited by: sudeep goswami

sudeep goswami

Re: lsmw

Former Member — Thu, 17 May 2007 11:49:13 GMT

hi,

First save your excel file with .csv format.

then go to specify files step of LSMW

select Legacy Data On PC

give file path and name

FILE CONTENTS->check Data for One source structure

DELIMITER : Comma->enter