1. Home
  2. Resources
  3. SAP Tables
  4. IDWTPARTNER - Withholding Tax Type, Code, and Vendor/Customer Master Data

SAP Table IDWTPARTNER

Withholding Tax Type, Code, and Vendor/Customer Master Data

IDWTPARTNER (Withholding Tax Type, Code, and Vendor/Customer Master Data) 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 IDWTPARTNER to other SAP tables.

IDWTPARTNER table fields

Field Data element Checktable Datatype Length Decimals
BUKRS Company Code BUKRS T001 CHAR 4 0
PARTNO_TYPE Type of partner number WT_PARTNO_TYPE CHAR 1 0
NULL Vendor/Customer (FI-AP/AR)
1 Business Partner (FI-CA)
PARTNERNO Partner ID PARTNERNO CHAR 35 0
WT_PERIOD Reporting Period WT_REPPERIOD NUMC 2 0
MONA Posting date calendar month BUMON NUMC 2 0
WITHT Indicator for withholding tax type WITHT CHAR 2 0
WT_WITHCD Withholding tax code WT_WITHCD CHAR 2 0
QLAND Withholding Tax Country Key QLAND CHAR 3 0
QLTXT Country for the Withholding Tax WT_QLTXT CHAR 30 0
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
KUNNR Customer Number KUNNR CHAR 10 0
PARTNER_SEQ_NB Partner sequential number on Withholding Tax lists PARTNER_SEQ_NB NUMC 6 0
TEXT40 Description of Withholding tax type for Ext. WT WT_TYPE_DESC CHAR 40 0
WT_TYPECODE_TEXT Description of Wth/Tax Type + code for Ext. WT WT_TYPE_CODE_DESC CHAR 40 0
QSCOD Official Withholding Tax Key WT_OWTCD CHAR 4 0
WT_OFFWT_TEXT Text of the Official Withholding Tax Code WT_OFFWT_TEXT CHAR 40 0
TAX_REGION Tax Region Code for Withholding Tax Code TAX_REGIO CHAR 3 0
TAX_REGION_NUM Official numerical state code WT_REGIO_NUM CHAR 3 0
TAX_REGION_TXT Tax Region Name for Wtihholding Tax Code TAX_REGION_TXT CHAR 20 0
CTNUMBER Withholding Tax Certificate Number CTNUMBER CHAR 10 0
WT_POSTM Posting time WT_POSTM CHAR 1 0
1 Posting at time of invoice entry
2 Posting at time of payment
WT_POSIN Posting indicator WT_POSIN CHAR 1 0
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
FPRCD Provincial tax code FPRCD CHAR 3 0
QEKAR Income Type QEKAR CHAR 4 0
EATXT Description of the income type WT_INCOME_TYPE_DESC CHAR 40 0
XQFOR Indicator: Calculate withholding tax according to formula? XQFOR CHAR 1 0
X Yes
NULL No
QPROZ Percentage Subject to Withholding Tax QPROZ DEC 5 2
QSATZ Withholding tax rate WT_QSATZ DEC 7 4
QSATR Reduced withholding tax rate WT_QSATR DEC 7 4
SORTL Sort field SORTL CHAR 10 0
SPRAS Language Key SPRAS LANG 1 0
BRSCH Industry key BRSCH CHAR 4 0
STCD1 Tax Number 1 STCD1 CHAR 16 0
STCD2 Tax Number 2 STCD2 CHAR 11 0
STCD3 Tax Number 3 STCD3 CHAR 18 0
STCD4 Tax Number 4 STCD4 CHAR 18 0
GBDAT Date of birth of the person subject to withholding tax GBDAT_Q DATS 8 0
GBORT Place of birth of the person subject to withholding tax GBORT_Q CHAR 25 0
SEXKZ Key for the Sex of the Person Subject to Withholding Tax SEXKZ CHAR 1 0
1 Male
2 Female
STKZN Natural Person STKZN CHAR 1 0
X Natural person
NULL Legal person
STKZU Liable for VAT STKZU CHAR 1 0
X Yes
NULL No
VBUND Company ID of trading partner RASSC CHAR 6 0
STCEG VAT Registration Number STCEG CHAR 20 0
TXJCD Tax Jurisdiction TXJCD CHAR 15 0
WERKS Plant WERKS_D CHAR 4 0
DTAMS Indicator for Data Medium Exchange DTAMS CHAR 1 0
1 Single data record not to be forwarded to the Bundesbank
0 Single data record can be forwarded to the Bundesbank
NULL Use house bank default value
ADDRNUMBER Address number AD_ADDRNUM CHAR 10 0
DATE_FROM Valid-from date - in current Release only 00010101 possible AD_DATE_FR DATS 8 0
DATE_TO Valid-to date in current Release only 99991231 possible AD_DATE_TO DATS 8 0
TITLE Form-of-Address Key AD_TITLE TSAD3 CHAR 4 0
NAME1 Name 1 AD_NAME1 CHAR 40 0
NAME2 Name 2 AD_NAME2 CHAR 40 0
NAME3 Name 3 AD_NAME3 CHAR 40 0
NAME4 Name 4 AD_NAME4 CHAR 40 0
NAME_TXT Converted name field (with form of address) AD_NAMETXT CHAR 50 0
NAME_CO c/o name AD_NAME_CO CHAR 40 0
CITY1 City AD_CITY1 CHAR 40 0
CITY2 District AD_CITY2 CHAR 40 0
CITY_CODE City code for city/street file AD_CITYNUM ADRCITY CHAR 12 0
CITYP_CODE District code for City and Street file AD_CITYPNM ADRCITYPRT CHAR 8 0
HOME_CITY City (different from postal city) AD_CITY3 CHAR 40 0
CITYH_CODE Different city for city/street file AD_CITYHNM ADRCITY CHAR 12 0
CHCKSTATUS City file test status AD_CHECKST CHAR 1 0
NULL Not checked
C checked against city index
D differs from city index
REGIOGROUP Regional structure grouping REGIOGROUP ADRREGGRP CHAR 8 0
POST_CODE1 City postal code AD_PSTCD1 CHAR 10 0
POST_CODE2 PO Box Postal Code AD_PSTCD2 CHAR 10 0
POST_CODE3 Company Postal Code (for Large Customers) AD_PSTCD3 CHAR 10 0
PCODE1_EXT (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code AD_PST1XT CHAR 10 0
PCODE2_EXT (Not Supported) PO Box Postal Code Extension AD_PST2XT CHAR 10 0
PCODE3_EXT (Not Supported) Major Customer Postal Code Extension AD_PST3XT CHAR 10 0
PO_BOX PO Box AD_POBX CHAR 10 0
DONT_USE_P PO Box Address Undeliverable Flag AD_NO_USEP TSAD12 CHAR 4 0
PO_BOX_NUM Flag: PO Box Without Number AD_POBXNUM CHAR 1 0
X Yes
NULL No
PO_BOX_LOC PO Box city AD_POBXLOC CHAR 40 0
CITY_CODE2 City PO box code (City file) AD_CIT2NUM ADRCITY CHAR 12 0
PO_BOX_REG Region for PO Box (Country, State, Province, ...) AD_POBXREG T005S CHAR 3 0
PO_BOX_CTY PO box country AD_POBXCTY T005 CHAR 3 0
POSTALAREA (Not Supported) Post Delivery District AD_PSTLAR CHAR 15 0
TRANSPZONE Transportation zone to or from which the goods are delivered LZONE TZONE CHAR 10 0
STREET Street AD_STREET CHAR 60 0
DONT_USE_S Street Address Undeliverable Flag AD_NO_USES TSAD12 CHAR 4 0
STREETCODE Street Number for City/Street File AD_STRNUM ADRSTREET CHAR 12 0
STREETABBR (Not Supported) Abbreviation of Street Name AD_STRABBR ADRSTRTYPE CHAR 2 0
HOUSE_NUM1 House Number AD_HSNM1 CHAR 10 0
HOUSE_NUM2 House number supplement AD_HSNM2 CHAR 10 0
HOUSE_NUM3 (Not supported) House Number Range AD_HSNM3 CHAR 10 0
STR_SUPPL1 Street 2 AD_STRSPP1 CHAR 40 0
STR_SUPPL2 Street 3 AD_STRSPP2 CHAR 40 0
STR_SUPPL3 Street 4 AD_STRSPP3 CHAR 40 0
LOCATION Street 5 AD_LCTN CHAR 40 0
BUILDING Building (Number or Code) AD_BLDNG CHAR 20 0
FLOOR Floor in building AD_FLOOR CHAR 10 0
ROOMNUMBER Room or Appartment Number AD_ROOMNUM CHAR 10 0
COUNTRY Country Key LAND1 T005 CHAR 3 0
LANGU Language Key SPRAS T002 LANG 1 0
REGION Region (State, Province, County) REGIO T005S CHAR 3 0
SORT1 Search Term 1 AD_SORT1UL CHAR 20 0
SORT2 Search Term 2 AD_SORT2UL CHAR 20 0
SORT_PHN (Not Supported) Phonetic Search Sort Field AD_SRTPHN CHAR 20 0
ADDRORIGIN (Not Supported) Address Data Source (Key) AD_ORIGINA TSAD6 CHAR 4 0
EXTENSION1 Extension (only for data conversion) (e.g. data line) AD_EXTENS1 CHAR 40 0
EXTENSION2 Extension (only for data conversion) (e.g. telebox) AD_EXTENS2 CHAR 40 0
TIME_ZONE Address time zone AD_TZONE TTZZ CHAR 6 0
TAXJURCODE Tax Jurisdiction AD_TXJCD CHAR 15 0
ADDRESS_ID (Not supported) Physical address ID AD_ADDR_ID CHAR 10 0
REMARK Address notes AD_REMARK1 CHAR 50 0
LANGU_CREA Address record creation original language AD_LANGUCR T002 LANG 1 0
PO_BOX_LOBBY PO Box Lobby AD_PO_BOX_LBY CHAR 40 0
DELI_SERV_TYPE Type of Delivery Service AD_DELIVERY_SERVICE_TYPE ADDRC_DELI_SERV CHAR 4 0
DELI_SERV_NUMBER Number of Delivery Service AD_DELIVERY_SERVICE_NUMBER CHAR 10 0
COUNTY_CODE County code for county AD_CNTYNUM ADRCOUNTY CHAR 8 0
COUNTY County AD_COUNTY CHAR 40 0
TOWNSHIP_CODE Township code for Township AD_TWSHPNUM ADRTOWNSHIP CHAR 8 0
TOWNSHIP Township AD_TOWNSHIP CHAR 40 0
DEFLT_COMM Communication Method (Key) (Business Address Services) AD_COMM TSAC CHAR 3 0
LANDX Country Name LANDX CHAR 15 0
NATIO Nationality NATIO CHAR 15 0
BEZEI Region AD_REGION CHAR 20 0
TEL_NUMBER First telephone no.: dialling code+number AD_TLNMBR1 CHAR 30 0
WT_SHORT_ADDR One-line short form of formatted address AD_LINE_S CHAR 80 0
FITYP Tax type J_1AFITP_D CHAR 2 0
STCDT Tax Number Type J_1ATOID CHAR 2 0
KUKLA Customer classification KUKLA CHAR 2 0
BAHNS Train station BAHNS CHAR 25 0
J_1KFREPRE Name of Representative REPRES CHAR 10 0
J_1KFTBUS Type of Business GESTYP CHAR 30 0
J_1KFTIND Type of Industry INDTYP CHAR 30 0
QSREC Vendor Recipient Type QSREC CHAR 2 0
WT_WTSTCD Withholding tax identification number WT_WTSTCD CHAR 16 0
WT_EXNR Exemption certificate number WT_EXNR CHAR 15 0
WT_EXRT Exemption rate WT_EXRT DEC 5 2
WT_EXDF Date on which exemption begins WT_EXDF DATS 8 0
WT_EXDT Date on which exemption ends WT_EXDT DATS 8 0
WT_WTEXRS Reason for exemption WT_WTEXRS CHAR 2 0
WT_WTAGT Indicator: Withholding tax agent? WT_WTAGT CHAR 1 0
X Yes
NULL No
WT_AGTDF Obligated to withhold tax from WT_AGTDF DATS 8 0
WT_AGTDT Obligated to withhold tax until WT_AGTDT DATS 8 0
QSZNR Certificate Number of the Withholding Tax Exemption (old WT) WT_QSZNR CHAR 10 0
QSZDT Validity Date for Wth/Tax Exemption Certificate (old WT) WT_QSZDT DATS 8 0
HBKID Short Key for a House Bank HBKID CHAR 5 0
COUNC County Code COUNC CHAR 3 0
CITYC City Code CITYC CHAR 4 0
RPMKR Regional Market RPMKR CHAR 5 0
GFORM Legal status GFORM CHAR 2 0
NIELS Nielsen ID NIELS CHAR 2 0
HWAER Reporting currency ( local or alternative ) WT_HWAER CUKY 5 0
WT_GROUP1 Grouping criterion WT_GROUP CHAR 10 0
DMBTR Gross amount in Reporting Currency WT_DMBTR CURR 15 2
WT_QSSHH Withholding Tax Base Amount in Reporting Currency WT_BASE_AMT CURR 15 2
WT_QBSHH Withholding Tax Amount in Reporting Currency WT_TAX_AMT CURR 15 2
WT_QSFHH Amount exempt from withholding tax (in reporting currency) WT_EXMP_AMT CURR 15 2
WT_TAXHH Tax Amount in Reporting Currency WT_HWSTE CURR 15 2
WT_AMEXCLVAT Net amount 2 = Invoice amount - VAT ( in Reporting currency) WT_EXCLVAT CURR 15 2
WT_AMRBASE WT base amount excluding taxes ( in reporting currency) WT_RBASE CURR 15 2
WT_AMREXMP Amount Exempt from WH Tax - VAT (in Reporting Currency) WT_REXMP CURR 15 2
SKNTO Cash discount amount in local currency WT_SKNTO CURR 15 2
PROFS Profession PROFS CHAR 30 0
CIIU Economic Code Activity CIIU CHAR 16 0
ADDITIONAL_INFO Additional Vendor information ADDITIONAL_INFO CHAR 1 0
BUPLA Business Place BUPLA CHAR 4 0
ALT_PAYEE Partner ID PARTNERNO CHAR 35 0
GB_CIS_SC_TRDNM Subcontractor's Trading Name GB_CIS_SC_TRDNM CHAR 64 0
GB_CIS_SC_FSNM Subcontractor's First Name GB_CIS_SC_FSNM CHAR 64 0
GB_CIS_SC_SCNM Subcontractor's Second Name GB_CIS_SC_SCNM CHAR 64 0
GB_CIS_SC_INTL Subcontractor's Last Name GB_CIS_SC_INTL CHAR 64 0
GB_CIS_SC_VFNNUM Verification Number GB_CIS_SC_VFNNUM CHAR 20 0
GB_CIS_SC_UTR Subcontractor's Unique Tax Reference (UTR) GB_CIS_SC_UTR CHAR 20 0
GB_CIS_SC_VFNSTS Sub contractor verification status GB_CIS_SC_VFNSTS CHAR 1 0
GB_CIS_SCNUM Numerical Character Field of Length 6 NUM6 NUMC 6 0
BE_BA_5060 Minimum Base Amount BE_MINBASE CURR 13 2
BE_BA_5061 Minimum Base Amount BE_MINBASE CURR 13 2
BE_BA_5062 Minimum Base Amount BE_MINBASE CURR 13 2
BE_BA_5063 Minimum Base Amount BE_MINBASE CURR 13 2
BE_CO_TOTAL Minimum Base Amount BE_MINBASE CURR 13 2
STENR Tax Number at Responsible Tax Authority STENR CHAR 18 0
KVERM Memo KVERM CHAR 30 0
BE_NIHIL Payment Indicator - Fiche- Belgium BE_NIHIL CHAR 1 0
KR_QSREC Vendor Recipient Type KR_QSREC CHAR 6 0
IE_CONTRACT_ID Contract identifier from Tax Authority IE_CONTRACT_ID INT4 10 0
IE_AMNT_UNDECL Amount Undeclared IE_AMNT_UNDECL CURR 13 2
IE_LST_PRTNR Last Partner Flag IE_LST_PRTNR CHAR 1 0
US_1099K_TRANS Number of transactions-1099K US_1099K_TRANS INT4 10 0

IDWTPARTNER foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
IDWTPARTNER ADDRORIGIN IDWTPARTNER ADDRORIGIN TSAD6 Source Address or Personal Data (Business Address Services) ORIGIN
IDWTPARTNER ADDRORIGIN * TSAD6 Source Address or Personal Data (Business Address Services) CLIENT
IDWTPARTNER BUKRS SYST MANDT T001 Company Codes MANDT
IDWTPARTNER BUKRS IDWTPARTNER BUKRS T001 Company Codes BUKRS
IDWTPARTNER CITYH_CODE * ADRCITY Postal cities CLIENT
IDWTPARTNER CITYH_CODE IDWTPARTNER COUNTRY ADRCITY Postal cities COUNTRY
IDWTPARTNER CITYH_CODE IDWTPARTNER CITYH_CODE ADRCITY Postal cities CITY_CODE
IDWTPARTNER CITYP_CODE * ADRCITYPRT Postal districts CLIENT
IDWTPARTNER CITYP_CODE IDWTPARTNER COUNTRY ADRCITYPRT Postal districts COUNTRY
IDWTPARTNER CITYP_CODE IDWTPARTNER CITY_CODE ADRCITYPRT Postal districts CITY_CODE
IDWTPARTNER CITYP_CODE IDWTPARTNER CITYP_CODE ADRCITYPRT Postal districts CITYP_CODE
IDWTPARTNER CITY_CODE IDWTPARTNER COUNTRY ADRCITY Postal cities COUNTRY
IDWTPARTNER CITY_CODE IDWTPARTNER CITY_CODE ADRCITY Postal cities CITY_CODE
IDWTPARTNER CITY_CODE * ADRCITY Postal cities CLIENT
IDWTPARTNER CITY_CODE2 * ADRCITY Postal cities CLIENT
IDWTPARTNER CITY_CODE2 IDWTPARTNER COUNTRY ADRCITY Postal cities COUNTRY
IDWTPARTNER CITY_CODE2 IDWTPARTNER CITY_CODE2 ADRCITY Postal cities CITY_CODE
IDWTPARTNER COUNTRY * T005 Countries MANDT
IDWTPARTNER COUNTRY IDWTPARTNER COUNTRY T005 Countries LAND1
IDWTPARTNER COUNTY_CODE IDWTPARTNER PO_BOX_CTY ADRCOUNTY County codes COUNTRY
IDWTPARTNER COUNTY_CODE IDWTPARTNER PO_BOX_REG ADRCOUNTY County codes REGION
IDWTPARTNER COUNTY_CODE IDWTPARTNER COUNTY_CODE ADRCOUNTY County codes COUNTY_CODE
IDWTPARTNER COUNTY_CODE SYST MANDT ADRCOUNTY County codes CLIENT
IDWTPARTNER DEFLT_COMM IDWTPARTNER DEFLT_COMM TSAC Communication Methods (Business Address Services) COMM_TYPE
IDWTPARTNER DELI_SERV_TYPE SYST MANDT ADDRC_DELI_SERV Address Service Types CLIENT
IDWTPARTNER DELI_SERV_TYPE IDWTPARTNER DELI_SERV_TYPE ADDRC_DELI_SERV Address Service Types DELI_SERV_TYPE
IDWTPARTNER DONT_USE_P IDWTPARTNER DONT_USE_P TSAD12 Reasons for Non-Delivery (Business Address Services) UNDELIVER
IDWTPARTNER DONT_USE_P SYST MANDT TSAD12 Reasons for Non-Delivery (Business Address Services) CLIENT
IDWTPARTNER DONT_USE_S SYST MANDT TSAD12 Reasons for Non-Delivery (Business Address Services) CLIENT
IDWTPARTNER DONT_USE_S IDWTPARTNER DONT_USE_S TSAD12 Reasons for Non-Delivery (Business Address Services) UNDELIVER
IDWTPARTNER LANGU IDWTPARTNER LANGU T002 Language Keys (Component BC-I18) SPRAS
IDWTPARTNER LANGU_CREA IDWTPARTNER LANGU_CREA T002 Language Keys (Component BC-I18) SPRAS
IDWTPARTNER PO_BOX_CTY * T005 Countries MANDT
IDWTPARTNER PO_BOX_CTY IDWTPARTNER PO_BOX_CTY T005 Countries LAND1
IDWTPARTNER PO_BOX_REG * T005S Taxes: Region (Province) Key MANDT
IDWTPARTNER PO_BOX_REG IDWTPARTNER PO_BOX_CTY T005S Taxes: Region (Province) Key LAND1
IDWTPARTNER PO_BOX_REG IDWTPARTNER PO_BOX_REG T005S Taxes: Region (Province) Key BLAND
IDWTPARTNER REGIOGROUP * ADRREGGRP Regional structure grouping CLIENT
IDWTPARTNER REGIOGROUP IDWTPARTNER REGIOGROUP ADRREGGRP Regional structure grouping REGIOGROUP
IDWTPARTNER REGION * T005S Taxes: Region (Province) Key MANDT
IDWTPARTNER REGION IDWTPARTNER COUNTRY T005S Taxes: Region (Province) Key LAND1
IDWTPARTNER REGION IDWTPARTNER REGION T005S Taxes: Region (Province) Key BLAND
IDWTPARTNER STREETABBR * ADRSTRTYPE Street type CLIENT
IDWTPARTNER STREETABBR IDWTPARTNER COUNTRY ADRSTRTYPE Street type COUNTRY
IDWTPARTNER STREETABBR IDWTPARTNER STREETABBR ADRSTRTYPE Street type STRTYPEAB
IDWTPARTNER STREETCODE IDWTPARTNER COUNTRY ADRSTREET Streets COUNTRY
IDWTPARTNER STREETCODE IDWTPARTNER STREETCODE ADRSTREET Streets STRT_CODE
IDWTPARTNER STREETCODE * ADRSTREET Streets CLIENT
IDWTPARTNER TIME_ZONE * TTZZ Time zones CLIENT
IDWTPARTNER TIME_ZONE IDWTPARTNER TIME_ZONE TTZZ Time zones TZONE
IDWTPARTNER TITLE * TSAD3 Forms of Address (Key) (Business Address Services) CLIENT
IDWTPARTNER TITLE IDWTPARTNER TITLE TSAD3 Forms of Address (Key) (Business Address Services) TITLE
IDWTPARTNER TOWNSHIP_CODE SYST MANDT ADRTOWNSHIP Township codes CLIENT
IDWTPARTNER TOWNSHIP_CODE IDWTPARTNER PO_BOX_CTY ADRTOWNSHIP Township codes COUNTRY
IDWTPARTNER TOWNSHIP_CODE IDWTPARTNER PO_BOX_REG ADRTOWNSHIP Township codes REGION
IDWTPARTNER TOWNSHIP_CODE IDWTPARTNER COUNTY_CODE ADRTOWNSHIP Township codes COUNTY_CODE
IDWTPARTNER TOWNSHIP_CODE IDWTPARTNER TOWNSHIP_CODE ADRTOWNSHIP Township codes TOWNSHIP_CODE
IDWTPARTNER TRANSPZONE IDWTPARTNER TRANSPZONE TZONE Customers: Regional zones ZONE1
IDWTPARTNER TRANSPZONE * TZONE Customers: Regional zones MANDT
IDWTPARTNER TRANSPZONE IDWTPARTNER COUNTRY TZONE Customers: Regional zones LAND1