SAP table T5KV1 (Vacation pay: Accrual and Payout)

SAP table T5KV1 has 3 primary key fields being MANDT,GRPVP,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
GRPVP Vacation pay employee grouping CHAR 2 0 PCA_GRPVP
ENDDA End Date DATS 8 0 ENDDA
BEGDA Start Date DATS 8 0 BEGDA
PCNTC Percentage of vacationable earnings defined by comp. policy DEC 5 3 PCA_PCNTC
PCNTP Percentage of vacationable earnings to be paid every period DEC 5 3 PCA_PCNTP
LVTYP Quota/Leave type CHAR 2 0 * PCA_LVTVP
LVTP1 Quota/Leave type CHAR 2 0 * PCA_LVTVP
LVTP2 Quota/Leave type CHAR 2 0 * PCA_LVTVP
LVTP3 Quota/Leave type CHAR 2 0 * PCA_LVTVP
LVTP4 Quota/Leave type CHAR 2 0 * PCA_LVTVP
LVTP5 Quota/Leave type CHAR 2 0 * PCA_LVTVP
LVTPA Leave type for carry over from preceding vacation year CHAR 2 0 * PCA_LVTCO
LVTPB Leave type for carry over from preceding vacation year CHAR 2 0 * PCA_LVTCO
LVTPC Leave type for carry over from preceding vacation year CHAR 2 0 * PCA_LVTCO
PAYIV Accrual/Payout of vacation pay upon end of vacation year CHAR 1 0 PCA_PAYIV
1 Pay out legal minimum, accrue remainder in following year
2 Pay out by comp. policy, accrue neg. amt. in following year
3 Pay out legal minimum, ignore comp. policy, delete remainder
4 Roll over vac. days into next year, pay out comp. remainder
5 Roll over vac. days into next year, pay out legal remainder
PAYIT Payout of vacation pay upon employee termination CHAR 1 0 PCA_PAYIT
Payout legal min. If +, adjust comp. bal. acc. to legal min.
1 Payout legal min. If +/-, adjust comp.bal.acc. to legal min.
2 Payout legal min. If -, payout greater of legal/company bal.
3 Payout comp.bal. if greater than legal bal., otherwise legal
4 Payout legal balance/company balance, whichever is greater
GRPWT Vacation pay wage type grouping CHAR 2 0 T5KV2 PCA_GWTVP
GRPAY Vacation pay accrual year grouping CHAR 2 0 T5KV3 PCA_GAYVP
CMPAI Vacation pay accrual formula CHAR 1 0 PCA_CMPAI
Accrue flat amount in specified wage type
1 Use [YTD accr. year vacationable earnings] x [legal/comp. %]
2 Use [Per-period vacationable earnings] x [legal/company %]
A Use [YTD accrual year vacationable days] x [valuation base]
VALBS Quota/Leave valuation base NUMC 2 0 PCA_LVVBS
ABSTY Vacation pay indicator: Quota or Leave CHAR 1 0 PCA_ABSTY

T5KV1 foreign key relationships

Table Field Check Table Check Field
0 T5KV1 GRPAY T5KV3 Vacation pay: Accrual Years MANDT
0 T5KV1 GRPAY T5KV3 Vacation pay: Accrual Years GRPAY
1 T5KV1 GRPWT T5KV2 Vacation pay: Wage Types for Special Events MANDT
1 T5KV1 GRPWT T5KV2 Vacation pay: Wage Types for Special Events GRPWT