SAP Table PERNR
Standard Selections for HR Master Data Reporting
PERNR (Standard Selections for HR Master Data Reporting) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link PERNR to other SAP tables.
PERNR table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
PERNR
Personnel Number
|
P_PERNR |
NUMC
|
8 | 0 | ||||||||||||||
|
MASSN
Action Type
|
MASSN | T529A |
CHAR
|
2 | 0 | |||||||||||||
|
MASSG
Reason for Action
|
MASSG | T530 |
CHAR
|
2 | 0 | |||||||||||||
|
STAT1
Customer-Specific Status
|
STAT1 | T529U |
CHAR
|
1 | 0 | |||||||||||||
|
STAT2
Employment Status
|
STAT2 | T529U |
CHAR
|
1 | 0 | |||||||||||||
|
STAT3
Special Payment Status
|
STAT3 | T529U |
CHAR
|
1 | 0 | |||||||||||||
|
BUKRS
Company Code
|
BUKRS | T001 |
CHAR
|
4 | 0 | |||||||||||||
|
WERKS
Personnel Area
|
PERSA | T500P |
CHAR
|
4 | 0 | |||||||||||||
|
PERSG
Employee Group
|
PERSG | T501 |
CHAR
|
1 | 0 | |||||||||||||
|
PERSK
Employee Subgroup
|
PERSK | T503K |
CHAR
|
2 | 0 | |||||||||||||
|
VDSK1
Organizational Key
|
VDSK1 | T527O |
CHAR
|
14 | 0 | |||||||||||||
|
GSBER
Business Area
|
GSBER | TGSB |
CHAR
|
4 | 0 | |||||||||||||
|
BTRTL
Personnel Subarea
|
BTRTL | T001P |
CHAR
|
4 | 0 | |||||||||||||
|
JUPER
Legal Person
|
JUPER |
CHAR
|
4 | 0 | ||||||||||||||
|
ABKRS
Payroll Area
|
ABKRS | T549A |
CHAR
|
2 | 0 | |||||||||||||
|
ANSVH
Work Contract
|
ANSVH | T542A |
CHAR
|
2 | 0 | |||||||||||||
|
KOSTL
Cost Center
|
KOSTL | CSKS |
CHAR
|
10 | 0 | |||||||||||||
|
ORGEH
Organizational Unit
|
ORGEH | T527X |
NUMC
|
8 | 0 | |||||||||||||
|
PLANS
Position
|
PLANS | T528B |
NUMC
|
8 | 0 | |||||||||||||
|
STELL
Job
|
STELL | T513 |
NUMC
|
8 | 0 | |||||||||||||
|
MSTBR
Supervisor Area
|
MSTBR |
CHAR
|
8 | 0 | ||||||||||||||
|
SACHA
Payroll Administrator
|
SACHA | T526 |
CHAR
|
3 | 0 | |||||||||||||
|
SACHP
Administrator for HR Master Data
|
SACHP | T526 |
CHAR
|
3 | 0 | |||||||||||||
|
SACHZ
Administrator for Time Recording
|
SACHZ | T526 |
CHAR
|
3 | 0 | |||||||||||||
|
SNAME
Employee's Name (Sortable by LAST NAME FIRST NAME)
|
SMNAM |
CHAR
|
30 | 0 | ||||||||||||||
|
ENAME
Formatted Name of Employee or Applicant
|
EMNAM |
CHAR
|
40 | 0 | ||||||||||||||
|
OTYPE
Object Type
|
OTYPE | T778O |
CHAR
|
2 | 0 | |||||||||||||
|
SBMOD
Administrator Group
|
SBMOD |
CHAR
|
4 | 0 | ||||||||||||||
|
KOKRS
Controlling Area
|
KOKRS | TKA01 |
CHAR
|
4 | 0 | |||||||||||||
|
FISTL
Funds Center
|
FISTL |
CHAR
|
16 | 0 | ||||||||||||||
|
GEBER
Fund
|
BP_GEBER |
CHAR
|
10 | 0 | ||||||||||||||
|
FKBER
Functional Area
|
FKBER |
CHAR
|
16 | 0 | ||||||||||||||
|
GRANT_NBR
Grant
|
GM_GRANT_NBR |
CHAR
|
20 | 0 | ||||||||||||||
|
SGMNT
Segment for Segmental Reporting
|
FB_SEGMENT |
CHAR
|
10 | 0 | ||||||||||||||
|
BUDGET_PD
FM: Budget Period
|
FM_BUDGET_PERIOD |
CHAR
|
10 | 0 | ||||||||||||||
|
MASNG
Action, action reason
|
P_MASNG |
CHAR
|
4 | 0 | ||||||||||||||
|
STATU
Concatenated field: Status 1, 2 and 3
|
P_STATU |
CHAR
|
3 | 0 | ||||||||||||||
|
XBWBK
Personnel Area, Personnel Subarea, Cost Center
|
XBWBK |
CHAR
|
18 | 0 | ||||||||||||||
|
KOKTL
Controlling area, cost center
|
P_KOKTL |
CHAR
|
14 | 0 | ||||||||||||||
|
XPGPK
Employee Group, Employee Subgroup
|
XPGPK |
CHAR
|
3 | 0 | ||||||||||||||
|
SASBA
Administrator modifier, payroll administrator
|
P_SASBA |
CHAR
|
7 | 0 | ||||||||||||||
|
SASBP
Administrator modifier, personnel administrator
|
P_SASBP |
CHAR
|
7 | 0 | ||||||||||||||
|
SASBZ
Administrator modifier, time administrator
|
P_SASBZ |
CHAR
|
7 | 0 | ||||||||||||||
|
DAYPS
Start Date of Person Selection Period
|
PNPBEGPS |
DATS
|
8 | 0 | ||||||||||||||
|
EXPID
External Person ID
|
PERSONID_EXT |
CHAR
|
20 | 0 | ||||||||||||||
|
PAYTY
Payroll type
|
PAYTY |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
PERNR foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| PERNR | ABKRS | PERNR | ABKRS |
T549A
Payroll areas
|
ABKRS |
| PERNR | ABKRS | SYST | MANDT |
T549A
Payroll areas
|
MANDT |
| PERNR | ANSVH | SYST | MANDT |
T542A
Work Contract
|
MANDT |
| PERNR | ANSVH | T500P | MOLGA |
T542A
Work Contract
|
MOLGA |
| PERNR | ANSVH | PERNR | ANSVH |
T542A
Work Contract
|
ANSVH |
| PERNR | BTRTL | SYST | MANDT |
T001P
Personnel Area/Subarea
|
MANDT |
| PERNR | BTRTL | PERNR | WERKS |
T001P
Personnel Area/Subarea
|
WERKS |
| PERNR | BTRTL | PERNR | BTRTL |
T001P
Personnel Area/Subarea
|
BTRTL |
| PERNR | BUKRS | SYST | MANDT |
T001
Company Codes
|
MANDT |
| PERNR | BUKRS | PERNR | BUKRS |
T001
Company Codes
|
BUKRS |
| PERNR | GSBER | SYST | MANDT |
TGSB
Business Areas
|
MANDT |
| PERNR | GSBER | PERNR | GSBER |
TGSB
Business Areas
|
GSBER |
| PERNR | KOKRS | SYST | MANDT |
TKA01
Controlling Areas
|
MANDT |
| PERNR | KOKRS | PERNR | KOKRS |
TKA01
Controlling Areas
|
KOKRS |
| PERNR | KOSTL | SYST | MANDT |
CSKS
Cost Center Master Data
|
MANDT |
| PERNR | KOSTL | PERNR | KOKRS |
CSKS
Cost Center Master Data
|
KOKRS |
| PERNR | KOSTL | PERNR | KOSTL |
CSKS
Cost Center Master Data
|
KOSTL |
| PERNR | KOSTL | * |
CSKS
Cost Center Master Data
|
DATBI | |
| PERNR | MASSG | PERNR | MASSG |
T530
Reasons for Actions
|
MASSG |
| PERNR | MASSG | SYST | MANDT |
T530
Reasons for Actions
|
MANDT |
| PERNR | MASSG | PERNR | MASSN |
T530
Reasons for Actions
|
MASSN |
| PERNR | MASSN | SYST | MANDT |
T529A
Personnel Action Types
|
MANDT |
| PERNR | MASSN | PERNR | MASSN |
T529A
Personnel Action Types
|
MASSN |
| PERNR | ORGEH | PERNR | ORGEH |
T527X
Organizational Units
|
ORGEH |
| PERNR | ORGEH | * |
T527X
Organizational Units
|
ENDDA | |
| PERNR | ORGEH | SYST | MANDT |
T527X
Organizational Units
|
MANDT |
| PERNR | ORGEH | * |
T527X
Organizational Units
|
SPRSL | |
| PERNR | OTYPE | SYST | MANDT |
T778O
Object Types
|
MANDT |
| PERNR | OTYPE | PERNR | OTYPE |
T778O
Object Types
|
OTYPE |
| PERNR | PERSG | SYST | MANDT |
T501
Employee Group
|
MANDT |
| PERNR | PERSG | PERNR | PERSG |
T501
Employee Group
|
PERSG |
| PERNR | PERSK | SYST | MANDT |
T503K
Employee subgroup
|
MANDT |
| PERNR | PERSK | PERNR | PERSK |
T503K
Employee subgroup
|
PERSK |
| PERNR | PLANS | SYST | MANDT |
T528B
Positions
|
MANDT |
| PERNR | PLANS | PERNR | OTYPE |
T528B
Positions
|
OTYPE |
| PERNR | PLANS | PERNR | PLANS |
T528B
Positions
|
PLANS |
| PERNR | PLANS | * |
T528B
Positions
|
ENDDA | |
| PERNR | SACHA | SYST | MANDT |
T526
Administrators
|
MANDT |
| PERNR | SACHA | PERNR | SBMOD |
T526
Administrators
|
WERKS |
| PERNR | SACHA | PERNR | SACHA |
T526
Administrators
|
SACHX |
| PERNR | SACHP | PERNR | SBMOD |
T526
Administrators
|
WERKS |
| PERNR | SACHP | PERNR | SACHP |
T526
Administrators
|
SACHX |
| PERNR | SACHP | SYST | MANDT |
T526
Administrators
|
MANDT |
| PERNR | SACHZ | SYST | MANDT |
T526
Administrators
|
MANDT |
| PERNR | SACHZ | PERNR | SBMOD |
T526
Administrators
|
WERKS |
| PERNR | SACHZ | PERNR | SACHZ |
T526
Administrators
|
SACHX |
| PERNR | STAT1 | PERNR | STAT1 |
T529U
Status Values
|
STATV |
| PERNR | STAT1 | SYST | MANDT |
T529U
Status Values
|
MANDT |
| PERNR | STAT1 | SYST | LANGU |
T529U
Status Values
|
SPRSL |
| PERNR | STAT1 | '1' |
T529U
Status Values
|
STATN | |
| PERNR | STAT2 | SYST | MANDT |
T529U
Status Values
|
MANDT |
| PERNR | STAT2 | SYST | LANGU |
T529U
Status Values
|
SPRSL |
| PERNR | STAT2 | '2' |
T529U
Status Values
|
STATN | |
| PERNR | STAT2 | PERNR | STAT2 |
T529U
Status Values
|
STATV |
| PERNR | STAT3 | SYST | MANDT |
T529U
Status Values
|
MANDT |
| PERNR | STAT3 | SYST | LANGU |
T529U
Status Values
|
SPRSL |
| PERNR | STAT3 | '3' |
T529U
Status Values
|
STATN | |
| PERNR | STAT3 | PERNR | STAT3 |
T529U
Status Values
|
STATV |
| PERNR | STELL | PERNR | STELL |
T513
Jobs
|
STELL |
| PERNR | STELL | * |
T513
Jobs
|
ENDDA | |
| PERNR | STELL | SYST | MANDT |
T513
Jobs
|
MANDT |
| PERNR | VDSK1 | SYST | MANDT |
T527O
Organizational Key Validation
|
MANDT |
| PERNR | VDSK1 | '1' |
T527O
Organizational Key Validation
|
HIRAR | |
| PERNR | VDSK1 | PERNR | VDSK1 |
T527O
Organizational Key Validation
|
ORGKY |
| PERNR | WERKS | SYST | MANDT |
T500P
Personnel Areas
|
MANDT |
| PERNR | WERKS | PERNR | WERKS |
T500P
Personnel Areas
|
PERSA |