how to upload excel file in LSMW

[Former Member]

While Doing LSMW Text fiel is uploaded easily but cannot find the way how to upload the Excel file as master data.

[Former Member]

Dear Tomesh,

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 (',')

LSMW :

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

Regards,

Naveen.

[Former Member]

Hi Tomesh,

Use this document.. this is a step by step guide for using LSMW.

http://www.scmexpertonline.com/downloads/SCM_LSMW_StepsOnWeb.doc

Hope this helps..

Cheers

Amandeep

PS: Rewards points if you find this helpful.

[Former Member]

Hi,

Save the file as DAT file and during recording use the Tabulator method.

Good Luck

Om

[Former Member]

Hi Sahu,

While the excel file preparation is completed, after that you have to prepare the text file form the excel file. This can be done if you follow the following path:

1. Open the excel file

2. Got to file & to "Save as" new windows appears

3. In the new window go to "Save as type " and select Tab delimited & save the file.

The text file is created.

regards,

Devojit

[Former Member]

IN the exce file select option save as then select tab delemited

in the field save as type : in save as dialog box, then upload this text file

reward points if hekpful

[Former Member]

hai

you can do it

assigning files take the first radio button in file contents data for one source structure.

take separator as tabulator.

it shouldsolve the issue.

regards

nalla