HI,
LSMW : Legacy system migration workbench.
T.code : LSMW.
Is a data migration tool.
Advantage : can implement mapping logic automatically.
LSMW with batch input method.
go to t.code LSMW.
provide project name.
provide sub project name.
provide the object name.
project name is a interface prog name.
subproject name is attributes to the project.
object is identity while transfering the data.
go with create option in tool bar.
provide description for project, subproject, object.
F8 (execute)
It will display a window having 14 steps.
1 step :
Maintain object attributes and press F8
go with change mode
From the first step select option batch input recording.
provide recording name.
provide t.code we are doing recording.
provide data in application.
ctrl+s
double click on the field for eg LIFNR FIELD
provide the field of the internal table LIFNR
press ctrl+s
F3.
give description: for eg vendor account number.
delete the dummy value.
repeat the same process for the remaining 2 fields fro eg land1 and name1.
ctrl+s
F3.
with object attributes user can select a method required for data transfering.
go with 2nd step :
Maintain source structure : means an internal table for uploading .
F8.
create.
provide source structure : for eg KTAB(Internal table)
description.
ctrl +s
F3.
3RD step: Maintain source fields: Internal table fields.
place the ctrl on internal table i.e KTAB.
go with create option.
provide first field : LIFNR
description.
select lifnr and go for create.
same for remaining 2 fields also.
ctrl + s
4. Step : Maintain structure relations.
with structure relations internal table canbe assigned with database tables (<<<<) This symbol show it is already assigned.
ctrl+s
F3.
5. Step : Maintain Field mapping and conversion rules.
select the first field i.e LIFNR
go with assign source field in toolbar.
double click on lifnr field
select the next field.
go with assign source field.
double click on the field.
if all records want to have same country then we go for constant data.
6.step: Maintain fixed values ,translations use-defined routines.
it is for reusability.
7th step : specify the files F8.
select the first option
go for create.
specify the file name.
create text file enter the values, provide tabdelimiter.
give the description
give description.
select the file structure.
fields names at the begining of the file.
provide the text file in any sequence but having field names on the top of the records.
ctrl+s
design the flatfile.
8step:
go with Assign files.
ctrl+s
F3.
9th step : read data:
F8
we can see the records which read by syst.
10 th step: display read data.
loop and endloop will be executed
F8.
11 th step : go with convert data:
mapping logic executes.
F8.
12th step:Display converted data : for display purpose.
F8.
F3.
13 th step ; Batch input session
F8
14 th step: Run batch input session.
F8.
go with process Select foreground
textfile records will appear in application.
pls reward if helpful.
Bluesky
