ADP Payforce data extraction to SAP

I finally completed all the custom SQL queries to extract data out of ADP Payforce to SAP HCM/Payroll. Historic data was impossible to pull because ADP doesn’t have a “from” and “to” range for an action (it’s based on “effective date” and “effective sequence”). So, you would either corrupt your historic data by modifying the dates or just load the most current record. I chose the latter.

The whole process was very painful and I had to built a lot of lookup tables to accomodate SAP infotypes. Apparently we are the first company to convert from ADP PayForce to SAP, so there was no help available from anyone. The queries were tested for two properties and they seemed to work, but the real test is coming up this Friday when I extract all employees througho ut the company. The biggest pain was extracting the YTD data out of ADP. It’s so different in both systems that I had to write some UNION ALL queries to combine multiple data sets. I strongly suggest to convert in the beginning of the year. Quarter-end conversions are possible, but extracting the YTD details is extremely difficult. Unfortunately, we do not have a choice and have to migrate at the end of this quarter…our implementation partner wasn’t ready on Jan 1st.