- Home
- Resources
- SAP Tables
- T5UTZ - Tax Authorities
SAP Table T5UTZ
Tax Authorities
T5UTZ (Tax Authorities) 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 T5UTZ to other SAP tables.
Source: T5UTZ (Tax Authorities)
T5UTZ table fields
| Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
| MANDT |
Client |
MANDT |
T000
|
CLNT |
|
3 |
0 |
|
| TAXAU |
Tax authority |
TAXAT |
|
CHAR |
|
4 |
0 |
|
| STATE |
Region (State, Province, County) |
REGIO |
T005S
|
CHAR |
|
3 |
0 |
|
| TAXLV |
Tax level |
TXLEV |
|
CHAR |
|
1 |
0 |
Possible values
| A |
Federal |
| B |
State |
| C |
County |
| D |
City |
| E |
School District |
| F |
Other |
|
| CONTY |
Text length 25 |
TEXT25 |
|
CHAR |
|
25 |
0 |
|
| LTEXT |
Description |
DESC30 |
|
CHAR |
|
30 |
0 |
|
| SRTNO |
Sort number for tax authorities |
SRTNO |
|
NUMC |
|
8 |
0 |
|
| W4IND |
W-4 indicator |
W4IND |
|
CHAR |
|
1 |
0 |
Possible values
| 1 |
W-4 mandatory for Federal or state level |
| 2 |
W-4 optional for state level (exemption on separate form) |
| 3 |
W-4 not allowed for state level (exemption on separate form) |
| 4 |
W-4 not applicable for state level |
| 5 |
W-4 optional for state level |
| 6 |
W-4 not allowed for state level |
|
| IRSID |
IRS limit ID |
IRSID |
|
CHAR |
|
1 |
0 |
Possible values
| 1 |
IRS limits or equivalent optional for state level |
| 2 |
IRS limits or equivalent not allowed for state level |
| 3 |
IRS limits or equivalent not applicable for state level |
|
| NONUS |
Territory indicator |
NONUS |
|
CHAR |
|
1 |
0 |
|
| DEFAW |
Default number of allowances |
PB10_DEFAW |
|
NUMC |
|
2 |
0 |
|
| DEFMS |
Default filing status |
PB10_DEFMS |
|
NUMC |
|
5 |
0 |
|
| AWLMT |
Number of allowances limit |
PB10_AWLMT |
|
NUMC |
|
2 |
0 |
|
| AWFED |
Allowance not greater than Federal |
PB10_AWFED |
|
CHAR |
|
1 |
0 |
Possible values
|
| AAPBT |
Additional Amount Prohibited |
PB10_AAPBT |
|
CHAR |
|
1 |
0 |
Possible values
|
| TEPBT |
Tax exemption prohibited |
PB10_TEPBT |
|
CHAR |
|
1 |
0 |
Possible values
|
| EXMEM |
Exemption expiration month |
PB10_EXMEM |
|
NUMC |
|
2 |
0 |
|
| EXMED |
Exemption expiration day |
PB10_EXMED |
|
NUMC |
|
2 |
0 |
|
| RFBEGDA |
Reciprocal Formula Begin Date |
RFBEGDA |
|
DATS |
|
8 |
0 |
|
| RFENDDA |
Reciprocal Formula End Date |
RFENDDA |
|
DATS |
|
8 |
0 |
|
T5UTZ foreign key relationships
| Table |
Field |
Foreign key table |
Foreign key field |
Check table |
Check field |
| T5UTZ |
MANDT |
T5UTZ |
MANDT |
T000 |
Clients |
MANDT |
| T5UTZ |
STATE |
SYST |
MANDT |
T005S |
Taxes: Region (Province) Key |
MANDT |
| T5UTZ |
STATE |
'US ' |
|
T005S |
Taxes: Region (Province) Key |
LAND1 |
| T5UTZ |
STATE |
T5UTZ |
STATE |
T005S |
Taxes: Region (Province) Key |
BLAND |
