T5N1Q SAP table for – Pension Accounting (NL)

Here we would like to draw your attention to T5N1Q table in SAP. As we know it is being mainly used with the SAP PA-PA (Personnel Administration in PA) component which is coming under HR (HCM) PA module (Personnel Management). T5N1Q is a SAP standard transp table used for storing Pension Accounting (NL) related data in SAP. If you want to download PDF material about SAP HR PA click here. It comes under the package PB05.

SAP T5N1Q table

Table T5N1Q technical data

TableT5N1Q
Data storingPension Accounting (NL)
ModulePA
Sub ModulePA-PA-NL
SAP PackagePB05
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentSAP_HRCNL
Table CategoryTRANSP

SAP T5N1Q Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in T5N1Q table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • PENSK : Pension Indicator
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • ENDDA : End Date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BEGDA : Start Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • WGPP1 : Employer’s Contribution 1 (%)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • WGPP2 : Employer’s Contribution 2 (%)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • WNPP1 : Employee’s Contribution 1 (%)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • WNPP2 : Employee’s Contribution 2 (%)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • OPPP1 : Increase Percentage 1
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • OPPP2 : Increase Percentage 2
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • GRPP1 : Marginal Percentage
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • MAPPR : Maximum Annual Contribution
    Its data type is CURR (Currency Field) with field length 9
  • MIPPR : Minimum Annual Contribution
    Its data type is CURR (Currency Field) with field length 9
  • DAGMX : Maximum Daily Pension Contribution
    Its data type is CURR (Currency Field) with field length 7
  • DRPPR : Threshold Sum
    Its data type is CURR (Currency Field) with field length 9
  • FRPPR : Annual ‘Franchise’ (Port.of Sal.Disreg.in Calc.Pens.Contr.)
    Its data type is CURR (Currency Field) with field length 9
  • LEEFT : Minimum Age
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • STLFT : Age for Pensionable Salary Freeze
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • STPCT : Increase Percentage
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • RKHER : Retroactive Accounting Indicator
    Its data type is CHAR (Character String) with field length 1
  • TKHER : Part-time Calculation Indicator
    Its data type is CHAR (Character String) with field length 1
  • RKPFS : Routine Indicator
    Its data type is CHAR (Character String) with field length 1
  • INSTL : Authority
    Its data type is CHAR (Character String) with field length 3
  • FRPPR2 : Annual ‘Franchise’ (Port.of Sal.Disreg.in Calc.Pens.Contr.)
    Its data type is CURR (Currency Field) with field length 9
  • FONDS : Pension Fund
    Its data type is CHAR (Character String) with field length 4