SAP table T059F (Formulas for Calculating Withholding Tax)

SAP table T059F has 6 primary key fields being MANDT,LAND1,WAERS,QSSKZ,QLAND,BBASB.

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
WAERS Currency Key CUKY 5 0 TCURC WAERS
QSSKZ Withholding Tax Code CHAR 2 0 T059Q QSSKZ
QLAND Withholding Tax Country/Region Key CHAR 3 0 T005Q QLAND
BBASB To Base Amount for Calculating Withholding Tax NUMC 23 0 BBASB
QSATZ Withholding Tax Rate DEC 4 2 QSATZ
QSATR Reduced Withholding Tax Rate for Exemption DEC 4 2 QSATR
QMBAB Reduction of Base Amount CURR 23 2 QMBAB
QMBAR Decreased Reduction of Base Amount CURR 23 2 QMBAR

T059F foreign key relationships

Table Field Check Table Check Field
0 T059F LAND1 T005 Countries MANDT
0 T059F LAND1 T005 Countries LAND1
1 T059F MANDT T000 Clients MANDT
0 T059F QLAND T005Q Country Keys for Withholding Tax Calculation MANDT
0 T059F QLAND T005Q Country Keys for Withholding Tax Calculation LAND1
1 T059F QSSKZ T059Q Withholding Tax MANDT
1 T059F QSSKZ T059Q Withholding Tax LAND1
1 T059F QSSKZ T059Q Withholding Tax QSSKZ
0 T059F WAERS TCURC Currency Codes MANDT
0 T059F WAERS TCURC Currency Codes WAERS