SAP table T059P (Withholding tax types)

SAP table T059P has 3 primary key fields being MANDT,LAND1,WITHT.

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 WITHT
WT_TPNR Sequential Number of a Withholding Tax Type NUMC 3 0 WT_TPNR
WT_ACCPT Accumulation Period CHAR 1 0 WT_ACCPT
0 No accumulation
1 Per calendar year
2 Per quarter
3 Per month
A Accumulation per Year Beginning with Month 01
B Accumulation per Year Beginning with Month 02
C Accumulation per Year Beginning with Month 03
D Accumulation per Year Beginning with Month 04
E Accumulation per Year Beginning with Month 05
F Accumulation per Year Beginning with Month 06
G Accumulation per Year Beginning with Month 07
H Accumulation per Year Beginning with Month 08
I Accumulation per Year Beginning with Month 09
J Accumulation per Year Beginning with Month 10
K Accumulation per Year Beginning with Month 11
L Accumulation per Year Beginning with Month 12
WT_ACCALL Indicator: Accum. Several Cust./Vend. and CoCdes Together? CHAR 1 0 WT_ACCALL
WT_ACCTMAX Indicator: Withhold Accumulated Withholding Tax to Maximum? CHAR 1 0 WT_ACCTMAX
WT_WTRD Rounding Rule CHAR 2 0 WT_WTRD
00 Round up or down one place
01 Always round up
02 Always round down
WT_CEINV Central Invoice CHAR 1 0 WT_CEINV
0 "Central invoice" concept not used
1 "Central invoice": Proportional base amnt for partial pmnts
2 "Central invoice": Total base amount for first partial pmnt
WT_BASE Type of Withholding Tax Base Amount CHAR 1 0 WT_BASE
1 Net amount
2 Gross amount
3 Tax amount
4 Modified net amount
5 Modified tax amount
WT_DOPOST Post Withholding Tax Amount CHAR 1 0 WT_DOPOST
WT_POSTM Posting Time CHAR 1 0 WT_POSTM
1 Posting at time of invoice entry
2 Posting at time of payment
WT_ALWT Indicator: Withholding Tax Already Withheld? CHAR 1 0 WT_ALWT
WT_WTDSC Indicator: Calculate W/Tax Prior to Cash Discount Deduction CHAR 1 0 WT_WTDSC
WT_SLFWT Self-Withholding Possible? CHAR 1 0 WT_SLFWT
WT_WTDP Withholding Tax Type Number on Which This W/Tax Type Depends NUMC 3 0 WT_WTDP
WT_MANUAL Indicator: Allow Manual Entry of Withholding Tax Amount CHAR 1 0 WT_MANUAL
WT_MAINTB Maintenance of Minimum Base Amount CHAR 1 0 WT_MAINTB
WT_MAINTA Maintenance of Minimum/Maximum Withholding Tax Amount CHAR 1 0 WT_MAINTA
WT_REDBAS Indicator: Reduce Base Amount by Withholding Tax Amount? CHAR 1 0 WT_REDBAS
WT_WTINV Indicator: Enter WTax Amount Manually for Payments? CHAR 1 0 WT_WTINV
REGIO Region (State, Province, County) CHAR 3 0 T005S REGIO
TDFORM Form name CHAR 16 0 TDFORM
WT_BCPLVL Minimum Check at Document Level CHAR 1 0 WT_BCPLVL
0 Minimum Check at Item Level
1 Check on minimum base amount at payment document level
2 Check on minimum base amount at invoice document level
3 Minimum Amount Check at Payment Document Level
WT_CTNBRL Indicator: Type Not Relevant for Certificate Numbering? CHAR 1 0 WT_CTNBRL
WT_MANBAS Indicator: Allow Manual Entry of Withholding Tax Base Amount CHAR 1 0 WT_MANBAS
KSCHL Condition Type CHAR 4 0 T685A KSCHL
J_1BSUMVAL Transfer to Nota Fiscal CHAR 1 0 J_1BSUMVAL
J_1BTEXKEY MM: Text key for automatic text determination CHAR 4 0 J_1BMMNFTT J_1BTEXKEY
WT_KURST Ex.Rate Type for Determining Exch.Rate for WTax Calculation CHAR 4 0 TCURV WT_KURST
WT_INHERITBASE Indicator: Base Amount Equals Amount of Other Type CHAR 1 0 WT_INHERITBASE
WT_NOREDUCTION Indicator: Vendor Line Item Not Reduced by W/holding Tax Amt CHAR 1 0 WT_NOREDUCTION
J_1AFORMAT Certificate Format CHAR 1 0 TYP_FORMAT
Format xxxx-xxxxxxxx
N Format Res, SICORE xxxx-xxxx-xxxxxx
KSCHL_TX Condition Type CHAR 4 0 T685 KSCHL
J_1BWHTBASE_NF Origin of Real Withholding Tax Calculation Base CHAR 1 0 J_1BWHTBASE_NF
Base in Standard FI Tables
X Base Stored in Nota Fiscal
ALL_TAX_CODES Consider All Tax Codes CHAR 1 0 J_1A_ALL_TAX_CODES
J_DAILY_ACC Daily accumulation CHAR 1 0 J_DAILY_ACC

T059P foreign key relationships

Table Field Check Table Check Field
0 T059P J_1BTEXKEY J_1BMMNFTT MM: Allowed automatic texts MANDT
0 T059P J_1BTEXKEY J_1BMMNFTT MM: Allowed automatic texts TEXTKEY
1 T059P KSCHL T685A Conditions: Types: Additional Price Element Data KAPPL
1 T059P KSCHL T685A Conditions: Types: Additional Price Element Data KSCHL
0 T059P KSCHL_TX T685 Conditions: Types KAPPL
0 T059P KSCHL_TX T685 Conditions: Types KSCHL
1 T059P LAND1 T005 Countries MANDT
1 T059P LAND1 T005 Countries LAND1
0 T059P MANDT T000 Clients MANDT
1 T059P REGIO T005S Taxes: Region (Province) Key LAND1
0 T059P WT_KURST TCURV Exchange rate types for currency translation MANDT
0 T059P WT_KURST TCURV Exchange rate types for currency translation KURST