T5N5Q

Calculation Table for Pensions (NL) | #masterdata | Component: Reporting

🔑 Keys (3)
💰 Amounts (16)
∑ Quantities
📅 Dates (2)
☰ Categorical (11)
Other (14)
🔗 Relations (17)

Column Name	Description
MANDT FK	Client
PENSK	Pension Indicator
ENDDA	End Date

Column Name	Description
💲 Currency Key (T500C.WAERS):
OWGMN	Minimum Increment 1
OWGMX	Maximum Increment 1
OWNMN	Minimum Increment 2
OWNMX	Maximum Increment 2
MXGWG	Maximum Pensionable Base Employer
MXGWN	Maximum Pensionable Base Employee
MNGWG	Minimum Pensionable Base Employer
MNGWN	Minimum Pensionable Base Employee
MXPWG	Maximum Employer Contribution
MXPWN	Maximum Employee Contribution
MNPWG	Minimum Employer Contribution
MNPWN	Minimum Employee Contribution
FRCWG	Employer Franchise
FRCWN	Employee Franchise
VPAWG	Fixed Employer Contribution Allowance
VPAWN	Fixed Employee Contribution Allowance

Column Name	Description

Column Name	Description
ENDDA	End Date
BEGDA	Start Date

Column Name	Description
LFTBM	Age Determination Date	Show values
PTBER	Part-time Calculation Method	Show values
RKHER	Routine Indicator for Cumulative Retroactive Accounting	Show values
CUMHB	Method for Cumulative Retroactive Accounting	Show values
AFRPG	Rounding Method for Pensionable Salary	Show values
AFRWG	Rounding Method Employer Contribution	Show values
AFRWN	Rounding Method Employee Contribution	Show values
CLCPS	Determination Method for Pensionable Salary	Show values
ECCPB	Exclude Company Car from Pensionable Wage	Show values
CLCPS_2	Determination Method for Pensionable Salary	Show values
AFRPG_2	Rounding Method for Pensionable Salary	Show values

Column Name	Description	Domain name
PP_WG	Employer Contribution Percentage	P05_PPWG
PP_WN	Employee Contribution Percentage	P05_PPWN
OPWG1	Increment Percentage for Annual Salary	P05_OPWG
OPWG2	Increment Percentage for Annual Salary	P05_OPWG
OPWN1	Increment Percentage for Annual Salary Plus 1st Increment	P05_OPWN
OPWN2	Increment Percentage for Annual Salary Plus 1st Increment	P05_OPWN
AWGWN	Share of Employer in Employee Contribution	P05_DEC7_4
APSJB	Payroll Period Start Annual Accounting	P05_APSJB
MNLFT	Minimum Age	DEC3
STLFT	Age for Pensionable Salary Freeze	DEC3
STPCT	Increase Percentage for Pensionable Salary	P05_STPCT
STPRD	Increase Period	P05_STPRD
NRATO	Factoring	CHAR1
ARATO	Factoring AOW+5	CHAR1

Master Data Relations	Join Conditions
Wage Type for Pensionable Base Special Pay ? ? Client Wage Type for Pensionable Base Special Pay	`T5N5Q.[column in domain "MOLGA"] == T512W.MOLGA` `T5N5Q.[column in domain "ENDDA"] == T512W.ENDDA` `T5N5Q.MANDT == T512W.MANDT` `T5N5Q.LCGBB == T512W.LGART`
Wage Type for Pensionable Base ? ? Client Wage Type for Pensionable Base	`T5N5Q.[column in domain "MOLGA"] == T512W.MOLGA` `T5N5Q.[column in domain "ENDDA"] == T512W.ENDDA` `T5N5Q.MANDT == T512W.MANDT` `T5N5Q.LCGSL == T512W.LGART`
Wage Type for 100% Pensionable Base ? ? Client Wage Type for 100% Pensionable Base	`T5N5Q.[column in domain "MOLGA"] == T512W.MOLGA` `T5N5Q.[column in domain "ENDDA"] == T512W.ENDDA` `T5N5Q.MANDT == T512W.MANDT` `T5N5Q.LCHPG == T512W.LGART`
Wage type annual basis (100%) ? ? Client Wage type annual basis (100%)	`T5N5Q.[column in domain "MOLGA"] == T512W.MOLGA` `T5N5Q.[column in domain "ENDDA"] == T512W.ENDDA` `T5N5Q.MANDT == T512W.MANDT` `T5N5Q.LCJGS == T512W.LGART`
Wage Type for Pensionable Salary Employer ? ? Client Wage Type for Pensionable Salary Employer	`T5N5Q.[column in domain "MOLGA"] == T512W.MOLGA` `T5N5Q.[column in domain "ENDDA"] == T512W.ENDDA` `T5N5Q.MANDT == T512W.MANDT` `T5N5Q.LCPGS_WG == T512W.LGART`
Wage Type for Pensionable Salary Employer ? ? Client Wage Type for Pensionable Salary Employer	`T5N5Q.[column in domain "MOLGA"] == T512W.MOLGA` `T5N5Q.[column in domain "ENDDA"] == T512W.ENDDA` `T5N5Q.MANDT == T512W.MANDT` `T5N5Q.LCPGS_WG_2 == T512W.LGART`
Wage Type for Pensionable Salary Employee ? ? Client Wage Type for Pensionable Salary Employee	`T5N5Q.[column in domain "MOLGA"] == T512W.MOLGA` `T5N5Q.[column in domain "ENDDA"] == T512W.ENDDA` `T5N5Q.MANDT == T512W.MANDT` `T5N5Q.LCPGS_WN == T512W.LGART`
Wage Type for Pensionable Salary Employee ? ? Client Wage Type for Pensionable Salary Employee	`T5N5Q.[column in domain "MOLGA"] == T512W.MOLGA` `T5N5Q.[column in domain "ENDDA"] == T512W.ENDDA` `T5N5Q.MANDT == T512W.MANDT` `T5N5Q.LCPGS_WN_2 == T512W.LGART`
Wage Type for Part-time Percentage ? ? Client Wage Type for Part-time Percentage	`T5N5Q.[column in domain "MOLGA"] == T512W.MOLGA` `T5N5Q.[column in domain "ENDDA"] == T512W.ENDDA` `T5N5Q.MANDT == T512W.MANDT` `T5N5Q.LCPTP == T512W.LGART`
Wage Type for Employer Contribution ? ? Client Wage Type for Employer Contribution	`T5N5Q.[column in domain "MOLGA"] == T512W.MOLGA` `T5N5Q.[column in domain "ENDDA"] == T512W.ENDDA` `T5N5Q.MANDT == T512W.MANDT` `T5N5Q.LCPWG == T512W.LGART`
Wage Type for Employee Contribution ? ? Client Wage Type for Employee Contribution	`T5N5Q.[column in domain "MOLGA"] == T512W.MOLGA` `T5N5Q.[column in domain "ENDDA"] == T512W.ENDDA` `T5N5Q.MANDT == T512W.MANDT` `T5N5Q.LCPWN == T512W.LGART`
Wage Type Employee Contribution Special Pay ? ? Client Wage Type Employee Contribution Special Pay	`T5N5Q.[column in domain "MOLGA"] == T512W.MOLGA` `T5N5Q.[column in domain "ENDDA"] == T512W.ENDDA` `T5N5Q.MANDT == T512W.MANDT` `T5N5Q.LCPWN_BB == T512W.LGART`
Wage Type for Variable Part of Pensionable Base ? ? Client Wage Type for Variable Part of Pensionable Base	`T5N5Q.[column in domain "MOLGA"] == T512W.MOLGA` `T5N5Q.[column in domain "ENDDA"] == T512W.ENDDA` `T5N5Q.MANDT == T512W.MANDT` `T5N5Q.LCVRG == T512W.LGART`
Wage Type for Fixed Part of Pensionable Base ? ? Client Wage Type for Fixed Part of Pensionable Base	`T5N5Q.[column in domain "MOLGA"] == T512W.MOLGA` `T5N5Q.[column in domain "ENDDA"] == T512W.ENDDA` `T5N5Q.MANDT == T512W.MANDT` `T5N5Q.LCVSG == T512W.LGART`
Client	`T5N5Q.MANDT == T000.MANDT`
Calculation Method	`T5N5Q.MANDT == T5N5M.MANDT` `T5N5Q.RCODE == T5N5M.RCODE`

Other Relations \| to Master Data Relations ↑	Join Conditions
Pension Scheme ? Client Pension Scheme	`T5N5Q.[column in domain "ENDDA"] == T5N5P.ENDDA` `T5N5Q.MANDT == T5N5P.MANDT` `T5N5Q.PENRG == T5N5P.PENRG`