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
X Yes
NULL No
XQSBZ Indicator: Withholding tax posting with payment ? XQSBZ CHAR 1 0
X Yes
NULL No
QSATR Reduced Withholding Tax Rate for Exemption QSATR DEC 4 2
XQFOR Indicator: Calculate withholding tax according to formula? XQFOR CHAR 1 0
X Yes
NULL No
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
A Advertising
C Contractors
S Sub-contractors
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