SAP ABAP Table U_17185 (Generated Table for View U_17185)

Basic Data

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

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	PERNR	☑	PERSNO	PERSNO	NUMC	8	0	Personnel number	PA0003
3	SUBTY	☑	SUBTY	SUBTY	CHAR	4	0	Subtype
4	OBJPS	☑	OBJPS	OBJPS	CHAR	2	0	Object Identification
5	SPRPS	☑	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
6	ENDDA	☑	ENDDA	DATUM	DATS	8	0	End Date
7	BEGDA	☑	BEGDA	DATUM	DATS	8	0	Start Date
8	SEQNR	☑	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
9	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
10	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
11	HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
12	ITXEX	☐	ITXEX	XFELD	CHAR	1	0	Text Exists for Infotype
13	REFEX	☐	PRFEX	XFELD	CHAR	1	0	Reference Fields Exist (Primary/Secondary Costs)
14	ORDEX	☐	ORDEX	XFELD	CHAR	1	0	Confirmation Fields Exist
15	ITBLD	☐	ITBLD	CHAR2	CHAR	2	0	Infotype Screen Control
16	PREAS	☐	PREAS	PREAS	CHAR	2	0	Reason for Changing Master Data	T530E
17	BAREA	☐	BEN_AREA	BEN_AREA	CHAR	2	0	Benefit area	T5UB3
18	PLTYP	☐	BEN_TYPE	BEN_TYPE	CHAR	4	0	Benefit plan type	T5UB1
19	BPLAN	☐	BEN_PLAN	BEN_PLAN	CHAR	4	0	Benefit plan	T5UBA
20	BENGR	☐	BEN_GROUP	BEN_GROUP	CHAR	4	0	Benefit First Program Grouping	T5UBT
21	BSTAT	☐	BEN_EESTAT	BEN_EESTAT	CHAR	4	0	Benefit Second Program Grouping	T5UB9
22	ELIDT	☐	BEN_ELIDT	DATUM	DATS	8	0	Benefit calculated eligibility date
23	ELDTO	☐	BEN_ELIDTO	DATUM	DATS	8	0	Benefit override eligibility date
24	PARDT	☐	BEN_PARTDT	DATUM	DATS	8	0	Benefit date of first participation in plan
25	BCOVR	☐	BEN_COVLVL	BEN_COVLVL	CHAR	4	0	Benefit Insurance Option	T74FA
26	SALOV	☐	BEN_SALOVR	P_AMT08	CURR	15	2	Benefit salary override amount
27	COVOV	☐	BEN_COVOVR	P_AMT08	CURR	15	2	Benefit Alternative Amount for Insurance Coverage Amount
28	ADDNO	☐	BEN_ADDNO	DEC9	DEC	9	0	Benefit Number of Additional Insurance Coverage Units
29	CURRE	☐	BEN_CURR	WAERS	CUKY	5	0	Benefit Currency Key	TCURC
30	ENRTY	☐	BEN_ENRTYP	BEN_ENRTYP	CHAR	1	0	Benefit Type of Plan Enrollment
31	EVENT	☐	BEN_EVENT	BEN_EVENT	CHAR	4	0	Benefit adjustment reason	T74HA
32	EOGRP	☐	BEN_EOGRP	DATUM	DATS	8	0	Benefits End of Grace Period
33	EOIRQ	☐	BEN_EOIRQ	XFELD	CHAR	1	0	Benefit Statement of Insurability Required
34	EOIPR	☐	BEN_EOIPR	XFELD	CHAR	1	0	Benefit Insurability Proven
35	PRETX	☐	BEN_PRETX	XFELD	CHAR	1	0	Benefit Indicator Deductions Based on Pre-Tax

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	U_17185	BAREA	T5UB3	BAREA
2	U_17185	BCOVR	T74FA	BCOVR
3	U_17185	BENGR	T5UBT	BENGR
4	U_17185	BPLAN	T5UBA	BPLAN
5	U_17185	BSTAT	T5UB9	BSTAT	KEY	1	CN
6	U_17185	CURRE	TCURC	WAERS
7	U_17185	EVENT	T74HA	EVENT	REF	C	CN
8	U_17185	MANDT	T000	MANDT	KEY	1	CN
9	U_17185	PERNR	PA0003	PERNR
10	U_17185	PLTYP	T5UB1	PLTYP
11	U_17185	PREAS	T530E	PREAS

History

Last changed by/on	SAP	20010402
SAP Release Created in