Data Cleansing in SAP HR

Hi ssskumar.
The data cleansing in HR is to be done infotype by infotype. Open master data table for each infotype (PAXXXX) when XXXX is a number of the infotype using SE11 transaction. You will find what kind of data need to be used and from the legacy system distribute then for each infotype you need. This is a very boring process. Use an spreadsheet to organize data that came form legacy system to SAP. An spreadsheet for each infotype and fill it with legacy data. Save spreadsheet with CSV format and build a LSMW object to load data to SAP.
Good look, my friend.

Help the community by fixing grammatical or spelling errors, summarizing or clarifying the solution, and adding supporting information or resources. Always respect the original author.

Popular White Paper On This Topic

Hi ssskumar.
The data cleansing in HR is to be done infotype by infotype. Open master data table for each infotype (PAXXXX) when XXXX is a number of the infotype using SE11 transaction. You will find what kind of data need to be used and from the legacy system distribute then for each infotype you need. This is a very boring process. Use an spreadsheet to organize data that came form legacy system to SAP. An spreadsheet for each infotype and fill it with legacy data. Save spreadsheet with CSV format and build a LSMW object to load data to SAP.
Good look, my friend.

Generally, you will have to spool the current data from SAP (either using specific reports, query, or even direct from DB tables). For infotype tables, the tablename is PAxxxx; For OM tables, it is HRPxxxx (where xxxx is the infotype number).

After you have spooled the current data, you will have to go through with users to find out which are the uncleaned data to cleanse. As mentioned by Leanardo, you can use LSMW to load the cleansed data into SAP.

Note that you will typically go through mutiple iterations on the above process before the entire data are considered cleansed.

Copyright 1998-2015 Ziff Davis, LLC (Toolbox.com). All rights reserved. All product names are trademarks of their respective companies. Toolbox.com is not
affiliated with or endorsed by any company listed at this site.