SAP ABAP Table HREIC_S_EMPLOYEE (EIC Employee Search)

Hierarchy

☛ EA-HRGXX (Software Component) Sub component EA-HRGXX of EA-HR
   ⤷ PA-EIC (Application Component) Employee Interaction Center
     ⤷ PAOC_EIC_APPL_COMMON (Package) Employee Interaction Center: Common Objects

Basic Data

Table Category	INTTAB	Structure
Structure	HREIC_S_EMPLOYEE	Table Relationship Diagram
Short Description	EIC Employee Search

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	GUID	☐	CRMT_GENIL_OBJECT_GUID	SYSUUID	RAW	16	0	Object GUID in Generic Interaction Layer
2	PERNR	☐	P_PERNR	PERNR	NUMC	8	0	Personnel Number
3	PERSONID	☐	PERSONID_EXT	PERSONID_EXT	CHAR	20	0	External Person ID
4	TEXT_WERKS	☐	HREIC_DESCRIPTION	CHAR30K	CHAR	30	0	EIC: Description
5	TEXT_PERSG	☐	HREIC_DESCRIPTION	CHAR30K	CHAR	30	0	EIC: Description
6	TEXT_PERSK	☐	HREIC_DESCRIPTION	CHAR30K	CHAR	30	0	EIC: Description
7	TEXT_KOSTL	☐	HREIC_DESCRIPTION	CHAR30K	CHAR	30	0	EIC: Description
8	TEXT_BTRTL	☐	HREIC_DESCRIPTION	CHAR30K	CHAR	30	0	EIC: Description
9	TEXT_STAT2	☐	HREIC_DESCRIPTION	CHAR30K	CHAR	30	0	EIC: Description
10	TEXT_BUKRS	☐	HREIC_DESCRIPTION	CHAR30K	CHAR	30	0	EIC: Description
11	HIREDATE	☐	HREIC_DATE	HREIC_DATE	CHAR	10	0	Hiring Date for EIC
12	LEAVEDATE	☐	HREIC_DATE	HREIC_DATE	CHAR	10	0	Hiring Date for EIC
13	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
14	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
15	.INCLUDE	☐				0	0	HR Master Record: Infotype 0000 (Actions)
16	MASSN	☐	MASSN	MASSN	CHAR	2	0	Action Type	T529A
17	MASSG	☐	MASSG	MASSG	CHAR	2	0	Reason for Action	T530
18	STAT1	☐	STAT1	STATA	CHAR	1	0	Customer-Specific Status	T529U
19	STAT2	☐	STAT2	STATA	CHAR	1	0	Employment Status	T529U
20	STAT3	☐	STAT3	STATA	CHAR	1	0	Special Payment Status	T529U
21	.INCLUDE	☐				0	0	HR Master Record: Infotype 0002 (Personal Data)
22	INITS	☐	INITS	TEXT10	CHAR	10	0	Initials
23	NACHN	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
24	NAME2	☐	PAD_NAME2	PAD_NACHN	CHAR	40	0	Name at Birth
25	NACH2	☐	PAD_NACH2	PAD_NACHN	CHAR	40	0	Second Name
26	VORNA	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
27	CNAME	☐	PAD_CNAME	TEXT80	CHAR	80	0	Complete Name
28	TITEL	☐	TITEL	TITEL	CHAR	15	0	Title	T535N
29	TITL2	☐	TITL2	TITEL	CHAR	15	0	Second Title	T535N
30	NAMZU	☐	NAMZU	TITEL	CHAR	15	0	Other Title	T535N
31	VORSW	☐	VORSW	TITEL	CHAR	15	0	Name Prefix	T535N
32	VORS2	☐	VORS2	TITEL	CHAR	15	0	Second Name Prefix	T535N
33	RUFNM	☐	PAD_RUFNM	PAD_VORNM	CHAR	40	0	Nickname
34	MIDNM	☐	PAD_MIDNM	PAD_VORNM	CHAR	40	0	Middle Name
35	KNZNM	☐	KNZNM	KNZN2	NUMC	2	0	Name Format Indicator for Employee in a List
36	ANRED	☐	ANRDE	ANRDE	CHAR	1	0	Form-of-Address Key	T522G
37	GESCH	☐	GESCH	GESCH	CHAR	1	0	Gender Key
38	GBDAT	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
39	GBLND	☐	GBLND	LAND1	CHAR	3	0	Country of Birth	T005
40	GBDEP	☐	GBDEP	REGIO	CHAR	3	0	State	T005S
41	GBORT	☐	PAD_GBORT	PAD_ORT01	CHAR	40	0	Birthplace
42	NATIO	☐	NATSL	LAND1	CHAR	3	0	Nationality	T005
43	NATI2	☐	NATS2	LAND1	CHAR	3	0	Second Nationality	T005
44	NATI3	☐	NATS3	LAND1	CHAR	3	0	Third Nationality	T005
45	SPRSL	☐	PAD_SPRAS	SPRAS	LANG	1	0	Communication Language	T002
46	KONFE	☐	KONFE	KONFE	CHAR	2	0	Religious Denomination Key	*
47	FAMST	☐	FAMST	FAMST	CHAR	1	0	Marital Status Key	*
48	FAMDT	☐	FAMDT	DATUM	DATS	8	0	Valid From Date of Current Marital Status
49	ANZKD	☐	ANZKD	DEC03	DEC	3	0	Number of Children
50	NACON	☐	NACON	CHAR1	CHAR	1	0	Name Connection
51	PERMO	☐	PIDMO	CHAR2	CHAR	2	0	Modifier for Personnel Identifier
52	PERID	☐	PRDNI	CHAR20	CHAR	20	0	Personnel ID Number
53	GBPAS	☐	GBPAS	DATUM	DATS	8	0	Date of Birth According to Passport
54	FNAMK	☐	P22J_PFNMK	P22J_PNAME	CHAR	40	0	First name (Katakana)
55	LNAMK	☐	P22J_PLNMK	P22J_PNAME	CHAR	40	0	Last name (Katakana)
56	FNAMR	☐	P22J_PFNMR	P22J_PNAME	CHAR	40	0	First Name (Romaji)
57	LNAMR	☐	P22J_PLNMR	P22J_PNAME	CHAR	40	0	Last Name (Romaji)
58	NABIK	☐	P22J_PNBIK	P22J_PNAME	CHAR	40	0	Name of Birth (Katakana)
59	NABIR	☐	P22J_PNBIR	P22J_PNAME	CHAR	40	0	Name of Birth (Romaji)
60	NICKK	☐	P22J_PNCKK	P22J_PNAME	CHAR	40	0	Koseki (Katakana)
61	NICKR	☐	P22J_PNCKR	P22J_PNAME	CHAR	40	0	Koseki (Romaji)
62	GBJHR	☐	GBJHR	GJAHR	NUMC	4	0	Year of Birth
63	GBMON	☐	GBMON	NUM2	NUMC	2	0	Month of Birth
64	GBTAG	☐	GBTAG	NUM2	NUMC	2	0	Birth Date (to Month/Year)
65	NCHMC	☐	NACHNMC	CHAR25	CHAR	25	0	Last Name (Field for Search Help)
66	VNAMC	☐	VORNAMC	CHAR25	CHAR	25	0	First Name (Field for Search Help)
67	NAMZ2	☐	NAMZ2	TITEL	CHAR	15	0	Name Affix for Name at Birth	T535N
68	.INCLUDE	☐				0	0
69	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
70	STRAS	☐	STRAS	TEXT30	CHAR	30	0	House number and street
71	ORT01	☐	ORT01	TEXT25	CHAR	25	0	City
72	HSNMR	☐	HSNMR	NUMC6	NUMC	6	0	House Number
73	USRIDLONG	☐	COMM_ID_LONG	COMM_ID_LONG	CHAR	241	0	Communication: Long Identification/Number
74	USRTY	☐	USRTY	SUBTY_591A	CHAR	4	0	Communication Type	*
75	.INCLUDE	☐				0	0	HR Master Record: Infotype 0001 (Org. Assignment)
76	.INCLUDE	☐				0	0	HR Master Record: Infotype 0001 (Org. Assignment)
77	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
78	WERKS	☐	PERSA	PERSA	CHAR	4	0	Personnel Area	*
79	PERSG	☐	PERSG	PERSG	CHAR	1	0	Employee Group	*
80	PERSK	☐	PERSK	PERSK	CHAR	2	0	Employee Subgroup	*
81	VDSK1	☐	VDSK1	VDSK1	CHAR	14	0	Organizational Key	*
82	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
83	BTRTL	☐	BTRTL	BTRTL	CHAR	4	0	Personnel Subarea	*
84	JUPER	☐	JUPER	JUPER	CHAR	4	0	Legal Person
85	ABKRS	☐	ABKRS	ABKRS	CHAR	2	0	Payroll Area	*
86	ANSVH	☐	ANSVH	ANSVH	CHAR	2	0	Work Contract	*
87	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
88	ORGEH	☐	ORGEH	ORGEH	NUMC	8	0	Organizational Unit	*
89	PLANS	☐	PLANS	PLANS	NUMC	8	0	Position	T528B
90	STELL	☐	STELL	STELL	NUMC	8	0	Job	*
91	MSTBR	☐	MSTBR	MSTBR	CHAR	8	0	Supervisor Area
92	SACHA	☐	SACHA	SACHA	CHAR	3	0	Payroll Administrator	T526
93	SACHP	☐	SACHP	SACHA	CHAR	3	0	Administrator for HR Master Data	T526
94	SACHZ	☐	SACHZ	SACHA	CHAR	3	0	Administrator for Time Recording	T526
95	SNAME	☐	SMNAM	CHAR30	CHAR	30	0	Employee's Name (Sortable by LAST NAME FIRST NAME)
96	ENAME	☐	EMNAM	TEXT40	CHAR	40	0	Formatted Name of Employee or Applicant
97	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
98	SBMOD	☐	SBMOD	CHAR4	CHAR	4	0	Administrator Group
99	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
100	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
101	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
102	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
103	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
104	SGMNT	☐	FB_SEGMENT	FB_SEGMENT	CHAR	10	0	Segment for Segmental Reporting	*
105	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	HREIC_S_EMPLOYEE	ANRED	T522G	ANRED
2	HREIC_S_EMPLOYEE	BUKRS	T001	BUKRS
3	HREIC_S_EMPLOYEE	GBDEP	T005S	BLAND
4	HREIC_S_EMPLOYEE	GBLND	T005	LAND1
5	HREIC_S_EMPLOYEE	MASSG	T530	MASSG
6	HREIC_S_EMPLOYEE	MASSN	T529A	MASSN
7	HREIC_S_EMPLOYEE	NAMZ2	T535N	TITEL
8	HREIC_S_EMPLOYEE	NAMZU	T535N	TITEL
9	HREIC_S_EMPLOYEE	NATI2	T005	LAND1
10	HREIC_S_EMPLOYEE	NATI3	T005	LAND1
11	HREIC_S_EMPLOYEE	NATIO	T005	LAND1
12	HREIC_S_EMPLOYEE	OTYPE	T778O	OTYPE
13	HREIC_S_EMPLOYEE	PLANS	T528B	PLANS
14	HREIC_S_EMPLOYEE	SACHA	T526	SACHX
15	HREIC_S_EMPLOYEE	SACHP	T526	SACHX
16	HREIC_S_EMPLOYEE	SACHZ	T526	SACHX
17	HREIC_S_EMPLOYEE	SPRSL	T002	SPRAS
18	HREIC_S_EMPLOYEE	STAT1	T529U	STATV
19	HREIC_S_EMPLOYEE	STAT2	T529U	STATV
20	HREIC_S_EMPLOYEE	STAT3	T529U	STATV
21	HREIC_S_EMPLOYEE	TITEL	T535N	TITEL
22	HREIC_S_EMPLOYEE	TITL2	T535N	TITEL
23	HREIC_S_EMPLOYEE	VORS2	T535N	TITEL
24	HREIC_S_EMPLOYEE	VORSW	T535N	TITEL

History

Last changed by/on	SAP	20110901
SAP Release Created in	600