Time evaluation_quota generation

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!

SAP Managed Tags:
HCM (Human Capital Management)

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (4)

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.

Comment

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.

Comment

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

How are you cumulating attendances in the time type without time evaluation taking place?

RAghu

It means, maintaining of time event is mandatory in that case, based on that I will be able to store days in time types?

****

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*

Yes it is mandatory to maintain time events so that you can count presence or you can manually input attendance in IT-2002, then run time evaluation to count number of days

Raghu

Hi,

May I request to please brief my in detail.

Hi,

Please check through T. code "PT_Bal00" for Time types i.e day balces, cumul;ation balances (their selction conditions is there for day balnces and time wage types also selct cumulation balances only)..

I mean in your time type (Monthly balnce) value is there or not.

Following time types, Im using.

a) Time type 1 : Assigned in Based entitlement agt. period balance ( checked all boxes of time types)

b) time type 2 : attendance cumulation (same checked all boxes)

c) time type 3 : pre.year earned leave cumulation (same checked all boxes)

Plz advise further

Any inputs, please be suggested

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

Hi,

Check Your PCR the following conditions..

HRS=M(Attendance time type what you cumulated entire year include current month+Aviled EL in the Year)

HRS?CZ240E (maintained in T511k for 240days)

= Here meets your condition.

> Here meets your condition.

< Here does not meet the condition

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

No, only actual attendance will be considered, (no paid holidays + week off). Also, please not we don't maintain employee attendance (IT2011/2002)

Please suggest

In first rule(where generating XXXX) assign 2 more condition:for Off day VARST - FREE and for Holiday VARST - HOLCL is 0.

Again you need to check with client if employee works on Holiday and weekly off days, weather it will consider for 240 days?

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)

colop*

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

colop*

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*

vartsreday

colop*

hrs=O9m01

hrs?kz240e

colop*

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

if you need specify, Then use VARSTDPRCL for query of DWS class for adn VARST HOLCL combination in first PCR.

Use GCY..

Exe:

zm01

****

varstdprcl

colop*

varstholcl

colop*

gcygzm01A

varstholcl

gcygzm01a

colop*

****

(use here first PCR)

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

COLOP* TIP >TOP curr.TType

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

COLOP* TIP >TOP curr.TType

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

VARSTREDAY Rel. day of period

COLOP* TIP >TOP curr.TType

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.

No it is not like that. Since we are using negative time, so not maintaining IT2011 (time events). Only IT2001 is in use

Eventhough you need to run.. Otherwise how the month balance will update for the 2011 year..

Do you configure any time transfer specification to update month balance???

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?

Plz advise.

Regds:

Supriya

Now process time evaluation on 01012012 only and check in log how the data process and the base entitlement time type updated or not.

you need to check last PCR. i.e below Limit function inserted PCR..

Executed the same, but in SALDO it is generating only 1.00 (attn. cumluation time type) and no quota generated.

Plz suggest

Hi Sir,

Now I changed the place of PCR, placed under LIMIT (Limits for time balances) and re-run for first year i.e. 31.12.11 and found quota is generated for first year only where it should generate in next year i.e. 01.01.12 (time transfer should be happened)

Please suggest

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.

Supriya,

can you mail me your requirement on ( 1983bharath[at]gmail.com ), i can you reply back with screen shots.

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

COLOP* TIP >TOP curr.TType

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

COLOP* TIP >TOP curr.TType

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

VARSTREDAY Rel. day of period

COLOP* TIP >TOP curr.TType

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.

Comment

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.

Comment

Ask a Question

Top Q&A Solution Author

User

Count