2008 May 23 5:44 AM
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
2008 May 23 5:50 AM
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.
2008 May 23 5:53 AM
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
2008 May 23 7:27 AM
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