SAP ABAP Table PC2NL_PRAP (Pension Return)

Hierarchy

☛ SAP_HRCNL (Software Component) Sub component SAP_HRCNL of SAP_HR
   ⤷ PY-NL-RP (Application Component) Reporting
     ⤷ PC05 (Package) HR Payroll: Netherlands

Basic Data

Table Category	INTTAB	Structure
Structure	PC2NL_PRAP	Table Relationship Diagram
Short Description	Pension Return

Delivery and Maintenance

Pool/cluster
Delivery Class
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	PRNSP	☐	PRSPL	RAW1	RAW	1	0	Tax split
2	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
3	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
4	DDATE	☐	P05_PRNL_DDATE	DATS	DATS	8	0	Date of Death
5	FAMST	☐	FAMST	FAMST	CHAR	1	0	Marital Status Key	T502T
6	FAMDT	☐	FAMDT	DATUM	DATS	8	0	Valid From Date of Current Marital Status
7	FANAP	☐	P05_PRNL_FANAP	PAD_NACHN	CHAR	40	0	Birthname Partner
8	NPFXP	☐	P05_PRNL_NPFXP	TITEL	CHAR	15	0	Name Prefix Partner	*
9	INITP	☐	P05_PRNL_INITP	TEXT10	CHAR	10	0	Initials Partner
10	INVEX	☐	P05_PRNL_INVEX	P05_PRNL_INVEX	CHAR	1	0	Individual exemptions
11	NUMIR	☐	P05_PRNL_NUMIR	P05_PRNL_NUMIR	NUMC	4	0	Number Income Relationship
12	IRBEG	☐	P05_PRNL_IRBEG	DATS	DATS	8	0	Start Date Income Relationship
13	IREND	☐	P05_PRNL_IREND	DATS	DATS	8	0	End Date Income Relationship
14	IRRES	☐	P05_PRNL_IRRES	P05_PRNL_IRRES	CHAR	1	0	Reason for ending Income Relationship
15	IRTYP	☐	P05_PRNL_IRTYP	P05_PRNL_IRTYP	CHAR	2	0	Type of Income Relationship	T77PRNL_ICR
16	IPBEG	☐	P05_PRNL_BEGDA_IP	DATS	DATS	8	0	Start Date Income Period
17	IPEND	☐	P05_PRNL_ENDDA_IP	DATS	DATS	8	0	End Date Income Period
18	IPPAR	☐	P05_PRNL_IPPAR	P05_PRNL_IPPAR	CHAR	3	0	Particularization of Income Period	T77PRNL_ICP
19	INKKD	☐	INKKD	P05_INKKD	NUMC	2	0	Income Indicator	T5N2F
20	CAOCL	☐	P05_CAOCL	P05_CAOCD	NUMC	4	0	Collective Agreement Indicator on Wage Return	T5N73
21	OCCOD	☐	P05_PRNL_OCCOD	P05_PRNL_OCCOD	NUMC	4	0	Code Occupation	T77PRNL_OCC
22	CNTCD	☐	P05_PRNL_CNTCD	P05_PRNL_CNTCD	CHAR	3	0	Counting Code
23	PRDCD	☐	P05_PRNL_PRDCD	P05_PRNL_PRDCD	CHAR	6	0	Product Code
24	PRDVA	☐	P05_PRNL_PRDVA	P05_PRNL_PRDVA	CHAR	2	0	Product Variant
25	PRBEG	☐	P05_PRNL_PRBEG	DATS	DATS	8	0	Start date Pension/Insurance Relationship
26	VAEND	☐	P05_PRNL_VAEND	DATS	DATS	8	0	Enddate Product Variant
27	PPBEG	☐	P05_PRNL_PPBEG	DATS	DATS	8	0	Start date Pension/Insurance Relationship Period
28	BWGTP	☐	P05_PRNL_BWTTP	P05_PRNL_BWTTP	CHAR	1	0	Type of Basis Wage
29	AUNWK	☐	P05_PRNL_PAY_SCALE_HOURS	STDAZ	DEC	5	2	Weekly Pay Scale Working Time in Hours
30	PRDCL	☐	P05_PRNL_PRDCD_LONG	P05_PRNL_PRDCD_LONG	CHAR	20	0	Product Code (long)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PC2NL_PRAP	CAOCL	T5N73	CAOCL	KEY	1	CN
2	PC2NL_PRAP	FAMST	T502T	FAMST	KEY	1	CN
3	PC2NL_PRAP	INKKD	T5N2F	INKKD	KEY	1	CN
4	PC2NL_PRAP	IPPAR	T77PRNL_ICP	IPPAR	KEY	1	CN
5	PC2NL_PRAP	IRTYP	T77PRNL_ICR	IRTYP	KEY	1	CN
6	PC2NL_PRAP	OCCOD	T77PRNL_OCC	OCCOD	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in