Dates Indicator in RT table

[former_member615096]

Hi All,

We have a scenario where we need to show start and end dates to wage types in RT table Similar to Split indicators(i.e. if we have multiple entries - 01, 02, 03) .

Can you please suggest is there any possible way to populate start and end dates in RT table ?

Regards,

Abhinaya.

[BGibbons]

Hi,

Can you elaborate a little on your requirement.

If you are using SAP TIme then perhaps you can leverage the ZL table which can hold wage types by date.

Payroll processes by pay period not by date so the whole concept of getting from/to dates on to the RT table is dubious in the extreme.

Why you actually need these dates and for what wage types will drive any potential solutions.

If the wage types you are interested in origonate on infotypes then the fact they will have a start/end date might point the way.

bg

[former_member615096]

Hi All,

Sorry for late response.

Thanks Brendan, Bala and Binder for your reply and we found solution.

Sharing details below - so that others can use who has similar scenario.

Absences:

1.Created custom operation to populate start and end dates to Absence wage type records in Result Table (i.e. RT) and Start and end dates will be populated in absence wage types Rate field.

2.Created new PCR with custom operation and called same PCR in the time schema (i.e. ZT00) to process absence wage types in Payroll log.

3.Added Split indicator to Absence wage types through PCR to capture the hours as per the absences start and end date as similar to AB table.

4. Read Absence wage types from Payroll results and display it in time statement.

5.As a result of split indicator to the absence wage types, the current pay slip shows the wage type splits in the output form. It requires code change to cumulate the wage type values and show as before.

Attendances:

1.There are no wage types exist for attendances in our system so, created new wage types based on attendance types and populate the hours through PCR in time evaluation.

2. ZL table in time evaluation holds the new attendance wage types with start and end date along with the hours.

3.The standard function (i.e. ZLIT) cumulates the time wage types before passing it to the output table but, the requirement is to show the hours based on attendance records in the master data. Hence created new Custom Function to read the attendance wage types from time evaluation into Payroll log and generated new set of wage types,which holds hours based on attendance records in master data.

4.Start and end dates will be populated in attendance wage types Rate field

5.The new set of wage types can be read from payroll results and display in time statement.

Regards,

Abhinaya.

[former_member226519]

Splits in table RT are related to splits in table WPBP (which contains BEGDA/ENDDA) via field APZNR.

[former_member699899]

Hi Abhinaya,

I am also working on same requirement . Please share if you found any solution

Thanks ,

Manju

[former_member615096]

Hi Brendan,

Thanks for your reply.

If we will read from Master data - we can able to see Whatever records are active but we won't see the deletion record /revised hours.

The Expected will be - E.g. 01/06/2020 - 15/06/2020 - Attendace Entered as 30 hours

15/06/2020 - 30/06/2020 - in this pay period, The Preivous period Attendance are revised from 30 hours to 20 hours i.e. in time statement 01/06/2020 - 15/06/2020 - - 10 should displayed in In Period of 15/06/2020-30/06/2020.

Similarly we have a test case where it only changes to start and end dates but no change in hours and overlapping pay periods.

Please suggest any way to resolve this issue.

Regards,

Abhinaya.

[BGibbons]

Hi,

for clarity, the date ranges referred to above 01/06/2020 - 15/06/2020 - 30/06/2020. These are pay periods? is that the lowest level you wish to report on ie by specific absence/attendance type for a period?

If that is the case then normal retro functionality with the RT table should provide all you need. You just need to ensure you have individual wage types populated to the RT for the absences/attendance you wish to report on.

Brendan

[BGibbons]

Hi,

OK not clear why you need to involve mods to the payroll cluster to facilitate. Do you need to include actual montetary values with the reported absences / attendances?

Your new time statement could read data directly from the info types and if you need them broken down further you can use FM HR_PERSON_READ_WORK_SCHEDULE , this will give you a breakdown by day (and part day) of attendances and absences.

bg

[former_member615096]

Hi Brendan & Bala ,

Thanks for your reply.

we are going to develop time statement for Absences & Attendance with start and end dates view similar to Payslip(i.e.without start & end dates).So, Currently, will be using AB cluster table to show absences on time statement but for Attendances , we dont have any table to view the data and we are unable to call direclty from time management as it will not support retro /due to dynamic tables exist in time.

I have checked with ABAPer to create custom cluser table but they mentioned, it is very difficult to create it.,So, I planned to create wage types in Time based on attendance type which we will call same in Payroll log with start & End dates.

I am searching way to create start and end date with below options.Can you please help me on how to do through PCR.

We tried wih Master data change log but client need different concept to populate Absences/Attendance and Can we use P2002 opearion to read the data in Payroll ?

Regards,

Abhinaya.

[BalaAP]

Hi,

I read a similar development in Canada Payroll, in ASUG conference during year 2003. They created a new cluster table named RT_X (which is same as RT with additional field "date") to display "date" value in pay stub. They used this RT_X table to store date which is coming from ZL table (for time wage types), as mentioned by Brendan Gibbons.

This is not as easy as creating a Z table, since, we need to write lot of PCR's and functions to bring those date values to this custom RT table. You can always refer the date values with wage type reporter - PC00_M99_CWTR or create some custom Z report to fetch date split-up.

[BalaAP]

Hi, RT is a cluster table which is having essential fields (which is optimized for storage). Date values are not there (it is stored per payroll period). You may need to do some development for creating your own cluster tables (which is very expensive & hard to do it).