SQL Performance Optimizations During SAP ECC to SAP S/4 HANA Migration

Too often, manufacturers and distributors stick to dated practices and technology just out of habit. However, most of these businesses experience delays and mistakes that they brush off as inevitable. Worse, they eventually realize that they are slipping further and further behind the competition.

SAP, the market leader (in revenue terms) has decided to phase out support for SAP ECC in next 5 years and its existing install base customers are bewildered in deciding how they should migrate from earlier versions to S/4HANA. Migration gives the organization a chance to streamline its processes, rationalize interfaces, decommission custom code, enforce standard SAP modules to become more efficient.  However, migration from SAP ECC to SAP S/4 HANA comes with its own set of unique challenges from organization perspective, vendor perspective, end user perspective and the consultant’s perspective.

In this paper are described SQL performance optimizations during SAP ECC to SAP S/4 HANA migration.