The risks of using LSMW for data migrations into SAP S/4HANA

By Winshuttle Staff Blogger on Nov 28, 2018

If your organization is using or planning to use LSMW as a data load tool in a migration project to SAP S/4HANA, you may face significant challenges. It was initially highlighted in the very first simplification list for S/4HANA 1511, page 302: “The LSMW (Legacy System Migration Workbench) function is still available within SAP S/4HANA, (on-premise edition) but not considered as the migration tool. The use of LSMW for data load to SAP S/4HANA is not recommended and at the customer’s own risk.”

LSMW not recommended for S/4HANA

And this is not surprising, LSMW is a tool originally created to support data transfers from legacy non-SAP systems to SAP systems, using csv files as the source to import legacy data. But the latest version, LSMW 4.0, was released by SAP in 2004. 14 years in the software industry is a very long time, even for SAP. These are just a few of the challenges that SAP customers face when using LSMW for data migrations to S/4HANA:

  • Is a tool designed for IT that requires extra SAP authorizations. You need to be fairly technical to use it, and only a few people in the organization usually have access to it.
  • The error-handling process is very cumbersome. A single error will stop the whole data upload and doesn’t help you much on identifying the wrong data.
  • It’s not flexible. If you want to change an LSMW script, the process can take a long time before a change is approved and implemented.
  • It has restrictions and requires workarounds when recording some of the transactions that have changed in S/4HANA, such as the Business Partner CVI interface instead of customer and vendor IDocs.
  • It’s hard to keep the audit trail as IT is usually running LSMW scripts on behalf of the business, who actually owns the data.
14-step process with LSMW

14-step process with LSMW

So, why are system integrators and SAP consultants still using LSMW as one of the main tools for migrating data to S/4HANA when it’s an outdated technology and SAP is clearly advising against it?

Back to the first versions of S/4HANA, the answer to this question was clear: there wasn’t really anything else apart from implementing Data Services. It took SAP some time to react, but they eventually released a couple of free options to address data migrations to S/4HANA from 1610 on-prem version onwards:

Option 1: SAP Rapid Data Migration package, based on SAP Data Services software. Predefined best practices content for critical data objects based on SAP Data Services software to extract, transform, map, and validate legacy data for upload to S/4HANA on-prem using SAP NetWeaver IDoc technology.

  • Basic Data Integrator: There is a basic free offering included in the HANA license, that provides ETL functionalities for loading legacy data in S/4HANA on-premise, but without further data quality and reporting capabilities.
  • Full Data Services: The complete offering is separately licensed (not part of SAP S/4HANA) and unleashes all data quality features for mitigating risk during the data migration process.

Option 2: SAP S/4HANA Migration Cockpit, a new basic tool included free of charge in S/4HANA 1610 and onwards with a browser-based UI and predefined templates and mapping for the most common master and transactional data objects. In addition, you can use a tool called Migration Object Modeler to adjust the predefined standard migration objects or to create additional ones.

The main challenge of these two options is that they are still technical tools designed for the IT department, and they don’t facilitate the participation of the business, who are the owners of the data and can ensure high data quality in the new system. Besides, even though the SAP tools offer predefined content for the critical data objects, we often find cases where it doesn’t cover 30%-40% of the objects in the project’s scope, which means technical resources need to get involved to create additional custom mass upload programs.

Using Winshuttle for data migration to S/4HANA on-premise

Winshuttle Studio offers an easy and flexible alternative to complete a full S/4HANA data migration project, or fill the gaps companies will encounter using SAP tools. Its fast implementation helps organizations address that long tail of data objects that are often excluded from the project, and also react to all those inevitable changes in the scope when things like mergers and acquisitions happen.

With Winshuttle, business users who are usually the owners of the data can use Excel to extract SAP data from a legacy system, manipulate it and upload it directly into S/4HANA, accelerating the data migration process, reducing costs, and removing the dependency on costly IT resources or consultants.

Winshuttle Studio to migrate materials

Material migration with Winshuttle Studio

About the author

Staff Blogger

The Winshuttle blog is written by professional thought leaders who are dedicated to providing content on a variety of topics, including industry news, best practices, software updates, continued education, tips and techniques, and much more.

Questions or comments about this article?

Tweet @Winshuttle to continue the conversation!