SAP ABAP View V_T5N5Q (View for Cumulation Table T5N5Q)

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

View Type	C	Maintenance View
Maintenance View	V_T5N5Q
Short Description	View for Cumulation Table T5N5Q
Root table	T5N5Q	Calculation Table for Pensions (NL)

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	T5N5Q	T5N5Q
2	T5N5M	T5N5Q	RCODE	E
3	T5N5P	T5N5Q	PENRG	E
4	T5N5R	T5N5Q	PENSK	I
5	T5N5N	T5N5P	PENRG	E
6	T5N5O	T5N5N	PENRG	I

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field

View Fields

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

Maintenance Status

Access

☐   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☑   read, change, delete and insert

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

History

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