SAP table IDWTPARTNER (Withholding Tax Type, Code, and Vendor/Customer Master Data)

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

IDWTPARTNER foreign key relationships

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