SAP ABAP Table T5UBA (Benefit plan)

Hierarchy

☛ SAP_HRRXX (Software Component) Sub component SAP_HRRXX of SAP_HR
   ⤷ PA-BN (Application Component) Benefits
     ⤷ PBEN (Package) Benefits

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	T5UBA	Table Relationship Diagram
Short Description	Benefit plan

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	BAREA	☑	BEN_AREA	BEN_AREA	CHAR	2	0	Benefit area	T5UB3
3	BPLAN	☑	BEN_PLAN	BEN_PLAN	CHAR	4	0	Benefit plan
4	ENDDA	☑	ENDDA	DATUM	DATS	8	0	End Date
5	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
6	PLTYP	☐	BEN_TYPE	BEN_TYPE	CHAR	4	0	Benefit plan type	T5UB1
7	CRENR	☐	BEN_PROV	CRENR	NUMC	8	0	Benefit provider	T51RH
8	PLNNO	☐	BEN_PLANNO	CHAR20	CHAR	20	0	Benefit plan number
9	PLSTA	☐	BEN_PLSTAT	BEN_PLSTAT	CHAR	2	0	Benefit plan status	T5UB2
10	RLPVR	☐	BEN_RLPVR	BEN_RLPVR	CHAR	4	0	Benefit Dependent/Beneficiary Eligibility Rule Variant	T74HS
11	COBOK	☐	BEN_COBRA	XFELD	CHAR	1	0	Benefit indicator COBRA relevance
12	IMPUT	☐	BEN_IMPUT	XFELD	CHAR	1	0	Benefit indicator imputed income relevant
13	DEFER	☐	BEN_DEFERR	XFELD	CHAR	1	0	Benefits Indicator Qualified Plan
14	FLXCR	☐	BEN_FLXCR	XFELD	CHAR	1	0	Benefits Indicator: Credits Can Be Used
15	GTLIF	☐	BEN_GTLIF	BEN_GTLIF	NUMC	1	0	Benefits Determination of Imputed Income (Group Term Life)
16	CSTCR	☐	BEN_CSTCR	XFELD	CHAR	1	0	Benefit indicator for plan attribute costs/credits
17	ERNOC	☐	BEN_ERNOC	XFELD	CHAR	1	0	Benefit employer costs are not credited to the employee
18	L457S	☐	BEN_L457S	XFELD	CHAR	1	0	Benefit Indicator Plan is Savings Plan According to §457
19	L403B	☐	BEN_L403B	XFELD	CHAR	1	0	Benefit indicator plan is relevant for 403(b) limit
20	EEOWN	☐	BEN_EEOWN	XFELD	CHAR	1	0	Benefit indicator 403(b) plan belongs to employee
21	TPASV	☐	BEN_TPASV	BEN_TPASV	CHAR	1	0	Benefit scope of third party administrator (TPA) service
22	CMTSV	☐	BEN_CMTSV	PBAS_CUMTY	CHAR	1	0	Benefit Calendar Type for Length of Service Calculation	T54C2
23	CPMOD	☐	BEN_CPMOE	BEN_CPMOD	CHAR	4	0	Benefit Compensation Model for Calculating Earnings	T74HM
24	CPMOH	☐	BEN_CPMOH	BEN_CPMOD	CHAR	4	0	Benefit Compensation Model for Calculating Working Hours	T74HM
25	EQSCH	☐	BEN_EQSCH	XFELD	CHAR	1	0	Benefit Indic. Ben. Accrual Hours according to Plnd W. Time
26	EQHRS	☐	BEN_EQHRS	PRANZHL	DEC	15	2	Benefit Number of Benefit Accrual Hours
27	EQPER	☐	BEN_EQPER	PFREQ	NUMC	2	0	Benefit Reference Period for Benefit Accrual Hours
28	LNCOD	☐	BEN_LNCOD	BEN_LNCOD	CHAR	3	0	Benefit insurance line code for IDOC transmission
29	SPARQ	☐	BEN_SPARQ	XFELD	CHAR	1	0	Benefit indicator spouse's approval required
30	PRDED	☐	BEN_PRDED	XFELD	CHAR	1	0	Benefit indicator prededuction from employee leaving
31	DEPYN	☐	BEN_DEPYN	XFELD	CHAR	1	0	Benefit indicator for relevancy of dependents
32	BENYN	☐	BEN_BENYN	XFELD	CHAR	1	0	Benefit Indicator for Relevancy of Beneficiaries
33	EEBYN	☐	BEN_EEBYN	XFELD	CHAR	1	0	Benefit indicator employee's beneficiary status
34	CTGYN	☐	BEN_CTGYN	XFELD	CHAR	1	0	Benefit indicator relevancy of contingency beneficiary
35	INVYN	☐	BEN_INVYN	XFELD	CHAR	1	0	Benefit indicator for relevancy of investments
36	PREYN	☐	BEN_PREYN	XFELD	CHAR	1	0	Benefit indicator pre-tax deductions allowed
37	PSTYN	☐	BEN_PSTYN	XFELD	CHAR	1	0	Benefit indicator post-tax deductions allowed
38	CSTYN	☐	BEN_CSTYN	XFELD	CHAR	1	0	Benefit indicator for cost rule variant relevancy
39	CRDYN	☐	BEN_CRDYN	XFELD	CHAR	1	0	Benefit indicator for credit rule variant relevancy
40	COVYN	☐	BEN_COVYN	XFELD	CHAR	1	0	Benefit indicator for coverage rule variant relevancy
41	EECYN	☐	BEN_EECYN	XFELD	CHAR	1	0	Benefit indicator for relevancy of EE contribution
42	ERCYN	☐	BEN_ERCYN	XFELD	CHAR	1	0	Benefit indicator for relevancy of ER contribution
43	VESYN	☐	BEN_VESYN	XFELD	CHAR	1	0	Benefit indicator for relevancy of vesting rule
44	BONYN	☐	BEN_BONYN	XFELD	CHAR	1	0	Benefit indicator plan relevant for bonus payments
45	EEWTY	☐	BEN_EEWTYP	LGART	CHAR	4	0	Benefit Wage Type for Pre-Tax Employee Contributions	*
46	PTWTY	☐	BEN_PTWTYP	LGART	CHAR	4	0	Benefit Wage Type for Post-Tax Employee Contributions	*
47	ERWTY	☐	BEN_ERWTYP	LGART	CHAR	4	0	Benefit Wage Type for Employer Contribution	*
48	TBWTY	☐	BEN_TBWTYP	LGART	CHAR	4	0	Benefit wage type for technical calculation base	*
49	BEWTY	☐	BEN_BEWTYP	LGART	CHAR	4	0	Benefit wage type for bonus employee pre-tax amount	*
50	BPWTY	☐	BEN_BPWTYP	LGART	CHAR	4	0	Benefit wage type for employee post-tax bonus contribution	*
51	BRWTY	☐	BEN_BRWTYP	LGART	CHAR	4	0	Benefit wage type for employer bonus contribution	*
52	BTWTY	☐	BEN_BTWTYP	LGART	CHAR	4	0	Benefit Technical Wage Type for Bonus Payment	*
53	PRWTY	☐	BEN_PRWTYP	LGART	CHAR	4	0	Benefit wage type for payments to provider	*
54	BSWTY	☐	BEN_BSWTYP	LGART	CHAR	4	0	Benefit wage type for calculation base	*
55	INWTY	☐	BEN_INWTYP	LGART	CHAR	4	0	Benefit wage type for investment	*
56	CPWTY	☐	BEN_CPWTYP	LGART	CHAR	4	0	Benefit Wage Type for Storage of Compensation from Model	*
57	IIWTY	☐	BEN_IIWTY	LGART	CHAR	4	0	Benefits Wage Type for Imputed Income	*
58	URLPL	☐	BEN_URLPL	BEN_URLID	CHAR	4	0	Benefit URL ID for Information on Benefits Plan	T74HP
59	PPLAN	☐	BEN_PPLAN	BEN_PLAN	CHAR	4	0	To be deleted - no longer used!	T5UBA
60	ROTHP	☐	BEN_ROTHP	XFELD	CHAR	1	0	Benefits Indicator Roth Plan
61	HSAPL	☐	BEN_HSAPL	XFELD	CHAR	1	0	Benefits Indicator HSA Plan
62	COBSR	☐	BEN_COBSR	CHAR1	CHAR	1	0	Relevant for COBRA subsidy
63	COBCM	☐	BEN_COBCM	CHAR1	CHAR	1	0	COBRA indicator for calendar month plans

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	T5UBA	BAREA	T5UB3	BAREA	KEY	1	CN
2	T5UBA	CMTSV	T54C2	CUMTY	REF	C	CN
3	T5UBA	CPMOD	T74HM	CPMOD	REF	C	CN
4	T5UBA	CPMOH	T74HM	CPMOD	REF	C	CN
5	T5UBA	CRENR	T51RH	CRENR	KEY	1	CN
6	T5UBA	MANDT	T000	MANDT	KEY	1	CN
7	T5UBA	PLSTA	T5UB2	PLSTA	KEY	1	CN
8	T5UBA	PLTYP	T5UB1	PLTYP	KEY	1	CN
9	T5UBA	PPLAN	T5UBA	BPLAN	KEY	1	CN
10	T5UBA	RLPVR	T74HS	RLPVR	REF	C	CN
11	T5UBA	URLPL	T74HP	URLID	REF	C	CN

History

Last changed by/on	SAP	20110809
SAP Release Created in