SAP table T059Z (Withholding tax code (enhanced functions))

SAP table T059Z has 4 primary key fields being MANDT,LAND1,WITHT,WT_WITHCD.

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
WITHT Indicator for Withholding Tax Type CHAR 2 0 T059P WITHT
WT_WITHCD Withholding Tax Code CHAR 2 0 WT_WITHCD
QSCOD Official Withholding Tax Key CHAR 4 0 T059O WT_OWTCD
QPROZ Percentage Subject to Withholding Tax DEC 5 2 QPROZ
QSATZ Withholding Tax Rate DEC 7 4 WT_QSATZ
QSATR Reduced Withholding Tax Rate DEC 7 4 WT_QSATR
XQFOR Indicator: Calculate Withholding Tax According to Formula? CHAR 1 0 XQFOR
REGIO Region (State, Province, County) CHAR 3 0 T005S REGIO
FPRCD Provincial Tax Code CHAR 3 0 T005P FPRCD
QEKAR Income Type CHAR 4 0 T059E QEKAR
WT_POSIN Posting Indicator CHAR 1 0 WT_POSIN
1 Standard posting: Bank/vendor/customer line item reduced
2 Offsetting entry to G/L account ("grossing up")
3 Offsetting entry to G/L account
WT_RATEZ Withholding Tax Rate Numerator INT2 5 0 WT_RATEZ
WT_RATEN Withholding Tax Rate Denominator INT2 5 0 WT_RATEN
WITHCD2 Withholding Tax Key CHAR 16 0 T059Z_WITHCD2 WITHCD2

T059Z foreign key relationships

Table Field Check Table Check Field
0 T059Z FPRCD T005P Validation of tax keys MANDT
0 T059Z FPRCD T005P Validation of tax keys LAND1
0 T059Z FPRCD T005P Validation of tax keys BLAND
1 T059Z LAND1 T005 Countries MANDT
1 T059Z LAND1 T005 Countries LAND1
0 T059Z MANDT T000 Clients MANDT
1 T059Z QEKAR T059E Income Types MANDT
1 T059Z QEKAR T059E Income Types LAND1
1 T059Z QEKAR T059E Income Types QEKAR
0 T059Z QSCOD T059O Official withholding tax key - Descriptions MANDT
0 T059Z QSCOD T059O Official withholding tax key - Descriptions LAND1
0 T059Z QSCOD T059O Official withholding tax key - Descriptions WT_QSCOD
1 T059Z REGIO T005S Taxes: Region (Province) Key LAND1
0 T059Z WITHCD2 T059Z_WITHCD2 Entity Table: Additional Official Withholding Tax Code MANDT
0 T059Z WITHCD2 T059Z_WITHCD2 Entity Table: Additional Official Withholding Tax Code LAND1
1 T059Z WITHT T059P Withholding tax types MANDT
1 T059Z WITHT T059P Withholding tax types LAND1
1 T059Z WITHT T059P Withholding tax types WITHT