1. Home
  2. Resources
  3. SAP Tables
  4. T059P - Withholding tax types

SAP Table T059P

Withholding tax types

T059P (Withholding tax types) 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 T059P to other SAP tables.

T059P table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
LAND1 Country Key LAND1 T005 CHAR 3 0
WITHT Indicator for withholding tax type WITHT CHAR 2 0
WT_TPNR Sequential number of a withholding tax type WT_TPNR NUMC 3 0
WT_ACCPT Accumulation period WT_ACCPT CHAR 1 0
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? WT_ACCALL CHAR 1 0
X Yes
NULL No
WT_ACCTMAX Indicator: Withhold accumulated withholding tax to maximum? WT_ACCTMAX CHAR 1 0
X Yes
NULL No
WT_WTRD Rounding Rule WT_WTRD CHAR 2 0
00 Round up or down one place
01 Always round up
02 Always round down
WT_CEINV Central invoice WT_CEINV CHAR 1 0
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 WT_BASE CHAR 1 0
1 Net amount
2 Gross amount
3 Tax amount
4 Modified net amount
5 Modified tax amount
WT_DOPOST Post withholding tax amount WT_DOPOST CHAR 1 0
X Yes
NULL No
WT_POSTM Posting time WT_POSTM CHAR 1 0
1 Posting at time of invoice entry
2 Posting at time of payment
WT_ALWT Indicator: Withholding tax already withheld? WT_ALWT CHAR 1 0
X Yes
NULL No
WT_WTDSC Indicator: Calculate w/tax prior to cash discount deduction WT_WTDSC CHAR 1 0
X Yes
NULL No
WT_SLFWT Self-withholding possible? WT_SLFWT CHAR 1 0
X Yes
NULL No
WT_WTDP Withholding tax type number on which this w/tax type depends WT_WTDP NUMC 3 0
WT_MANUAL Indicator: Allow manual entry of withholding tax amount WT_MANUAL CHAR 1 0
X Yes
NULL No
WT_MAINTB Maintenance of minimum base amount WT_MAINTB CHAR 1 0
1 Withholding tax type level
2 Withholding tax code level
WT_MAINTA Maintenance of minimum/maximum withholding tax amount WT_MAINTA CHAR 1 0
1 Withholding tax type level
2 Withholding tax code level
WT_REDBAS Indicator: Reduce base amount by withholding tax amount? WT_REDBAS CHAR 1 0
X Yes
NULL No
WT_WTINV Indicator: Enter w/tax amount manually for payments? WT_WTINV CHAR 1 0
X Yes
NULL No
REGIO Region (State, Province, County) REGIO T005S CHAR 3 0
TDFORM Form Name TDFORM CHAR 16 0
WT_BCPLVL Minimum Check at Document Level WT_BCPLVL CHAR 1 0
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? WT_CTNBRL CHAR 1 0
X Yes
NULL No
WT_MANBAS Indicator: Allow manual entry of withholding tax base amnt WT_MANBAS CHAR 1 0
X Yes
NULL No
KSCHL Condition Type KSCHL T685A CHAR 4 0
J_1BSUMVAL Transfer to Nota Fiscal J_1BSUMVAL CHAR 1 0
X Yes
NULL No
J_1BTEXKEY MM: Text key for automatic text determination J_1BTEXKEY J_1BMMNFTT CHAR 4 0
WT_KURST Ex.Rate Type for Determining Ex.Rate for W/holding Tax Calc. WT_KURST TCURV CHAR 4 0
WT_INHERITBASE Indicator: Base Amount Equals Amount of Other Type WT_INHERITBASE CHAR 1 0
X Yes
NULL No
WT_NOREDUCTION Indicator: Vendor Line Item Not Reduced by W/holding Tax Amt WT_NOREDUCTION CHAR 1 0
X Yes
NULL No
J_1AFORMAT Certificate Format TYP_FORMAT CHAR 1 0
NULL Format xxxx-xxxxxxxx
N Format Res, SICORE xxxx-xxxx-xxxxxx
KSCHL_TX Condition Type KSCHL T685 CHAR 4 0
J_1BWHTBASE_NF Origin of Real Withholding Tax Calculation Base J_1BWHTBASE_NF CHAR 1 0
NULL Base in Standard FI Tables
X Base Stored in Nota Fiscal
ALL_TAX_CODES Consider All Tax Codes J_1A_ALL_TAX_CODES CHAR 1 0
X Yes
NULL No

T059P foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
T059P J_1BTEXKEY T059P MANDT J_1BMMNFTT MM: Allowed automatic texts MANDT
T059P J_1BTEXKEY T059P J_1BTEXKEY J_1BMMNFTT MM: Allowed automatic texts TEXTKEY
T059P KSCHL SY MANDT T685A Conditions: Types: Additional Price Element Data MANDT
T059P KSCHL 'V' T685A Conditions: Types: Additional Price Element Data KAPPL
T059P KSCHL T059P KSCHL T685A Conditions: Types: Additional Price Element Data KSCHL
T059P KSCHL_TX T059P KSCHL_TX T685 Conditions: Types KSCHL
T059P KSCHL_TX T059P MANDT T685 Conditions: Types MANDT
T059P KSCHL_TX * T685 Conditions: Types KVEWE
T059P KSCHL_TX 'TX' T685 Conditions: Types KAPPL
T059P LAND1 T059P MANDT T005 Countries MANDT
T059P LAND1 T059P LAND1 T005 Countries LAND1
T059P MANDT T059P MANDT T000 Clients MANDT
T059P REGIO T059P LAND1 T005S Taxes: Region (Province) Key LAND1
T059P REGIO T059P REGIO T005S Taxes: Region (Province) Key BLAND
T059P REGIO T059P MANDT T005S Taxes: Region (Province) Key MANDT
T059P WT_KURST T059P WT_KURST TCURV Exchange rate types for currency translation KURST
T059P WT_KURST T059P MANDT TCURV Exchange rate types for currency translation MANDT