PA0164 SAP () Table details

Dictionary Type: Table
Description:




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




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

PA0164 is a standard SAP Table which is used to store data and is available within R/3 SAP systems depending on the version and release level.

The PA0164 table consists of various fields, each holding specific information or linking keys about data available in SAP. These include PERNR (Personnel number), SUBTY (Subtype), OBJPS (Object Identification), SPRPS (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. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP PA0164 table 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
MANDTClient MANDTCLNT3T000MANDT
PERNRPersonnel number PERSNONUMC8PA0003PERSNOPER
SUBTYSubtype SUBTYCHAR4SUBTYSUB
OBJPSObject Identification OBJPSCHAR2OBJPSOPS
SPRPSLock Indicator for HR Master Data Record SPRPSCHAR1SPRPS
ENDDAEnd Date ENDDADATS8DATUM
BEGDAStart Date BEGDADATS8DATUM
SEQNRNumber of Infotype Record with Same Key SEQNRNUMC3NUM03
AEDTMChanged On AEDATDATS8DATUM
UNAMEName of Person Who Changed Object AENAMCHAR12USNAM
HISTOHistorical Record Flag HISTOCHAR1CHAR1
ITXEXText Exists for Infotype ITXEXCHAR1XFELD
REFEXReference Fields Exist (Primary/Secondary Costs) PRFEXCHAR1XFELD
ORDEXConfirmation Fields Exist ORDEXCHAR1XFELD
ITBLDInfotype Screen Control ITBLDCHAR2CHAR2
PREASReason for Changing Master Data PREASCHAR2T530EPREAS
FLAG1Reserved Field/Unused Field NUSEDCHAR1NUSED
FLAG2Reserved Field/Unused Field NUSEDCHAR1NUSED
FLAG3Reserved Field/Unused Field NUSEDCHAR1NUSED
FLAG4Reserved Field/Unused Field NUSEDCHAR1NUSED
RESE1Reserved Field/Unused Field of Length 2 NUSED2CHAR2NUSED2
RESE2Reserved Field/Unused Field of Length 2 NUSED2CHAR2NUSED2
GRPVLGrouping Value for Personnel Assignments PCCE_GPVALCHAR4PCCE_GPVAL
SVNUMSI ID P21_SVNUMCHAR10P21_SVNUM
SVKNUSI card number P21_SVKNUCHAR20P21_SVKNU
AGRENEmployer's pension contribution level P21_AGRENCHAR1T5H1DP21_SVBST
AGKRAEmployer's health insurance contribution level P21_AGKRACHAR1T5H1DP21_SVBST
AGARBEmployer contribution P21_AGARBCHAR1T5H1DP21_SVBST
AGAZUEmployer's education contribution level P21_AGAZUCHAR1T5H1DP21_SVBST
ANRENEmployee's pension contribution level P21_ANRENCHAR1T5H1DP21_SVBST
ANKRAEmployee's health insurance contribution P21_ANKRACHAR1T5H1DP21_SVBST
ANARBEmployee contribution P21_ANARBCHAR1T5H1DP21_SVBST
TBKIFSI paying office P21_TBKIFCHAR2T5H1HP21_TBKIF
NJMAXMax. daily contribution P21_NJMAXCURR9(2) WERTV5
EUHOZHealth insurance pay P21_EUHOZCHAR1T5H1DP21_SVBST
ALKMNEmployment category code P21_TBKODNUMC2Assigned to domainP21_TBKOD
MANYPHR-H private pension fund P21_MANYPCHAR1T5H1DP21_SVBST
VALKIHR-H employer's supplement P21_VALKICHAR1T5H1DP21_SVBST
DOLKIHR-H employee's supplement (private pension fund) P21_DOLKIDEC3(2) P21_SZZLK
JCKODHR-H private pension fund title code P21_JCKODCHAR2T5H1MP21_JCKOD
EUPRZPercentual health insurance pay (from 1999) P21_EUPRZCHAR1T5H1DP21_SVBST
MEGJSRemark to NYENYI P21_MEGJSCHAR78P21_MEGJS
SKTIP P21_SKTIPCHAR1P21_SKTIP
MVEHO P21_MVEHOCHAR1T5H1DP21_SVBST
MEKHO P21_MEKHOCHAR1P21_EKHO
TAKER P21_TAKERCHAR1P21_TAKER
NYNLEReason for non-deduction of pension contribution P21_NYNLECHAR1P21_NYNLE
EUNLEReason for non-deduction of health contribution P21_EUNLECHAR1P21_EUNLE
EUN13 P21_EUN13CHAR1P21_EUN13
ANKRB P21_ANKRBCHAR1T5H1DP21_SVBST
PENLEReason for non-deduction of cash health ins. contribution P21_PENLECHAR1P21_PENLE
TENLEReason for non-deduction of health contribution in-kind P21_TENLECHAR1P21_TENLE
NYUTIPension type P21_NYUTINUMC1P21_NYUTI
RATJO P21_RATJOCHAR1P21_TAKER
NYUTOPensioner's personnel number P21_NYUTOCHAR9P21_NYUTO
NORMJRaised amount of contributions 07-12.2009. P21_NORMJCHAR1P21_NORMJ
KKEDVContribution level of early retirement insurance contrib. P21_KKEDVCHAR1T5H1DP21_SVBST
FOGLJ P21_FOGLJCHAR2P21_FOGLJ
KOFOGPublic employee P21_KOFOGCHAR1P21_KOFOG
RMIKF P21_RMIKFCHAR1XFELD
HEKHO P21_HEKHOCHAR1P21_HEKHO
SZKEPJob not requiring professional training P21_SZKEPCHAR1XFELD
KAHIDCareer Bridge program P21_KAHIDCHAR1XFELD
MBERMAllowance for preserving net earned income P21_MBERMCHAR1P21_MBERM
NYUT2Pension type P21_NYUT2NUMC2P21_NYUT2
REHABRehabilitation card allowance P21_REHABCHAR1XFELD
KFKMPPublicly employed: state compensation rate P21_KFKMPNUMC3P21_NUMC3
GYEDSAfter GYED, GYES, GYET P21_GYEDSCHAR1P21_GYEDS
K5525Employee under 25 / above 55 years P21_K5525CHAR1P21_K5525
K25FEE/e under 25 years max. 180 days P21_K25FECHAR1P21_K25FE
SZVALEmployed in free enterprising zone P21_SZVALCHAR1P21_SZVAL
KUTATEmployed as researcher P21_KUTATCHAR1P21_KUTAT

Key field Non-key field



How do I retrieve data from SAP table PA0164 using ABAP code

The following ABAP code Example will allow you to do a basic selection on PA0164 to SELECT all data from the table
DATA: WA_PA0164 TYPE PA0164.

SELECT SINGLE *
FROM PA0164
INTO CORRESPONDING FIELDS OF WA_PA0164
WHERE...

How to access SAP table PA0164

Within an ECC or HANA version of SAP you can also view further information about PA0164 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!