SAP table T059Q (Withholding Tax)

SAP table T059Q has 3 primary key fields being MANDT,LAND1,QSSKZ.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
LAND1 Country/Region Key CHAR 3 0 T005 LAND1
QSSKZ 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
A Advertising
C Contractors
S Sub-contractors
J_1IXVNDS withholding tax - vendor type description CHAR 20 0 J_1ITXVNDS

T059Q foreign key relationships

Table Field Check Table Check Field
0 T059Q BLAND T005S Taxes: Region (Province) Key LAND1
1 T059Q LAND1 T005 Countries MANDT
1 T059Q LAND1 T005 Countries LAND1
0 T059Q MANDT T000 Clients MANDT
1 T059Q QEKAR T059E Income Types MANDT
1 T059Q QEKAR T059E Income Types LAND1
1 T059Q QEKAR T059E Income Types QEKAR
0 T059Q QMIWA TCURC Currency Codes MANDT
0 T059Q QMIWA TCURC Currency Codes WAERS