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

Dictionary Type: Structure
Description: Withholding Tax Type, Code, and Vendor/Customer Master Data




ABAP Code to SELECT data from IDWTPARTNER
Related tables to IDWTPARTNER
Access table IDWTPARTNER




Structure field list including key, data, relationships and ABAP select examples

IDWTPARTNER is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Withholding Tax Type, Code, and Vendor/Customer Master Data" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_IDWTPARTNER TYPE IDWTPARTNER.

The IDWTPARTNER table consists of various fields, each holding specific information or linking keys about Withholding Tax Type, Code, and Vendor/Customer Master Data data available in SAP. These include PARTNO_TYPE (Type of partner number), PARTNERNO (Partner ID), WT_PERIOD (Reporting Period), MONA (Posting date calendar month).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)


SAP IDWTPARTNER structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
PARTNO_TYPEType of partner number WT_PARTNO_TYPECHAR1WT_PARNO_TYPE
PARTNERNOPartner ID PARTNERNOCHAR35
WT_PERIODReporting Period WT_REPPERIODNUMC2
MONAPosting date calendar month BUMONNUMC2MONAT
WITHTIndicator for withholding tax type WITHTCHAR2Assigned to domainWITHT
WT_WITHCDWithholding tax code WT_WITHCDCHAR2Assigned to domainWT_WITHCD
QLANDWithholding Tax Country Key QLANDCHAR3Assigned to domainQLAND
QLTXTCountry for the Withholding Tax WT_QLTXTCHAR30TXT30
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
KUNNRCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
PARTNER_SEQ_NBPartner sequential number on Withholding Tax lists PARTNER_SEQ_NBNUMC6
TEXT40Description of Withholding tax type for Ext. WT WT_TYPE_DESCCHAR40TEXT40
WT_TYPECODE_TEXTDescription of Wth/Tax Type + code for Ext. WT WT_TYPE_CODE_DESCCHAR40TEXT40
QSCODOfficial Withholding Tax Key WT_OWTCDCHAR4Assigned to domainWT_OWTCD
WT_OFFWT_TEXTText of the Official Withholding Tax Code WT_OFFWT_TEXTCHAR40TEXT40
TAX_REGIONTax Region Code for Withholding Tax Code TAX_REGIOCHAR3Assigned to domainREGIO
TAX_REGION_NUMOfficial numerical state code WT_REGIO_NUMCHAR3FPRCD
TAX_REGION_TXTTax Region Name for Wtihholding Tax Code TAX_REGION_TXTCHAR20
CTNUMBERWithholding Tax Certificate Number CTNUMBERCHAR10CHAR10
WT_POSTMPosting time WT_POSTMCHAR1WT_POSTM
WT_POSINPosting indicator WT_POSINCHAR1WT_POSIN
FPRCDProvincial tax code FPRCDCHAR3FPRCD
QEKARIncome Type QEKARCHAR4Assigned to domainQEKAR
EATXTDescription of the income type WT_INCOME_TYPE_DESCCHAR40TXT40
XQFORIndicator: Calculate withholding tax according to formula? XQFORCHAR1XFELD
QPROZPercentage Subject to Withholding Tax QPROZDEC5(2) PRZ32
QSATZWithholding tax rate WT_QSATZDEC7(4) PRZ34
QSATRReduced withholding tax rate WT_QSATRDEC7(4) PRZ34
SORTLSort field SORTLCHAR10CHAR10
SPRASLanguage Key SPRASLANG1Assigned to domainISOLASPRASSPRH_T002
BRSCHIndustry key BRSCHCHAR4Assigned to domainBRSCH
STCD1Tax Number 1 STCD1CHAR16STCD1
STCD2Tax Number 2 STCD2CHAR11STCD2
STCD3Tax Number 3 STCD3CHAR18CHAR18
STCD4Tax Number 4 STCD4CHAR18CHAR18
GBDATDate of birth of the person subject to withholding tax GBDAT_QDATS8DATUM
GBORTPlace of birth of the person subject to withholding tax GBORT_QCHAR25TEXT25
SEXKZKey for the Sex of the Person Subject to Withholding Tax SEXKZCHAR1SEXKZ
STKZNNatural Person STKZNCHAR1STKZN
STKZULiable for VAT STKZUCHAR1XFELD
VBUNDCompany ID of trading partner RASSCCHAR6Assigned to domainALPHARCOMPPGS
STCEGVAT Registration Number STCEGCHAR20STCEG
TXJCDTax Jurisdiction TXJCDCHAR15Assigned to domainTXJCDTXJ
WERKSPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
DTAMSIndicator for Data Medium Exchange DTAMSCHAR1DTAMS
ADDRNUMBERAddress number AD_ADDRNUMCHAR10Assigned to domainALPHAAD_ADDRNUMADR
DATE_FROMValid-from date - in current Release only 00010101 possible AD_DATE_FRDATS8DATUM
DATE_TOValid-to date in current Release only 99991231 possible AD_DATE_TODATS8DATUM
TITLEForm-of-Address Key AD_TITLECHAR4TSAD3AD_TITLE
NAME1Name 1 AD_NAME1CHAR40TEXT40
NAME2Name 2 AD_NAME2CHAR40TEXT40
NAME3Name 3 AD_NAME3CHAR40TEXT40
NAME4Name 4 AD_NAME4CHAR40TEXT40
NAME_TXTConverted name field (with form of address) AD_NAMETXTCHAR50TEXT50
NAME_COc/o name AD_NAME_COCHAR40TEXT40
CITY1City AD_CITY1CHAR40TEXT40CLCITYNAME
CITY2District AD_CITY2CHAR40TEXT40CITY_PART
CITY_CODECity code for city/street file AD_CITYNUMCHAR12ADRCITYALPHACITY_CODE
CITYP_CODEDistrict code for City and Street file AD_CITYPNMCHAR8ADRCITYPRTALPHACITYP_CODE
HOME_CITYCity (different from postal city) AD_CITY3CHAR40TEXT40
CITYH_CODEDifferent city for city/street file AD_CITYHNMCHAR12ADRCITYALPHACITY_CODE
CHCKSTATUSCity file test status AD_CHECKSTCHAR1AD_CHECKST
REGIOGROUPRegional structure grouping REGIOGROUPCHAR8ADRREGGRPREGIOGROUP
POST_CODE1City postal code AD_PSTCD1CHAR10CHAR10
POST_CODE2PO Box Postal Code AD_PSTCD2CHAR10CHAR10
POST_CODE3Company Postal Code (for Large Customers) AD_PSTCD3CHAR10CHAR10
PCODE1_EXT(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code AD_PST1XTCHAR10CHAR10
PCODE2_EXT(Not Supported) PO Box Postal Code Extension AD_PST2XTCHAR10CHAR10
PCODE3_EXT(Not Supported) Major Customer Postal Code Extension AD_PST3XTCHAR10CHAR10
PO_BOXPO Box AD_POBXCHAR10CHAR10
DONT_USE_PPO Box Address Undeliverable Flag AD_NO_USEPCHAR4TSAD12AD_NO_USE
PO_BOX_NUMFlag: PO Box Without Number AD_POBXNUMCHAR1XFELD
PO_BOX_LOCPO Box city AD_POBXLOCCHAR40TEXT40CITY_NAME
CITY_CODE2City PO box code (City file) AD_CIT2NUMCHAR12ADRCITYALPHACITY_CODE
PO_BOX_REGRegion for PO Box (Country, State, Province, ...) AD_POBXREGCHAR3T005SREGIO
PO_BOX_CTYPO box country AD_POBXCTYCHAR3T005LAND1
POSTALAREA(Not Supported) Post Delivery District AD_PSTLARCHAR15TEXT15
TRANSPZONETransportation zone to or from which the goods are delivered LZONECHAR10TZONEZONE
STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
DONT_USE_SStreet Address Undeliverable Flag AD_NO_USESCHAR4TSAD12AD_NO_USE
STREETCODEStreet Number for City/Street File AD_STRNUMCHAR12ADRSTREETALPHASTRT_CODE
STREETABBR(Not Supported) Abbreviation of Street Name AD_STRABBRCHAR2ADRSTRTYPESTRTYPEAB
HOUSE_NUM1House Number AD_HSNM1CHAR10TEXT10
HOUSE_NUM2House number supplement AD_HSNM2CHAR10TEXT10
HOUSE_NUM3(Not supported) House Number Range AD_HSNM3CHAR10TEXT10
STR_SUPPL1Street 2 AD_STRSPP1CHAR40TEXT40
STR_SUPPL2Street 3 AD_STRSPP2CHAR40TEXT40
STR_SUPPL3Street 4 AD_STRSPP3CHAR40TEXT40
LOCATIONStreet 5 AD_LCTNCHAR40TEXT40
BUILDINGBuilding (Number or Code) AD_BLDNGCHAR20TEXT20
FLOORFloor in building AD_FLOORCHAR10TEXT10
ROOMNUMBERRoom or Appartment Number AD_ROOMNUMCHAR10TEXT10
COUNTRYCountry Key LAND1CHAR3T005LAND1LND
LANGULanguage Key SPRASLANG1T002ISOLASPRASSPRH_T002
REGIONSTATE (State, Province, County) REGIOCHAR3T005SREGIO
SORT1Search Term 1 AD_SORT1ULCHAR20TEXT20
SORT2Search Term 2 AD_SORT2ULCHAR20TEXT20
SORT_PHN(Not Supported) Phonetic Search Sort Field AD_SRTPHNCHAR20CHAR20
ADDRORIGIN(Not Supported) Address Data Source (Key) AD_ORIGINACHAR4TSAD6AD_ORIGIN
EXTENSION1Extension (only for data conversion) (e.g. data line) AD_EXTENS1CHAR40TEXT40
EXTENSION2Extension (only for data conversion) (e.g. telebox) AD_EXTENS2CHAR40TEXT40
TIME_ZONEAddress time zone AD_TZONECHAR6TTZZTZNZONE
TAXJURCODETax Jurisdiction AD_TXJCDCHAR15AD_TXJCDTXJ
ADDRESS_ID(Not supported) Physical address ID AD_ADDR_IDCHAR10ALPHAAD_ADDR_ID
REMARKAddress notes AD_REMARK1CHAR50TEXT50
LANGU_CREAAddress record creation original language AD_LANGUCRLANG1T002ISOLASPRAS
PO_BOX_LOBBYPO Box Lobby AD_PO_BOX_LBYCHAR40TEXT40
DELI_SERV_TYPEType of Delivery Service AD_DELIVERY_SERVICE_TYPECHAR4ADDRC_DELI_SERVAD_DELIVERY_SERVICE_TYPE
DELI_SERV_NUMBERNumber of Delivery Service AD_DELIVERY_SERVICE_NUMBERCHAR10CHAR10
COUNTY_CODECounty code for county AD_CNTYNUMCHAR8ADRCOUNTYALPHACNTY_CODE
COUNTYCounty AD_COUNTYCHAR40TEXT40CLTCNTYNAME
TOWNSHIP_CODETownship code for Township AD_TWSHPNUMCHAR8ADRTOWNSHIPALPHATWSHP_CODE
TOWNSHIPTownship AD_TOWNSHIPCHAR40TEXT40CLTWSHPNAME
DEFLT_COMMCommunication Method (Key) (Business Address Services) AD_COMMCHAR3TSACAD_COMM
LANDXCountry Name LANDXCHAR15TEXT15
NATIONationality NATIOCHAR15TEXT15
BEZEIRegion AD_REGIONCHAR20TEXT20
TEL_NUMBERFirst telephone no.: dialling code+number AD_TLNMBR1CHAR30CHAR30
WT_SHORT_ADDROne-line short form of formatted address AD_LINE_SCHAR80CHAR80
FITYPTax type J_1AFITP_DCHAR2Assigned to domainJ_1AFITP
STCDTTax Number Type J_1ATOIDCHAR2Assigned to domainJ_1ATOID
KUKLACustomer classification KUKLACHAR2Assigned to domainKUKLA
BAHNSTrain station BAHNSCHAR25BAHNH
J_1KFREPREName of Representative REPRESCHAR10REPRES
J_1KFTBUSType of Business GESTYPCHAR30Assigned to domainGESTYP
J_1KFTINDType of Industry INDTYPCHAR30Assigned to domainINDTYP
QSRECVendor Recipient Type QSRECCHAR2Assigned to domainQSREC
WT_WTSTCDWithholding tax identification number WT_WTSTCDCHAR16STCD1
WT_EXNRExemption certificate number WT_EXNRCHAR15CHAR15
WT_EXRTExemption rate WT_EXRTDEC5(2) PRZ32
WT_EXDFDate on which exemption begins WT_EXDFDATS8WT_START
WT_EXDTDate on which exemption ends WT_EXDTDATS8WT_END
WT_WTEXRSReason for exemption WT_WTEXRSCHAR2Assigned to domainWT_WTEXRS
WT_WTAGTIndicator: Withholding tax agent? WT_WTAGTCHAR1XFELD
WT_AGTDFObligated to withhold tax from WT_AGTDFDATS8WT_START
WT_AGTDTObligated to withhold tax until WT_AGTDTDATS8WT_END
QSZNRCertificate Number of the Withholding Tax Exemption (old WT) WT_QSZNRCHAR10CHAR10
QSZDTValidity Date for Wth/Tax Exemption Certificate (old WT) WT_QSZDTDATS8DATUM
HBKIDShort Key for a House Bank HBKIDCHAR5Assigned to domainHBKID
COUNCCounty Code COUNCCHAR3Assigned to domainCOUNC
CITYCCity Code CITYCCHAR4Assigned to domainCITYC
RPMKRRegional Market RPMKRCHAR5RPMKR
GFORMLegal status GFORMCHAR2Assigned to domainGFORM
NIELSNielsen ID NIELSCHAR2Assigned to domainNIELS
HWAERReporting currency ( local or alternative ) WT_HWAERCUKY5Assigned to domainWAERS
WT_GROUP1Grouping criterion WT_GROUPCHAR10CHAR10
DMBTRGross amount in Reporting Currency WT_DMBTRCURR15(2) WERT8
WT_QSSHHWithholding Tax Base Amount in Reporting Currency WT_BASE_AMTCURR15(2) WERTV8
WT_QBSHHWithholding Tax Amount in Reporting Currency WT_TAX_AMTCURR15(2) WERTV8
WT_QSFHHAmount exempt from withholding tax (in reporting currency) WT_EXMP_AMTCURR15(2) WERTV8
WT_TAXHHTax Amount in Reporting Currency WT_HWSTECURR15(2) WERT8
WT_AMEXCLVATNet amount 2 = Invoice amount - VAT ( in Reporting currency) WT_EXCLVATCURR15(2) WERTV8
WT_AMRBASEWT base amount excluding taxes ( in reporting currency) WT_RBASECURR15(2) WERTV8
WT_AMREXMPAmount Exempt from WH Tax - VAT (in Reporting Currency) WT_REXMPCURR15(2) WERTV8
SKNTOCash discount amount in local currency WT_SKNTOCURR15(2) WERT8
PROFSProfession PROFSCHAR30TEXT30
CIIUEconomic Code Activity CIIUCHAR16CHAR16
ADDITIONAL_INFOAdditional Vendor information ADDITIONAL_INFOCHAR1CHAR1
BUPLABusiness Place BUPLACHAR4Assigned to domainJ_1BBRANCH
ALT_PAYEEPartner ID PARTNERNOCHAR35
GB_CIS_SC_TRDNMSubcontractor's Trading Name GB_CIS_SC_TRDNMCHAR64CHAR64
GB_CIS_SC_FSNMSubcontractor's First Name GB_CIS_SC_FSNMCHAR64CHAR64
GB_CIS_SC_SCNMSubcontractor's Second Name GB_CIS_SC_SCNMCHAR64CHAR64
GB_CIS_SC_INTLSubcontractor's Last Name GB_CIS_SC_INTLCHAR64CHAR64
GB_CIS_SC_VFNNUMVerification Number GB_CIS_SC_VFNNUMCHAR20CHAR20
GB_CIS_SC_UTRSubcontractor's Unique Tax Reference (UTR) GB_CIS_SC_UTRCHAR20CHAR20
GB_CIS_SC_VFNSTSSub contractor verification status GB_CIS_SC_VFNSTSCHAR1CHAR1
GB_CIS_SCNUMNumerical Character Field of Length 6 NUM6NUMC6NUM06
BE_BA_5060Minimum Base Amount BE_MINBASECURR13(2) BE_MINBASE
BE_BA_5061Minimum Base Amount BE_MINBASECURR13(2) BE_MINBASE
BE_BA_5062Minimum Base Amount BE_MINBASECURR13(2) BE_MINBASE
BE_BA_5063Minimum Base Amount BE_MINBASECURR13(2) BE_MINBASE
BE_CO_TOTALMinimum Base Amount BE_MINBASECURR13(2) BE_MINBASE
STENRTax Number at Responsible Tax Authority STENRCHAR18CHAR18
KVERMMemo KVERMCHAR30TEXT30
BE_NIHILPayment Indicator - Fiche- Belgium BE_NIHILCHAR1
KR_QSRECVendor Recipient Type KR_QSRECCHAR6KR_QSREC
IE_CONTRACT_IDContract identifier from Tax Authority IE_CONTRACT_IDINT410INT4
IE_AMNT_UNDECLAmount Undeclared IE_AMNT_UNDECLCURR13(2)
IE_LST_PRTNRLast Partner Flag IE_LST_PRTNRCHAR1
US_1099K_TRANSNumber of transactions-1099K US_1099K_TRANSINT410

Key field Non-key field



How do I retrieve data from SAP structure IDWTPARTNER using ABAP code?

As IDWTPARTNER is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on IDWTPARTNER as there is no data to select.

How to access SAP table IDWTPARTNER

Within an ECC or HANA version of SAP you can also view further information about IDWTPARTNER and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!