Legacy System Asset Data Transfer using LSMW
I have had a chance to work on multiple projects where we have uploaded assets using LSMW. Even in cases where Z programs exist for asset upload, many times the documentation does not exist and much effort is lost in trying to understand and modify how the program works. So, LSMW seems an easier solution as it does not take much effort to build one even from scratch. This document shows steps to build a simple LSMW to upload assets where the fields to be uploaded are standard.
Step 1: Create Project, Subproject and Object for the asset transfer. A project or subproject already exisiting in the system could also be used to create the object. For a scenario where we are migrating a company code from Legacy to SAP, we could use the same project and subproject and create different objects for uploading vendors, assets, customers etc.
Use the create button on the top of the screen to start.
Step 2: Enter the project, subproject and object name and click on execute.
Step 3: Click on the Maintain Object Attributes line and click on execute
There are 4 options through which data can be transferred through LSMW to the SAP system:
- Standard Batch/Direct Input
- Batch Input Recording
- Business Object Method (BAPI)
In this document, we will use the Batch Input Recording method which is the easiest according to me. In Batch input recording, we do a recording of AS91 transaction code for a sample asset filling in all fields which we would require for our data transfer. Remember to fill only those fields which are required for data transfer.
So, select the Batch Input Recording radio button and enter a name for the recording. Once done, click the overview button next to the recording name field.
On the overview screen, select the “create recording” button to start the recording by giving a name and description.
On the next screen that appears, enter transaction code AS91. We will not use transaction AS01 to create asset because we are creating a legacy asset. Using AS91 will allow us to enter carry over values for asset from the legacy system.
After entering the transaction code, transaction AS91 initial screen is displayed. Enter data for a sample asset and carefully fill only the fields required. The fields filled/changed for the sample asset would be captured in the target structure for the LSMW as shown below. Once ascertained that all the fields are captured, use the Default All button to default the fields to the target structure. The target structure is nothing but the list of fields which SAP is expecting will be provided values with for creating assets through LSMW. In case it is felt that the recording was not done correctly or fields were missed, use the repeat recording button to repeat the recording and capture the correct fields. It is always recommended to create the LSMW in Test system, so that repeat recording can be done as many times as possible and the sample assets thereby created do not effect as much as if it were done in the Production system. Once it is ascertained that the LSMW is working fine in the test system, it can be exported and imported to the Production system.
Step 4: Execute the next step “Maintain Source Structures”
Create a source structure name and description
Step 5: Execute “Maintain Source Fields”
Create Source fields for the source structure. Source structure is the structure of the file used to load data into SAP through LSMW
The above screenshot shows all the source fields in the source structure. The excel or text file used to input data should have the same fields as defined in the source structure and in the same order.
Step 6: Execute “Maintain Structure Relations”
Here the source structure created is mapped to the target structure
Step 7: Execute “Maintain field mapping and conversion rules”
This step is used to map the source structure field from which the value is input to every target structure field. All the target structure fields must be mapped in this step. Click on the target structure field and use the Create Source field button to assign
Step 8: Execute “Maintain fixed values, translations, user defined routines”
Step 9: Execute “Specify Files”
The input file is on the computer. Click on the “Legacy Data : On the PC” and use the Add entry button to specify files.
Enter parameters as needed and save. Special attention needs to be paid to the check box “Field Names at start of File” to see if the input file has the first row as field names or not.
Step 10: Execute “Assign Files”
The screen should already have the file specified in the previous step assigned against the Source structure name
The below screenshot shows the sample file used. As can be seen, the fields in the excel match the fields in the source structure. Since, we specified a text file as the input file in Step 9, the below excel needs to be converted to a .txt file before data can be uploaded.
Step 11: Execute “Read Data”
This step reads the input file from the location specified. Generally, we read all the rows from our input file. So, no transaction numbers are specified.
The whole file is read and as seen in the status below, 9 transactions have been read.
Step 12: Execute “Display Read Data”
In this step, all the records read from the input file are displayed.
Double click on a row to see the field values read against each of the fields in the source structure.
Step 13: Execute “Convert Data”
Since we need all the records read from the input file to be converted to the target structure, no transaction numbers are specified.
All the 9 records are converted as shown in the screenshot below.
Step 14: Execute “Display converted data”
All the records converted to the target structure are displayed.
Double click on one of the rows to see the values as read into the target structure fields and will be uploaded into SAP.
Step 15: Execute “Create Batch Input Session”
Specify the Name of the Batch session. Do not forget to select checkbox “Keep batch input folder” so that logs for the batch input session can be analyzed once the session processing is complete.
A message with number of records read for asset upload is displayed as shown below.
Step 16: Execute “Run Batch Input Session”
Click on the batch input session and choose to execute in foreground or background. Once the session is executed successfully, the assets are created in SAP and the asset numbers can be seen in the log for the batch input session.
I have published another document with important SPRO setting to be done before asset upload –> SPRO Settings for Legacy System Asset Data Transfer