SAP Table
T059Q Withholding Tax
SAP table T059Q has 3 primary key fields being MANDT,LAND1,QSSKZ.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
T059Q columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||
| KeyLAND1 | Country/Region Key | CHAR | 3 | 0 | T005 | LAND1 | |||||||
| KeyQSSKZ | Withholding Tax Code | CHAR | 2 | 0 | QSSKZ | ||||||||
| QSCOD | Official Withholding Tax Code | CHAR | 4 | 0 | QSCOD | ||||||||
| QSBEZ | Description of Withholding Tax Code | CHAR | 40 | 0 | QSBEZ | ||||||||
| QPROZ | Percentage Subject to Withholding Tax | DEC | 5 | 2 | QPROZ | ||||||||
| QSATZ | Withholding Tax Rate | DEC | 4 | 2 | QSATZ | ||||||||
| XNTTO | Indicator: Base for Calculating Net Withholding Tax? | CHAR | 1 | 0 | XNTTO | ||||||||
| XQSBZ | Indicator: Withholding Tax Posting with Payment? | CHAR | 1 | 0 | XQSBZ | ||||||||
| QSATR | Reduced Withholding Tax Rate for Exemption | DEC | 4 | 2 | QSATR | ||||||||
| XQFOR | Indicator: Calculate Withholding Tax According to Formula? | CHAR | 1 | 0 | XQFOR | ||||||||
| QMIND | Minimum Amount for Withholding Tax Report (Shiharai Choso) | CURR | 23 | 2 | QMIND | ||||||||
| QMIWA | Currency for Minimum Amount | CUKY | 5 | 0 | TCURC | QMIWA | |||||||
| BLAND | Region (State, Province, County) | CHAR | 3 | 0 | T005S | REGIO | |||||||
| FPRCD | Provincial Tax Code | CHAR | 3 | 0 | FPRCD | ||||||||
| QEKAR | Income Type | CHAR | 4 | 0 | T059E | QEKAR | |||||||
| QSATS | German Reunification Tax for the Withholding Tax | DEC | 4 | 2 | QSATS | ||||||||
| J_1ISECTIO | TDS Section | CHAR | 10 | 0 | J_1ISECTIO | ||||||||
| J_1ITXVNTY | Type of Company | CHAR | 1 | 0 | J_1ITXVNTY | ||||||||
|
|||||||||||||
| J_1IXVNDS | withholding tax - vendor type description | CHAR | 20 | 0 | J_1ITXVNDS | ||||||||
/ Relationships
T059Q foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| T059Q | BLAND | T005S | Taxes: Region (Province) Key | LAND1 |
| T059Q | LAND1 | T005 | Countries | MANDT |
| T059Q | LAND1 | T005 | Countries | LAND1 |
| T059Q | MANDT | T000 | Clients | MANDT |
| T059Q | QEKAR | T059E | Income Types | MANDT |
| T059Q | QEKAR | T059E | Income Types | LAND1 |
| T059Q | QEKAR | T059E | Income Types | QEKAR |
| T059Q | QMIWA | TCURC | Currency Codes | MANDT |
| T059Q | QMIWA | TCURC | Currency Codes | WAERS |