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!