SAP ABAP Table P05TPRNL_LP_COLL (Pension Return: Collective Return - Legal 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_LP_COLL	Table Relationship Diagram
Short Description	Pension Return: Collective Return - Legal 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 Legal Person level
3	APPL	☑	P_APPL	P_APPL	CHAR	4	0	Subapplication	T596A
4	JUPER	☑	JUPER	JUPER	CHAR	4	0	Legal Person
5	WERKS	☑	PERSA	PERSA	CHAR	4	0	Personnel Area	T500P
6	REGYR	☑	P05_PRNL_REGYR	GJAHR	NUMC	4	0	For-Period Year
7	REGPE	☑	P05_PRNL_REGPE	PABRP	NUMC	2	0	For-Period
8	SEQNO	☑	P05_PRNL_SEQNO	NUMC4	NUMC	4	0	Sequence number
9	REPTP	☑	P05_PRNL_REPTP	P05_PRNL_REPTP	CHAR	1	0	Reporting Type	*
10	PRDCD	☑	P05_PRNL_PRDCD_LONG	P05_PRNL_PRDCD_LONG	CHAR	20	0	Product Code (long)
11	PRDVA	☑	P05_PRNL_PRDVA	P05_PRNL_PRDVA	CHAR	2	0	Product Variant
12	INDIC	☑	P05_PRNL_INDIC	NUMC4	NUMC	4	0	Pension Return Indicator
13	AMOUNT	☐	MAXBT	PRBETRG	CURR	15	2	HR Payroll: Amount
14	NUMBR	☐	PRANZ	PRANZHL	DEC	15	2	HR payroll: Number
15	TIME_UNIT	☐	PT_ZEINH	RPMSH	CHAR	3	0	Time/Measurement Unit	T538A

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	P05TPRNL_LP_COLL	APPL	T596A	APPL	KEY
2	P05TPRNL_LP_COLL	MANDT	T000	MANDT	KEY	1	CN
3	P05TPRNL_LP_COLL	TIME_UNIT	T538A	ZEINH	KEY	1	CN
4	P05TPRNL_LP_COLL	WERKS	T500P	PERSA	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in