SAP Table V_5UBA_B (Generated Table for View)

SAP table V_5UBA_B 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
IMPUT Benefit indicator imputed income relevant CHAR 1 0 BEN_IMPUT
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
PREYN Benefit indicator pre-tax deductions allowed CHAR 1 0 BEN_PREYN
PSTYN Benefit indicator post-tax deductions allowed CHAR 1 0 BEN_PSTYN
ERNOC Benefit employer costs are not credited to the employee CHAR 1 0 BEN_ERNOC
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
LTEXT Text (30 Characters) CHAR 30 0 TEXT30
STEXT Text (10 Characters) CHAR 10 0 TEXT10
TYPTX Benefit text (15 characters) CHAR 15 0 BEN_TEXT15
CRETX HR payee text CHAR 25 0 CRETX
STATX Text (10 Characters) CHAR 10 0 TEXT10
BPCAT Benefit Plan Category CHAR 1 0 BEN_CATEG
1 Credit plan
A Health plan
B Insurance plan
C Savings plan
D Flexible spending acct
E Miscellaneous plan
F Stock purchase plan
RLPVR Benefit Dependent/Beneficiary Eligibility Rule Variant CHAR 4 0 T74HS BEN_RLPVR
ERWTY Benefit Wage Type for Employer Contribution CHAR 4 0 BEN_ERWTYP
EEWTY Benefit Wage Type for Pre-Tax Employee Contributions CHAR 4 0 BEN_EEWTYP
BSWTY Benefit wage type for calculation base CHAR 4 0 BEN_BSWTYP
PRWTY Benefit wage type for payments to provider CHAR 4 0 BEN_PRWTYP
PTWTY Benefit Wage Type for Post-Tax Employee Contributions CHAR 4 0 BEN_PTWTYP
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
BONYN Benefit indicator plan relevant for bonus payments CHAR 1 0 BEN_BONYN
PRDED Benefit indicator prededuction from employee leaving CHAR 1 0 BEN_PRDED
URLPL Benefit URL ID for Information on Benefits Plan CHAR 4 0 T74HP BEN_URLPL

V_5UBA_B foreign key relationships

Table Field Check Table Check Field
0 V_5UBA_B BAREA T5UB3 Benefit area MANDT
0 V_5UBA_B BAREA T5UB3 Benefit area BAREA
1 V_5UBA_B CRENR T51RH HR payee derived link to FI vendor MANDT
0 V_5UBA_B MANDT T000 Clients MANDT
1 V_5UBA_B PLSTA T5UB2 Benefit plan status MANDT
1 V_5UBA_B PLSTA T5UB2 Benefit plan status PLSTA
0 V_5UBA_B PLTYP T5UB1 Benefit plan type MANDT
0 V_5UBA_B PLTYP T5UB1 Benefit plan type PLTYP