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.

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
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
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
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
X Yes
NULL No
AAPBT Additional Amount Prohibited PB10_AAPBT CHAR 1 0
X Yes
NULL No
TEPBT Tax exemption prohibited PB10_TEPBT CHAR 1 0
X Yes
NULL No
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 'US ' T005S Taxes: Region (Province) Key LAND1
T5UTZ STATE T5UTZ STATE T005S Taxes: Region (Province) Key BLAND
T5UTZ STATE SYST MANDT T005S Taxes: Region (Province) Key MANDT