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 | Possible values | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||
|
||||||||||||||
|
XQSBZ
Indicator: Withholding tax posting with payment ?
|
XQSBZ |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
QSATR
Reduced Withholding Tax Rate for Exemption
|
QSATR |
DEC
|
4 | 2 | ||||||||||
|
XQFOR
Indicator: Calculate withholding tax according to formula?
|
XQFOR |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
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 | ||||||||||
|
||||||||||||||
|
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 | MANDT |
T059E
Income Types
|
MANDT |
| T059Q | QEKAR | T059Q | LAND1 |
T059E
Income Types
|
LAND1 |
| T059Q | QEKAR | T059Q | QEKAR |
T059E
Income Types
|
QEKAR |
| T059Q | QMIWA | T059Q | MANDT |
TCURC
Currency Codes
|
MANDT |
| T059Q | QMIWA | T059Q | QMIWA |
TCURC
Currency Codes
|
WAERS |