SAP ABAP Table P05TPRNL_EE_PD (Pension Return: Personal Data - Pers Level)

Hierarchy

☛ SAP_HRCNL (Software Component) Sub component SAP_HRCNL of SAP_HR
   ⤷ PY-NL-RP (Application Component) Reporting
     ⤷ P05T (Package) HR Payroll: The Netherlands

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	P05TPRNL_EE_PD	Table Relationship Diagram
Short Description	Pension Return: Personal Data - Pers Level

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	.INCLUDE	☑				0	0	Key for Extractor Tables on employee level
3	.INCLUDE	☑				0	0	Key for Extractor Tables on Legal Person level
4	APPL	☑	P_APPL	P_APPL	CHAR	4	0	Subapplication	T596A
5	JUPER	☑	JUPER	JUPER	CHAR	4	0	Legal Person
6	WERKS	☑	PERSA	PERSA	CHAR	4	0	Personnel Area	T500P
7	REGYR	☑	P05_PRNL_REGYR	GJAHR	NUMC	4	0	For-Period Year
8	REGPE	☑	P05_PRNL_REGPE	PABRP	NUMC	2	0	For-Period
9	SEQNO	☑	P05_PRNL_SEQNO	NUMC4	NUMC	4	0	Sequence number
10	REPTP	☑	P05_PRNL_REPTP	P05_PRNL_REPTP	CHAR	1	0	Reporting Type
11	PERNR	☑	P_PERNR	PERNR	NUMC	8	0	Personnel Number
12	BEGDA_IR	☑	P05_PRNL_BEGDA_IR	DATS	DATS	8	0	Start Date Income Relationship
13	ADDRTP	☐	P05_PRNL_ADDRTP	P05_PRNL_ADDRTP	CHAR	1	0	Address Type
14	BSNCD	☐	P05_BSN	NUM9	NUMC	9	0	Citizen Service Number [BSN]
15	NACHN	☐	NACHN	NACHN	CHAR	25	0	Last Name
16	INITS	☐	INITS	TEXT10	CHAR	10	0	Initials
17	VORSW	☐	VORSW	TITEL	CHAR	15	0	Name Prefix	*
18	GBDAT	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
19	NATIO	☐	NATSL	LAND1	CHAR	3	0	Nationality	*
20	GESCH	☐	GESCH	GESCH	CHAR	1	0	Gender Key
21	DDATE	☐	P05_PRNL_DDATE	DATS	DATS	8	0	Date of Death
22	FAMST	☐	FAMST	FAMST	CHAR	1	0	Marital Status Key	*
23	FAMDT	☐	FAMDT	DATUM	DATS	8	0	Valid From Date of Current Marital Status
24	FANAP	☐	P05_PRNL_FANAP	PAD_NACHN	CHAR	40	0	Birthname Partner
25	NPFXP	☐	P05_PRNL_NPFXP	TITEL	CHAR	15	0	Name Prefix Partner	*
26	INITP	☐	P05_PRNL_INITP	TEXT10	CHAR	10	0	Initials Partner
27	INVEX	☐	P05_PRNL_INVEX	P05_PRNL_INVEX	CHAR	1	0	Individual exemptions
28	STRAS	☐	PAD_STRAS	PAD_STRAS	CHAR	60	0	Street and House Number
29	HSNMR	☐	PAD_HSNMR	PAD_HSNMR	CHAR	10	0	House Number
30	POSTA	☐	PAD_POSTA	PAD_HSNMR	CHAR	10	0	Identification of an apartment in a building
31	LOCAT	☐	PAD_LOCAT	PAD_LOCAT	CHAR	40	0	2nd address line
32	PSTLZ	☐	PSTLZ_HR	PSTLZ	CHAR	10	0	Postal Code
33	ORT01	☐	PAD_ORT01	PAD_ORT01	CHAR	40	0	City
34	STATE	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
35	LAND1	☐	INTCA	INTCA	CHAR	2	0	Country ISO code

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	P05TPRNL_EE_PD	APPL	T596A	APPL	KEY
2	P05TPRNL_EE_PD	MANDT	T000	MANDT	KEY	1	CN
3	P05TPRNL_EE_PD	STATE	T005S	BLAND	KEY	1	CN
4	P05TPRNL_EE_PD	WERKS	T500P	PERSA	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in