Skip to Content
0
Former Member
Nov 02, 2012 at 04:58 PM

Payroll and CATSDB Integration

115 Views

Hello Experts,

I am writing a payroll extractor for BW. I need some functional help on the Payroll and CATSDB side that's why I am posting my question here.

In the Payroll extractor I need some fields from CATSDB table as well. So I needed to establish a link between payroll and catsdb tables. (by link I mean Key fields needed to link records between tables) I was able to do that but unfortunately I am not able to find unique records from that link.

Here is how I was trying to link Payroll RT table with Payroll ALP table and then link ALP with CATSDB Table.

  1. Payrolll RT Table has the ALP Indicator for example 01.
  2. By looking at the ALP Indicator I pick up a date from ALP Table ( for example 07/09/2012)
  3. Based on the Date picked up from ALP Table and the Personnel number I was trying to identify corresponding CATSDB field (for example receiving cost center)

But my problem is the logic above is not able to identify a unique record from CATSDB. I am getting 4 records with the above logic. I probably need an additional Key to identify unique records in the CATSDB table from the ALP table. In other words How does the ALP Table connect with CATSDB?

I would appreciate your feedback on this.

Attachments