SAP ABAP Table PERNR (Standard Selections for HR Master Data Reporting)

Hierarchy

☛ SAP_HRRXX (Software Component) Sub component SAP_HRRXX of SAP_HR
   ⤷ PA-PA (Application Component) Personnel Administration
     ⤷ PBAS (Package) SAP HR Master Data Application Development

Basic Data

Table Category	INTTAB	Structure
Structure	PERNR	Table Relationship Diagram
Short Description	Standard Selections for HR Master Data Reporting

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	☐	P_PERNR	PERNR	NUMC	8	0	Personnel Number
2	.INCLUDE	☐				0	0	HR Master Record: Infotype 0000 (Actions)
3	MASSN	☐	MASSN	MASSN	CHAR	2	0	Action Type	T529A
4	MASSG	☐	MASSG	MASSG	CHAR	2	0	Reason for Action	T530
5	STAT1	☐	STAT1	STATA	CHAR	1	0	Customer-Specific Status	T529U
6	STAT2	☐	STAT2	STATA	CHAR	1	0	Employment Status	T529U
7	STAT3	☐	STAT3	STATA	CHAR	1	0	Special Payment Status	T529U
8	.INCLUDE	☐				0	0	HR Master Record: Infotype 0001 (Org. Assignment)
9	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
10	WERKS	☐	PERSA	PERSA	CHAR	4	0	Personnel Area	T500P
11	PERSG	☐	PERSG	PERSG	CHAR	1	0	Employee Group	T501
12	PERSK	☐	PERSK	PERSK	CHAR	2	0	Employee Subgroup	T503K
13	VDSK1	☐	VDSK1	VDSK1	CHAR	14	0	Organizational Key	T527O
14	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
15	BTRTL	☐	BTRTL	BTRTL	CHAR	4	0	Personnel Subarea	T001P
16	JUPER	☐	JUPER	JUPER	CHAR	4	0	Legal Person
17	ABKRS	☐	ABKRS	ABKRS	CHAR	2	0	Payroll Area	T549A
18	ANSVH	☐	ANSVH	ANSVH	CHAR	2	0	Work Contract	T542A
19	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
20	ORGEH	☐	ORGEH	ORGEH	NUMC	8	0	Organizational Unit	T527X
21	PLANS	☐	PLANS	PLANS	NUMC	8	0	Position	T528B
22	STELL	☐	STELL	STELL	NUMC	8	0	Job	T513
23	MSTBR	☐	MSTBR	MSTBR	CHAR	8	0	Supervisor Area
24	SACHA	☐	SACHA	SACHA	CHAR	3	0	Payroll Administrator	T526
25	SACHP	☐	SACHP	SACHA	CHAR	3	0	Administrator for HR Master Data	T526
26	SACHZ	☐	SACHZ	SACHA	CHAR	3	0	Administrator for Time Recording	T526
27	SNAME	☐	SMNAM	CHAR30	CHAR	30	0	Employee's Name (Sortable by LAST NAME FIRST NAME)
28	ENAME	☐	EMNAM	TEXT40	CHAR	40	0	Formatted Name of Employee or Applicant
29	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
30	SBMOD	☐	SBMOD	CHAR4	CHAR	4	0	Administrator Group
31	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
32	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
33	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
34	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
35	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
36	SGMNT	☐	FB_SEGMENT	FB_SEGMENT	CHAR	10	0	Segment for Segmental Reporting	*
37	MASNG	☐	P_MASNG	CHAR4	CHAR	4	0	Action, action reason
38	STATU	☐	P_STATU	CHAR3	CHAR	3	0	Concatenated field: Status 1, 2 and 3
39	XBWBK	☐	XBWBK	CHAR18	CHAR	18	0	Personnel Area, Personnel Subarea, Cost Center
40	KOKTL	☐	P_KOKTL	CHAR14	CHAR	14	0	Controlling area, cost center
41	XPGPK	☐	XPGPK	CHAR3	CHAR	3	0	Employee Group, Employee Subgroup
42	SASBA	☐	P_SASBA	CHAR7	CHAR	7	0	Administrator modifier, payroll administrator
43	SASBP	☐	P_SASBP	CHAR7	CHAR	7	0	Administrator modifier, personnel administrator
44	SASBZ	☐	P_SASBZ	CHAR7	CHAR	7	0	Administrator modifier, time administrator
45	DAYPS	☐	PNPBEGPS	DATUM	DATS	8	0	Start Date of Person Selection Period
46	EXPID	☐	PERSONID_EXT	PERSONID_EXT	CHAR	20	0	External Person ID
47	PAYTY	☐	PAYTY	PAYTY	CHAR	1	0	Payroll type

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PERNR	ABKRS	T549A	ABKRS
2	PERNR	ANSVH	T542A	ANSVH		1	CN
3	PERNR	BTRTL	T001P	BTRTL
4	PERNR	BUKRS	T001	BUKRS
5	PERNR	GSBER	TGSB	GSBER
6	PERNR	KOKRS	TKA01	KOKRS
7	PERNR	KOSTL	CSKS	KOSTL
8	PERNR	MASSG	T530	MASSG
9	PERNR	MASSN	T529A	MASSN
10	PERNR	ORGEH	T527X	ORGEH
11	PERNR	OTYPE	T778O	OTYPE
12	PERNR	PERSG	T501	PERSG
13	PERNR	PERSK	T503K	PERSK
14	PERNR	PLANS	T528B	PLANS
15	PERNR	SACHA	T526	SACHX
16	PERNR	SACHP	T526	SACHX
17	PERNR	SACHZ	T526	SACHX
18	PERNR	STAT1	T529U	STATV
19	PERNR	STAT2	T529U	STATV
20	PERNR	STAT3	T529U	STATV
21	PERNR	STELL	T513	STELL
22	PERNR	VDSK1	T527O	ORGKY
23	PERNR	WERKS	T500P	PERSA

History

Last changed by/on	SAP	20110901
SAP Release Created in