SAP ABAP Table V_5UBA_DB (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_5UBA_DB	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
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	RLPVR	☐	BEN_RLPVR	BEN_RLPVR	CHAR	4	0	Benefit Dependent/Beneficiary Eligibility Rule Variant	T74HS
7	PLNTX	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
8	RPVTX	☐	BEN_RLPVTX	TEXT30	CHAR	30	0	Benefits Dependent/Beneficiary Rule Variant Text
9	PLTYP	☐	BEN_TYPE	BEN_TYPE	CHAR	4	0	Benefit plan type	T5UB1
10	CRENR	☐	BEN_PROV	CRENR	NUMC	8	0	Benefit provider	T51RH
11	PLNNO	☐	BEN_PLANNO	CHAR20	CHAR	20	0	Benefit plan number
12	PLSTA	☐	BEN_PLSTAT	BEN_PLSTAT	CHAR	2	0	Benefit plan status	T5UB2
13	COBOK	☐	BEN_COBRA	XFELD	CHAR	1	0	Benefit indicator COBRA relevance
14	IMPUT	☐	BEN_IMPUT	XFELD	CHAR	1	0	Benefit indicator imputed income relevant
15	DEFER	☐	BEN_DEFERR	XFELD	CHAR	1	0	Benefits Indicator Qualified Plan
16	FLXCR	☐	BEN_FLXCR	XFELD	CHAR	1	0	Benefits Indicator: Credits Can Be Used
17	GTLIF	☐	BEN_GTLIF	BEN_GTLIF	NUMC	1	0	Benefits Determination of Imputed Income (Group Term Life)
18	CSTCR	☐	BEN_CSTCR	XFELD	CHAR	1	0	Benefit indicator for plan attribute costs/credits
19	ERNOC	☐	BEN_ERNOC	XFELD	CHAR	1	0	Benefit employer costs are not credited to the employee
20	L457S	☐	BEN_L457S	XFELD	CHAR	1	0	Benefit Indicator Plan is Savings Plan According to §457
21	L403B	☐	BEN_L403B	XFELD	CHAR	1	0	Benefit indicator plan is relevant for 403(b) limit
22	EEOWN	☐	BEN_EEOWN	XFELD	CHAR	1	0	Benefit indicator 403(b) plan belongs to employee
23	TPASV	☐	BEN_TPASV	BEN_TPASV	CHAR	1	0	Benefit scope of third party administrator (TPA) service
24	CMTSV	☐	BEN_CMTSV	PBAS_CUMTY	CHAR	1	0	Benefit Calendar Type for Length of Service Calculation	T54C2
25	CPMOD	☐	BEN_CPMOE	BEN_CPMOD	CHAR	4	0	Benefit Compensation Model for Calculating Earnings	T74HM
26	CPMOH	☐	BEN_CPMOH	BEN_CPMOD	CHAR	4	0	Benefit Compensation Model for Calculating Working Hours	T74HM
27	EQSCH	☐	BEN_EQSCH	XFELD	CHAR	1	0	Benefit Indic. Ben. Accrual Hours according to Plnd W. Time
28	EQHRS	☐	BEN_EQHRS	PRANZHL	DEC	15	2	Benefit Number of Benefit Accrual Hours
29	EQPER	☐	BEN_EQPER	PFREQ	NUMC	2	0	Benefit Reference Period for Benefit Accrual Hours
30	LNCOD	☐	BEN_LNCOD	BEN_LNCOD	CHAR	3	0	Benefit insurance line code for IDOC transmission
31	PRDED	☐	BEN_PRDED	XFELD	CHAR	1	0	Benefit indicator prededuction from employee leaving
32	INVYN	☐	BEN_INVYN	XFELD	CHAR	1	0	Benefit indicator for relevancy of investments
33	PREYN	☐	BEN_PREYN	XFELD	CHAR	1	0	Benefit indicator pre-tax deductions allowed
34	PSTYN	☐	BEN_PSTYN	XFELD	CHAR	1	0	Benefit indicator post-tax deductions allowed
35	CSTYN	☐	BEN_CSTYN	XFELD	CHAR	1	0	Benefit indicator for cost rule variant relevancy
36	CRDYN	☐	BEN_CRDYN	XFELD	CHAR	1	0	Benefit indicator for credit rule variant relevancy
37	COVYN	☐	BEN_COVYN	XFELD	CHAR	1	0	Benefit indicator for coverage rule variant relevancy
38	EECYN	☐	BEN_EECYN	XFELD	CHAR	1	0	Benefit indicator for relevancy of EE contribution
39	ERCYN	☐	BEN_ERCYN	XFELD	CHAR	1	0	Benefit indicator for relevancy of ER contribution
40	VESYN	☐	BEN_VESYN	XFELD	CHAR	1	0	Benefit indicator for relevancy of vesting rule
41	BONYN	☐	BEN_BONYN	XFELD	CHAR	1	0	Benefit indicator plan relevant for bonus payments
42	EEWTY	☐	BEN_EEWTYP	LGART	CHAR	4	0	Benefit Wage Type for Pre-Tax Employee Contributions
43	PTWTY	☐	BEN_PTWTYP	LGART	CHAR	4	0	Benefit Wage Type for Post-Tax Employee Contributions
44	ERWTY	☐	BEN_ERWTYP	LGART	CHAR	4	0	Benefit Wage Type for Employer Contribution
45	TBWTY	☐	BEN_TBWTYP	LGART	CHAR	4	0	Benefit wage type for technical calculation base
46	BEWTY	☐	BEN_BEWTYP	LGART	CHAR	4	0	Benefit wage type for bonus employee pre-tax amount
47	BPWTY	☐	BEN_BPWTYP	LGART	CHAR	4	0	Benefit wage type for employee post-tax bonus contribution
48	BRWTY	☐	BEN_BRWTYP	LGART	CHAR	4	0	Benefit wage type for employer bonus contribution
49	BTWTY	☐	BEN_BTWTYP	LGART	CHAR	4	0	Benefit Technical Wage Type for Bonus Payment
50	PRWTY	☐	BEN_PRWTYP	LGART	CHAR	4	0	Benefit wage type for payments to provider
51	BSWTY	☐	BEN_BSWTYP	LGART	CHAR	4	0	Benefit wage type for calculation base
52	INWTY	☐	BEN_INWTYP	LGART	CHAR	4	0	Benefit wage type for investment
53	CPWTY	☐	BEN_CPWTYP	LGART	CHAR	4	0	Benefit Wage Type for Storage of Compensation from Model
54	IIWTY	☐	BEN_IIWTY	LGART	CHAR	4	0	Benefits Wage Type for Imputed Income
55	URLPL	☐	BEN_URLPL	BEN_URLID	CHAR	4	0	Benefit URL ID for Information on Benefits Plan	T74HP
56	BPCAT	☐	BEN_CATEG	BEN_CATEG	CHAR	1	0	Benefit Plan Category

Foreign Keys

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

History

Last changed by/on	SAP	20110809
SAP Release Created in