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

Dictionary Type: Table
Description: Calculation Table for Pensions (NL)




ABAP Code to SELECT data from T5N5Q
Related tables to T5N5Q
Access table T5N5Q




Table field list including key, data, relationships and ABAP select examples

T5N5Q is a standard SAP Table which is used to store Calculation Table for Pensions (NL) data and is available within R/3 SAP systems depending on the version and release level.

The T5N5Q table consists of various fields, each holding specific information or linking keys about Calculation Table for Pensions (NL) data available in SAP. These include PENSK (Pension Indicator), ENDDA (End Date), BEGDA (Start Date), PENRG (Pension Scheme).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

Text table = T5N5R


SAP T5N5Q table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
PENSKPension Indicator P05_PENSKCHAR3PENSK
ENDDAEnd Date ENDDADATS8DATUM
BEGDAStart Date BEGDADATS8DATUM
PENRGPension Scheme P05_PENRGCHAR3T5N5PP05_PENRGP05_PENRG
LCGSLWage Type for Pensionable Salary P05_LCGSLCHAR4T512WLGART
LCHPGWage Type for 100% Pensionable Salary P05_LCHPGCHAR4T512WLGART
LCVRGWage Type for Variable Part of Pensionable Salary P05_LCVRGCHAR4T512WLGART
LCVSGWage Type for Fixed Part of Pensionable Salary P05_LCVSGCHAR4T512WLGART
LCGBBWage Type for Pensionable Salary SP P05_LCGBBCHAR4T512WLGART
LCPGS_WGWage Type for Pensionable Salary ER P05_LCPGS_WGCHAR4T512WLGART
LCPGS_WNWage Type for Pensionable Salary EE P05_LCPGS_WNCHAR4T512WLGART
LCPWGWage Type for ER Contribution P05_LCPWGCHAR4T512WLGART
LCPWNWage Type for EE Contribution P05_LCPWNCHAR4T512WLGART
LCPWN_BBWage Type EE Contribution SP P05_LCPWN_BBCHAR4T512WLGART
LCPTPWage Type for Part-time Percentage P05_LCPTPCHAR4T512WLGART
PP_WGER Contribution Percentage P05_PPWGDEC7(4) P05_PPWG
PP_WNEE Contribution Percentage P05_PPWNDEC7(4) P05_PPWN
OPWG1Increment Percentage for Annual Salary P05_OPWGDEC7(4) P05_OPWG
OPWG2Increment Percentage for Annual Salary P05_OPWGDEC7(4) P05_OPWG
OPWN1Increment Percentage for Annual Salary Plus 1st Increment P05_OPWNDEC7(4) P05_OPWN
OPWN2Increment Percentage for Annual Salary Plus 1st Increment P05_OPWNDEC7(4) P05_OPWN
OWGMNMinimum Increment 1 P05_OPWGMNCURR9(2) P05_OPWGMN
OWGMXMaximum Increment 1 P05_OPWGMXCURR9(2) P05_OPWGMX
OWNMNMinimum Increment 2 P05_OPWNMNCURR9(2) P05_OPWNMN
OWNMXMaximum Increment 2 P05_OPWNMXCURR9(2) P05_OPWNMX
MXGWGMaximum Pensionable Salary ER P05_MXGWGCURR9(2) P05_MXGWG
MXGWNMaximum Pensionable Salary EE P05_MXGWNCURR9(2) P05_MXGWN
MNGWGMinimum Pensionable Salary ER P05_MNGWGCURR9(2) P05_MNGWG
MNGWNMinimum Pensionable Salary EE P05_MNGWNCURR9(2) P05_MNGWN
MXPWGMaximum ER Contribution P05_MXPWGCURR9(2) P05_MXPWG
MXPWNMaximum EE Contribution P05_MXPWNCURR9(2) P05_MXPWN
MNPWGMinimum ER Contribution P05_MNPWGCURR9(2) P05_MNPWG
MNPWNMinimum EE Contribution P05_MNPWNCURR9(2) P05_MNPWN
FRCWGEmployer 'Franchise' (Port.of Sal.Disreg.in Calc.Pens.Contr) P05_FRCWGCURR9(2) P05_FRCWG
FRCWNEmployee 'Franchise' (Port.of Sal.Disreg.in Calc.Pens.Contr) P05_FRCWNCURR9(2) P05_FRCWN
VPAWGFixed ER Contribution Allowance P05_VPAWGCURR9(2) P05_VPAWG
VPAWNFixed EE Contribution Allowance P05_VPAWNCURR9(2) P05_VPAWN
AWGWNEmployer's Share in EE Contribution P05_AWGWNDEC7(4) P05_DEC7_4
APSJBPayroll Period Start Annual Accounting P05_APSJBNUMC2P05_APSJB
MNLFTMinimum Age LEEF2DEC3DEC3
LFTBMAge Determination Date P05_LFTBMCHAR1P05_LFTBM
STLFTAge for Pensionable Salary Freeze STLFTDEC3DEC3
STPCTIncrease Percentage for Pensionable Salary P05_STPCTDEC7(4) P05_STPCT
STPRDIncrease Period P05_STPRDNUMC2P05_STPRD
PTBERPart-time Calculation Method P05_PTBERCHAR1P05_PTBER
RKHERRoutine Indicator for Cumulative Retroactive Accounting P05_RKHERCHAR1P05_RKHER
RCODERoutine Indicator P05_RCODECHAR3T5N5MP05_RCODE
CUMHBCumulative Retroactive Accounting P05_CUMHBCHAR1P05_CUMHB
NRATOFactoring P05_NRATOCHAR1CHAR1
AFRPGRounding Method for Pensionable Salary P05_AFRPGCHAR1P05_AFRND
AFRWGRounding Method ER Contribution P05_AFRWGCHAR1P05_AFRND
AFRWNRounding Method EE Contribution P05_AFRWNCHAR1P05_AFRND
CLCPSWage Type Code for Pensionable Salary P05_CLCPSCHAR1P05_CLCPS
LCJGSWage type annual basis (100%) P05_LCJGSCHAR4T512WLGART
ECCPBExclude Company Car from Pensionable Wage P05_EXCLUDE_COMP_CARCHAR1XFELD

Key field Non-key field



How do I retrieve data from SAP table T5N5Q using ABAP code

The following ABAP code Example will allow you to do a basic selection on T5N5Q to SELECT all data from the table
DATA: WA_T5N5Q TYPE T5N5Q.

SELECT SINGLE *
FROM T5N5Q
INTO CORRESPONDING FIELDS OF WA_T5N5Q
WHERE...

How to access SAP table T5N5Q

Within an ECC or HANA version of SAP you can also view further information about T5N5Q and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!