SAP ABAP Table IDWTCOMPCD (Company Code and Country Data for Withholding Tax Report)
Hierarchy
☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-LOC (Application Component) Localization
     ⤷ ID-FI-WT (Package) Withholding Tax reporting
Basic Data
Table Category INTTAB    Structure 
Structure IDWTCOMPCD   Table Relationship Diagram
Short Description Company Code and Country Data for Withholding Tax Report    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 BUKRS BUKRS BUKRS CHAR 4   0   Company Code *
2 BUPLA BUPLA J_1BBRANCH CHAR 4   0   Business Place *
3 BUTXT BUTXT TEXT25 CHAR 25   0   Name of Company Code or Company  
4 WT_NEWWT WT_NEWWT XFELD CHAR 1   0   Indicator: Extended withholding tax active  
5 STCEG STCEG STCEG CHAR 20   0   VAT Registration Number  
6 WT_TAXREF1_VAL WT_REFV1 TEXT48 CHAR 48   0   Company ( or Business place ) Tax reference 1  
7 WT_TAXREF2_VAL WT_REFV2 TEXT48 CHAR 48   0   Company ( or business place ) Tax reference 2  
8 WT_EDIREF_VAL WT_EDIREF TEXT48 CHAR 48   0   EDI reference of the company for Withholding tax reporting  
9 KTOPL KTOPL KTOPL CHAR 4   0   Chart of Accounts *
10 KR_REPRES REPRES REPRES CHAR 10   0   Name of Representative  
11 KR_TAXOFF TAXOFF TAXOFF CHAR 3   0   District Tax Office *
12 KR_TAXOFF_NAME OFFICENAME TEXT40 CHAR 40   0   Name of Tax Office  
13 .INCLUDE       0   0   Address of Company, Business Place, and Vendor or Customer  
14 ADDRNUMBER AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
15 .INCLUDE       0   0   Address transfer structure  
16 DATE_FROM AD_DATE_FR DATUM DATS 8   0   Valid-from date - in current Release only 00010101 possible  
17 DATE_TO AD_DATE_TO DATUM DATS 8   0   Valid-to date in current Release only 99991231 possible  
18 .INCLUDE       0   0   Include structure with name attributes of the ADRC address  
19 TITLE AD_TITLE AD_TITLE CHAR 4   0   Form-of-Address Key TSAD3
20 NAME1 AD_NAME1 TEXT40 CHAR 40   0   Name 1  
21 NAME2 AD_NAME2 TEXT40 CHAR 40   0   Name 2  
22 NAME3 AD_NAME3 TEXT40 CHAR 40   0   Name 3  
23 NAME4 AD_NAME4 TEXT40 CHAR 40   0   Name 4  
24 NAME_TXT AD_NAMETXT TEXT50 CHAR 50   0   Converted name field (with form of address)  
25 .INCLUDE       0   0   Include structure with ADRC attributes without name fields  
26 NAME_CO AD_NAME_CO TEXT40 CHAR 40   0   c/o name  
27 CITY1 AD_CITY1 TEXT40 CHAR 40   0   City  
28 CITY2 AD_CITY2 TEXT40 CHAR 40   0   District  
29 CITY_CODE AD_CITYNUM CITY_CODE CHAR 12   0   City code for city/street file ADRCITY
30 CITYP_CODE AD_CITYPNM CITYP_CODE CHAR 8   0   District code for City and Street file ADRCITYPRT
31 HOME_CITY AD_CITY3 TEXT40 CHAR 40   0   City (different from postal city)  
32 CITYH_CODE AD_CITYHNM CITY_CODE CHAR 12   0   Different city for city/street file ADRCITY
33 CHCKSTATUS AD_CHECKST AD_CHECKST CHAR 1   0   City file test status  
34 REGIOGROUP REGIOGROUP REGIOGROUP CHAR 8   0   Regional structure grouping ADRREGGRP
35 POST_CODE1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
36 POST_CODE2 AD_PSTCD2 CHAR10 CHAR 10   0   PO Box postal code  
37 POST_CODE3 AD_PSTCD3 CHAR10 CHAR 10   0   Company postal code (for large customers)  
38 PCODE1_EXT AD_PST1XT CHAR10 CHAR 10   0   (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code  
39 PCODE2_EXT AD_PST2XT CHAR10 CHAR 10   0   (Not Supported) PO Box Postal Code Extension  
40 PCODE3_EXT AD_PST3XT CHAR10 CHAR 10   0   (Not Supported) Major Customer Postal Code Extension  
41 PO_BOX AD_POBX CHAR10 CHAR 10   0   PO Box  
42 DONT_USE_P AD_NO_USEP AD_NO_USE CHAR 4   0   PO Box Address Undeliverable Flag TSAD12
43 PO_BOX_NUM AD_POBXNUM XFELD CHAR 1   0   Flag: PO Box without number  
44 PO_BOX_LOC AD_POBXLOC TEXT40 CHAR 40   0   PO Box city  
45 CITY_CODE2 AD_CIT2NUM CITY_CODE CHAR 12   0   City PO box code (City file) ADRCITY
46 PO_BOX_REG AD_POBXREG REGIO CHAR 3   0   Region for PO Box (Country, State, Province, ...) T005S
47 PO_BOX_CTY AD_POBXCTY LAND1 CHAR 3   0   PO box country T005
48 POSTALAREA AD_PSTLAR TEXT15 CHAR 15   0   (Not Supported) Post Delivery District  
49 TRANSPZONE LZONE ZONE CHAR 10   0   Transportation zone to or from which the goods are delivered TZONE
50 STREET AD_STREET TEXT60 CHAR 60   0   Street  
51 DONT_USE_S AD_NO_USES AD_NO_USE CHAR 4   0   Street Address Undeliverable Flag TSAD12
52 STREETCODE AD_STRNUM STRT_CODE CHAR 12   0   Street Number for City/Street File ADRSTREET
53 STREETABBR AD_STRABBR STRTYPEAB CHAR 2   0   (Not Supported) Abbreviation of Street Name ADRSTRTYPE
54 HOUSE_NUM1 AD_HSNM1 TEXT10 CHAR 10   0   House Number  
55 HOUSE_NUM2 AD_HSNM2 TEXT10 CHAR 10   0   House number supplement  
56 HOUSE_NUM3 AD_HSNM3 TEXT10 CHAR 10   0   (Not supported) House Number Range  
57 STR_SUPPL1 AD_STRSPP1 TEXT40 CHAR 40   0   Street 2  
58 STR_SUPPL2 AD_STRSPP2 TEXT40 CHAR 40   0   Street 3  
59 STR_SUPPL3 AD_STRSPP3 TEXT40 CHAR 40   0   Street 4  
60 LOCATION AD_LCTN TEXT40 CHAR 40   0   Street 5  
61 BUILDING AD_BLDNG TEXT20 CHAR 20   0   Building (Number or Code)  
62 FLOOR AD_FLOOR TEXT10 CHAR 10   0   Floor in building  
63 ROOMNUMBER AD_ROOMNUM TEXT10 CHAR 10   0   Room or Appartment Number  
64 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key T005
65 LANGU SPRAS SPRAS LANG 1   0   Language Key T002
66 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
67 SORT1 AD_SORT1UL TEXT20 CHAR 20   0   Search Term 1  
68 SORT2 AD_SORT2UL TEXT20 CHAR 20   0   Search Term 2  
69 SORT_PHN AD_SRTPHN CHAR20 CHAR 20   0   (Not Supported) Phonetic Search Sort Field  
70 ADDRORIGIN AD_ORIGINA AD_ORIGIN CHAR 4   0   (Not Supported) Address Data Source (Key) TSAD6
71 EXTENSION1 AD_EXTENS1 TEXT40 CHAR 40   0   Extension (only for data conversion) (e.g. data line)  
72 EXTENSION2 AD_EXTENS2 TEXT40 CHAR 40   0   Extension (only for data conversion) (e.g. telebox)  
73 TIME_ZONE AD_TZONE TZNZONE CHAR 6   0   Address time zone TTZZ
74 TAXJURCODE AD_TXJCD AD_TXJCD CHAR 15   0   Tax Jurisdiction  
75 ADDRESS_ID AD_ADDR_ID AD_ADDR_ID CHAR 10   0   (Not supported) Physical address ID  
76 REMARK AD_REMARK1 TEXT50 CHAR 50   0   Address notes  
77 LANGU_CREA AD_LANGUCR SPRAS LANG 1   0   Address record creation original language T002
78 PO_BOX_LOBBY AD_PO_BOX_LBY TEXT40 CHAR 40   0   PO Box Lobby  
79 DELI_SERV_TYPE AD_DELIVERY_SERVICE_TYPE AD_DELIVERY_SERVICE_TYPE CHAR 4   0   Type of Delivery Service ADDRC_DELI_SERV
80 DELI_SERV_NUMBER AD_DELIVERY_SERVICE_NUMBER CHAR10 CHAR 10   0   Number of Delivery Service  
81 COUNTY_CODE AD_CNTYNUM CNTY_CODE CHAR 8   0   County code for county ADRCOUNTY
82 COUNTY AD_COUNTY TEXT40 CHAR 40   0   County  
83 TOWNSHIP_CODE AD_TWSHPNUM TWSHP_CODE CHAR 8   0   Township code for Township ADRTOWNSHIP
84 TOWNSHIP AD_TOWNSHIP TEXT40 CHAR 40   0   Township  
85 DEFLT_COMM AD_COMM AD_COMM CHAR 3   0   Communication Method (Key) (Business Address Services) TSAC
86 LANDX LANDX TEXT15 CHAR 15   0   Country Name  
87 NATIO NATIO TEXT15 CHAR 15   0   Nationality  
88 BEZEI AD_REGION TEXT20 CHAR 20   0   Region  
89 TEL_NUMBER AD_TLNMBR1 CHAR30 CHAR 30   0   First telephone no.: dialling code+number  
90 TXTID TXTID_001G TXTID_001G CHAR 2   0   Sender Variant *
91 TXTKO TXTKO_001G TDFORMNEW CHAR 16   0   Header Text Name in Word Processing  
92 TXTFU TXTFU_001G TDFORMNEW CHAR 16   0   Footer Text Name in Word Processing  
93 TXTUN TXTUN_001G TDFORMNEW CHAR 16   0   Text Name for the Signature  
94 TXTAB TXTAB_001G TDFORMNEW CHAR 16   0   Text Name for the Sender Details in the Letter Window  
95 WT_GROUP1 WT_GROUP CHAR10 CHAR 10   0   Grouping criterion  
96 WAERS WT_HWAER WAERS CUKY 5   0   Reporting currency ( local or alternative ) *
97 DMBTR WT_DMBTR WERT8 CURR 15   2   Gross amount in Reporting Currency  
98 WT_QSSHH WT_BASE_AMT WERTV8 CURR 15   2   Withholding Tax Base Amount in Reporting Currency  
99 WT_QBSHH WT_TAX_AMT WERTV8 CURR 15   2   Withholding Tax Amount in Reporting Currency  
100 WT_QSFHH WT_EXMP_AMT WERTV8 CURR 15   2   Amount exempt from withholding tax (in reporting currency)  
101 WT_TAXHH WT_HWSTE WERT8 CURR 15   2   Tax Amount in Reporting Currency  
102 WT_AMEXCLVAT WT_EXCLVAT WERTV8 CURR 15   2   Net amount 2 = Invoice amount - VAT ( in Reporting currency)  
103 WT_AMRBASE WT_RBASE WERTV8 CURR 15   2   WT base amount excluding taxes ( in reporting currency)  
104 WT_AMREXMP WT_REXMP WERTV8 CURR 15   2   Amount Exempt from WH Tax - VAT (in Reporting Currency)  
105 SKNTO WT_SKNTO WERT8 CURR 15   2   Cash discount amount in local currency  
106 .INCLUDE       0   0   Additional Comapny code specifc fields for WT Reporting  
107 .INCLUDE       0   0   Additional Company Code Specific Data for CIS Reporting (GB)  
108 GB_CIS_WTAOR WT_WTAOR CHAR50 CHAR 50   0   Account Office Reference for CIS Reporting Comp Code  
109 GB_CIS_WTTOR WT_WTTOR CHAR25 CHAR 25   0   Tax office Reference Number for Contractor (PAYE Reference)  
110 GB_CIS_WTTON WT_WTTON CHAR10 CHAR 10   0   Tax Office Number for contractor (reporting company code)  
111 GB_CIS_WTCER WT_WTCER CHAR50 CHAR 50   0   Contractor's Employer Reference  
112 GB_CIS_WTUTR WT_WTUTR CHAR50 CHAR 50   0   Universal Tax Referen  
113 GB_CIS_SNDRID WT_SENDRID WT_SNDRENUM CHAR 30   0   Sender Id  
114 GB_CIS_AUTHVAL WT_AUTHVAL WT_SNDRENUM CHAR 30   0   password  
115 GB_CIS_SNDRENUM WT_SNDRENUM WT_SNDRENUM CHAR 30   0   SENDER ENUMERATION  
116 .INCLUDE       0   0   Additional Company Code Specific Data for WT Reporting (BE)  
117 BE_TAXID1 BE_TAX_ID BE_TAX_ID CHAR 2   0   Tax Identification Number for Belgium  
118 BE_TAXID2 BE_TAX_ID BE_TAX_ID CHAR 2   0   Tax Identification Number for Belgium  
119 BE_CONTACT_ID BE_CONTACT_ID BE_CONTACT_ID CHAR 34   0   Contact Person Name  
120 BE_CONTACT_EM BE_CONTACT_EM BE_CONTACT_EM CHAR 44   0   Email Address of the Contact Person  
121 BE_MINBASE BE_MINBASE BE_MINBASE CURR 13   2   Minimum Base Amount  
122 BE_REPORTYEAR BE_REPORTYEAR BE_REPORTYEAR NUMC 4   0   Reporting Year in the Withholding Tax Return  
123 BE_SEQ_NUM BE_SEQ_NUM   CHAR 4   0   Sequential Number for Fiche - Belgium  
124 BE_CORR_INDICATOR BE_CORR_INDICATOR BE_CORR_INDICATOR CHAR 1   0   Correction Indicator for Withholding Tax Return  
125 BE_TEST_RUN BE_TEST_RUN   CHAR 1   0   Test Run Indicator - Belgium  
126 BE_CORR_REFERENCE BE_CORR_REFERENCE BE_CORR_REFERENCE CHAR 6   0   Reference Number for the Correction  
127 BE_NIHIL BE_NIHIL   CHAR 1   0   Payment Indicator - Fiche- Belgium  
128 BE_HWAER WT_HWAER WAERS CUKY 5   0   Reporting currency ( local or alternative ) *
129 BE_REPORTDATE DATUM DATUM DATS 8   0   Date  
130 BE_R8010_REC BE_REC_LEN   NUMC 8   0   Number of Records  
131 BE_R9010_REC BE_REC_LEN   NUMC 8   0   Number of Records  
132 BE_R9011_TOTREC BE_REC_LEN   NUMC 8   0   Number of Records  
133 BE_SEND_STREET AD_STREET TEXT60 CHAR 60   0   Street  
134 BE_SEND_STR_NO AD_STRNUM STRT_CODE CHAR 12   0   Street Number for City/Street File *
135 BE_SEND_POCODE BE_SEND_POCODE   CHAR 4   0   Sender Postal Code  
136 BE_SEND_CITY AD_CITY1 TEXT40 CHAR 40   0   City  
137 BE_SEND_NAME BE_SEND_NAME BE_SEND_NAME CHAR 40   0   Sender's Name  
138 BE_SEND_ENT_NO BE_SEND_ENTNO BE_SEND_ENTNO CHAR 10   0   Sender Enterprise Number  
139 BE_GEN_INFO_HDR BE_GEN_INFO_HDR   CHAR 35   0   BE General Information Header  
140 BE_SEND_INFO_HDR BE_SEND_INFO_HDR   CHAR 35   0   BE Sender Information Header  
141 BE_DIVISION BE_DIVISION   CHAR 35   0   Division Code  
142 BE_DIVISION_HDR BE_DIVISION_HDR   CHAR 35   0   BE Division Header Information  
143 BE_SEND_TEL_NO AD_TLNMBR1 CHAR30 CHAR 30   0   First telephone no.: dialling code+number  
144 BE_NR_INTERVAL BE_NR_INTERVAL   CHAR 2   0   Sender Number Range Interval  
145 BE_SPRAS BE_SPRAS   CHAR 1   0   Language of Sender Company  
146 BE_QLAND BE_QLAND   CHAR 5   0   Belgium Sender Country Key  
147 BE_MIN_9314 BE_MINBASE BE_MINBASE CURR 13   2   Minimum Base Amount  
148 .INCLUDE       0   0   Additional Company Code Specific Data for WT Reporting (FR)  
149 FR_MIN_AMT FR_MIN_AMT FR_MIN_AMT CURR 13   2   Minimum Amount for Partner (FR)  
150 FR_GEN_INFO_HDR FR_GEN_INFO_HDR   CHAR 35   0   FR General Information Header  
151 FR_HWAER WT_HWAER WAERS CUKY 5   0   Reporting currency ( local or alternative ) *
152 FR_CONTACT_NAME FR_CONTACT_NAME CHAR50 CHAR 50   0   Name of Contact Person (FR)  
153 FR_CONTACT_EM FR_CONTACT_EM FR_CONTACT_EM CHAR 60   0   Email Address of Contact Person (FR)  
154 .INCLUDE       0   0   Additional Company Code Specific Data for WT Reporting (VE)  
155 VE_COMPCD_RIF PAVAL TEXT48 CHAR 48   0   Parameter value  
156 VE_PERIOD CHAR6 CHAR6 CHAR 6   0   Character field of length 6  
157 VE_HR_INDICATOR XFELD XFELD CHAR 1   0   Checkbox  
158 .INCLUDE       0   0   Additional Company Code Specific Data for WT Reporting (TH)  
159 TH_SUB_NATURE TH_SUB_NATURE TH_SUB_NATURE CHAR 1   0   Submit Nature for withholding tax  
160 TH_SUB_NO TH_SUB_NO   NUMC 3   0   Submit Number  
161 TH_ADD_SUB TH_ADD_SUB XFELD CHAR 1   0   Additional Submission Indicator  
162 TH_PAYT_DATE TH_PAYT_DATE DATUM DATS 8   0   Overwrite Payment Date  
163 TH_BRANCH TH_BRANCH   CHAR 5   0   Official branch code Thailand  
164 TH_PAYER TH_PAYER TH_PAYER NUMC 1   0   Tax Payer type  
165 .INCLUDE       0   0   Additional Company Code Specific Data for WT Reporting (IE)  
166 IE_GEN_INFO_HDR IE_GEN_INFO_HDR   CHAR 35   0   BE General Information Header  
167 IE_DUEDATE IE_DUEDATE   DATS 8   0   Due Date  
168 IE_RTYPE IE_RTYPE IE_RTYPE CHAR 6   0   Return Type  
169 IE_AMNT_DECL WT_BASE_AMT WERTV8 CURR 15   2   Withholding Tax Base Amount in Reporting Currency  
170 IE_AMNT_UNDECL IE_AMNT_UNDECL   CURR 13   2   Amount Undeclared  
171 IE_FILED_STATUS IE_FILED_STATUS   CHAR 17   0   Filed Status  
172 IE_BUKRS_TITLE AD_TITLETX TEXT30 CHAR 30   0   Title text  
173 IE_BUKRS_SUFFIX IE_BUKRS_SUFFIX CHAR30 CHAR 30   0   Company Code suffix  
174 IE_BUKRS_ADDRESS AD_LINE_S CHAR80 CHAR 80   0   One-line short form of formatted address  
175 IE_TAX_RATE IE_CONTRACT_RATE PRZ32 DEC 5   2   Contract Deduction Rate  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 IDWTCOMPCD ADDRORIGIN TSAD6 ORIGIN REF C CN
2 IDWTCOMPCD CITYH_CODE ADRCITY CITY_CODE REF C CN
3 IDWTCOMPCD CITYP_CODE ADRCITYPRT CITYP_CODE REF C CN
4 IDWTCOMPCD CITY_CODE ADRCITY CITY_CODE REF C CN
5 IDWTCOMPCD CITY_CODE2 ADRCITY CITY_CODE REF C CN
6 IDWTCOMPCD COUNTRY T005 LAND1 REF C CN
7 IDWTCOMPCD COUNTY_CODE ADRCOUNTY COUNTY_CODE REF C CN
8 IDWTCOMPCD DEFLT_COMM TSAC COMM_TYPE REF C CN
9 IDWTCOMPCD DELI_SERV_TYPE ADDRC_DELI_SERV DELI_SERV_TYPE 1 CN
10 IDWTCOMPCD DONT_USE_P TSAD12 UNDELIVER KEY C CN
11 IDWTCOMPCD DONT_USE_S TSAD12 UNDELIVER REF C CN
12 IDWTCOMPCD LANGU T002 SPRAS REF C CN
13 IDWTCOMPCD LANGU_CREA T002 SPRAS REF C CN
14 IDWTCOMPCD PO_BOX_CTY T005 LAND1 REF C CN
15 IDWTCOMPCD PO_BOX_REG T005S BLAND REF C CN
16 IDWTCOMPCD REGIOGROUP ADRREGGRP REGIOGROUP REF C CN
17 IDWTCOMPCD REGION T005S BLAND REF C CN
18 IDWTCOMPCD STREETABBR ADRSTRTYPE STRTYPEAB REF C CN
19 IDWTCOMPCD STREETCODE ADRSTREET STRT_CODE REF C CN
20 IDWTCOMPCD TIME_ZONE TTZZ TZONE REF C CN
21 IDWTCOMPCD TITLE TSAD3 TITLE REF C CN
22 IDWTCOMPCD TOWNSHIP_CODE ADRTOWNSHIP TOWNSHIP_CODE REF C CN
23 IDWTCOMPCD TRANSPZONE TZONE ZONE1 REF C CN
History
Last changed by/on SAP  20131127 
SAP Release Created in