Skip to Content
0
Former Member
Nov 12, 2012 at 03:34 PM

0CALMONTH + 0DATEFROM & 0DATETO

59 Views

Hello people!

One of the requirements I have to build is a FTE monthly counter, but these counter is as follows:

- if a person works a full month: counter = 1

- if a person doesn't work a full month, counter must be proportional to working days, for example, if start date is 06.09.2012, that september employee has worked a total of 25 days, so, 25/30 = counter = 0.83

In order to build this, I need following characteristics (amongst others): 0DATETO, 0DATEFROM, 0CALMONTH.

I'm getting 0DATETO and 0DATEFROM from employee masterdata, and 0CALMONTH from transactional datasource 0HR_PA_0 (Employee).

I was thinking to do this:

Joining both datasources into any infoprovider1 in a way I join data and getting the following:

Employee Date from Date to Cal Month => Counter (Infoprovider 2 will have a kf filled by a routine from infoprovider 1)

1 01.11.2010 05.03.2011 07.2012 0

1 01.11.2010 05.03.2011 08.2012 0

1 01.11.2010 05.03.2011 09.2012 0

1 06.03.2011 08.07.2012 07.2012 0.29

1 06.03.2011 08.07.2012 08.2012 0

1 06.03.2011 08.07.2012 09.2012 0

1 09.07.2012 31.12.9999 07.2012 0.71

1 09.07.2012 31.12.9999 08.2012 1

1 09.07.2012 31.12.9999 09.2012 1

My question is the following: what kind of data flow do you think is the most appropriate to build this? Do you think the above explanations is ok?

Any suggestions?

Thanks!