P05TPRNL_EE_PD SAP (Pension Return: Personal Data - Pers Level) Table details
Dictionary Type: Table
Description: Pension Return: Personal Data - Pers Level
Description: Pension Return: Personal Data - Pers Level
ABAP Code to SELECT data from P05TPRNL_EE_PD
Related tables to P05TPRNL_EE_PD
Access table P05TPRNL_EE_PD
Related tables to P05TPRNL_EE_PD
Access table P05TPRNL_EE_PD
Table field list including key, data, relationships and ABAP select examples
P05TPRNL_EE_PD is a standard SAP Table which is used to store Pension Return: Personal Data - Pers Level data and is available within R/3 SAP systems depending on the version and release level.
The P05TPRNL_EE_PD table consists of various fields, each holding specific information or linking keys about Pension Return: Personal Data - Pers Level data available in SAP. These include APPL (Subapplication), JUPER (Legal Person), WERKS (Personnel Area), REGYR (For-Period Year).. 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: Can be enhanced (character-type or numeric)
SAP P05TPRNL_EE_PD 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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
APPL | Subapplication | P_APPL | CHAR | 4 | T596A | P_APPL | |||
JUPER | Legal Person | JUPER | CHAR | 4 | JUPER | ||||
WERKS | Personnel Area | PERSA | CHAR | 4 | T500P | PERSA | PBR | ||
REGYR | For-Period Year | P05_PRNL_REGYR | NUMC | 4 | GJAHR | GJAHR | |||
REGPE | For-Period | P05_PRNL_REGPE | NUMC | 2 | PABRP | ||||
SEQNO | Sequence number | P05_PRNL_SEQNO | NUMC | 4 | NUMC4 | ||||
REPTP | Reporting Type | P05_PRNL_REPTP | CHAR | 1 | P05_PRNL_REPTP | ||||
PERNR | Personnel Number | P_PERNR | NUMC | 8 | PERNR | ||||
BEGDA_IR | Start Date Income Relationship | P05_PRNL_BEGDA_IR | DATS | 8 | DATS | ||||
ADDRTP | Address Type | P05_PRNL_ADDRTP | CHAR | 1 | P05_PRNL_ADDRTP | ||||
BSNCD | Citizen Service Number [BSN] | P05_BSN | NUMC | 9 | NUM9 | ||||
NACHN | Last Name | NACHN | CHAR | 25 | NACHN | ||||
INITS | Initials | INITS | CHAR | 10 | TEXT10 | ||||
VORSW | Name Prefix | VORSW | CHAR | 15 | Assigned to domain | TITEL | |||
GBDAT | Date of Birth | GBDAT | DATS | 8 | PDATE | GBDAT | |||
NATIO | Nationality | NATSL | CHAR | 3 | Assigned to domain | LAND1 | NAT | ||
GESCH | Gender Key | GESCH | CHAR | 1 | GESCH | ||||
DDATE | Date of Death | P05_PRNL_DDATE | DATS | 8 | DATS | ||||
FAMST | Marital Status Key | FAMST | CHAR | 1 | Assigned to domain | FAMST | |||
FAMDT | Valid From Date of Current Marital Status | FAMDT | DATS | 8 | DATUM | ||||
FANAP | Birthname Partner | P05_PRNL_FANAP | CHAR | 40 | PAD_NACHN | ||||
NPFXP | Name Prefix Partner | P05_PRNL_NPFXP | CHAR | 15 | Assigned to domain | TITEL | |||
INITP | Initials Partner | P05_PRNL_INITP | CHAR | 10 | TEXT10 | ||||
INVEX | Individual exemptions | P05_PRNL_INVEX | CHAR | 1 | P05_PRNL_INVEX | ||||
STRAS | Street and House Number | PAD_STRAS | CHAR | 60 | PAD_STRAS | ||||
HSNMR | House Number | PAD_HSNMR | CHAR | 10 | PAD_HSNMR | ||||
POSTA | Identification of an apartment in a building | PAD_POSTA | CHAR | 10 | PAD_HSNMR | ||||
LOCAT | 2nd Address Line | PAD_LOCAT | CHAR | 40 | PAD_LOCAT | ||||
PSTLZ | Postal Code | PSTLZ_HR | CHAR | 10 | PSTLZ | ||||
ORT01 | City | PAD_ORT01 | CHAR | 40 | PAD_ORT01 | ||||
STATE | STATE (State, Province, County) | REGIO | CHAR | 3 | T005S | REGIO | |||
LAND1 | Country ISO code | INTCA | CHAR | 2 | INTCA | F4_INTCA |
Key field | Non-key field |
How do I retrieve data from SAP table P05TPRNL_EE_PD using ABAP code
The following ABAP code Example will allow you to do a basic selection on P05TPRNL_EE_PD to SELECT all data from the tableDATA: WA_P05TPRNL_EE_PD TYPE P05TPRNL_EE_PD.
SELECT SINGLE *
FROM P05TPRNL_EE_PD
INTO CORRESPONDING FIELDS OF WA_P05TPRNL_EE_PD
WHERE...
How to access SAP table P05TPRNL_EE_PD
Within an ECC or HANA version of SAP you can also view further information about P05TPRNL_EE_PD and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects