SAP ABAP Table P05TPRNL_EE_RG (Pension Return: Income Relationship - Sector Risk Group)

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_RG	Table Relationship Diagram
Short Description	Pension Return: Income Relationship - Sector Risk Group

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	*
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	SECT	☑	P05T_SECT	NUMC3	NUMC	3	0	Wage Return: Sector (Sector Risk Group)
14	RISGRP	☑	P05T_RISGRP	NUMC2	NUMC	2	0	Wage Return: Risk Contribution Group (Sector Risk Group)
15	BEGDA_RG	☑	P05_PRNL_BEGDA_RG	DATUM	DATS	8	0	Sector Risk Group Start Date
16	ENDDA_RG	☐	P05_PRNL_ENDDA_RG	DATUM	DATS	8	0	Sector Risk Group End Date

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	P05TPRNL_EE_RG	APPL	T596A	APPL	KEY
2	P05TPRNL_EE_RG	WERKS	T500P	PERSA	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in