Re:Data upload through LSMW

[Former Member]

what is LSMW, how many steps, what purpose

[Former Member]

Hi

LEGACY SYSTEM MIGRATION WORKBENCH (LSMW)

LSMW is a collection of projects (SAP). Project is a collection of subprojects. Subproject is a collection of objects.

Steps:

 Maintain object attributes: In this step we assign transaction code for the LSMW using a records object.

 Maintain source structures: In this step we need to define an internal table for getting data from flat files into SAP application.

 Maintain source files: In this step we need to add fields for the structure created in step2.

 Maintain structure relations: n this step SAP generates a relation between the created internal table (ITAB) and the recording object

 Maintain field mapping & Conversion Rules: In this step we need to generate the relationship between the internal table and recording object field.

 Maintain Field Values: This is optional step for LSMW. We can use the SAP generated default values.

 Specify Files: In this step we specify the file to be extracted for BDC processing using LSMW

 Assign Files: In this step SAP generates the relation between the Flat File assigned in Step7 and internal table defined in Step2.

 Import Data: In this step SAP Reads the data from assigned file into ITAB (internal table) internally SAP creates a file with extension as ……….. .lsmw.read.

 10. Display Import Data: Data in ITAB will be displayed as Report in this step. Report data will be in yellow color as data is in between source and recording objects.

 11. Convert Data: In this step data will move from table to recording object. Internally SAP transfers the data from “LSMW.Read” file into “LSMW.Conv:. Data in this file is ready for populating data into BDC session object.

 12. Display Converted Data: Data in Recording object will be displayed as report in this step. Here Report should be in green color.

 13. Create Batch Input Session: Based on Recording object data SAP creates a session object and transfers the data into the session object.

 14. Run Batch Inpurt Session: Opens “SM35” transaction Code to Process BDC session object.

Hope this helps u

pls assign points if useful

[sridevi_p]

Hi,

LSMW - Legacy System WorkBench - Helps to transfer data from legacy system to SAP either one time or periodically.

Steps -

1. Import data (legacy data in spreadsheet tables and/or sequential files)

2. Convert data (from source format to target format)

3. Import data (into the database of the SAP application)

a. Maintain Structure relations, field mapping and conversion rules.

b. Data from legacy system is read

c. Based on step a, the data gets converted

d. The converted data is imported to R/3 system based onBatch input processing or Direct Input or through IDOC Inbound processing

<i><b>Please assign points, if useful</b></i>

regards,

sridevi

[Former Member]

thanks a lot

Regards

shekar