SAP ABAP Table EHS_PERNR (Personnel Data)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ EHS-HEA (Application Component) Occupational Health
     ⤷ P99Q1 (Package) EH&S: Occupational Health

Basic Data

Table Category	INTTAB	Structure
Structure	EHS_PERNR	Table Relationship Diagram
Short Description	Personnel Data

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	PERNR	☐	EHS00_PERNR	EHS00_PERNR	NUMC	8	0	Personnel number
2	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	WERKS	☐	PERSA	PERSA	CHAR	4	0	Personnel Area	T500P
4	PERSG	☐	PERSG	PERSG	CHAR	1	0	Employee Group	T501
5	PERSK	☐	PERSK	PERSK	CHAR	2	0	Employee Subgroup	T503K
6	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
7	BTRTL	☐	BTRTL	BTRTL	CHAR	4	0	Personnel Subarea	T001P
8	ABKRS	☐	ABKRS	ABKRS	CHAR	2	0	Payroll Area	T549A
9	ORGEH	☐	ORGEH	ORGEH	NUMC	8	0	Organizational Unit	T527X
10	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
11	MSTBR	☐	MSTBR	MSTBR	CHAR	8	0	Supervisor Area
12	PLANS	☐	PLANS	PLANS	NUMC	8	0	Position	T528B
13	STELL	☐	STELL	STELL	NUMC	8	0	Job	T513
14	SNAME	☐	SMNAM	CHAR30	CHAR	30	0	Employee's Name (Sortable by LAST NAME FIRST NAME)
15	ENAME	☐	EMNAM	TEXT40	CHAR	40	0	Formatted Name of Employee or Applicant
16	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
17	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
18	DAYPS	☐	EHS00_PAZDATUM	DATUM	DATS	8	0	EHS: Selection Period for Persons
19	GESCH	☐	GESCH	GESCH	CHAR	1	0	Gender Key
20	GBDAT	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
21	GBLND	☐	GBLND	LAND1	CHAR	3	0	Country of Birth	T005
22	GBORT	☐	PAD_GBORT	PAD_ORT01	CHAR	40	0	Birthplace
23	NATIO	☐	NATSL	LAND1	CHAR	3	0	Nationality	T005
24	FAMST	☐	FAMST	FAMST	CHAR	1	0	Marital Status Key	T502T
25	SPRSL	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
26	STAT2	☐	STAT2	STATA	CHAR	1	0	Employment Status	T529U
27	HCENT	☐	EHS00_HEALTHCENTRE	BU_PARTNER	CHAR	10	0	Health Center	*
28	PERID	☐	PRDNI	CHAR20	CHAR	20	0	Personnel ID Number
29	PERSON_ID	☐	EHS00_PERID	CHAR10	CHAR	10	0	Person Identification
30	PERSON_FLAG	☐	EHS00_PERSFLAG	EHS00_PERSFLAG	CHAR	1	0	Person Group: Employee / Applicant / External Person
31	NACHN	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
32	VORNA	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EHS_PERNR	ABKRS	T549A	ABKRS
2	EHS_PERNR	BTRTL	T001P	BTRTL
3	EHS_PERNR	BUKRS	T001	BUKRS
4	EHS_PERNR	FAMST	T502T	FAMST
5	EHS_PERNR	GBLND	T005	LAND1
6	EHS_PERNR	GSBER	TGSB	GSBER
7	EHS_PERNR	KOKRS	TKA01	KOKRS
8	EHS_PERNR	KOSTL	CSKS	KOSTL
9	EHS_PERNR	NATIO	T005	LAND1
10	EHS_PERNR	ORGEH	T527X	ORGEH
11	EHS_PERNR	OTYPE	T778O	OTYPE
12	EHS_PERNR	PERSG	T501	PERSG
13	EHS_PERNR	PERSK	T503K	PERSK
14	EHS_PERNR	PLANS	T528B	PLANS
15	EHS_PERNR	SPRSL	T002	SPRAS
16	EHS_PERNR	STAT2	T529U	STATV
17	EHS_PERNR	STELL	T513	STELL
18	EHS_PERNR	WERKS	T500P	PERSA

History

Last changed by/on	SAP	20130529
SAP Release Created in