SAP HR Data Extraction

[Former Member]

Hello All,

Has anybody got any information on how best to extract all HR and payroll data for the past two years for all employees from SAP HR?

I am working on a project where all SAP HR data needs to migrated to another system (not Success Factors).

Thanks

Mike

[jagan_gunja · Accepted solution]

1. Key fields in PA/PD data are configured in various tables and can be similarly extracted.  This data can be used to interpret the data in PA, PD, PT, PY, etc

2. PA & PD data can be extracted using SE16 for each infotype.

3. PY data: To some extent Wage type reporter(txn PC00_M99_CWTR) can be used to extract payroll data. SAP reporting programs can be adapted to extract data More capable functionality is available in SAP provided functions (or possibly 3rd party s/w). 

See some links found in google below

Payroll Results for Reconciliation - Payroll - SAP Library

SAPexperts | Ease Reporting On Payroll Results With Dedicated Payroll Infotypes</title> …

An SAP Consultant: HR ABAP - Reading Payroll results from Cluster tables

How can you view new payroll results during a payroll run?

HR_GB_GET_PAYROLL_RESULTS SAP ABAP Function Module - Get payroll results from RG cluster

Reading payroll results for an employee from AB... | SCN

SAP PY tables (Payroll)

SAP ABAP development source code and step by step guides

SAPTechnical.COM - Program to read Payroll data

Reports in SAP HR Module

SpinifexIT Easy Payment Summaries for SAP HR and Payroll | SpinifexIT

http://www.tikconsulting.com.au/products/payroll-verification-modules/

4. The above data ca be imported to databases like MS Access.  Reports can be made by relating the PA/PD/PY data to config data with Access/SQL/etc skills.

Hope this helps.

I have done 1, 2 & 4 without Access or VB expertise but with some SQL skills.

People like Christopher Solomon, Martin Gillet are experts with excellent knowledge, skills & experience.

br, JG

[Former Member · Accepted solution]

Thank you Jagan.

The issue I'm facing using SE16 is that it is also giving me data for employees that have left the company. For example, when I run SE16 for PA0002 it is providing data for active and inactive employees. How can I retrieve data only for active employees?

Thanks

Mike

[ChrisSolomon · Accepted solution]

Employee status

[jagan_gunja · Accepted solution]

As I said before, extraction in SE16 for one infotype can not be related to the data in another infotype or table.

All the data extracted for all employees and all infotypes as required including IT 0, etc, need to be saved in *.txt files, imported to MS Access database.

Then you can relate different infotypes as required along with IT 0, then suitable queries designed to report on employees in service on a specific date or in a period, etc.

May I suggest you go through a response fully before jumping to conclusion?

[former_member320152]

Hi,

Take reference of report RPLDAP_MANAGER.

[ChrisSolomon]

One time "dump" or continuous ?