1. Home
  2. Resources
  3. SAP Tables
  4. V_5UBA_B - Generated Table for View

SAP Table V_5UBA_B

Generated Table for View

V_5UBA_B (Generated Table for View) 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 V_5UBA_B to other SAP tables.

Source: V_5UBA_B (Generated Table for View)

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

V_5UBA_B foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
V_5UBA_B BAREA V_5UBA_B MANDT T5UB3 Benefit area MANDT
V_5UBA_B BAREA V_5UBA_B BAREA T5UB3 Benefit area BAREA
V_5UBA_B CRENR V_5UBA_B CRENR T51RH HR payee derived link to FI vendor CRENR
V_5UBA_B CRENR '3' T51RH HR payee derived link to FI vendor CRETY
V_5UBA_B CRENR V_5UBA_B MANDT T51RH HR payee derived link to FI vendor MANDT
V_5UBA_B MANDT V_5UBA_B MANDT T000 Clients MANDT
V_5UBA_B PLSTA V_5UBA_B PLSTA T5UB2 Benefit plan status PLSTA
V_5UBA_B PLSTA V_5UBA_B BAREA T5UB2 Benefit plan status BAREA
V_5UBA_B PLSTA V_5UBA_B MANDT T5UB2 Benefit plan status MANDT
V_5UBA_B PLTYP V_5UBA_B MANDT T5UB1 Benefit plan type MANDT
V_5UBA_B PLTYP V_5UBA_B BAREA T5UB1 Benefit plan type BAREA
V_5UBA_B PLTYP V_5UBA_B PLTYP T5UB1 Benefit plan type PLTYP
V_5UBA_B RLPVR V_5UBA_B BAREA T74HS Benefit Dependent/Beneficiary Eligibility Rule Variant BAREA
V_5UBA_B RLPVR V_5UBA_B RLPVR T74HS Benefit Dependent/Beneficiary Eligibility Rule Variant RLPVR
V_5UBA_B RLPVR V_5UBA_B MANDT T74HS Benefit Dependent/Beneficiary Eligibility Rule Variant MANDT
V_5UBA_B URLPL V_5UBA_B URLPL T74HP Benefits Uniform Resource Locator (URL) URLID
V_5UBA_B URLPL V_5UBA_B BAREA T74HP Benefits Uniform Resource Locator (URL) BAREA
V_5UBA_B URLPL V_5UBA_B MANDT T74HP Benefits Uniform Resource Locator (URL) MANDT