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 | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
Possible values
|
||||||||
| 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 |
Possible values
|
||||||||
| 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 | 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 | FPRCD | T059Z | FPRCD | T005P | Validation of tax keys | FPRCD |
| T059Z | LAND1 | T059Z | MANDT | T005 | Countries | MANDT |
| T059Z | LAND1 | T059Z | LAND1 | T005 | Countries | LAND1 |
| T059Z | MANDT | T059Z | MANDT | T000 | Clients | MANDT |
| T059Z | QEKAR | T059Z | MANDT | T059E | Income Types | MANDT |
| T059Z | QEKAR | T059Z | LAND1 | T059E | Income Types | LAND1 |
| T059Z | QEKAR | T059Z | QEKAR | T059E | Income Types | QEKAR |
| T059Z | QSCOD | T059Z | LAND1 | T059O | Official withholding tax key - Descriptions | LAND1 |
| T059Z | QSCOD | T059Z | QSCOD | T059O | Official withholding tax key - Descriptions | WT_QSCOD |
| T059Z | QSCOD | T059Z | MANDT | T059O | Official withholding tax key - Descriptions | MANDT |
| T059Z | REGIO | T059Z | LAND1 | T005S | Taxes: Region (Province) Key | LAND1 |
| T059Z | REGIO | T059Z | REGIO | T005S | Taxes: Region (Province) Key | BLAND |
| T059Z | REGIO | T059Z | MANDT | T005S | Taxes: Region (Province) Key | MANDT |
| 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 |
