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.
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.
