SAP table T5UBI (Benefit cost rule)

SAP table T5UBI has 12 primary key fields being MANDT,BAREA,BPLAN,BCOST,SALGR,AGEGR,LOSGR,CSTV1,GENDR,SMOKE,LIMIT,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 T000 MANDT
BAREA Benefit area CHAR 2 0 T5UB3 BEN_AREA
BPLAN Benefit plan CHAR 4 0 T5UBA BEN_PLAN
BCOST Benefit Cost Rule Variant CHAR 4 0 T5UBH BEN_CSTFM
SALGR Benefit salary group CHAR 4 0 T5UBK BEN_SALGR
AGEGR Benefit age group CHAR 4 0 T5UBL BEN_AGEGR
LOSGR Benefit seniority group CHAR 4 0 T5UBM BEN_LOSGR
CSTV1 Benefit cost grouping CHAR 4 0 T5UB5 BEN_CSTV1
GENDR Benefit gender data for insurance costs calculation CHAR 1 0 BEN_GENDER
* Not relevant
1 Male
2 Female
SMOKE Benefit smoker indicator CHAR 1 0 BEN_SMOKER
LIMIT Benefit insurance cost rule variant limit NUMC 13 0 BEN_LIMIT
ENDDA End Date DATS 8 0 ENDDA
BEGDA Start Date DATS 8 0 BEGDA
INCRE Benefit base unit for insurance cost calculation CURR 13 2 BEN_INCREM
EECST Benefit Employee Cost Amount CURR 13 2 BEN_EECOST
EEFAC To be deleted - no longer used! CHAR 1 0 BEN_EEFAC
CSTFA Benefits Factor for Employee Costs DEC 7 4 BEN_CSTFA
CSTRL Benefit rounding rule CHAR 1 0 BEN_ROUNDR
CSTRN Benefit rounding divisor CURR 13 2 BEN_ROUNDD
ERCST Benefit Employer Cost/Credit Amount CURR 13 2 BEN_ERCOST
ERFAC To be deleted - no longer used! CHAR 1 0 BEN_ERFAC
ERCFA Benefit Factor for Employer Credit/Costs DEC 7 4 BEN_ERCFA
ERCRL Benefit rounding rule CHAR 1 0 BEN_ROUNDR
ERCRN Benefit rounding divisor CURR 13 2 BEN_ROUNDD
ACCST Benefit Provider Cost Amount CURR 13 2 BEN_ACCOST
ACFAC To be deleted - no longer used! CHAR 1 0 BEN_ACFAC
ACCFA Benefit Factor for Provider Cost DEC 7 4 BEN_ACCFA
ACCRL Benefit rounding rule CHAR 1 0 BEN_ROUNDR
ACCRN Benefit rounding divisor CURR 13 2 BEN_ROUNDD
PTCST Benefits Additional Employee Post-Tax Costs CURR 13 2 BEN_PTCST
IMINC Benefits Imputed Income CURR 13 2 BEN_IMINC

T5UBI foreign key relationships

Table Field Check Table Check Field
0 T5UBI AGEGR T5UBL Benefit age group MANDT
0 T5UBI AGEGR T5UBL Benefit age group CRGRP
1 T5UBI BAREA T5UB3 Benefit area MANDT
1 T5UBI BAREA T5UB3 Benefit area BAREA
0 T5UBI BCOST T5UBH Benefit cost rule variant MANDT
0 T5UBI BCOST T5UBH Benefit cost rule variant BPLAN
1 T5UBI BPLAN T5UBA Benefit plan MANDT
1 T5UBI BPLAN T5UBA Benefit plan ENDDA
0 T5UBI CSTV1 T5UB5 Benefit cost grouping MANDT
1 T5UBI LOSGR T5UBM Benefit seniority group MANDT
1 T5UBI LOSGR T5UBM Benefit seniority group CRGRP
0 T5UBI SALGR T5UBK Benefit Salary Group MANDT
0 T5UBI SALGR T5UBK Benefit Salary Group CRGRP