SAP ABAP Table U_17170 (Generated Table for View)

Basic Data

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

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

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	COBOK	☑	BEN_COBRA	XFELD	CHAR	1	0	Benefit indicator COBRA relevance
11	IMPUT	☑	BEN_IMPUT	XFELD	CHAR	1	0	Benefit indicator imputed income relevant
12	ERWTY	☑	BEN_ERWTYP	LGART	CHAR	4	0	Benefit Wage Type for Employer Contribution
13	EEWTY	☑	BEN_EEWTYP	LGART	CHAR	4	0	Benefit Wage Type for Pre-Tax Employee Contributions
14	BSWTY	☑	BEN_BSWTYP	LGART	CHAR	4	0	Benefit wage type for calculation base
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	PRWTY	☑	BEN_PRWTYP	LGART	CHAR	4	0	Benefit wage type for payments to provider
19	TBWTY	☑	BEN_TBWTYP	LGART	CHAR	4	0	Benefit wage type for technical calculation base
20	LANGU	☑	LANGU	SPRAS	LANG	1	0	Language Key	T002
21	LTEXT	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
22	STEXT	☐	TEXT10	TEXT10	CHAR	10	0	Text (10 Characters)
23	DEPYN	☐	BEN_DEPYN	XFELD	CHAR	1	0	Benefit indicator for relevancy of dependents
24	BENYN	☐	BEN_BENYN	XFELD	CHAR	1	0	Benefit Indicator for Relevancy of Beneficiaries
25	EEBYN	☐	BEN_EEBYN	XFELD	CHAR	1	0	Benefit indicator employee's beneficiary status
26	CTGYN	☐	BEN_CTGYN	XFELD	CHAR	1	0	Benefit indicator relevancy of contingency beneficiary
27	INVYN	☐	BEN_INVYN	XFELD	CHAR	1	0	Benefit indicator for relevancy of investments
28	PREYN	☐	BEN_PREYN	XFELD	CHAR	1	0	Benefit indicator pre-tax deductions allowed
29	PSTYN	☐	BEN_PSTYN	XFELD	CHAR	1	0	Benefit indicator post-tax deductions allowed
30	CSTYN	☐	BEN_CSTYN	XFELD	CHAR	1	0	Benefit indicator for cost rule variant relevancy
31	CRDYN	☐	BEN_CRDYN	XFELD	CHAR	1	0	Benefit indicator for credit rule variant relevancy
32	COVYN	☐	BEN_COVYN	XFELD	CHAR	1	0	Benefit indicator for coverage rule variant relevancy
33	EECYN	☐	BEN_EECYN	XFELD	CHAR	1	0	Benefit indicator for relevancy of EE contribution
34	ERCYN	☐	BEN_ERCYN	XFELD	CHAR	1	0	Benefit indicator for relevancy of ER contribution
35	VESYN	☐	BEN_VESYN	XFELD	CHAR	1	0	Benefit indicator for relevancy of vesting rule
36	CSTCR	☐	BEN_CSTCR	XFELD	CHAR	1	0	Benefit indicator for plan attribute costs/credits
37	PTWTY	☐	BEN_PTWTYP	LGART	CHAR	4	0	Benefit Wage Type for Post-Tax Employee Contributions

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	U_17170	BAREA	T5UB3	BAREA	KEY	1	CN
2	U_17170	CRENR	T51RH	CRENR	KEY	1	CN
3	U_17170	LANGU	T002	SPRAS	KEY	1	CN
4	U_17170	MANDT	T000	MANDT	KEY	1	CN
5	U_17170	PLSTA	T5UB2	PLSTA	KEY	1	CN
6	U_17170	PLTYP	T5UB1	PLTYP	KEY	1	CN

History

Last changed by/on	SAP	20110809
SAP Release Created in