PERNR SAP (Standard Selections for HR Master Data Reporting) Structure details

Dictionary Type: Structure
Description: Standard Selections for HR Master Data Reporting




ABAP Code to SELECT data from PERNR
Related tables to PERNR
Access table PERNR




Structure field list including key, data, relationships and ABAP select examples

PERNR is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Standard Selections for HR Master Data Reporting" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_PERNR TYPE PERNR.

The PERNR table consists of various fields, each holding specific information or linking keys about Standard Selections for HR Master Data Reporting data available in SAP. These include MASSN (Action Type), MASSG (Reason for Action), STAT1 (Customer-Specific Status), STAT2 (Employment Status).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP PERNR structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
PERNRPersonnel Number P_PERNRNUMC8PERNR
MASSNAction Type MASSNCHAR2T529AMASSN
MASSGReason for Action MASSGCHAR2T530MASSG
STAT1Customer-Specific Status STAT1CHAR1T529USTATA
STAT2Employment Status STAT2CHAR1T529USTATA
STAT3Special Payment Status STAT3CHAR1T529USTATA
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
WERKSPersonnel Area PERSACHAR4T500PPERSAPBR
PERSGEmployee Group PERSGCHAR1T501PERSGPRG
PERSKEmployee Subgroup PERSKCHAR2T503KPERSKPKR
VDSK1Organizational Key VDSK1CHAR14T527OVDSK1
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
BTRTLPersonnel Subarea BTRTLCHAR4T001PBTRTLPBS
JUPERLegal Person JUPERCHAR4JUPER
ABKRSPayroll Area ABKRSCHAR2T549AABKRSABK
ANSVHWork Contract ANSVHCHAR2T542AANSVH
KOSTLCost Center KOSTLCHAR10CSKSALPHAKOSTLKOS
ORGEHOrganizational Unit ORGEHNUMC8T527XORGEH
PLANSPosition PLANSNUMC8T528BPLANS
STELLJob STELLNUMC8T513STELL
MSTBRSupervisor Area MSTBRCHAR8MSTBR
SACHAPayroll Administrator SACHACHAR3T526SACHA
SACHPAdministrator for HR Master Data SACHPCHAR3T526SACHA
SACHZAdministrator for Time Recording SACHZCHAR3T526SACHA
SNAMEEmployee's Name (Sortable by LAST NAME FIRST NAME) SMNAMCHAR30CHAR30
ENAMEFormatted Name of Employee or Applicant EMNAMCHAR40TEXT40
OTYPEObject Type OTYPECHAR2T778OOTYPEPOT
SBMODAdministrator Group SBMODCHAR4CHAR4SGR
KOKRSControlling Area KOKRSCHAR4TKA01CACCDCAC
FISTLFunds Center FISTLCHAR16Assigned to domainFISTLFIS
GEBERFund BP_GEBERCHAR10Assigned to domainBP_GEBERFIC
FKBERFunctional Area FKBERCHAR16Assigned to domainFKBERFBE
GRANT_NBRGrant GM_GRANT_NBRCHAR20ALPHAGM_GRANT_NBRGM_GRANT_NBRGRANTS_GENERIC
SGMNTSegment for Segmental Reporting FB_SEGMENTCHAR10Assigned to domainALPHAFB_SEGMENT
BUDGET_PDFM: Budget Period FM_BUDGET_PERIODCHAR10Assigned to domainFM_BUDGET_PERIODBUDPER
MASNGAction, action reason P_MASNGCHAR4CHAR4
STATUConcatenated field: Status 1, 2 and 3 P_STATUCHAR3CHAR3
XBWBKPersonnel Area, Personnel Subarea, Cost Center XBWBKCHAR18CHAR18
KOKTLControlling area, cost center P_KOKTLCHAR14CHAR14
XPGPKEmployee Group, Employee Subgroup XPGPKCHAR3CHAR3
SASBAAdministrator modifier, payroll administrator P_SASBACHAR7CHAR7
SASBPAdministrator modifier, personnel administrator P_SASBPCHAR7CHAR7
SASBZAdministrator modifier, time administrator P_SASBZCHAR7CHAR7
DAYPSStart Date of Person Selection Period PNPBEGPSDATS8DATUM
EXPIDExternal Person ID PERSONID_EXTCHAR20ALPHAPERSONID_EXT
PAYTYPayroll type PAYTYCHAR1PAYTY

Key field Non-key field



How do I retrieve data from SAP structure PERNR using ABAP code?

As PERNR is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on PERNR as there is no data to select.

How to access SAP table PERNR

Within an ECC or HANA version of SAP you can also view further information about PERNR and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!