Reference no: EM133670633

Enterprise Resource Planning Systems Implementation

Data cleansing & conversion

Learning Outcome 1: Analyse and evaluate the critical stages of an SAP - ERP implementation in the development of enterprise wide systems

Learning Outcome 2: Design the SAP - ERP implementation process using SAP tools

Assessment Structure

KKAE is an industrial company that is undergoing an SAP implementation.
The rollout has reached the phase of data conversion and migration and they have decided to hire your team to perform the action. This deliverable aims to show the procedures of how KKAE Pte. Ltd handled the data cleansing and data mapping based on a list of employees who were using the SAP system in KKAE. The conversion is based upon a set of business assumptions.

In the pre-meeting, KKAE has given your team two files:
The first file is a list of employees who are using SAP system:
This list contains their contact and SAP access information
Some of the information is duplicated, and some information contains human-unreadable characters or invalid data
The second file is a template that shows the required layout format of the final output list.

They have required that the following tasks are to be completed by the deadlines:
Mark all the duplicated data with proper error flags.
Mark all the missing data with proper error flags.
Verify the human-unreadable characters, then take proper action on it; either remove the human- unreadable character or correct the unreadable character.
Verify and mark all the invalid data with proper error flags, then correct it.
Once the data is cleansed, map the data based on the template's pre-defined layout and create the final list.

Instructions

During software implementations, data transfer and the set-up of periodic/permanent interfaces is one of the most costly and time-intensive work packages. Several market studies have shown that, on average, data transfer accounts for 20% of implementation costs. In individual cases, it can exceed that amount.
In order to perform the initial data transfer from non-SAP systems, you need to efficiently carry out the following steps:
Identify data to be transferred in the legacy system and, if possible, eliminate (Clean up/filter) obsolete data and inconsistent data records at the same time.
Extract relevant data and write it to an ASCII file.
Convert the data from ASCII format to the object-specific data format required by SAP.
Process the converted data file based on BAPI, batch input or direct input technologies using SAP Load Programs (load).
Run your own check programs (if available) to further examine the results of the data transfer. You can
compare information such as the number of open items or the number of materials in both systems. Basic consistency checks are run during loading, as R/3 does not allow the creation of inconsistent data sets.

To get started on your assessment task, please follow the below instructions.
Self-enroll into a group of 4 (maximum).
Download Mapforce or become familiar with the software package you are using to complete this task.
Read the Assessment Structure carefully and view the following customer data files (Excel Sheet):
File 1: This first file contains 199 records of customer data and will need to be converted.
File 2: This second file contains about 10 records and will become the template file.
Perform the tasks by:
Using a package to cleanse File 1 (199 customer records)
Using another package to convert File 1 into the same format as File 2
Review the instructions above to perform the initial data transfer from non-SAP systems.
Submit your assessment including the following:
Student declaration form with % participation included and team number
File of cleansing
File of conversion
Word file with assumptions and screen captures describing the process of cleansing and conversion in full
Final output file (in xls or txt or csv format) after cleansing and conversion

You should have formulated groups within your session, so the next thing to do is to self-enrol