time record service date

Hi bernfc10,

Though you say all you have is TR-DATE, I assume you have employee ID or at least Pay Plan Code?  If not, then I don't think you can get it, unless all your employees are on the same calendar.

The critical pieces are the company, the pay plan code and the effective date (of the pay plan)

• Company is obvious
• The effective date is just going to determine which "version" of the Pay Plan is current.  (See PR21.1/PR21.2 to see how this works)
• To get the pay plan code from the EmployeeID, then you need to retrieve EMP-OT-PLAN-CODE.

Once you have , you should be able to use PROVERTIME or PROTPAYPRD to determine the relevant period dates.  You don't really say what fields you are specifically trying to fetch, but this should help point you in the right direction.

Good Luck.

One other thing - if you are looking for benefit cycle information, you might check out BNCYCDTL (BS06), which includes benefit cycle from/thru dates.

Hi Kelly, thank you so much for the prompted response. Yes, I do have all the required data including company, plan code and the effective date, and pay sum group. I am looking to fetch the PER-END-DATE and PER-START-date. I am looking for Pay Period where the EE was active in the LP Structure being processed. Example: tr-date is 11/06/2011. I am looking at some sample code and hope to be able to take it from there.

This is for Absence managment LP140 accruals calculation.Your help is greatly appreciated!