SAP table T5UBA (Benefit plan)

SAP table T5UBA has 4 primary key fields being MANDT,BAREA,BPLAN,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 BEN_PLAN
ENDDA End Date DATS 8 0 ENDDA
BEGDA Start Date DATS 8 0 BEGDA
PLTYP Benefit plan type CHAR 4 0 T5UB1 BEN_TYPE
CRENR Benefit provider NUMC 8 0 T51RH BEN_PROV
PLNNO Benefit plan number CHAR 20 0 BEN_PLANNO
PLSTA Benefit plan status CHAR 2 0 T5UB2 BEN_PLSTAT
RLPVR Benefit Dependent/Beneficiary Eligibility Rule Variant CHAR 4 0 T74HS BEN_RLPVR
COBOK Benefit indicator COBRA relevance CHAR 1 0 BEN_COBRA
IMPUT Benefit indicator imputed income relevant CHAR 1 0 BEN_IMPUT
DEFER Benefits Indicator Qualified Plan CHAR 1 0 BEN_DEFERR
FLXCR Benefits Indicator: Credits Can Be Used CHAR 1 0 BEN_FLXCR
GTLIF Benefits Determination of Imputed Income (Group Term Life) NUMC 1 0 BEN_GTLIF
0 Plan not relevant for imputed income
1 Employee determines imputed income
2 Spouse determines imputed income
3 Child determines imputed income
CSTCR Benefit indicator for plan attribute costs/credits CHAR 1 0 BEN_CSTCR
ERNOC Benefit employer costs are not credited to the employee CHAR 1 0 BEN_ERNOC
L457S Benefit Indicator Plan is Savings Plan According to ยง457 CHAR 1 0 BEN_L457S
L403B Benefit indicator plan is relevant for 403(b) limit CHAR 1 0 BEN_L403B
EEOWN Benefit indicator 403(b) plan belongs to employee CHAR 1 0 BEN_EEOWN
TPASV Benefit scope of third party administrator (TPA) service CHAR 1 0 BEN_TPASV
F Full TPA service
P Partial TPA service
CMTSV Benefit Calendar Type for Length of Service Calculation CHAR 1 0 T54C2 BEN_CMTSV
CPMOD Benefit Compensation Model for Calculating Earnings CHAR 4 0 T74HM BEN_CPMOE
CPMOH Benefit Compensation Model for Calculating Working Hours CHAR 4 0 T74HM BEN_CPMOH
EQSCH Benefit Indic. Ben. Accrual Hours according to Plnd W. Time CHAR 1 0 BEN_EQSCH
EQHRS Benefit Number of Benefit Accrual Hours DEC 15 2 BEN_EQHRS
EQPER Benefit Reference Period for Benefit Accrual Hours NUMC 2 0 BEN_EQPER
LNCOD Benefit insurance line code for IDOC transmission CHAR 3 0 BEN_LNCOD
403 403(B) Tax-Sheltered Annuity
AC Basic Life
ADD Accidental Death or Dismemberment
AF Supplemental Life
AG Preventitive Care / Wellness
AH 24 Hour Care
AJ Medicare Risk
AK Mental Health
AP Paid-Up Life
AR Dependent Life
BC Death and Dismemberment
BE Supplemental Death and Dismemberment
BH Weekly Indemnity
BK Weeky Indemnity - New York Employees
CHU 403(C) Church Exempt Annuity Plans Covered by ERISA
CLF Contributory Life
DCP Dental Capitation
DEN Dental
EMP 408(K) Employer Sponsored Qualified Defined Distrib. Plans
EPO Exclusive Provider Organization
FAC Facility
GDC 457(B) Government Deferred Compensation
HE Hearing
HLT Health
HMO Health Maintenance Organization
IRA Group Individual Retirment Account
IRC 408(B) Individual Retirement Account (IRA) Annuity Contract
LL Lifestyle Life (Individualized Basic Life)
LTC Long-Term Care
LTD Long-Term Disability
MM Major Medical
MOD Mail-Order Drugs
NGD 457(F) Non-Government Deferred Compensation
NQ Non-Qualified
PDG Prescription Drugs
POS Point of Service
PPO Preferred Provider Organization
PRA Practitioner
PSP Profit-Sharing Plan
QDA 401(K) Qualified Cash or Deferred Arrangement
QDC 401(A) Qualified Defined Contribution
STD Short-Term Disability
UL Universal Life
UR Utilization Review
VIS Vision
SPARQ Benefit indicator spouse's approval required CHAR 1 0 BEN_SPARQ
PRDED Benefit indicator prededuction from employee leaving CHAR 1 0 BEN_PRDED
DEPYN Benefit indicator for relevancy of dependents CHAR 1 0 BEN_DEPYN
BENYN Benefit Indicator for Relevancy of Beneficiaries CHAR 1 0 BEN_BENYN
EEBYN Benefit indicator employee's beneficiary status CHAR 1 0 BEN_EEBYN
CTGYN Benefit indicator relevancy of contingency beneficiary CHAR 1 0 BEN_CTGYN
INVYN Benefit indicator for relevancy of investments CHAR 1 0 BEN_INVYN
PREYN Benefit indicator pre-tax deductions allowed CHAR 1 0 BEN_PREYN
PSTYN Benefit indicator post-tax deductions allowed CHAR 1 0 BEN_PSTYN
CSTYN Benefit indicator for cost rule variant relevancy CHAR 1 0 BEN_CSTYN
CRDYN Benefit indicator for credit rule variant relevancy CHAR 1 0 BEN_CRDYN
COVYN Benefit indicator for coverage rule variant relevancy CHAR 1 0 BEN_COVYN
EECYN Benefit indicator for relevancy of EE contribution CHAR 1 0 BEN_EECYN
ERCYN Benefit indicator for relevancy of ER contribution CHAR 1 0 BEN_ERCYN
VESYN Benefit indicator for relevancy of vesting rule CHAR 1 0 BEN_VESYN
BONYN Benefit indicator plan relevant for bonus payments CHAR 1 0 BEN_BONYN
EEWTY Benefit Wage Type for Pre-Tax Employee Contributions CHAR 4 0 * BEN_EEWTYP
PTWTY Benefit Wage Type for Post-Tax Employee Contributions CHAR 4 0 * BEN_PTWTYP
ERWTY Benefit Wage Type for Employer Contribution CHAR 4 0 * BEN_ERWTYP
TBWTY Benefit wage type for technical calculation base CHAR 4 0 * BEN_TBWTYP
BEWTY Benefit wage type for bonus employee pre-tax amount CHAR 4 0 * BEN_BEWTYP
BPWTY Benefit wage type for employee post-tax bonus contribution CHAR 4 0 * BEN_BPWTYP
BRWTY Benefit wage type for employer bonus contribution CHAR 4 0 * BEN_BRWTYP
BTWTY Benefit Technical Wage Type for Bonus Payment CHAR 4 0 * BEN_BTWTYP
PRWTY Benefit wage type for payments to provider CHAR 4 0 * BEN_PRWTYP
BSWTY Benefit wage type for calculation base CHAR 4 0 * BEN_BSWTYP
INWTY Benefit wage type for investment CHAR 4 0 * BEN_INWTYP
CPWTY Benefit Wage Type for Storage of Compensation from Model CHAR 4 0 * BEN_CPWTYP
IIWTY Benefits Wage Type for Imputed Income CHAR 4 0 * BEN_IIWTY
URLPL Benefit URL ID for Information on Benefits Plan CHAR 4 0 T74HP BEN_URLPL
PPLAN To be deleted - no longer used! CHAR 4 0 T5UBA BEN_PPLAN
ROTHP Benefits Indicator Roth Plan CHAR 1 0 BEN_ROTHP
HSAPL Benefits Indicator HSA Plan CHAR 1 0 BEN_HSAPL
COBSR Relevant for COBRA subsidy CHAR 1 0 BEN_COBSR
COBCM COBRA indicator for calendar month plans CHAR 1 0 BEN_COBCM

T5UBA foreign key relationships

Table Field Check Table Check Field
0 T5UBA BAREA T5UB3 Benefit area MANDT
0 T5UBA BAREA T5UB3 Benefit area BAREA
1 T5UBA CMTSV T54C2 Calendar Type MANDT
1 T5UBA CMTSV T54C2 Calendar Type CUMTY
0 T5UBA CRENR T51RH HR payee derived link to FI vendor MANDT
1 T5UBA PLSTA T5UB2 Benefit plan status MANDT
1 T5UBA PLSTA T5UB2 Benefit plan status PLSTA
0 T5UBA PLTYP T5UB1 Benefit plan type MANDT
0 T5UBA PLTYP T5UB1 Benefit plan type PLTYP
1 T5UBA PPLAN T5UBA Benefit plan MANDT
1 T5UBA PPLAN T5UBA Benefit plan ENDDA