SAP ABAP Table T5N5Q (Calculation Table for Pensions (NL))

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	TRANSP	Transparent table
Transparent table	T5N5Q	Table Relationship Diagram
Short Description	Calculation Table for Pensions (NL)

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

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	PENSK	☑	P05_PENSK	PENSK	CHAR	3	0	Pension Indicator
3	ENDDA	☑	ENDDA	DATUM	DATS	8	0	End Date
4	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
5	PENRG	☐	P05_PENRG	P05_PENRG	CHAR	3	0	Pension Scheme	T5N5P
6	LCGSL	☐	P05_LCGSL	LGART	CHAR	4	0	Wage Type for Pensionable Salary	T512W
7	LCHPG	☐	P05_LCHPG	LGART	CHAR	4	0	Wage Type for 100% Pensionable Salary	T512W
8	LCVRG	☐	P05_LCVRG	LGART	CHAR	4	0	Wage Type for Variable Part of Pensionable Salary	T512W
9	LCVSG	☐	P05_LCVSG	LGART	CHAR	4	0	Wage Type for Fixed Part of Pensionable Salary	T512W
10	LCGBB	☐	P05_LCGBB	LGART	CHAR	4	0	Wage Type for Pensionable Salary SP	T512W
11	LCPGS_WG	☐	P05_LCPGS_WG	LGART	CHAR	4	0	Wage Type for Pensionable Salary ER	T512W
12	LCPGS_WN	☐	P05_LCPGS_WN	LGART	CHAR	4	0	Wage Type for Pensionable Salary EE	T512W
13	LCPWG	☐	P05_LCPWG	LGART	CHAR	4	0	Wage Type for ER Contribution	T512W
14	LCPWN	☐	P05_LCPWN	LGART	CHAR	4	0	Wage Type for EE Contribution	T512W
15	LCPWN_BB	☐	P05_LCPWN_BB	LGART	CHAR	4	0	Wage Type EE Contribution SP	T512W
16	LCPTP	☐	P05_LCPTP	LGART	CHAR	4	0	Wage Type for Part-time Percentage	T512W
17	PP_WG	☐	P05_PPWG	P05_PPWG	DEC	7	4	ER Contribution Percentage
18	PP_WN	☐	P05_PPWN	P05_PPWN	DEC	7	4	EE Contribution Percentage
19	OPWG1	☐	P05_OPWG	P05_OPWG	DEC	7	4	Increment Percentage for Annual Salary
20	OPWG2	☐	P05_OPWG	P05_OPWG	DEC	7	4	Increment Percentage for Annual Salary
21	OPWN1	☐	P05_OPWN	P05_OPWN	DEC	7	4	Increment Percentage for Annual Salary Plus 1st Increment
22	OPWN2	☐	P05_OPWN	P05_OPWN	DEC	7	4	Increment Percentage for Annual Salary Plus 1st Increment
23	OWGMN	☐	P05_OPWGMN	P05_OPWGMN	CURR	9	2	Minimum Increment 1
24	OWGMX	☐	P05_OPWGMX	P05_OPWGMX	CURR	9	2	Maximum Increment 1
25	OWNMN	☐	P05_OPWNMN	P05_OPWNMN	CURR	9	2	Minimum Increment 2
26	OWNMX	☐	P05_OPWNMX	P05_OPWNMX	CURR	9	2	Maximum Increment 2
27	MXGWG	☐	P05_MXGWG	P05_MXGWG	CURR	9	2	Maximum Pensionable Salary ER
28	MXGWN	☐	P05_MXGWN	P05_MXGWN	CURR	9	2	Maximum Pensionable Salary EE
29	MNGWG	☐	P05_MNGWG	P05_MNGWG	CURR	9	2	Minimum Pensionable Salary ER
30	MNGWN	☐	P05_MNGWN	P05_MNGWN	CURR	9	2	Minimum Pensionable Salary EE
31	MXPWG	☐	P05_MXPWG	P05_MXPWG	CURR	9	2	Maximum ER Contribution
32	MXPWN	☐	P05_MXPWN	P05_MXPWN	CURR	9	2	Maximum EE Contribution
33	MNPWG	☐	P05_MNPWG	P05_MNPWG	CURR	9	2	Minimum ER Contribution
34	MNPWN	☐	P05_MNPWN	P05_MNPWN	CURR	9	2	Minimum EE Contribution
35	FRCWG	☐	P05_FRCWG	P05_FRCWG	CURR	9	2	Employer 'Franchise' (Port.of Sal.Disreg.in Calc.Pens.Contr)
36	FRCWN	☐	P05_FRCWN	P05_FRCWN	CURR	9	2	Employee 'Franchise' (Port.of Sal.Disreg.in Calc.Pens.Contr)
37	VPAWG	☐	P05_VPAWG	P05_VPAWG	CURR	9	2	Fixed ER Contribution Allowance
38	VPAWN	☐	P05_VPAWN	P05_VPAWN	CURR	9	2	Fixed EE Contribution Allowance
39	AWGWN	☐	P05_AWGWN	P05_DEC7_4	DEC	7	4	Employer's Share in EE Contribution
40	APSJB	☐	P05_APSJB	P05_APSJB	NUMC	2	0	Payroll Period Start Annual Accounting
41	MNLFT	☐	LEEF2	DEC3	DEC	3	0	Minimum Age
42	LFTBM	☐	P05_LFTBM	P05_LFTBM	CHAR	1	0	Age Determination Date
43	STLFT	☐	STLFT	DEC3	DEC	3	0	Age for Pensionable Salary Freeze
44	STPCT	☐	P05_STPCT	P05_STPCT	DEC	7	4	Increase Percentage for Pensionable Salary
45	STPRD	☐	P05_STPRD	P05_STPRD	NUMC	2	0	Increase Period
46	PTBER	☐	P05_PTBER	P05_PTBER	CHAR	1	0	Part-time Calculation Method
47	RKHER	☐	P05_RKHER	P05_RKHER	CHAR	1	0	Routine Indicator for Cumulative Retroactive Accounting
48	RCODE	☐	P05_RCODE	P05_RCODE	CHAR	3	0	Routine Indicator	T5N5M
49	CUMHB	☐	P05_CUMHB	P05_CUMHB	CHAR	1	0	Cumulative Retroactive Accounting
50	NRATO	☐	P05_NRATO	CHAR1	CHAR	1	0	Factoring
51	AFRPG	☐	P05_AFRPG	P05_AFRND	CHAR	1	0	Rounding Method for Pensionable Salary
52	AFRWG	☐	P05_AFRWG	P05_AFRND	CHAR	1	0	Rounding Method ER Contribution
53	AFRWN	☐	P05_AFRWN	P05_AFRND	CHAR	1	0	Rounding Method EE Contribution
54	CLCPS	☐	P05_CLCPS	P05_CLCPS	CHAR	1	0	Wage Type Code for Pensionable Salary
55	LCJGS	☐	P05_LCJGS	LGART	CHAR	4	0	Wage type annual basis (100%)	T512W
56	ECCPB	☐	P05_EXCLUDE_COMP_CAR	XFELD	CHAR	1	0	Exclude Company Car from Pensionable Wage

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	T5N5Q	LCGBB	T512W	LGART
2	T5N5Q	LCGSL	T512W	LGART
3	T5N5Q	LCHPG	T512W	LGART
4	T5N5Q	LCJGS	T512W	LGART
5	T5N5Q	LCPGS_WG	T512W	LGART
6	T5N5Q	LCPGS_WN	T512W	LGART
7	T5N5Q	LCPTP	T512W	LGART
8	T5N5Q	LCPWG	T512W	LGART
9	T5N5Q	LCPWN	T512W	LGART
10	T5N5Q	LCPWN_BB	T512W	LGART
11	T5N5Q	LCVRG	T512W	LGART
12	T5N5Q	LCVSG	T512W	LGART
13	T5N5Q	MANDT	T000	MANDT	KEY	1	CN
14	T5N5Q	PENRG	T5N5P	PENRG
15	T5N5Q	RCODE	T5N5M	RCODE	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	46C