file upload

[Former Member]

hello,

i want to upload the excell files to fico i.e. G.L. master of one file, in excell i made the template and enter the data and this file i want upload data from an excel sheet in to sap, how to do through lsmw please help me i want to do very urgently

thanks

suja

[Former Member]

Hi Sujatha,

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

reward if it helps..

Regards,

Omkar.