SAP table T5DCA (Entitlements / Benefit Types)

SAP table T5DCA has 3 primary key fields being MANDT,ANTYP,ANSPR.

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 T000 MANDT
ANTYP Entitlement Type (Entitlement/Benefit Type) CHAR 1 0 P01C_ANTYP
1 Entitlement
2 Benefit Type
ANSPR Entitlement to Company Retirement Pension Plan CHAR 4 0 P01C_ANSPR
BVANS Calculation Method Entitlement/Benefit Type CHAR 2 0 T5DWY P01C_BVANS
TABBV Primary Function Table CHAR 5 0 P01C_TABBV
ITBLD Screen Groups Infotype CHAR 2 0 T5DC0 P01C_ITBLD
ASTYP Type of Entitlement/Benefit CHAR 1 0 P01C_ASTYP
ZEITB Time Constraint CHAR 1 0 P01C_ZEITB
KOKLA Collision Class NUMC 2 0 P01C_KOKLA
01 Collision Class 01 to 20
KREAK Reaction in Case of Collision CHAR 20 0 P01C_KREAK
RELRE Relevance for Reimbursement CHAR 1 0 P01C_RELRE
MORER Reimbursement Grouping CHAR 2 0 T5DC7 P01C_MORER
RELVU Relevance for Capital Transfer CHAR 1 0 P01C_RELVU
RELBS Relevance for Vested Payments CHAR 1 0 P01C_RELBS
No Calculation
X If Pension > 0
Y Always
DTYBS Type of Vested Payment Dynamic Modification CHAR 1 0 T5DCG P01C_DTYBS
STABS Entitlement Status After Calculation of Vested Payments CHAR 1 0 T5DCV P01C_STABS
DATEI Date Type for Technical Entry Date CHAR 2 0 T548Y P01C_DATEI
P16EI Different Entry Date from Contract Elements CHAR 1 0 P01C_P16EI
1 Date of initial entry
2 Entry into group
CSCRN Collision Screen Automatically when Saving CHAR 1 0 P01C_CSCRN
VLSTG Pension Benefit CHAR 1 0 P01C_VLSTG
SLSTG Benefit CHAR 1 0 P01C_SLSTG
SONLS Other Benefit CHAR 1 0 P01C_SONLS
LSTTR Origin of Benefit CHAR 1 0 P01C_LSTTR
1 Company
2 Pension Fund
3 Death Benefit Fund
4 Other Institution
VLTRG Proposal for Fixed Benefits Provider CHAR 4 0 T5DCU P01C_VLTRG
VLTMA Default Pension Organization for Employee Company CHAR 1 0 P01C_VBKMA
LTFIX Not Modifiable CHAR 1 0 P01C_KZFIX
VLTZF Default Responsible Company CHAR 1 0 P01C_VLTZF
VLUSP Default Responsible Company CHAR 4 0 T5DC3 P01C_VLUSP
VLUMA Default Pension Organization for Employee Company CHAR 1 0 P01C_VBKMA
LUFIX Not Modifiable CHAR 1 0 P01C_KZFIX
ZEINH Time/measurement unit CHAR 3 0 T538A P01C_PT_ZEINH
ANZMI Minimum number DEC 7 2 P01C_ANZMI
ANZMA Maximum Number DEC 7 2 P01C_ANZMA
REGRL Legal Basis for Entitlements CHAR 1 0 T5DCG P01C_REGRL
VSTAT Proposal for Entitlement Status CHAR 1 0 T5DCV P01C_VSTAT
USEST Use of Entitlement Status CHAR 1 0 P01C_USEST
BABEI Use of Contributions as Base CHAR 1 0 P01C_BABEI
IDBEP Identfication of Contributions from Entitlement CHAR 1 0 P01C_IDBEP
IDBER Indicates whether Calculation Method Is from Entitlement CHAR 1 0 P01C_IDBER
IDBE1 Identification for Paid Contributions CHAR 4 0 P01C_IDBE1
IDBE2 Identification for Contribution Increase CHAR 4 0 P01C_IDBE2
BAEIN Use of Income as Base CHAR 1 0 P01C_BAEIN
IDBAP Identification of Income from Entitlement CHAR 1 0 P01C_IDBAP
IDBA1 Identification for Income CHAR 4 0 T5DW1 P01C_IDBA1
IDBA2 Identication of Notional Income for Increase CHAR 4 0 T5DW1 P01C_IDBA2
ANLND Country Key for Entitlement CHAR 3 0 T005 P01C_ANLND
CHKFR Qualification Check is Possible CHAR 1 0 P01C_CHKFR
BESGR Statement Grouping Entitements CHAR 2 0 T5DC7 P01C_BESGR
BLAGR Statement Grouping for Benefit Types CHAR 2 0 T5DC7 P01C_BLAGR
RDACV Calculate Status of Pension Rights CHAR 1 0 P01C_RDACV
RELAB Base Determination through Payroll Accounting CHAR 1 0 P01C_RELAB
VRLAB Determination of Basis by SAP Payroll Accounting as Default CHAR 1 0 R01C_VRLAB
KZABL Type of Entitlement Derivation CHAR 1 0 P01C_KZABL
1 Entitlement
2 Additional Benefit
3 Bonus
KZUMW Indicator for Deferred Compensation CHAR 1 0 P01C_KZUMW
BGRRB Limited Pension Benefits CHAR 1 0 P01C_BGRRB
ZANSP Target Entitlement for Calculation of Guaranteed Payment CHAR 4 0 T5DCA P01C_ZANSP
KNZZF Flag: Eligible for Bonus under AVmG CHAR 1 0 P01C_KNZZF
ZERTF Certification Number CHAR 6 0 P01A_ZERTF
BEWUZ PEP: Evaluation Immediate / Periodic CHAR 1 0 P01_VA_BEWUZ
U Immediate Evaluation
Z Periodic Evaluation
ENDGH PEP: Pension Based on Final Salary CHAR 1 0 P01_VA_ENDGH
GLRSK PEP: Identical Term Coverage for Equalization Paymt Eligible CHAR 1 0 P01_VA_GLRSK
TLREL Split Relevance CHAR 1 0 P01_VA_TLREL
Relevant for Split
1 Not Relevant for Split
2 Not Ready for Split
VAKMT Method for Immediate Reduction CHAR 1 0 P01_VA_VAKMT
Calendar Day Rule
1 30-Day Rule
3 30-Day Weighting
RBZUS Defined Contribution Scheme CHAR 1 0 P01A_RBZUS
ANPPF Adjustment Liability CHAR 1 0 P01A_ANPPF
FKTUA Function Determining Portion to be Adjusted Vested Pen.Rghts CHAR 2 0 T5DWY P01A_FKTUA

T5DCA foreign key relationships

Table Field Check Table Check Field
0 T5DCA ANLND T005 Countries MANDT
0 T5DCA ANLND T005 Countries LAND1
1 T5DCA BESGR T5DC7 CPS Groupings MANDT
0 T5DCA BLAGR T5DC7 CPS Groupings MANDT
1 T5DCA BVANS T5DWY Functions for Company Pension Scheme MANDT
1 T5DCA BVANS T5DWY Functions for Company Pension Scheme FKTID
1 T5DCA BVANS T5DWY Functions for Company Pension Scheme NUMID
0 T5DCA DATEI T548Y Date Types MANDT
0 T5DCA DATEI T548Y Date Types DATAR
1 T5DCA DTYBS T5DCG CPS Indicator MANDT
1 T5DCA DTYBS T5DCG CPS Indicator KZTYP
0 T5DCA FKTUA T5DWY Functions for Company Pension Scheme MANDT
0 T5DCA FKTUA T5DWY Functions for Company Pension Scheme FKTID
0 T5DCA FKTUA T5DWY Functions for Company Pension Scheme NUMID
1 T5DCA IDBA1 T5DW1 CPS Identification Features MANDT
1 T5DCA IDBA1 T5DW1 CPS Identification Features GRTP4
0 T5DCA IDBA2 T5DW1 CPS Identification Features MANDT
0 T5DCA IDBA2 T5DW1 CPS Identification Features GRTP4
1 T5DCA ITBLD T5DC0 Control Screen Types for Entitlements MANDT
1 T5DCA ITBLD T5DC0 Control Screen Types for Entitlements ITBLD
0 T5DCA MORER T5DC7 CPS Groupings MANDT
1 T5DCA REGRL T5DCG CPS Indicator MANDT
1 T5DCA REGRL T5DCG CPS Indicator KZTYP
0 T5DCA STABS T5DCV Entitlement Status MANDT
0 T5DCA STABS T5DCV Entitlement Status HANSP
0 T5DCA STABS T5DCV Entitlement Status MITST
1 T5DCA VLTRG T5DCU Account Assignment: Basic Pension Pay MANDT
1 T5DCA VLTRG T5DCU Account Assignment: Basic Pension Pay LTRGR
1 T5DCA VLTRG T5DCU Account Assignment: Basic Pension Pay ENDDA
0 T5DCA VLUSP T5DC3 Pension Organization for Company Pension Scheme MANDT
1 T5DCA VSTAT T5DCV Entitlement Status MANDT
1 T5DCA VSTAT T5DCV Entitlement Status HANSP
1 T5DCA VSTAT T5DCV Entitlement Status MITST
0 T5DCA ZANSP T5DCA Entitlements / Benefit Types MANDT
0 T5DCA ZANSP T5DCA Entitlements / Benefit Types ANTYP
1 T5DCA ZEINH T538A HR Time/Measurement Units MANDT
1 T5DCA ZEINH T538A HR Time/Measurement Units ZEINH