SAP PAR40 Personnel Record Infotype 0006 (Addresses) AR Table data and field list

PAR40 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 "Personnel Record Infotype 0006 (Addresses) AR" 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_PAR40 TYPE PAR40.

The PAR40 table consists of various fields, each holding specific information or linking keys about Personnel Record Infotype 0006 (Addresses) AR data available in SAP. These include EMPLOYEENO (Personnel Number), SUBTYPE (Subtype), OBJECTID (Object Identification), LOCKINDIC (Lock Indicator for HR Master Data Record)... 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. .

PAR40 structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


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

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the PAR40 table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
EMPLOYEENOPersonnel Number PERNR_DNUMC8PERNRPER
SUBTYPESubtype SUBTYCHAR4SUBTYSUB
OBJECTIDObject Identification OBJPSCHAR2OBJPSOPS
LOCKINDICLock Indicator for HR Master Data Record SPRPSCHAR1SPRPS
VALIDENDEnd Date ENDDADATS8DATUM
VALIDBEGINStart Date BEGDADATS8DATUM
RECORDNRNumber of Infotype Record with Same Key SEQNRNUMC3NUM03
ADDRESSTYPEAddress Record Type ANSSACHAR4T591ASUBTY_591A
NAMEOFADDRESSTYPEName of Subtype SBTTXCHAR40TEXT40
CONAMEContact Name PAD_CONAMCHAR40PAD_NACHN
STREETANDHOUSENOStreet and House Number PAD_STRASCHAR60PAD_STRAS
SCNDADDRESSLINE2nd Address Line PAD_LOCATCHAR40PAD_LOCAT
CITYCity PAD_ORT01CHAR40PAD_ORT01
DISTRICTDistrict PAD_ORT02CHAR40PAD_ORT01
POSTALCODECITYPostal Code PSTLZ_HRCHAR10PSTLZ
STATESTATE (State, Province, County) REGIOCHAR3T005SREGIO
NAMEOFSTATEDescription BEZEI20CHAR20TEXT20
COUNTRYCountry Key LAND1CHAR3T005LAND1LND
NAMEOFCOUNTRYCountry Name LANDXCHAR15TEXT15
TELEPHONENUMBERTelephone Number TELNRCHAR14TELNR
HOUSENUMBERHouse Number PAD_HSNMRCHAR10PAD_HSNMR
FLOORFloor in building AD_FLOORCHAR10TEXT10
IDAPARTMENTINBUILDIdentification of an apartment in a building PAD_POSTACHAR10PAD_HSNMR
DISTANCEINKMDistance in Kilometers ENTKMDEC3DEC3
DISTANCEINKM1Distance in Kilometers ENTKMDEC3DEC3
COMPANYOWNEDAPTCompany Housing WKWNGCHAR1CHAR1
BUSROUTEBus Route BUSRTCHAR3CHAR3

Key field Non-key field



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

As PAR40 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 PAR40 as there is no data to select.

How to access SAP table PAR40

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

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