1. Home
  2. Resources
  3. SAP Tables
  4. T5UBA - Benefit plan

SAP Table T5UBA

Benefit plan

T5UBA (Benefit plan) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link T5UBA to other SAP tables.

T5UBA table fields

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

T5UBA foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
T5UBA BAREA T5UBA MANDT T5UB3 Benefit area MANDT
T5UBA BAREA T5UBA BAREA T5UB3 Benefit area BAREA
T5UBA CMTSV T5UBA MANDT T54C2 Calendar Type MANDT
T5UBA CMTSV T5UBA CMTSV T54C2 Calendar Type CUMTY
T5UBA CPMOD T5UBA MANDT T74HM Benefit Compensation Model MANDT
T5UBA CPMOD T5UBA BAREA T74HM Benefit Compensation Model BAREA
T5UBA CPMOD T5UBA CPMOD T74HM Benefit Compensation Model CPMOD
T5UBA CPMOH T5UBA CPMOH T74HM Benefit Compensation Model CPMOD
T5UBA CPMOH T5UBA MANDT T74HM Benefit Compensation Model MANDT
T5UBA CPMOH T5UBA BAREA T74HM Benefit Compensation Model BAREA
T5UBA CRENR '3' T51RH HR payee derived link to FI vendor CRETY
T5UBA CRENR T5UBA CRENR T51RH HR payee derived link to FI vendor CRENR
T5UBA CRENR T5UBA MANDT T51RH HR payee derived link to FI vendor MANDT
T5UBA MANDT T5UBA MANDT T000 Clients MANDT
T5UBA PLSTA T5UBA MANDT T5UB2 Benefit plan status MANDT
T5UBA PLSTA T5UBA BAREA T5UB2 Benefit plan status BAREA
T5UBA PLSTA T5UBA PLSTA T5UB2 Benefit plan status PLSTA
T5UBA PLTYP T5UBA BAREA T5UB1 Benefit plan type BAREA
T5UBA PLTYP T5UBA PLTYP T5UB1 Benefit plan type PLTYP
T5UBA PLTYP T5UBA MANDT T5UB1 Benefit plan type MANDT
T5UBA PPLAN T5UBA MANDT T5UBA Benefit plan MANDT
T5UBA PPLAN T5UBA BAREA T5UBA Benefit plan BAREA
T5UBA PPLAN T5UBA PPLAN T5UBA Benefit plan BPLAN
T5UBA PPLAN T5UBA ENDDA T5UBA Benefit plan ENDDA
T5UBA RLPVR T5UBA BAREA T74HS Benefit Dependent/Beneficiary Eligibility Rule Variant BAREA
T5UBA RLPVR T5UBA RLPVR T74HS Benefit Dependent/Beneficiary Eligibility Rule Variant RLPVR
T5UBA RLPVR T5UBA MANDT T74HS Benefit Dependent/Beneficiary Eligibility Rule Variant MANDT
T5UBA URLPL T5UBA MANDT T74HP Benefits Uniform Resource Locator (URL) MANDT
T5UBA URLPL T5UBA BAREA T74HP Benefits Uniform Resource Locator (URL) BAREA
T5UBA URLPL T5UBA URLPL T74HP Benefits Uniform Resource Locator (URL) URLID