on 03-11-2009 9:11 AM
Hi
I would like to retrieve leave balances from tables within SAP and export it into a realtime external/Non SAP time and attendance system .
Is there single table that holds this information?
Hi ,
i think there so direct table...
leave balance we will get it as a ......
in IT2006(ABSENCE QUOTA) -
total number of quota minus deduction(used quota)=leave balance.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Santosh
If the employee did not take all his/her leave with in his/her leave cycle(s), I would have to sum all the annual leave qouta types(number and deductions) to make sure that the balances is correct. Am i correct?
Annual Leave 01.05.2008 - 30.04.2009
Number = 20
Deduction = 5
Leave balance = 15
Annual Leave 01.05.2007-30.04.2008
Number = 20
Deduction = 0
Leave balance = 20
*PT50: Leave balance = 35*
Check with PT_QTA10
and export that one into Excel................
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
you can use Tcode PT_QTA10 for quota balances.
Regards
sri
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
You can get from this time cluster table ABWKONTI Absence Quotas or PA2006 employee master data
Regards
Mani
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.