SAP ABAP Table P05TPRNL_EE_IRP (Pension Return: Income Relationship # Income Period - Pers L)

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_IRP	Table Relationship Diagram
Short Description	Pension Return: Income Relationship # Income Period - Pers L

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	BEGDA_IP	☑	P05_PRNL_BEGDA_IP	DATS	DATS	8	0	Start Date Income Period
14	IPPAR	☐	P05_PRNL_IPPAR	P05_PRNL_IPPAR	CHAR	3	0	Particularization of Income Period	*
15	INKKD	☐	INKKD	P05_INKKD	NUMC	2	0	Income Indicator	*
16	CAOCL	☐	P05_CAOCL	P05_CAOCD	NUMC	4	0	Collective Agreement Indicator on Wage Return	T5N73
17	OCCOD	☐	P05_PRNL_OCCOD	P05_PRNL_OCCOD	NUMC	4	0	Code Occupation	T77PRNL_OCC
18	PTFAC	☐	P05_PRNL_PTFAC	P05_PRNL_PTFAC	DEC	5	4	Parttime Factor
19	CNTCD	☐	P05_PRNL_CNTCD	P05_PRNL_CNTCD	CHAR	3	0	Counting Code
20	CDAARD	☐	P05T_CDAARD	P05_CAARD	CHAR	2	0	Wage Return: Type of Work Relationship Code	*
21	CDINVLVPL	☐	P05_CIVPL	P05_CIVPL	CHAR	3	0	Insurance Obligation Influence Code	*
22	CDBEPTD	☐	P05T_CDBEPTD	P05T_CDBEPTD	CHAR	1	0	Wage Return: Open-Ended/Fixed-Term Contract Code
23	CDINCINKVERM	☐	P05T_CDINCINKVERM	P05T_CDINCINKVERM	CHAR	1	0	Wage Return: Incidental Income Reduction Code
24	AANTUNORMWK	☐	P05_PRNL_PAY_SCALE_HOURS	STDAZ	DEC	5	2	Weekly Pay Scale Working Time in Hours

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	P05TPRNL_EE_IRP	APPL	T596A	APPL	KEY
2	P05TPRNL_EE_IRP	CAOCL	T5N73	CAOCL	KEY	1	CN
3	P05TPRNL_EE_IRP	MANDT	T000	MANDT	KEY	1	CN
4	P05TPRNL_EE_IRP	OCCOD	T77PRNL_OCC	OCCOD	KEY	1	CN
5	P05TPRNL_EE_IRP	WERKS	T500P	PERSA	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in