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 | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
Possible values
|
||||||||||||
PERNR foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| PERNR | ABKRS | SYST | MANDT | T549A | Payroll areas | MANDT |
| PERNR | ABKRS | PERNR | ABKRS | T549A | Payroll areas | ABKRS |
| PERNR | ANSVH | T500P | MOLGA | T542A | Work Contract | MOLGA |
| PERNR | ANSVH | PERNR | ANSVH | T542A | Work Contract | ANSVH |
| PERNR | ANSVH | SYST | MANDT | T542A | Work Contract | MANDT |
| PERNR | BTRTL | PERNR | BTRTL | T001P | Personnel Area/Subarea | BTRTL |
| PERNR | BTRTL | SYST | MANDT | T001P | Personnel Area/Subarea | MANDT |
| PERNR | BTRTL | PERNR | WERKS | T001P | Personnel Area/Subarea | WERKS |
| 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 | * | CSKS | Cost Center Master Data | DATBI | |
| 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 | MASSG | SYST | MANDT | T530 | Reasons for Actions | MANDT |
| PERNR | MASSG | PERNR | MASSN | T530 | Reasons for Actions | MASSN |
| PERNR | MASSG | PERNR | MASSG | T530 | Reasons for Actions | MASSG |
| PERNR | MASSN | SYST | MANDT | T529A | Personnel Action Types | MANDT |
| PERNR | MASSN | PERNR | MASSN | T529A | Personnel Action Types | MASSN |
| PERNR | ORGEH | SYST | MANDT | T527X | Organizational Units | MANDT |
| PERNR | ORGEH | * | T527X | Organizational Units | SPRSL | |
| PERNR | ORGEH | PERNR | ORGEH | T527X | Organizational Units | ORGEH |
| PERNR | ORGEH | * | T527X | Organizational Units | ENDDA | |
| 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 | PERNR | PERSK | T503K | Employee subgroup | PERSK |
| PERNR | PERSK | SYST | MANDT | T503K | Employee subgroup | MANDT |
| PERNR | PLANS | PERNR | OTYPE | T528B | Positions | OTYPE |
| PERNR | PLANS | PERNR | PLANS | T528B | Positions | PLANS |
| PERNR | PLANS | * | T528B | Positions | ENDDA | |
| PERNR | PLANS | SYST | MANDT | T528B | Positions | MANDT |
| PERNR | SACHA | PERNR | SBMOD | T526 | Administrators | WERKS |
| PERNR | SACHA | PERNR | SACHA | T526 | Administrators | SACHX |
| PERNR | SACHA | SYST | MANDT | T526 | Administrators | MANDT |
| PERNR | SACHP | SYST | MANDT | T526 | Administrators | MANDT |
| PERNR | SACHP | PERNR | SBMOD | T526 | Administrators | WERKS |
| PERNR | SACHP | PERNR | SACHP | T526 | Administrators | SACHX |
| PERNR | SACHZ | SYST | MANDT | T526 | Administrators | MANDT |
| PERNR | SACHZ | PERNR | SBMOD | T526 | Administrators | WERKS |
| PERNR | SACHZ | PERNR | SACHZ | T526 | Administrators | SACHX |
| PERNR | STAT1 | SYST | MANDT | T529U | Status Values | MANDT |
| PERNR | STAT1 | SYST | LANGU | T529U | Status Values | SPRSL |
| PERNR | STAT1 | '1' | T529U | Status Values | STATN | |
| PERNR | STAT1 | PERNR | STAT1 | T529U | Status Values | STATV |
| PERNR | STAT2 | '2' | T529U | Status Values | STATN | |
| PERNR | STAT2 | PERNR | STAT2 | T529U | Status Values | STATV |
| PERNR | STAT2 | SYST | MANDT | T529U | Status Values | MANDT |
| PERNR | STAT2 | SYST | LANGU | T529U | Status Values | SPRSL |
| PERNR | STAT3 | PERNR | STAT3 | 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 | STELL | SYST | MANDT | T513 | Jobs | MANDT |
| PERNR | STELL | PERNR | STELL | T513 | Jobs | STELL |
| PERNR | STELL | * | T513 | Jobs | ENDDA | |
| 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 |
