SAP ABAP Table P05TPRNL_EE_ADMS (Pension Return: Admin of Status Income Relationship - 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_ADMS	Table Relationship Diagram
Short Description	Pension Return: Admin of Status Income Relationship - 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	SEQNOSTATUS	☑	P05_PRNL_SEQNO	NUMC4	NUMC	4	0	Sequence number
14	STATUS	☐	P05_PRNL_STATUS	P05_PRNL_STATUS	NUMC	2	0	Pension Return: Return Status
15	REPORT	☐	PROGRAMM	PROGRAMM	CHAR	40	0	ABAP Program Name	*
16	UNAME	☐	UNAME	UNAME	CHAR	12	0	User Name
17	GDATE	☐	P05T_GDATE	DATS	DATS	8	0	Creation/Change Date
18	GTIME	☐	P05T_GTIME	UZEIT	TIMS	6	0	Creation/Change Hour
19	INPERJ	☐	P05_PRNL_INPERJ	GJAHR	NUMC	4	0	In-Period Year
20	INPERP	☐	P05_PRNL_INPERP	PABRP	NUMC	2	0	In-Period

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	P05TPRNL_EE_ADMS	APPL	T596A	APPL	KEY
2	P05TPRNL_EE_ADMS	MANDT	T000	MANDT	KEY	1	CN
3	P05TPRNL_EE_ADMS	WERKS	T500P	PERSA	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in