on 12-05-2011 9:26 AM
We are using -ve time mgmt for time evaluation. The requirement, EL would generate if employee completed 240 days (Attendace day + previous year availed EL). If an employee complete the eligibility i.e. 240 days, so quota would be generated, calculation method: total attendance day / 20.
For example, total attend. is 220 days + previous year availed e/l is 35 = total day 255 days, so quota would be generated on 220 days / 20 on last day of year i.e. 31.12.
please advise!
Hie,
This is verymuch posible in standard by configuring table V_554S_M. In this table you need maintain your LWP absence type. With minimum number as 1 and max number as 366 and put tick mark in check box.
when u run tqta or tm00 system will read for this lwp absence type and reduces the number of days from the calendar days. Accordingly system treats as these days employee is inactive.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Do you maintaining every day attendance for employee duty?
It can possible eigher -ve or +ve time evealuation.. You need to store each employee present in Monthly Time type in SALDO which is transfer prev. period for checking 240 days attendance of last year.. You can Query for last month balance as"HRS=O1000" here O is reresent to lastmonth, 1000 is deamed time type.
+Availed EL you can query through Time type if are maintain each Availed EL storing in Month balance or Query of Absemce Quota through "HRS=F"
In that last day of calender year After Saldo you need insert PCR for Quota generation.
Hardly Three/Four different Business PCRs required.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Since it is -ve time, so im not maintaining employee time events. I have created 3 types (attendance cumulation, EL entitiled previous year& one time type of add balance) and written a pcr, but quota is not generating
*
****
HRS=M(ATTEND. TIME TYPE)
HRS?240
*
HRS/20
ADDMB(time type)
HRS=0
ADDMB (ATTEND. TIME TYPE)
ADDMB (PR. E/L TIME TYPE)
Plz advice further
*
****
HRS=M(ATTEND. TIME TYPE) ( *Please confirm here how much value on particular period using PTBal00 report* because your checking HRS value 240 or not here you require write =, >,only your business pass, incase of < then no generation right as per your business, You need to value and update What your maintain base entitlemnt time type for EL only)_
HRS?240
*
HRS/20
ADDMB(time type)
HRS=0
ADDMB (ATTEND. TIME TYPE)
ADDMB (PR. E/L TIME TYPE)
Exe:
HRS=M(ATTEND. TIME TYPE)
Hrs?CZE240 (Which is maintained value in T511k for 240, incase any changes in future just delimit is enough)
=
Business Logic (Here the final value store in Base entitlement which your maintain time type for EL)
>
Business logic. (Here the final value store in Base entitlement which your maintain time type for EL)
<
Colop*
Hi,
Now able to generate quota and system checking the attendance eligibility too. But still one issue arises, while executing next year, system is not checking the eligibility (240 days) and generating quota that should not happened. In every year, system should check the attendance eligibility (240 days) from time type and generate accordingly.
Please advice
Already did the same,
*
****
HRS=m time type (attendance)
hrs+m time type (pre. el balance)
hrs?cz240e (constant, maintained in table t511k)
=
m time type (atten)
hrs/20
ADDMB time type (maintained in base entitlement)
>
m time type (atten)
hrs/20
ADDMB time type (maintained in base entitlement)
<
colop*
Here, what the system is behaving, in first year it is generating correct, but next year generating not as per actual. In Attend.Time Type, I have maintained, day balance , period balance & trans. prev period as 1 where no transfer maintained in transfer prev. year. And while executing, in table SALDO, time type attendace is 247 and quota is generating 10.78 where it should generate 12.
Please suggest
Your logic should be below.
Total entitlemet is 12 (assume), If employee works more than 240 days or more he is eligible for 12 days otherwise propranate assume other wise put colop for < or use the below business.
*
****
HRS=m time type (attendance)
hrs+m time type (pre. el balance)
adddb3456
hrs=d 3456
hrs?cz240e (constant, maintained in table t511k)
= (In this case employee works exact 240 days)
hrs=czel12 ( this 12 days also maintain in T511k is better)
ADDMB time type (maintained in base entitlement)
> (In this case employee works more than 240 days)
hrs=czel12 ( this 12 days also maintain in T511k is better)
ADDMB time type (maintained in base entitlement)
< ( In this case employee works less than 240 days)
hrs=cze12l
hrs/cz240e
addvs 1234
hrs=k1234
hrs* d 3456
addmb time type (maintained in base entitlement).
Or you use in generation rule multiplication with time balance in accural entitlement Tab simplfiying your business.
Thanks for your response. But, here one more condition is, if employee attendance is 240 days (attendance + prev. el balance) then employee is eligible. But the calculation of EL would be on employee attendance. for example,
Emp. Attendance = 210 days
prev. el balance = 40
Total = 240 (means employee is eligible) but calculation would be on emp. attendance i.e. 210 / 20 = 10.5 days. Accordingly, I have written rule like
*
****
hrs=m time type (attn)
hrs+ m pre. el balance
HRS?CZ240E
=
hrs=m time type (atten.)
hrs/20
addmb (time type base entitlement)
>
hrs = m time type (atten)
hrs/20
addmb (time type base entitlement)
<
colop* (won't generate)
Also, I have assigned 0 as transfer previous year balance of employee attn. time type)
But, while generating for next, slight variation is coming, In table SALDO, employee att. time type is coming = 228 days, that means calculation should be 228 / 20 = 11.4 days, but it is generating 10.18 days.
Plz. advice why the variation is coming
HI,
Sorry to respond in delay.
Actually the requirement is got slight changed, instead of current year attendance (240 days), employee has to complete 240 in previous year.
For example, the quota would be generation in Jan (start of year) and while executing of time evaluation system will check his attendance (previous year (jan to dec + availed previous year earned leave) and if it is 240 or more so quota would be generated, calculation would be on actual working days / 20
Please advise
I think 240 days should include weekly off and Holiday also? you need to confirm from ur client which days are include to count 240 days.
Step1
Generate a time type eg. XXXX other than absence days, by using operation VARST - ABSCE or ABSWD.
This time type XXXX will be valid for current year only, which u can configured in T555A and select "No transfer" for field "Transfer prev. year".
Put the value of time type XXXX in SALDO by using ADDMB.
Step 2
On end of cal. year in SALDO table if value of XXXX is greater than 240 than pass to another timetype YYYY which. For YYYY time type select "Transfer" in T555A for field "Transfer prev. year".
Step 3
Check first day of Cal. year and pass the value of Time type YYYY to another Time type ZZZZ. For time type ZZZZ select no transfer for field "Transfer prev. period" and "Transfer prev. year".
.In the same rule may be on 3rd day or 4th day of Jan refresh the value of Time type YYYY ie. make Zero in SALDO.
In generation rule use Time type ZZZZ to generate quota.
Thanks
SK
Here i am providing PCRs for but in las PCR you need build logic as suggested earlier for base entitlement of EL
Zm01- Employee attendance in 9m01
*
****
varstprsnt (Here employee will be attend only at the week days only considering)
n
colop*
Y
hrs=1
adddb9m01z(here 9m01 is for cumulating daybalance, month balance and previous period also, dont selct previous year.
colop*
Note: Avtio or Ptip function can use.. put after P2002 function.
-
Zm02- Earned leave move to 9m01
*
****
varstabsce
n
colop*
y
outtpabtyp
****
colop*
EALV>>>>>>Earned Leave
Hrs=1
adddb9m01z
colop*
Note: use this pcr with Action and put "AB" in parameter 2 in schema,Insert after P2001 function
-
240 days checking and Quota genarting
Zm03-Earned leave Quota.
*
****
varstcurmo
**
colop*
10
vartsreday
**
colop*
01
hrs=O9m01
hrs?kz240e
<
colop*
=
build logic as suggested earlier for value inserting to Base entitlement maintain for EL
>
build logic as suggested earlier for value inserting to Base entitlement maintain for EL
Note: insert after LImit function in schema
Thanks for your reply.
Say this time only actual attendance would be considered + previous year availed leave, no paid holiday, EE worked on weekoff/holiday would be considered, as there is no time events maintained, only IT2011 is got updated.
If the requirement is for the generation of EL quota, EE attendays (actual attt + prev. year availed EL quota) should be 240 days or more, if employee is found eligible then calculation will be on employee actual attendance / 20
Total attendance = 220, prev. year availed leave is = 30 that means he has 250 days
So while executing time evaluation next year (jan'12) his quota should get generate 11 days (220 /20).
Please advise me to write PCR as I am not getting correct output by using your advice.
Please suggest
Dear Sir,
I did whatever you suggested but still my problem is not got solved. When Im going to generated quota on 01.01.12, quota is not generating and in table SALDO, attn time type cumulated is only 1 day.
Plz advise. If possible, forward your email, I will forward u docs
Regards,
Supriya
a) Attendance cumulation
TE1 Personnel Calculation Rule ZTE1
*
****
VARSTPRSNT Employee at work
N
COLOP* TIP >TOP curr.TType
Y
HRS=1 Set
ADDMBxxxx Add to month balance
COLOP* TIP >TOP curr.TType
b) el move to attn.
ZTE2 Personnel Calculation Rule ZTE1
*
****
VARSTABSCE Employee absent
N
COLOP* TIP >TOP curr.TType
Y
OUTTPABTYP Absence type
EARN
HRS=1 Set
ADDMBxxxxZ Set month bal. = 0
c) 240 days eligibility
ZTE3 Personnel Calculation Rule ZTE1
*
****
VARSTCURMO Current period
**
COLOP* TIP >TOP curr.TType
10
VARSTREDAY Rel. day of period
**
COLOP* TIP >TOP curr.TType
01
HRS=Oxxxx Set
HRS?KZ240E Decision op. HRS
<
COLOP* TIP >TOP curr.TTyp
=
HRS/20 Division
ADDMBYYYYZ Set month bal. = 0 (base entitlement)
>
HRS/20 Division
ADDMBYYYYZ Set month bal. = 0 (base entitlement)
COLOP* TIP >TOP curr.TType
As per your testing business...
Based on 2011 attendance you need to generate 01012012 Quota right..
Then you need to following business.
Step1: Run time evalution for jan 2011 to dec 2011 first.
After check report dated on 31.12.2011 in monthly balance using t.code PT_BAL00 selcting cumulation balance here give your attendance time type.
If you are find value is 240 or more your rule will work on 01012012 inother case will not process the data.
Yeah, I generated the report till 31.12
period
201104 :101
201105: 128
201106: 154
201107: 180
201108: 206
201109 232
201110: 257
201111: 283
201112: 309
And in table V_T559L (selection rule), accural period as calendar year, transfer time as upon accural are maintained. Do I need to any thing in multiplication with time balance under Accural entitlement or some other areas to time transfer?
Hello Supriya,
I guess you already got the current year attendance hours (attendance/20).
You need to write 2 more pcrs.
PCR1: This gets current year unused absence quota
it should work on dec 31 so use varstcurmo= 12 & varstreday = 31
hrs=fr(absence quota number->2 digit)C * this will get all the remaining absence quota*
Adddb(absence time type)
PCR2:Carry forward the quota to next year
It shud work on Jan 01 next year so use varstcurmo = 01 & varstreday = 01
HRS=L(ATTENDANCE TIME TYPE i.e 240/20)
ADDDB(NEW TTYPE for Current Year)Z
HRS=L(absence time type)
Adddb(NEW TTYPE for Current Year)
Also please insert the pcr above CUMBT & Quota.
It shud work fine.
Hi ERP & Joseph,
I request both of you to please go thru the below and advise accordingly.
Actually the requirement is to entitle EL benefit an employee has to attend (employee attendance) + previous year no. of availed leave ) should be 240 days or more,
Calculation of EL will be on Employee attendance (suppose ee attendance is 220 and availed leave is 25 = 245) so employee entitle will be (220 / 20) = 11 days.
Accordingly, I have created 2 time type, one for attendance cumulation and another to assign in base entitlement.
Time Type xxxx : Attendance cumulation, checked on day, period, month and no transfer on transfer prev. year
2nd time type assign in base entitlement of EL quota.
As per valuable advised by ERP, created below PCRs.
a) Attendance cumulation
ZTE1 Personnel Calculation Rule ZTE1
*
****
VARSTPRSNT Employee at work
N
COLOP* TIP >TOP curr.TType
Y
HRS=1 Set
ADDMBXXXX Add to month balance
COLOP* TIP >TOP curr.TType
and assigned below function, P2002
b) EL move to Attendance
ZTE2 Personnel Calculation Rule ZTE1
*
****
VARSTABSCE Employee absent
N
COLOP* TIP >TOP curr.TType
Y
OUTTPABTYP Absence type
ERND (EL leave)
HRS=1 Set
ADDMBxxxxZ Set month bal. = 0
COLOP* TIP >TOP curr.TType
and assigned below function P2001
c) to check 240 days eligibility
ZTE3 Personnel Calculation Rule ZTE1
*
****
VARSTCURMO Current period
**
COLOP* TIP >TOP curr.TType
10
VARSTREDAY Rel. day of period
**
COLOP* TIP >TOP curr.TType
01
HRS=Oxxxx Set ->>>>>>>>>> (atten. time type)
HRS?KZ240E Decision op. HRS
<
COLOP* TIP >TOP curr.TType
=
HRS/20 Division
ADDMBYYYYZ Set month bal. = 0
>
HRS/20 Division
ADDMBYYYYZ Set month bal. = 0 ->>>>> (base entitlement time type)
and assigned after function LIMIT
By doing this, Im able to generate quota but no 01Jan but at last day of year i.e. 31.12, wherein quota should generate 01.01 every year.
Since Joseph has advised to write two more rules
a) Current year unused quota
*
****
varstcurmo= 12
hrs=FR01C --->>>>>>> (EL quota)
Adddb -
>>>>>>>>>>>>>>>>>>>>>(absence time type)
b) Carry forward the quota to next year
*
****
varstcurmo = 01
HRS=LXXXX -
>>>>>>>>>>>>>(ATTENDANCE TIME TYPE i.e 240/20)
ADDDB -
>>>>>>>>>>>>>(NEW TTYPE for Current Year)Z
HRS=L -
>>>>>>>>>>>>>>(absence time type)
Adddb -
>>>>>>>>>>>>>>>(NEW TTYPE for Current Year)
Plz advise do I need to create new time types both for Absence & Attn.Cum (or use same that was created for Base entitlement & Attn. cumuluation i.e. YYYY & XXXX)
One more query arise in my mind is previously we have created PCR to move EL to attendance based on that calculation would be made, where the requirement is Attn + EL = but calculation will only be on Attendance / 20.
Plz Plz advice your valuable comments
Regards,
Supriya
If I m not wrong the requirement is each 20 attendance days 1 EL will generate, which will starts from 1st of Jan. But to start this it will check the 240 days of attendance+EL(availed) on previous year.
Good to Create 2 more time types, 1 will check the 240 days on first of Jan and from that day it will generate on Att. days+ EL availed days.
2nd will generate once value of 1st will be 20 in SALDO. so use the 2nd TT in T559L, with accural period daily.
This will not be possible if you are using -ve time management. How will the system identify 240days working?
Raghu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Customize the T559L table, Copy the schema TQTA to local. Write custom function/operation/as and when required.
Take help of technical person.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
96 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.