T5N2Q (Wage Tax [Loonheffing] Exemptions (NL)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link T5N2Q to other SAP tables.
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||
|
AUSNA
Special Employee Groups
|
AUSNS |
CHAR
|
3 | 0 | ||||||||||
|
LEEFT
Age Indicator (Over AOW Age)
|
LEEFT |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
ENDDA
End Date
|
ENDDA |
DATS
|
8 | 0 | ||||||||||
|
BEGDA
Start Date
|
BEGDA |
DATS
|
8 | 0 | ||||||||||
|
OTPC1
Compensatory Allowance [overhevelingstoeslag] Percentage
|
OTPC1 |
DEC
|
5 | 3 | ||||||||||
|
OTMAX
Maximum Compensatory Allowance [overhevelingstoeslag]
|
OTMAX |
CURR
|
7 | 2 | ||||||||||
|
LHPC1
Wage Tax [LH] Percentage for Tax Class 1
|
LHPC1 |
DEC
|
5 | 3 | ||||||||||
|
LHPC2
Wage Tax [LH] Percentage for Tax Class 2
|
LHPC2 |
DEC
|
5 | 3 | ||||||||||
|
LHPC3
Wage Tax [LH] Percentage for Tax Class 3
|
LHPC3 |
DEC
|
5 | 3 | ||||||||||
|
LHPC4
Wage Tax [LH] Percentage for Tax Class 4
|
LHPC4 |
DEC
|
5 | 3 | ||||||||||
|
LHPC5
Wage Tax [LH] Percentage for Tax Class 5
|
LHPC5 |
DEC
|
5 | 3 | ||||||||||
|
LHPC0
Wage Tax [LH] Percentage for Tax Class 0
|
P05_LHPC0 |
DEC
|
5 | 3 | ||||||||||
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| T5N2Q | MANDT | T5N2Q | MANDT |
T000
Clients
|
MANDT |