T5N2Q SAP table for – Wage Tax [Loonheffing] Exemptions (NL)

Here we would like to draw your attention to T5N2Q 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). T5N2Q is a SAP standard transp table used for storing Wage Tax [Loonheffing] Exemptions (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 T5N2Q table

Table T5N2Q technical data

TableT5N2Q
Data storingWage Tax [Loonheffing] Exemptions (NL)
ModulePA
Sub ModulePA-PA-NL
SAP PackagePB05
Delivery ClassE – System table whose data is transported with its own transport objects
ComponentSAP_HRCNL
Table CategoryTRANSP

SAP T5N2Q 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 T5N2Q table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • AUSNA : Special Employee Groups
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • LEEFT : Age Indicator (Over AOW Age)
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • 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
  • OTPC1 : Compensatory Allowance [overhevelingstoeslag] Percentage
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • OTMAX : Maximum Compensatory Allowance [overhevelingstoeslag]
    Its data type is CURR (Currency Field) with field length 7
  • LHPC1 : Wage Tax [LH] Percentage for Tax Class 1
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • LHPC2 : Wage Tax [LH] Percentage for Tax Class 2
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • LHPC3 : Wage Tax [LH] Percentage for Tax Class 3
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • LHPC4 : Wage Tax [LH] Percentage for Tax Class 4
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • LHPC5 : Wage Tax [LH] Percentage for Tax Class 5
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • LHPC0 : Wage Tax [LH] Percentage for Tax Class 0
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5