Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Regarding LSMW

Former Member
0 Likes
521

hi

How can we upload excel file data into SAP System using LSMW.

Please tell the procedure in Specify files.

Regards

Reddy

hi

How can we upload excel file data into SAP System using LSMW.

Please tell the procedure in Specify files.

Regards

Reddy

3 REPLIES 3
Read only

Former Member
0 Likes
500

Hi,

LSMW Steps:

1. TCode : LSMW.

2. Enter Project name, sub project name and object name.

Execute.

3. Maintain object attributes.

Execute

select Batch Input recording

goto->Recording overview

create

recording name.

enter transaction code.

start recording

do recording as per ur choice.

save + back.

enter recording name in lsmw screen.

save + back

Now there will be 14 steps.

2. MAINTAIN SOURCE STRUCTURES.

Here you have to enter the name of internal table.

display change

create

save + back

3. MAINTAIN SOURCE FIELDS.

display change

select structure

source_fields->copy fields.

a dialogue window will come .

select -> from data file

apply source fields

enter No. of fields

length of fields

attach file

save + back

4. MAINTAIN STRUCTURE RELATIONS

display change

save + back

5. MAINTAN FIELD MAPPING & CONVERSION RULE

display change

click on source field, select exact field from structue and enter

repeat these steps for all fields.

save+back

6. MAINTAIN FIXED VALUES, TRANSACTION, USER DEFINED

execute

save + back

7. SPECIFY FILES.

display change

click on legacy data

attah flat file

give description

select tabulatore

enter

save + back

8. ASSIGN FILE

execute

display change

save + back

9. IMPORT DATA.

execute

display change

save + back

10. DISPLAY IMPORTED DATA

enter ok, it willl show records only.

back

11. CONVERT DATA

execute

display change

save + back

12. DISPLAY CONVERTED DATA

execute

display change

save + back

13. CREATE BATCH INPUT SESSION

tick keep batch input folder

F8

back

14. RUN BATCH INPUT SESSION.

sm35 will come

Object name will be shown here

select object & process

Regards,

Aravind JM.

Read only

0 Likes
500

hi aravind

Thanx for ur quick response.

If you know tell me, otherwise don't tell .

What i am asking what you are posted.

Regards

Reddy

Read only

Former Member
0 Likes
500

hi,

Step 7: Specify files

In this step, we define how the layout of the input file is. The input file is a Tab delimited with the first row as field names. It is present on my PC (local drive) as C:\XD02.txt.

File attributes

Create an Excel file with your data and save it as a Tab-delimited text file on your local drive (C:\) and name it XD02. txt.

Source data in Excel file (saved as Tab delimited file)

pls reward if useful.

Regards,

Rajyalakshmi.

Edited by: Rajyalakshmi Attili on May 23, 2008 11:57 AM