P05TPRNL_EE_PD - Pension Return: Personal Data - Pers Level

Pension Return: Personal Data - Pers Level information is stored in SAP table P05TPRNL_EE_PD.
It is part of development package P05T in software component PY-NL-RP. This development package consists of objects that can be grouped under "HR Payroll: The Netherlands".

Fields for table P05TPRNL_EE_PD

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
.INCLUDE	PRNL_EE_KEY	X		P05_S_PRNL_EE_KEY	0
.INCLUDE	PRNL_LP_KEY	X		P05_S_PRNL_LP_KEY	0
APPL	Subapplication	X	P_APPL	CHAR	8	T596A
JUPER	Legal Person	X	JUPER	CHAR	8
WERKS	Personnel Area	X	PERSA	CHAR	8	T500P
REGYR	For-Period Year	X	P05_PRNL_REGYR	NUMC	8
REGPE	For-Period	X	P05_PRNL_REGPE	NUMC	4
SEQNO	Sequence number	X	P05_PRNL_SEQNO	NUMC	8
REPTP	Reporting Type	X	P05_PRNL_REPTP	CHAR	2
PERNR	Personnel Number	X	P_PERNR	NUMC	16
BEGDA_IR	Start Date Income Relationship	X	P05_PRNL_BEGDA_IR	DATS	16
ADDRTP	Address Type		P05_PRNL_ADDRTP	CHAR	2
BSNCD	Citizen Service Number [BSN]		P05_BSN	NUMC	18
NACHN	Last Name		NACHN	CHAR	50
INITS	Initials		INITS	CHAR	20
VORSW	Name Prefix		VORSW	CHAR	30
GBDAT	Date of Birth		GBDAT	DATS	16
NATIO	Nationality		NATSL	CHAR	6
GESCH	Gender		P05_PRNL_GENDER	CHAR	2
DDATE	Date of Death		P05_PRNL_DDATE	DATS	16
FAMST	Marital Status Key		FAMST	CHAR	2
FAMDT	Valid From Date of Current Marital Status		FAMDT	DATS	16
FANAP	Birthname Partner		P05_PRNL_FANAP	CHAR	80
NPFXP	Name Prefix Partner		P05_PRNL_NPFXP	CHAR	30
INITP	Initials Partner		P05_PRNL_INITP	CHAR	20
INVEX	Individual exemptions		P05_PRNL_INVEX	CHAR	2
STRAS	Street and House Number		PAD_STRAS	CHAR	120
HSNMR	House Number		PAD_HSNMR	CHAR	20
POSTA	Identification of an apartment in a building		PAD_POSTA	CHAR	20
LOCAT	2nd address line		PAD_LOCAT	CHAR	80
PSTLZ	Postal Code		PSTLZ_HR	CHAR	20
ORT01	City		PAD_ORT01	CHAR	80
STATE	Region (State, Province, County)		REGIO	CHAR	6	T005S
LAND1	ISO Code of the Country/Region		INTCA	CHAR	4
IBAN	IBAN (International Bank Account Number)		IBAN	CHAR	68
EMAIL	Communication: Long Identification/Number		COMM_ID_LONG	CHAR	482
GESCP	Gender Partner Code		P05_PRNL_GESCP	CHAR	2
NATUP	Nationality		P05_NANEN	CHAR	8
PAD_NACHN	Last Name		PAD_NACHN	CHAR	80
SPRSL	Communication Language		P05_SPRAS	LANG	2	T002