PA0002 is a standard Personnel Administration Transparent Table in SAP Personnel Mgmt application, which stores HR Master Record: Infotype 0002 (Personal Data) data. Below you can view the Table Structure, columns(fields), SAP Wiki pages, discussion threads, related TCodes, FMs, ABAP Reports, BW Datasources, and Authorization Objects for PA0002. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

PA0002 — Meta Data

Description: HR Master Record: Infotype 0002 (Personal Data)
Main Category: Personnel Mgmt
Sub Category: Personnel Administration
Table type: Transparent Table (TRANSP)

PA0002 — Table Structure, Fields(Columns) and Definitions

    Position Column Name Description Primary Key Data Type Length Check Table
    1 MANDT Client X CLNT 3 T000
    2 .INCLUDE X 0
    3 PERNR Personnel No. X NUMC 8 PA0003
    4 SUBTY Subtype X CHAR 4
    5 OBJPS Object Identification X CHAR 2
    6 SPRPS Lock Indicator for HR Master Data Record X CHAR 1
    7 ENDDA End Date X DATS 8
    8 BEGDA Start Date X DATS 8
    9 SEQNR Sequence Number X NUMC 3
    10 .INCLUDE 0
    11 AEDTM Date of Last Change DATS 8
    12 UNAME User Name CHAR 12
    13 HISTO Historical Record Flag CHAR 1
    14 ITXEX Text Exists for Infotype CHAR 1
    15 REFEX Reference Fields Exist (Primary/Secondary Costs) CHAR 1
    16 ORDEX Confirmation Fields Exist CHAR 1
    17 ITBLD Infotype Screen Control CHAR 2
    18 PREAS Reason for Changing Master Data CHAR 2 T530E
    19 FLAG1 Reserved Field/Unused Field CHAR 1
    20 FLAG2 Reserved Field/Unused Field CHAR 1
    21 FLAG3 Reserved Field/Unused Field CHAR 1
    22 FLAG4 Reserved Field/Unused Field CHAR 1
    23 RESE1 Reserved Field/Unused Field of Length 2 CHAR 2
    24 RESE2 Reserved Field/Unused Field of Length 2 CHAR 2
    25 GRPVL Grouping Value for Personnel Assignments CHAR 4
    26 .INCLUDE 0
    27 INITS Initials CHAR 10
    28 NACHN Last Name CHAR 40
    29 NAME2 Name 2 CHAR 40
    30 NACH2 Second Name CHAR 40
    31 VORNA First Name CHAR 40
    32 CNAME Company Name CHAR 80
    33 TITEL Title CHAR 15 T535N
    34 TITL2 Second Title CHAR 15 T535N
    35 NAMZU Other Title CHAR 15 T535N
    36 VORSW Name Prefix (Key) CHAR 15 T535N
    37 VORS2 Second Name Prefix CHAR 15 T535N
    38 RUFNM Nickname CHAR 40
    39 MIDNM Middle Name CHAR 40
    40 KNZNM Name Format Indicator for Employee in a List NUMC 2
    41 ANRED Form of address CHAR 1 T522G
    42 GESCH Gender CHAR 1
    43 GBDAT Birth date DATS 8
    44 GBLND Country of Birth CHAR 3 T005
    45 GBDEP State CHAR 3 T005S
    46 GBORT Location of Affected Property CHAR 40
    47 NATIO Nationality CHAR 3 T005
    48 NATI2 Recruitered's Nationality CHAR 3 T005
    49 NATI3 National ID Part3 CHAR 3 T005
    50 SPRSL Language LANG 1 T002
    51 KONFE Religious Denomination Key CHAR 2 *
    52 FAMST Marital Status Key CHAR 1 *
    53 FAMDT Valid From Date of Current Marital Status DATS 8
    54 ANZKD Number of Children DEC 3
    55 NACON Name Connection CHAR 1
    56 PERMO Period Parameters CHAR 2
    57 PERID Personnel ID Number CHAR 20
    58 GBPAS Date of Birth According to Passport DATS 8
    59 FNAMK First name (Katakana) CHAR 40
    60 LNAMK Last name (Katakana) CHAR 40
    61 FNAMR First Name (Romaji) CHAR 40
    62 LNAMR Last Name (Romaji) CHAR 40
    63 NABIK Name of Birth (Katakana) CHAR 40
    64 NABIR Name of Birth (Romaji) CHAR 40
    65 NICKK Koseki (Katakana) CHAR 40
    66 NICKR Koseki (Romaji) CHAR 40
    67 GBJHR Year of Birth NUMC 4
    68 GBMON Hirji Birth Month NUMC 2
    69 GBTAG Birth Date (to Month/Year) NUMC 2
    70 NCHMC Last Name (Field for Search Help) CHAR 25
    71 VNAMC First Name (Field for Search Help) CHAR 25
    72 NAMZ2 Name Affix for Name at Birth CHAR 15 T535N
    73 .INCLUDE 0

SAP Help, Wiki Resources, and Forum Discussions on PA0002

Click the above link for the full list of resources and help pages, only the first few are posted below

Related Tables

TABLE Description Functional Area
PA0001 HR Master Record: Infotype 0001 (Org. Assignment) Personnel Mgmt - Personnel Administration
PA0000 HR Master Record: Infotype 0000 (Actions) Personnel Mgmt - Personnel Administration
P0002 HR Master Record: Infotype 0002 (Personal Data) PA - Personnel Administration
PA0008 HR Master Record: Infotype 0008 (Basic Pay) Personnel Mgmt - Personnel Administration
P0001 HR Master Record: Infotype 0001 (Org. Assignment) PA - Personnel Administration
PA0105 HR Master Record: Infotype 0105 (Communications) Personnel Mgmt - Personnel Administration
HRP1001 Infotype 1001 DB Table Basis - Organizational Management

Transaction Codes for SAP Table PA0002

TCODE Description Functional Area
PA30 Maintain HR Master Data Personnel Mgmt - Personnel Administration
SLIS FI-SL Spec.Purpose Ledg. Info.System FI - Information System
SE11 ABAP Dictionary Maintenance Basis - Dictionary Maintenance
SPRO Customizing - Edit Project Basis - Customizing Project Management (IMG)
SE16 Data Browser Basis - Workbench Utilities
SE38 ABAP Editor Basis - ABAP Editor
SE37 ABAP Function Modules Basis - Function Builder
PA40 Personnel Actions Personnel Mgmt - Personnel Administration

FMs for SAP Table PA0002

FM Description Functional Area
REUSE_ALV_GRID_DISPLAY Output of a simple list (single-line) Basis - SAP List Viewer
GUI_UPLOAD Upload for Data Provider Basis - Graphical User Interface
GUI_DOWNLOAD Download an Internal Table to the PC Basis - Graphical User Interface
HR_READ_INFOTYPE Read Employee/Applicant Data From Infotypes Personnel Mgmt - Personnel Administration
REUSE_ALV_COMMENTARY_WRITE List body comment block output BC - SAP List Viewer
F4_FILENAME F4 for filename / Filemanager support to locate file in a directory PM - Plant Maintenance
WS_DOWNLOAD OBSOLETE: File Transfer from Internal Table to Presentation Server File Basis - Graphic
REUSE_ALV_EVENTS_GET Returns table of possible events for a list type BC - SAP List Viewer

ABAP Reports for SAP Table PA0002

ABAP REPORT Description Functional Area
SPRSL TEXT 630 - Workbench Tools: Editors
MP000200 Module Pool: Infotype 0002 Personal Data Personnel Mgmt - Personnel Administration
RPPPXD00 R/3 Data Definition for PCL1 and PCL2 Buffer Personnel Mgmt - Personnel Administration
RPPPXD10 Data Definition for PCL1, PCL2 Buffer Handler Personnel Mgmt - Personnel Administration
RPPPXM00 R/3 Module: Handling of PCL1(2) Buffer Personnel Mgmt - Personnel Administration
RPC2RX09 Data Definition for Cluster RD in PCL2 (Payroll Results for Germany) Payroll - Payroll: General Parts
RPC2CD09 Data Definition - CD Cluster Payroll - Payroll: General Parts
RSCONN01 SAPconnect: Start Send Process Basis - Communication Services: Mail, Fax, SMS, Telephony

Authorization Objects for SAP Table PA0002

AUTHORIZATION OBJECT Description Functional Area
P_PERNR HR: Master Data - Personnel Number Check
V_VBAK_VKO Sales Document: Authorization for Sales Areas
P_ORGIN HR: Master Data
S_CARRID Authorization Object for Airlines
K_KEKO CO-PC: Product Costing
S_TABU_DIS Table Maintenance (via standard tools such as SM30)