How to Upload file in LSMW

The Legacy System Migration Workbench (LSMW) is a standard SAP tool used for data migration from non-SAP systems (legacy systems) into SAP. One of the most common and efficient methods for mass data upload in LSMW is through file upload, where data is prepared in an external file (such as Excel or a text file), then imported into SAP. In this blog, we guide you through the process of uploading G/L accounts in SAP. As an example, we are uploading 11 G/L accounts.

• Learn How to Create LSMW here.

LSMW has 14 steps to complete. We can separate the LSMW into 2 parts:

7. Specify Files

First ready the file as per the format in Excel.

Convert it to TXT File and then store it in the local desktop or laptop.

Lets come back to SAP LSMW.

Select ‘Specify Files’ and click Execute, or double-click the line item directly.

We are currently in display mode; let’s switch to change mode.

Now double click on the Legacy data – On the PC (Frontend).

Now upload the file from the local desktop or laptop (as shown below).

Enter the description, select the ‘Tabular’ option, and click the Continue button.

Click on save button.

8. Assign Files

Select ‘Assign Files’ and click Execute, or double-click the line item directly.

We are currently in display mode; let’s switch to change mode.

Just click on save button.

9. Read Data

Select ‘Read Data’ and click Execute, or double-click the line item directly.

Click on Execute button.

We can see 11 number below, It indicates that we are uploading 11 G/L accounts.

10. Display Read Data

Select ‘Display Read Data’ and click Execute, or double-click the line item directly.

Popup will be appeared and click on continue button.

Now, we can see the 11 G/L accounts that the system has read. Let us also check by double click on the any line item.

As you can see, all the fields have been mapped correctly.

11. Convert Data

Select ‘Convert Data’ and click Execute, or double-click the line item directly.

Click on Execute button.

Just click back button.

12. Display Converted Data

Select ‘Display Converted Data’ and click Execute, or double-click the line item directly.

A pop-up will appear—just click the Continue button.

Now, we can see the 11 G/L accounts that the system has converted. Let us also check by double click on the any line item.

As you can see, all the fields have been mapped correctly.

13. Create Batch Input Session

Select ‘Create Batch Input Session’ and click Execute, or double-click the line item directly.

Click on Execute button.

Batch input session created successfully.

14. Run Batch Input Session

Select ‘Run Batch Input Session’ and click Execute, or double-click the line item directly.

Or you can use T code: SM35 to Run the Batch Input Session.

Now select the line and click on Process button.

Select the mode and click on process button.

Note:

• Process/Foreground – Executes the upload step-by-step in the foreground, allowing user interaction (Only suitable for 1 or very few).
• Display errors only – Runs in the background but stops and displays only when errors occur.
• Background – Executes the entire upload in the background without user interaction.

Wait for 1 minute and see all 11 GL Accounts upload successfully.

Note: In real-time scenarios, we may need to upload thousands or even hundreds of thousands of master or transactional records into SAP, which can take several hours to complete.

Interested to learning more in LSMW?

• How to Create LSMW in SAP
• Uploading Files in LSMW: Step-by-Step Guide in SAP
• How to Export LSMW in SAP
• How to Import LSMW in SAP
• How to Delete LSMW Project or Sub-project or Object in SAP

SAP FICO Sub module wise:

• How to Create a Controlling area in SAP: Click here
• SAP Finance Enterprise structure: Click here
• SAP Finance GL Accounting: Click here
• SAP Finance Accounts Payable: Click here
• SAP Finance Accounts Receivable: Click here
• SAP Finance Bank Accounting: Click here
• SAP Finance New Asset Accounting: Click here
• SAP Controlling – Cost Element Accounting: Click here
• SAP Controlling – Cost Center Accounting: Click here
• SAP Controlling – Profit Center Accounting: Click here
• SAP FI MM Integration: Click here