cancel
Showing results for 
Search instead for 
Did you mean: 

What table(s) would give me Leave balances?

Former Member
0 Kudos

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?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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.

Former Member
0 Kudos

check tcode PT50

Former Member
0 Kudos

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*

Former Member
0 Kudos

Hi ,

correct only,

we used to have multiple records for SL and PL .. why bcz leaves will carryforward...

but CL will laps so only one record should be exist....(if cl also carryfoward then multiple records)

Answers (3)

Answers (3)

sikindar_a
Active Contributor
0 Kudos

Check with PT_QTA10

and export that one into Excel................

Former Member
0 Kudos

Hi,

you can use Tcode PT_QTA10 for quota balances.

Regards

sri

Former Member
0 Kudos

Hi

You can get from this time cluster table ABWKONTI Absence Quotas or PA2006 employee master data

Regards

Mani