SAP ABAP Table U_17186 (Generated Table for View U_17186)

Basic Data

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

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	EEPCT	☐	BEN_EECPCT	DEC3_2	DEC	5	2	Benefit EE Pre-Tax Contribution Percentage
26	EEAMT	☐	BEN_EECAMT	P_AMT07	CURR	13	2	Benefit Employee Pre-Tax Contribution Amount
27	PTPCT	☐	BEN_PTPCT	DEC3_2	DEC	5	2	Benefit EE Post-Tax Contribution Percentage
28	PTAMT	☐	BEN_PTAMT	P_AMT07	CURR	13	2	Benefit EE Post-Tax Contribution Amount
29	PSTTX	☐	BEN_PSTTX	XFELD	CHAR	1	0	Benefit Indicator Start Post-Tax Contribution Deduct. Immed.
30	PAAMT	☐	BEN_PAAMT	P_AMT07	CURR	13	2	Benefit Pension Adjustment Amount
31	ACCTN	☐	BEN_ACCTNR	CHAR20	CHAR	20	0	Benefit Account number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	U_17186	BAREA	T5UB3	BAREA
2	U_17186	BENGR	T5UBT	BENGR
3	U_17186	BPLAN	T5UBA	BPLAN
4	U_17186	BSTAT	T5UB9	BSTAT	KEY	1	CN
5	U_17186	MANDT	T000	MANDT	KEY	1	CN
6	U_17186	PERNR	PA0003	PERNR
7	U_17186	PLTYP	T5UB1	PLTYP
8	U_17186	PREAS	T530E	PREAS

History

Last changed by/on	SAP	20010402
SAP Release Created in