1. Home
  2. Resources
  3. SAP Tables
  4. IDWTADD - Country speicific additional info for DME file

SAP Table IDWTADD

Country speicific additional info for DME file

IDWTADD (Country speicific additional info for DME file) 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 IDWTADD to other SAP tables.

Source: IDWTADD (Country speicific additional info for DME file)

IDWTADD table fields

Field Data element Checktable Datatype Length Decimals
US_INFO_1042_00 Long Field Label SCRTEXT_L CHAR 40 0
US_REPORT_YEAR Fiscal Year GJAHR NUMC 4 0
US_INFO_1042_10 Long Field Label SCRTEXT_L CHAR 40 0
US_CONT_NAME Name NAME1 CHAR 30 0
US_CONT_TELNO Phone number of person responsible for company area TELE CHAR 12 0
US_INFO_1042_20 Long Field Label SCRTEXT_L CHAR 40 0
US_PAYER_NAME Name NAME1 CHAR 30 0
US_PAYER_TAXNO Tax Number 1 STCD1 CHAR 16 0
US_INFO_1042_30 Long Field Label SCRTEXT_L CHAR 40 0
US_TRANS_TEST File type indicator WT_TEST_FILE CHAR 4 0
TEST Test file creation
NULL Transfer file creation
US_TRANS_AGENT Withholding Agent's EIN indicator WT_EIN_IND NUMC 1 0
1 Withholding Agent's EIN indicator 1
2 Withholding Agent's EIN indicator 2
US_TRANS_NAME Name NAME1 CHAR 30 0
US_TRANS_STRAS House number and street STRAS_GP CHAR 35 0
US_TRANS_CITY City CITY CHAR 25 0
US_TRANS_REGIO Region (State, Province, County) REGIO CHAR 3 0
US_TRANS_PSTLZ Postal Code PSTLZ CHAR 10 0
US_TRANS_TAXNO Tax Number 1 STCD1 CHAR 16 0
US_TCC Transmitter Control WT_T_CTRL CHAR 5 0
US_INFO_1099_10 Long Field Label SCRTEXT_L CHAR 40 0
US_VENDOR_STCD1 Tax Number 1 STCD1 CHAR 16 0
US_VENDOR_STCD2 Tax Number 2 STCD2 CHAR 11 0
US_VENDOR_REGIO Region (State, Province, County) REGIO CHAR 3 0
US_INFO_1099_20 Long Field Label SCRTEXT_L CHAR 40 0
US_HWAER Reporting currency ( local or alternative ) WT_HWAER CUKY 5 0
US_MIN_FED Minimum Amount Federal Tax WT_MINTAX CURR 13 2
US_MIN_ROYAL Minimum Base Amount - Royalties WT_MBASE2 CURR 13 2
US_MIN_DIVID Minimum Base Amount - Dividends WT_MBASE8 CURR 13 2
US_MIN_DIRECT Minimum Base Amount - Direct Sales WT_MBASE9 CURR 13 2
US_MIN_INT_GEN Minimum Base Amount - Interest income WT_MBASE1J CURR 13 2
US_MIN_INT_BUS Minimum Base Amount - Interest income for trade and business WT_MBASE1I CURR 13 2
US_MIN_G_UNEMPLOY Minimum Base Amount - Unemployment WT_MBASE1G CURR 13 2
US_MIN_G_TAX_REFUND Minimum Base Amount - State and Local Tax Refund WT_MBASE2G CURR 13 2
US_MIN_G_OTH_GRANT Minimum Base Amount - Other Taxable Grant WT_MBASE5G CURR 13 2
US_MIN_G_ATAA_PYMNT Minimum Base Amount - Other Taxable Grant WT_MBASE5G CURR 13 2
US_INFO_1099_30 Long Field Label SCRTEXT_L CHAR 40 0
US_TRANS_NAME1 Name 1 WT_NAME1 CHAR 40 0
US_TRANS_NAME2 Name 2 WT_NAME2 CHAR 40 0
US_TRANS_TCC Transmitter Control WT_T_CTRL CHAR 5 0
US_TRANS_TIN Character Length 11 CHAR11 CHAR 11 0
US_CONTACT_PERS Name NAME1 CHAR 30 0
US_CONTACT_TELNO Phone number of person responsible for company area TELE CHAR 12 0
US_CONTACT_EMAIL E-mail address WT_EMAIL CHAR 35 0
US_COMP_NAME1 Name 1 WT_NAME1 CHAR 40 0
US_COMP_NAME2 Name 2 WT_NAME2 CHAR 40 0
US_COMP_STRAS House number and street STRAS_GP CHAR 35 0
US_COMP_CITY City ORT01 CHAR 25 0
US_COMP_STATE Region (State, Province, County) REGIO CHAR 3 0
US_TRANS_POST Postal Code PSTLZ CHAR 10 0
US_INFO_1099_40 Long Field Label SCRTEXT_L CHAR 40 0
US_PAYER_AGENT Payer (P) / Transfer Agent (A) WT_US_PAYER_AGENT CHAR 1 0
P Payer
A Transfer Agent
US_PAYER_NAME1 Name 1 WT_NAME1 CHAR 40 0
US_PAYER_NAME2 Name 2 WT_NAME2 CHAR 40 0
US_PAYER_CTRL Payer Name Control WT_P_CTRL CHAR 4 0
US_PAYER_STRAS House number and street STRAS_GP CHAR 35 0
US_PAYER_CITY City ORT01 CHAR 25 0
US_PAYER_REGIO Region (State, Province, County) REGIO CHAR 3 0
US_PAYER_POST Postal Code PSTLZ CHAR 10 0
US_PAYER_TELNO Phone number of person responsible for company area TELE CHAR 12 0
US_PAYER_TIN Character Length 11 CHAR11 CHAR 11 0
US_INFO_1099_50 Long Field Label SCRTEXT_L CHAR 40 0
US_FILE_COMBINE Checkbox XFELD CHAR 1 0
X Yes
NULL No
US_FILE_TEST Checkbox XFELD CHAR 1 0
X Yes
NULL No
US_FILE_TAPE Checkbox XFELD CHAR 1 0
X Yes
NULL No
US_FILE_CORR_IND Correction File Indicator WT_CORR_IND CHAR 1 0
NULL No Correction
G First Correction
C Second Correction
US_FILE_TM_NO Transmitter Media Number WT_TM_NO CHAR 6 0
US_ALPHA_REPLACE Alpha Replacement Co WT_F_ALPHA CHAR 2 0
US_IRS_FNAME IRS File Name WT_F_EFILE CHAR 15 0
US_APPL_FILE Checkbox XFELD CHAR 1 0
X Yes
NULL No
US_APPL_FNAME Character field of length 40 CHAR40 CHAR 40 0
US_LOCAL_FILE Checkbox XFELD CHAR 1 0
X Yes
NULL No
US_LOCAL_FNAME Character field of length 40 CHAR40 CHAR 40 0
US_AGENT_NAME Withholding Tax Agent Contact Name US_1042_AGENT_NAME CHAR 45 0
US_DEPT_TITLE Withholding Agent's Department Title US_1042_DEPT_NAME CHAR 45 0
US_INFO_MULTI Long Field Label SCRTEXT_L CHAR 40 0
US_CONT_MULTI Check Box XFELD_US CHAR 1 0
X Yes
NULL No
US_CONT_COMPANY Company Code BUKRS_US CHAR 4 0
US_REC_TRUNC Checkbox XFELD CHAR 1 0
X Yes
NULL No
US_MIN_CHECK Checkbox XFELD CHAR 1 0
X Yes
NULL No
US_INFO_FILLER Long Field Label SCRTEXT_L CHAR 40 0
US_FILLER_PSE Payment Settlement Entity US_FILER_PSE CHAR 1 0
X Yes
NULL No
US_FILLER_EPF Electronic Payment Facilitator US_FILER_EPF CHAR 1 0
X Yes
NULL No
US_FILLER_TPP Indicator to check if Filer is TPP US_FILER_TPP CHAR 1 0
X Yes
NULL No
US_PSE_NAME Name of the PSE US_PSE_NAME CHAR 30 0
US_PSE_PHONE Telephone Number of the PSE US_PSE_PHONE CHAR 12 0
US_MIN_TRANS Minimum Number of Transactions US_MIN_TRANS NUMC 3 0
US_MIN_AMT Minimum Amount US_MIN_AMT CURR 13 2
US_POS_PERIOD Posting period US_POS_PERIOD NUMC 2 0
US_TRANS_PAYMT Check whether transaction type is payment card US_TRANS_PAYMT CHAR 1 0
X Yes
NULL No
US_TRANS_TPN Check whether transaction is third party network US_TRANS_TPN CHAR 1 0
X Yes
NULL No
IT_KANTIVA General Ledger Account HKONT CHAR 10 0
IT_ENASARCO General Ledger Account HKONT CHAR 10 0
IT_TAX_NO_SUBJ Tax on sales/purchases code MWSKZ CHAR 2 0
IT_RF07_BUKRS Company Code BUKRS CHAR 4 0
IT_RF07_GJAHR Fiscal Year GJAHR NUMC 4 0
IT_RF07_LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
IT_RF07_CAUS Modello 770 - Reason for payment of service CAUS CHAR 1 0
IT_RF07_NASSC Annual amount not subject to WT on the basis of std. system NASSC CHAR 13 0
IT_RF07_CDINAIL Withholding tax in Italy : Modello 770 - additional data CDINAIL CHAR 10 0
IT_RF07_DTINIZ Starting date of INAIL insurance covering DTINIZ DATS 8 0
IT_RF07_DTFINE Ending date of INAIL insurance covering DTFINE DATS 8 0
IT_RF07_CDCOMU Municipal code CDCOMU CHAR 4 0
IT_REP_LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
IT_REP_LAND1 Country Key LAND1 CHAR 3 0
IT_REP_SEXKZ Key for the Sex of the Person Subject to Withholding Tax SEXKZ CHAR 1 0
1 Male
2 Female
IT_REP_NAME1 Name NAME1 CHAR 30 0
IT_REP_NAME2 Name NAME1 CHAR 30 0
IT_REP_GBDAT Date of birth of the person subject to withholding tax GBDAT_Q DATS 8 0
IT_REP_GBORT Place of birth of the person subject to withholding tax GBORT_Q CHAR 25 0
IT_REP_CMDOM City ORT01 CHAR 25 0
IT_REP_PRDOM Region (State, Province, County) REGIO CHAR 3 0
IT_REP_INDOM House number and street STRAS CHAR 30 0
ES_FILL_DME Checkbox XFELD CHAR 1 0
X Yes
NULL No
ES_INV_DATE Update date for table QSTRE from invoice document WT_QSTRE_INV_DATE NUMC 1 0
1 Posting date
2 Document date
ES_PYMT_DATE Update date for table QSTRE from payment document WT_QSTRE_PYMT_DATE NUMC 1 0
1 Clearing date
2 Posting date
3 Document date
ES_QSTRE_DATE Field of type DATS DATS DATS 8 0
ES_OUTPUT Output option for ES/PT WT_ES_OUTPUT NUMC 1 0
1 Diskette
2 Tape
3 Internet
ES_DECL Declaration for Spain WT_ES_DECL NUMC 1 0
1 Ordinary declaration
2 Substitute declaration
3 Supplementary declaration
ES_ID_DECL ID of the declaration WT_ES_ID_DECL NUMC 13 0
ES_ID_PRV_DEC ID of the previous declaration WT_ES_ID_PRV_DEC NUMC 13 0
ES_NIF_WH_AG NIF of withholding agent WT_ES_NIF_WH_AG CHAR 16 0
ES_NAME_WH_AG Name of withholding agent WT_ES_NAME_AG CHAR 40 0
ES_TEL Telephone number WT_ES_TEL NUMC 9 0
ES_CONTACT_PERS Contact person WT_ES_PERS CHAR 40 0
ES_TAX_DEPT Provincial tax code FPRCD CHAR 3 0
KR_WT_TYPE1 Indicator for withholding tax type WITHT CHAR 2 0
KR_WT_TYPE2 Indicator for withholding tax type WITHT CHAR 2 0
KR_WT_CODE1 Withholding tax code WT_WITHCD CHAR 2 0
KR_WT_CODE2 Withholding tax code WT_WITHCD CHAR 2 0
KR_WT_DATE Reporting Date for Tax Report MLDDT_BSET DATS 8 0
KR_WT_PYDT1 Clearing Date AUGDT DATS 8 0
KR_WT_PYDT2 Clearing Date AUGDT DATS 8 0
KR_WT_SECCO1 Section Code SECCO CHAR 4 0
KR_WT_SECCO2 Section Code SECCO CHAR 4 0
KR_WT_QBSHH Withholding Tax Amount in Reporting Currency WT_TAX_AMT CURR 15 2
VE_L_BLART Document Type BLART CHAR 2 0
VE_U_BLART Document Type BLART CHAR 2 0
VE_CERTNUMBER Text field length 14 CHAR14 CHAR 14 0
VE_CPUDT Day On Which Accounting Document Was Entered CPUDT DATS 8 0
VE_CPUTM Time of Entry CPUTM TIMS 6 0
VE_TAXHB Tax Amount in Document Currency FWSTE CURR 13 2
VE_TAXHH Tax Amount in Local Currency HWSTE CURR 13 2
VE_CERT_RGN_FLG Reprint the Certificate? CERT_RGN_FLG CHAR 1 0
X Yes
NULL No
VE_DM_HDR Text field, length 35 CHAR_35 CHAR 35 0
VE_CERT_HDR Text field, length 35 CHAR_35 CHAR 35 0
VE_STCD1 Tax Number 1 STCD1 CHAR 16 0
VE_CNUM Document Header Text BKTXT CHAR 25 0
VE_WT_RATE Withholding tax rate WT_QSATZ DEC 7 4
GB_PERIOD_END_DATE New CIS Return - End date for a return Period GB_PERIOD_END_DATE DATS 8 0
GB_NIL_RETURN_INDICATOR Specifies if the current return is a Nil Return or n GB_NIL_RETURN_INDICATOR CHAR 1 0
X Yes
NULL No
GB_EMPSTAT_VFD_DCLRTN Employment Status Declaration GB_EMPSTAT_VFD_DCLRTN CHAR 1 0
X Yes
NULL No
GB_SC_VFD_DCLRTN Subcontractor Verification Declaration GB_SC_VFD_DCLRTN CHAR 1 0
X Yes
NULL No
GB_INFO_CRCT_DCLRTN Information Correct Declaration GB_INFO_CRCT_DCLRTN CHAR 1 0
X Yes
NULL No
GB_INACTIVITY_INDICATOR GB_INACTIVITY_INDICATOR GB_INACTIVITY_INDICATOR CHAR 1 0
X Yes
NULL No
GB_RETURN_HDR Text field, length 35 CHAR_35 CHAR 35 0
GB_DCLRTN_HDR Text field, length 35 CHAR_35 CHAR 35 0
GB_CIS_RTN_PSWRD Password for the Return filing GB_CIS_RTN_PSWRD CHAR 25 0
GB_CIS_GFF_SNDRID Sender Id for GFF EDI Transmission GB_GFF_SNDR_ID CHAR 35 0
GB_CIS_GFF_RCVRID GB CIS GFF Transmission Receiver Id GB_GFF_RCVR_ID CHAR 35 0
GB_FILE_HDR Data Element Type CHAR Length 35 CHAR35 CHAR 35 0
GB_CIS_ICR Text field length 14 CHAR14 CHAR 14 0
GB_CIS_TEST_TRNS TEST TRANSMISSION FLAG CIS_TEST_TRANS CHAR 1 0
X Yes
NULL No
ID_WT_PERIOD Reporting Period of Electronic Tax Return UMSVDPER NUMC 2 0
ID_WT_YEAR Reporting Year of Electronic Tax Return UMSVDYEA NUMC 4 0
ID_WT_CORRECTION Number of correction CORR_NUMBER NUMC 1 0
ID_WT_FORMCODE 30 Characters CHAR30 CHAR 30 0
ID_WT_RATE Withholding tax rate WT_QSATZ DEC 7 4
ID_WT_ADDRESS Char255 CHAR255 CHAR 255 0
ID_WT_SERVICE1 Version Number Component CHAR2 CHAR 2 0
ID_WT_SERVICE2 Version Number Component CHAR2 CHAR 2 0
ID_WT_SERVICE3 Version Number Component CHAR2 CHAR 2 0
ID_WT_SERVICE4 Version Number Component CHAR2 CHAR 2 0
ID_WT_SERVICE5 Version Number Component CHAR2 CHAR 2 0
ID_WT_SERVICE6 Version Number Component CHAR2 CHAR 2 0
ID_WT_ESTPERC Percentage Subject to Withholding Tax QPROZ DEC 5 2
ID_WT_GROSSAMT Net amount 2 = Invoice amount - VAT ( in Reporting currency) WT_EXCLVAT CURR 15 2
BE_CONTACT_ID Contact Person Name BE_CONTACT_ID CHAR 34 0
BE_CONTACT_EM Email Address of the Contact Person BE_CONTACT_EM CHAR 44 0
BE_MINBASE Minimum Base Amount BE_MINBASE CURR 13 2
BE_REPORTYEAR Reporting Year in the Withholding Tax Return BE_REPORTYEAR NUMC 4 0
BE_REPORTDATE Date of Report - Fiche (Belgium) BE_REPORTDATE DATS 8 0
BE_SEQ_NUM Sequential Number for Fiche - Belgium BE_SEQ_NUM CHAR 4 0
BE_CORR_INDICATOR Correction Indicator for Withholding Tax Return BE_CORR_INDICATOR CHAR 1 0
0 Ordinary
1 Grouped Correction - Correction
2 Grouped Correction - Addition
3 Grouped Correction - Deletion
4 Complete Replacement
BE_TEST_RUN Test Run Indicator - Belgium BE_TEST_RUN CHAR 1 0
BE_CORR_REFERENCE Reference Number for the Correction BE_CORR_REFERENCE CHAR 6 0
BE_NIHIL Payment Indicator - Fiche- Belgium BE_NIHIL CHAR 1 0
BE_HWAER Reporting currency ( local or alternative ) WT_HWAER CUKY 5 0
BE_INFO_MULTI Long Field Label SCRTEXT_L CHAR 40 0
BE_CONT_MULTI Multiple Company Codes XFELD_BE CHAR 1 0
X Yes
NULL No
BE_CONT_COMPANY Leading Company Code BUKRS_BE CHAR 4 0
TH_PAYER Tax Payer type TH_PAYER NUMC 1 0
1 Withhold at Source
2 Pay every time
3 Pay one time
4 Others