SAP Table T059Z
Withholding tax code (enhanced functions)
T059Z (Withholding tax code (enhanced functions)) 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 T059Z to other SAP tables.
T059Z table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||
|
LAND1
Country Key
|
LAND1 | T005 |
CHAR
|
3 | 0 | |||||||||
|
WITHT
Indicator for withholding tax type
|
WITHT | T059P |
CHAR
|
2 | 0 | |||||||||
|
WT_WITHCD
Withholding tax code
|
WT_WITHCD |
CHAR
|
2 | 0 | ||||||||||
|
QSCOD
Official Withholding Tax Key
|
WT_OWTCD | T059O |
CHAR
|
4 | 0 | |||||||||
|
QPROZ
Percentage Subject to Withholding Tax
|
QPROZ |
DEC
|
5 | 2 | ||||||||||
|
QSATZ
Withholding tax rate
|
WT_QSATZ |
DEC
|
7 | 4 | ||||||||||
|
QSATR
Reduced withholding tax rate
|
WT_QSATR |
DEC
|
7 | 4 | ||||||||||
|
XQFOR
Indicator: Calculate withholding tax according to formula?
|
XQFOR |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
REGIO
Region (State, Province, County)
|
REGIO | T005S |
CHAR
|
3 | 0 | |||||||||
|
FPRCD
Provincial tax code
|
FPRCD | T005P |
CHAR
|
3 | 0 | |||||||||
|
QEKAR
Income Type
|
QEKAR | T059E |
CHAR
|
4 | 0 | |||||||||
|
WT_POSIN
Posting indicator
|
WT_POSIN |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
WT_RATEZ
Withholding tax rate counter
|
WT_RATEZ |
INT2
|
5 | 0 | ||||||||||
|
WT_RATEN
Withholding tax rate denominator
|
WT_RATEN |
INT2
|
5 | 0 | ||||||||||
|
WITHCD2
Withholding Tax Key
|
WITHCD2 | T059Z_WITHCD2 |
CHAR
|
16 | 0 | |||||||||
T059Z foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| T059Z | FPRCD | T059Z | FPRCD |
T005P
Validation of tax keys
|
FPRCD |
| T059Z | FPRCD | T059Z | MANDT |
T005P
Validation of tax keys
|
MANDT |
| T059Z | FPRCD | T059Z | LAND1 |
T005P
Validation of tax keys
|
LAND1 |
| T059Z | FPRCD | T059Z | REGIO |
T005P
Validation of tax keys
|
BLAND |
| T059Z | LAND1 | T059Z | MANDT |
T005
Countries
|
MANDT |
| T059Z | LAND1 | T059Z | LAND1 |
T005
Countries
|
LAND1 |
| T059Z | MANDT | T059Z | MANDT |
T000
Clients
|
MANDT |
| T059Z | QEKAR | T059Z | LAND1 |
T059E
Income Types
|
LAND1 |
| T059Z | QEKAR | T059Z | QEKAR |
T059E
Income Types
|
QEKAR |
| T059Z | QEKAR | T059Z | MANDT |
T059E
Income Types
|
MANDT |
| T059Z | QSCOD | T059Z | MANDT |
T059O
Official withholding tax key - Descriptions
|
MANDT |
| T059Z | QSCOD | T059Z | LAND1 |
T059O
Official withholding tax key - Descriptions
|
LAND1 |
| T059Z | QSCOD | T059Z | QSCOD |
T059O
Official withholding tax key - Descriptions
|
WT_QSCOD |
| T059Z | REGIO | T059Z | MANDT |
T005S
Taxes: Region (Province) Key
|
MANDT |
| T059Z | REGIO | T059Z | LAND1 |
T005S
Taxes: Region (Province) Key
|
LAND1 |
| T059Z | REGIO | T059Z | REGIO |
T005S
Taxes: Region (Province) Key
|
BLAND |
| T059Z | WITHCD2 | T059Z | MANDT |
T059Z_WITHCD2
Entity Table: Additional Official Withholding Tax Code
|
MANDT |
| T059Z | WITHCD2 | T059Z | LAND1 |
T059Z_WITHCD2
Entity Table: Additional Official Withholding Tax Code
|
LAND1 |
| T059Z | WITHCD2 | T059Z | WITHCD2 |
T059Z_WITHCD2
Entity Table: Additional Official Withholding Tax Code
|
WITHCD2 |
| T059Z | WITHT | T059Z | MANDT |
T059P
Withholding tax types
|
MANDT |
| T059Z | WITHT | T059Z | LAND1 |
T059P
Withholding tax types
|
LAND1 |
| T059Z | WITHT | T059Z | WITHT |
T059P
Withholding tax types
|
WITHT |