SAP table T7PLL1 (Leave solution configuration)

SAP table T7PLL1 has 2 primary key fields being MANDT,ENDDA.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 * MANDT
ENDDA End Date DATS 8 0 ENDDA
BEGDA Start Date DATS 8 0 BEGDA
V2006 Display IT2006 content after update NUMC 1 0 PPL_2006V
0 Always
1 Never
2 In personnel fire actions
UM016 Mode for continous contracts in IT0016 CHAR 1 0 PPL_UM016
REHIR Personnel actions for rehiring CHAR 20 0 PPL_REHIR
ENLEAVE Enable leave support CHAR 1 0 PPL_LEAVES
REQ_AWART Absence code of on request leave CHAR 20 0 PPL_REQ_AWART
LIMIT_DATE Earliest year for limit recalculation NUMC 4 0 PPL_LIMIT_DATE
LEAVE_1_12 Absence Quota Type NUMC 2 0 T556A ABWKO
LEAVE_6_12 Absence Quota Type NUMC 2 0 T556A ABWKO
LEAVE_ANNUAL Absence Quota Type NUMC 2 0 T556A ABWKO
LEAVE_ADDITONAL Absence Quota Type NUMC 2 0 T556A ABWKO
LEAVE_DISABLED Absence Quota Type NUMC 2 0 T556A ABWKO
LEAVE_MSG Display warnings about IT2006 modification CHAR 1 0 PPL_LEAVE_MSG
ADD_LEAVE Additional leave - follow-on contracts CHAR 1 0 PPL_ADD_LEAVE
LEAVE_RED Limited reduction of leave by absences CHAR 1 0 PPL_LEAVE_RED
LEAVE_ROUND Round quota to 2 decimal places in the first year of work CHAR 1 0 PPL_LEAVE_ROUND
LEAVE_TEMP Choose quota generation method for temporary employees CHAR 1 0 PPL_LEAVE_TEMP
Every 30 days
M By calendar months
ROUND_UNIT Rounding DEC 6 5 PPL_ROUND_UNIT
SW1 Suspend also limitations before 10/2013 CHAR 1 0 PPL_SW1
SW2 Suspend across entire DESTA-DEEND CHAR 1 0 PPL_SW2
SW3 Suspend for leaves at any date CHAR 1 0 PPL_SW3

T7PLL1 foreign key relationships

Table Field Check Table Check Field
0 T7PLL1 LEAVE_1_12 T556A Absence Quota Types MANDT
0 T7PLL1 LEAVE_1_12 T556A Absence Quota Types MOPGK
0 T7PLL1 LEAVE_1_12 T556A Absence Quota Types MOZKO
0 T7PLL1 LEAVE_1_12 T556A Absence Quota Types KTART
0 T7PLL1 LEAVE_1_12 T556A Absence Quota Types ENDDA
1 T7PLL1 LEAVE_6_12 T556A Absence Quota Types MANDT
1 T7PLL1 LEAVE_6_12 T556A Absence Quota Types MOPGK
1 T7PLL1 LEAVE_6_12 T556A Absence Quota Types MOZKO
1 T7PLL1 LEAVE_6_12 T556A Absence Quota Types KTART
1 T7PLL1 LEAVE_6_12 T556A Absence Quota Types ENDDA
0 T7PLL1 LEAVE_ADDITONAL T556A Absence Quota Types MANDT
0 T7PLL1 LEAVE_ADDITONAL T556A Absence Quota Types MOPGK
0 T7PLL1 LEAVE_ADDITONAL T556A Absence Quota Types MOZKO
0 T7PLL1 LEAVE_ADDITONAL T556A Absence Quota Types KTART
0 T7PLL1 LEAVE_ADDITONAL T556A Absence Quota Types ENDDA
1 T7PLL1 LEAVE_ANNUAL T556A Absence Quota Types MANDT
1 T7PLL1 LEAVE_ANNUAL T556A Absence Quota Types MOPGK
1 T7PLL1 LEAVE_ANNUAL T556A Absence Quota Types MOZKO
1 T7PLL1 LEAVE_ANNUAL T556A Absence Quota Types KTART
1 T7PLL1 LEAVE_ANNUAL T556A Absence Quota Types ENDDA
0 T7PLL1 LEAVE_DISABLED T556A Absence Quota Types MANDT
0 T7PLL1 LEAVE_DISABLED T556A Absence Quota Types MOPGK
0 T7PLL1 LEAVE_DISABLED T556A Absence Quota Types MOZKO
0 T7PLL1 LEAVE_DISABLED T556A Absence Quota Types KTART
0 T7PLL1 LEAVE_DISABLED T556A Absence Quota Types ENDDA