SAP Data Migration

A single standardised ERP system, enabling greater efficiency and effectiveness throughout the entire organisation, with zero error tolerances related to data, was completed before the hectic stock-build-up period for the summer.”

An importer and manufacturer of beer and soft drinks, which are distributed and sold through a network of wholesale, retail and hospitality outlets both within New Zealand and abroad.  The company promotes itself and its brands at a consumer level whilst its distribution and availability to the consumer is supported by a mix of above and below the line activity.  This activity includes, for example, the provision of loans and services to customers based on a variety of terms and conditions.


The client faced a growing challenge as it operates multiple ERP systems to support the finance, sales order processing, brewing, packing and product costing.  The decision to standardise on a single ERP system and expand that ERP with applications and functionality that support the business is aimed at improving the efficiency and effectiveness of managing and extracting data.  It should also bring significant gains through providing more timely, accurate data for effective decision making within the business.


Tenzing was engaged to support the implementation of the SAP ECC5 solution.   As part of the larger implementation, the data team was responsible for the end-to-end migration of source system data to the new SAP system, including:

  • Conducting a Baseline Assessment, which defines the business rules for the data and determines the nature and extent of the data problem.  A Baseline Assessment also includes a root cause analysis and identification of the sources and targets for the data
  • Developed a Remediation Plan, defining the data cleansing and improvement activities for remediating all issues and cleaning the data.   Data was fixed/cleansed according to the strategy developed in the Baseline assessment at the source, the server, the operational data store, or at some intermediate point in the extraction/propagation process
  • Development of the data extraction and SAP LSMW tools for the migration process as well as data validation tools and techniques.


The project was delivered on budget and on time, just before the hectic stock-build-up period for the summer.  The single standardised ERP system enabled greater efficiency and effectiveness throughout the entire organisation.  Data was a major factor to the success of the implementation and the data team successfully delivered all the various data components with zero error tolerances and finished before the allotted time frame.  This feat was repeated four times as the different sites across the country were switched over to the new system.