SAP table T5JT3 (Payroll income tax table - daily OTSU)
SAP table T5JT3 has 5 primary key fields being MANDT,ENDDA,TABTY,LWLMT,UPLMT.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| ENDDA | End Date | DATS | 8 | 0 | ENDDA | ||
| TABTY | Taxation table type | CHAR | 2 | 0 | P22J_TABTY | ||
| LWLMT | Lower limit of amount | CURR | 9 | 2 | P22J_LWLMT | ||
| UPLMT | Upper limit of amount | CURR | 9 | 2 | P22J_UPLMT | ||
| BEGDA | Start Date | DATS | 8 | 0 | BEGDA | ||
| TXAMT | Tax amount | CURR | 9 | 2 | P22J_TXAMT | ||
| CTFLG | Control flag for operation | NUMC | 1 | 0 | P22J_CTFLG | ||
| CTAMT | Basis Amount for Calculation | CURR | 9 | 2 | P22J_CTAMT | ||
| PRCNT | Rate of additional tax on basis amount | DEC | 5 | 2 | P22J_PRCNT |