SAP Table T059Q
Withholding Tax
T059Q (Withholding Tax) 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 T059Q to other SAP tables.
T059Q table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||
| LAND1 | Country Key | LAND1 | T005 | CHAR | 3 | 0 | ||||||||
| QSSKZ | Withholding Tax Code | QSSKZ | CHAR | 2 | 0 | |||||||||
| QSCOD | Official Withholding Tax Code | QSCOD | CHAR | 4 | 0 | |||||||||
| QSBEZ | Description of Withholding Tax Code | QSBEZ | CHAR | 40 | 0 | |||||||||
| QPROZ | Percentage Subject to Withholding Tax | QPROZ | DEC | 5 | 2 | |||||||||
| QSATZ | Withholding Tax Rate | QSATZ | DEC | 4 | 2 | |||||||||
| XNTTO | Indicator: Base for calculating net withholding tax ? | XNTTO | CHAR | 1 | 0 |
Possible values
|
||||||||
| XQSBZ | Indicator: Withholding tax posting with payment ? | XQSBZ | CHAR | 1 | 0 |
Possible values
|
||||||||
| QSATR | Reduced Withholding Tax Rate for Exemption | QSATR | DEC | 4 | 2 | |||||||||
| XQFOR | Indicator: Calculate withholding tax according to formula? | XQFOR | CHAR | 1 | 0 |
Possible values
|
||||||||
| QMIND | Minimum amount for withholding tax report (Shiharai Choso) | QMIND | CURR | 13 | 2 | |||||||||
| QMIWA | Currency for minimum amount | QMIWA | TCURC | CUKY | 5 | 0 | ||||||||
| BLAND | Region (State, Province, County) | REGIO | T005S | CHAR | 3 | 0 | ||||||||
| FPRCD | Provincial tax code | FPRCD | CHAR | 3 | 0 | |||||||||
| QEKAR | Income Type | QEKAR | T059E | CHAR | 4 | 0 | ||||||||
| QSATS | German Reunification Tax for the Withholding Tax | QSATS | DEC | 4 | 2 | |||||||||
| J_1ISECTIO | TDS Section | J_1ISECTIO | CHAR | 10 | 0 | |||||||||
| J_1ITXVNTY | Type of Company | J_1ITXVNTY | CHAR | 1 | 0 |
Possible values
|
||||||||
| J_1IXVNDS | withholding tax - vendor type description | J_1ITXVNDS | CHAR | 20 | 0 | |||||||||
T059Q foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| T059Q | BLAND | T059Q | MANDT | T005S | Taxes: Region (Province) Key | MANDT |
| T059Q | BLAND | T059Q | LAND1 | T005S | Taxes: Region (Province) Key | LAND1 |
| T059Q | BLAND | T059Q | BLAND | T005S | Taxes: Region (Province) Key | BLAND |
| T059Q | LAND1 | T059Q | MANDT | T005 | Countries | MANDT |
| T059Q | LAND1 | T059Q | LAND1 | T005 | Countries | LAND1 |
| T059Q | MANDT | T059Q | MANDT | T000 | Clients | MANDT |
| T059Q | QEKAR | T059Q | QEKAR | T059E | Income Types | QEKAR |
| T059Q | QEKAR | T059Q | MANDT | T059E | Income Types | MANDT |
| T059Q | QEKAR | T059Q | LAND1 | T059E | Income Types | LAND1 |
| T059Q | QMIWA | T059Q | MANDT | TCURC | Currency Codes | MANDT |
| T059Q | QMIWA | T059Q | QMIWA | TCURC | Currency Codes | WAERS |
