Sap Hcm Consultants

SAP HR DATA MIGRATION

Data migration is a major and key task for a successful SAP HR implementation.

Data Migration refers to the process of transitioning data from the AS-IS environment(any non-SAP systems)  to the To-Be environment (SAP ECC HR).  In other words SAP data migration means the data transport from current systems such as Baan, JD Edwards Peoplesoft (any non-SAP systems)  into SAP  systems.

Data Migration Process 

Data migration process steps are as below

1:  Data Preparation and Analysis

Decide the strategy for data preparation. Identifies what data is needed in SAP HR application .It is based on implementation country.

2:  Data Mapping

Analysis phase is to identify the data sources that must be transported into the new system.Identifying legacy data fields to be migrated to SAP. Identification of gaps in requirements & data.

3:  Data Extraction and Conversion

Data Extraction from legacy system and Conversion to a format which is acceptable by SAP.

4:  Data Upload

Data Upload into the SAP HR database using any data migration tools such as LSMW

Group the data to be migrated  such as  core HR data, Time data, payroll relevant data.

5:  Data upload issue identification, resolution and Reload

Categories issues based on kind of error e.g. incorrect configuration, incorrect mapping, incorrect data.

Resolve data errors.

Reload data, if reload is necessary.

6:  Testing and data validation

After the data upload ,there are  number of tools  available to test & validate  data (SAP Standard Reports and SAP Database Tables). 

Infotypes for SAP HR Data Migration

Employee hr master data is maintained in different infotypes. Identify data for each infotype & migrate  those data to infotype tables (IT0000 to PA0000 table ,IT0001 to PA0001 table).Prepare excel sheet for each infotype in a specified format acceptable by SAP. Fields are identified in the upload excel  as mandatory or optional .

Following are important Infotypes for Data Migration

Group HR Data for Data Migration 

Data will be loaded in the following sequence

1. Hr Core Data:

Core HR data are FI Data (Bank data,Cost Centers, GL Accounts, Vendors)  and Organization Structure.

OM data is necessary information to assign employees to the positions, cost center, org units etc so Org Structure is needs to be loaded before employee master data creation in PA module.

2. Required Infotypes for payroll india.

PA Infotypes

PA0000:  IT 0000

PA0001: IT 0001

PA0002: IT 0002

PA0006: IT 0006

PA0008: IT 0008

PA0009: IT 0009

PA0015: IT 0015

PA0014: IT 0014

PA0021: IT 0021

PA0022: IT 0022

PA0023: IT 0023

PA0040: IT 0040

PA0016: IT 0016

PA0041: IT 0041

PA0105: IT 0105

PA0128: IT 0128

PA0185: IT 0185

PA0027: IT 0027 

Time ITs

PA0007: IT 0007

PA2001: IT 2001

PA2013: IT 2013

PA2010: IT 2010 

Payroll (India) ITs

PA0580: IT 0580

PA0581: IT 0581

PA0582: IT 0582

PA0583: IT 0583

PA0584: IT 0584

PA0585: IT 0585

PA0586: IT 0586

PA0587: IT 0587

PA0588: IT 0588

PA0589: IT 0589

PA0590: IT 0590

SAP Data Migration Using LSMW Tool

T Code: LSMW 

Legacy System Migration Workbench (LSMW) is a tool suggested by SAP that  can use for transfer data from legacy systems into SAP ECC System.

It is a very great tool available in SAP to upload large amount of data to the SAP system. Other tool recommended by SAP is eCATT (extended Computer Aided Test Tool). Through LSMW tool we   can create Master data (HR  Master data, Vendor master data, Customer master data) ,transactional data, modify existing master data etc.