IDWTADD SAP (Country speicific additional info for DME file) Structure details

Dictionary Type: Structure
Description: Country speicific additional info for DME file




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




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

IDWTADD 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 "Country speicific additional info for DME file" 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_IDWTADD TYPE IDWTADD.

The IDWTADD table consists of various fields, each holding specific information or linking keys about Country speicific additional info for DME file data available in SAP. These include US_INFO_1042_00 (Long Field Label), US_REPORT_YEAR (Fiscal Year), US_INFO_1042_10 (Long Field Label), US_CONT_NAME (Name).. 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 (character-type or numeric)


SAP IDWTADD 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
US_INFO_1042_00Long Field Label SCRTEXT_LCHAR40SCRTEXT_L
US_REPORT_YEARFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
US_INFO_1042_10Long Field Label SCRTEXT_LCHAR40SCRTEXT_L
US_CONT_NAMEName NAME1CHAR30TEXT30
US_CONT_TELNOPhone number of person responsible for company area TELECHAR12CHAR12
US_INFO_1042_20Long Field Label SCRTEXT_LCHAR40SCRTEXT_L
US_PAYER_NAMEName NAME1CHAR30TEXT30
US_PAYER_TAXNOTax Number 1 STCD1CHAR16STCD1
US_INFO_1042_30Long Field Label SCRTEXT_LCHAR40SCRTEXT_L
US_TRANS_TESTFile type indicator WT_TEST_FILECHAR4WT_US_TEST_FILE
US_TRANS_AGENTWithholding Agent's EIN indicator WT_EIN_INDNUMC1WT_US_EIN_IND
US_TRANS_NAMEName NAME1CHAR30TEXT30
US_TRANS_STRASHouse number and street STRAS_GPCHAR35TEXT35
US_TRANS_CITYCity CITYCHAR25CITY
US_TRANS_REGIOSTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
US_TRANS_PSTLZPostal Code PSTLZCHAR10PSTLZ
US_TRANS_TAXNOTax Number 1 STCD1CHAR16STCD1
US_TCCTransmitter Control WT_T_CTRLCHAR5CHAR5
US_INFO_1099_10Long Field Label SCRTEXT_LCHAR40SCRTEXT_L
US_VENDOR_STCD1Tax Number 1 STCD1CHAR16STCD1
US_VENDOR_STCD2Tax Number 2 STCD2CHAR11STCD2
US_VENDOR_REGIOSTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
US_INFO_1099_20Long Field Label SCRTEXT_LCHAR40SCRTEXT_L
US_HWAERReporting currency ( local or alternative ) WT_HWAERCUKY5Assigned to domainWAERS
US_MIN_FEDMinimum Amount Federal Tax WT_MINTAXCURR13(2) WERT7
US_MIN_ROYALMinimum Base Amount - Royalties WT_MBASE2CURR13(2) WERT7
US_MIN_DIVIDMinimum Base Amount - Dividends WT_MBASE8CURR13(2) WERT7
US_MIN_DIRECTMinimum Base Amount - Direct Sales WT_MBASE9CURR13(2) WERT7
US_MIN_INT_GENMinimum Base Amount - Interest income WT_MBASE1JCURR13(2) WERT7
US_MIN_INT_BUSMinimum Base Amount - Interest income for trade and business WT_MBASE1ICURR13(2) WERT7
US_MIN_G_UNEMPLOYMinimum Base Amount - Unemployment WT_MBASE1GCURR13(2) WERT7
US_MIN_G_TAX_REFUNDMinimum Base Amount - State and Local Tax Refund WT_MBASE2GCURR13(2) WERT7
US_MIN_G_OTH_GRANTMinimum Base Amount - Other Taxable Grant WT_MBASE5GCURR13(2) WERT7
US_MIN_G_ATAA_PYMNTMinimum Base Amount - Other Taxable Grant WT_MBASE5GCURR13(2) WERT7
US_INFO_1099_30Long Field Label SCRTEXT_LCHAR40SCRTEXT_L
US_TRANS_NAME1Name 1 WT_NAME1CHAR40CHAR40
US_TRANS_NAME2Name 2 WT_NAME2CHAR40CHAR40
US_TRANS_TCCTransmitter Control WT_T_CTRLCHAR5CHAR5
US_TRANS_TINCharacter Length 11 CHAR11CHAR11CHAR11
US_CONTACT_PERSName NAME1CHAR30TEXT30
US_CONTACT_TELNOPhone number of person responsible for company area TELECHAR12CHAR12
US_CONTACT_EMAILE-mail address WT_EMAILCHAR35CHAR35
US_COMP_NAME1Name 1 WT_NAME1CHAR40CHAR40
US_COMP_NAME2Name 2 WT_NAME2CHAR40CHAR40
US_COMP_STRASHouse number and street STRAS_GPCHAR35TEXT35
US_COMP_CITYCity ORT01CHAR25TEXT25
US_COMP_STATESTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
US_TRANS_POSTPostal Code PSTLZCHAR10PSTLZ
US_INFO_1099_40Long Field Label SCRTEXT_LCHAR40SCRTEXT_L
US_PAYER_AGENTPayer (P) / Transfer Agent (A) WT_US_PAYER_AGENTCHAR1WT_US_AGENT_OR_PAYER
US_PAYER_NAME1Name 1 WT_NAME1CHAR40CHAR40
US_PAYER_NAME2Name 2 WT_NAME2CHAR40CHAR40
US_PAYER_CTRLPayer Name Control WT_P_CTRLCHAR4CHAR4
US_PAYER_STRASHouse number and street STRAS_GPCHAR35TEXT35
US_PAYER_CITYCity ORT01CHAR25TEXT25
US_PAYER_REGIOSTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
US_PAYER_POSTPostal Code PSTLZCHAR10PSTLZ
US_PAYER_TELNOPhone number of person responsible for company area TELECHAR12CHAR12
US_PAYER_TINCharacter Length 11 CHAR11CHAR11CHAR11
US_INFO_1099_50Long Field Label SCRTEXT_LCHAR40SCRTEXT_L
US_FILE_COMBINECheckbox XFELDCHAR1XFELD
US_FILE_TESTCheckbox XFELDCHAR1XFELD
US_FILE_TAPECheckbox XFELDCHAR1XFELD
US_FILE_CORR_INDCorrection File Indicator WT_CORR_INDCHAR1WT_CORR_IND
US_FILE_TM_NOTransmitter Media Number WT_TM_NOCHAR6CHAR6
US_ALPHA_REPLACEAlpha Replacement Co WT_F_ALPHACHAR2CHAR02
US_IRS_FNAMEIRS File Name WT_F_EFILECHAR15CHAR15
US_APPL_FILECheckbox XFELDCHAR1XFELD
US_APPL_FNAMECharacter field of length 40 CHAR40CHAR40CHAR40
US_LOCAL_FILECheckbox XFELDCHAR1XFELD
US_LOCAL_FNAMECharacter field of length 40 CHAR40CHAR40CHAR40
US_AGENT_NAMEWithholding Tax Agent Contact Name US_1042_AGENT_NAMECHAR45CHAR45
US_DEPT_TITLEWithholding Agent's Department Title US_1042_DEPT_NAMECHAR45CHAR45
US_INFO_MULTILong Field Label SCRTEXT_LCHAR40SCRTEXT_L
US_CONT_MULTICheck Box XFELD_USCHAR1XFELD
US_CONT_COMPANYCompany Code BUKRS_USCHAR4Assigned to domainBUKRS
US_REC_TRUNCCheckbox XFELDCHAR1XFELD
US_MIN_CHECKCheckbox XFELDCHAR1XFELD
US_INFO_FILLERLong Field Label SCRTEXT_LCHAR40SCRTEXT_L
US_FILLER_PSEPayment Settlement Entity US_FILER_PSECHAR1XFELD
US_FILLER_EPFElectronic Payment Facilitator US_FILER_EPFCHAR1XFELD
US_FILLER_TPPIndicator to check if Filer is TPP US_FILER_TPPCHAR1XFELD
US_PSE_NAMEName of the PSE US_PSE_NAMECHAR30TEXT30
US_PSE_PHONETelephone Number of the PSE US_PSE_PHONECHAR12CHAR12
US_MIN_TRANSMinimum Number of Transactions US_MIN_TRANSNUMC3US_MIN_TRANS
US_MIN_AMTMinimum Amount US_MIN_AMTCURR13(2) US_MIN_AMT
US_POS_PERIODPosting period US_POS_PERIODNUMC2
US_TRANS_PAYMTCheck whether transaction type is payment card US_TRANS_PAYMTCHAR1XFELD
US_TRANS_TPNCheck whether transaction is third party network US_TRANS_TPNCHAR1XFELD
IT_KANTIVAGeneral Ledger Account HKONTCHAR10Assigned to domainALPHASAKNR
IT_ENASARCOGeneral Ledger Account HKONTCHAR10Assigned to domainALPHASAKNR
IT_TAX_NO_SUBJTax on sales/purchases code MWSKZCHAR2Assigned to domainMWSKZ
IT_RF07_BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
IT_RF07_GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
IT_RF07_LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
IT_RF07_CAUSModello 770 - Reason for payment of service CAUSCHAR1CHAR01
IT_RF07_NASSCAnnual amount not subject to WT on the basis of std. system NASSCCHAR13CHAR13
IT_RF07_CDINAILWithholding tax in Italy : Modello 770 - additional data CDINAILCHAR10CHAR10
IT_RF07_DTINIZStarting date of INAIL insurance covering DTINIZDATS8DATE
IT_RF07_DTFINEEnding date of INAIL insurance covering DTFINEDATS8DATE
IT_RF07_CDCOMUMunicipal code CDCOMUCHAR4CHAR04
IT_REP_LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
IT_REP_LAND1Country Key LAND1CHAR3Assigned to domainLAND1LND
IT_REP_SEXKZKey for the Sex of the Person Subject to Withholding Tax SEXKZCHAR1SEXKZ
IT_REP_NAME1Name NAME1CHAR30TEXT30
IT_REP_NAME2Name NAME1CHAR30TEXT30
IT_REP_GBDATDate of birth of the person subject to withholding tax GBDAT_QDATS8DATUM
IT_REP_GBORTPlace of birth of the person subject to withholding tax GBORT_QCHAR25TEXT25
IT_REP_CMDOMCity ORT01CHAR25TEXT25
IT_REP_PRDOMSTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
IT_REP_INDOMHouse number and street STRASCHAR30TEXT30
ES_FILL_DMECheckbox XFELDCHAR1XFELD
ES_INV_DATEUpdate date for table QSTRE from invoice document WT_QSTRE_INV_DATENUMC1WT_QSTRE_INV_DATE
ES_PYMT_DATEUpdate date for table QSTRE from payment document WT_QSTRE_PYMT_DATENUMC1WT_QSTRE_PYMT_DATE
ES_QSTRE_DATEField of type DATS DATSDATS8DATS
ES_OUTPUTOutput option for ES/PT WT_ES_OUTPUTNUMC1WT_ES_OUTPUT
ES_DECLDeclaration for Spain WT_ES_DECLNUMC1WT_ES_DECL
ES_ID_DECLID of the declaration WT_ES_ID_DECLNUMC13NUM13
ES_ID_PRV_DECID of the previous declaration WT_ES_ID_PRV_DECNUMC13NUM13
ES_NIF_WH_AGNIF of withholding agent WT_ES_NIF_WH_AGCHAR16CHAR16
ES_NAME_WH_AGName of withholding agent WT_ES_NAME_AGCHAR40CHAR_40
ES_TELTelephone number WT_ES_TELNUMC9NUM9
ES_CONTACT_PERSContact person WT_ES_PERSCHAR40CHAR_40
ES_TAX_DEPTProvincial tax code FPRCDCHAR3FPRCD
KR_WT_TYPE1Indicator for withholding tax type WITHTCHAR2Assigned to domainWITHT
KR_WT_TYPE2Indicator for withholding tax type WITHTCHAR2Assigned to domainWITHT
KR_WT_CODE1Withholding tax code WT_WITHCDCHAR2Assigned to domainWT_WITHCD
KR_WT_CODE2Withholding tax code WT_WITHCDCHAR2Assigned to domainWT_WITHCD
KR_WT_DATEReporting Date for Tax Report MLDDT_BSETDATS8DATUM
KR_WT_PYDT1Clearing Date AUGDTDATS8DATUM
KR_WT_PYDT2Clearing Date AUGDTDATS8DATUM
KR_WT_SECCO1Section Code SECCOCHAR4Assigned to domainSECCOSECCO_ABA
KR_WT_SECCO2Section Code SECCOCHAR4Assigned to domainSECCOSECCO_ABA
KR_WT_QBSHHWithholding Tax Amount in Reporting Currency WT_TAX_AMTCURR15(2) WERTV8
VE_L_BLARTDocument Type BLARTCHAR2Assigned to domainBLARTBAR
VE_U_BLARTDocument Type BLARTCHAR2Assigned to domainBLARTBAR
VE_CERTNUMBERText field length 14 CHAR14CHAR14CHAR14
VE_CPUDTDay On Which Accounting Document Was Entered CPUDTDATS8DATUM
VE_CPUTMTime of Entry CPUTMTIMS6UZEIT
VE_TAXHBTax Amount in Document Currency FWSTECURR13(2) WERT7
VE_TAXHHTax Amount in Local Currency HWSTECURR13(2) WERT7
VE_CERT_RGN_FLGReprint the Certificate? CERT_RGN_FLGCHAR1XFELD
VE_DM_HDRText field, length 35 CHAR_35CHAR35CHAR_35
VE_CERT_HDRText field, length 35 CHAR_35CHAR35CHAR_35
VE_STCD1Tax Number 1 STCD1CHAR16STCD1
VE_CNUMDocument Header Text BKTXTCHAR25TEXT25
VE_WT_RATEWithholding tax rate WT_QSATZDEC7(4) PRZ34
GB_PERIOD_END_DATENew CIS Return - End date for a return Period GB_PERIOD_END_DATEDATS8DATS
GB_NIL_RETURN_INDICATORSpecifies if the current return is a Nil Return or n GB_NIL_RETURN_INDICATORCHAR1XFELD
GB_EMPSTAT_VFD_DCLRTNEmployment Status Declaration GB_EMPSTAT_VFD_DCLRTNCHAR1XFELD
GB_SC_VFD_DCLRTNSubcontractor Verification Declaration GB_SC_VFD_DCLRTNCHAR1XFELD
GB_INFO_CRCT_DCLRTNInformation Correct Declaration GB_INFO_CRCT_DCLRTNCHAR1XFELD
GB_INACTIVITY_INDICATORGB_INACTIVITY_INDICATOR GB_INACTIVITY_INDICATORCHAR1XFELD
GB_RETURN_HDRText field, length 35 CHAR_35CHAR35CHAR_35
GB_DCLRTN_HDRText field, length 35 CHAR_35CHAR35CHAR_35
GB_CIS_RTN_PSWRDPassword for the Return filing GB_CIS_RTN_PSWRDCHAR25CHAR25
GB_CIS_GFF_SNDRIDSender Id for GFF EDI Transmission GB_GFF_SNDR_IDCHAR35CHAR35
GB_CIS_GFF_RCVRIDGB CIS GFF Transmission Receiver Id GB_GFF_RCVR_IDCHAR35CHAR35
GB_FILE_HDRData Element Type CHAR Length 35 CHAR35CHAR35CHAR35
GB_CIS_ICRText field length 14 CHAR14CHAR14CHAR14
GB_CIS_TEST_TRNSTEST TRANSMISSION FLAG CIS_TEST_TRANSCHAR1XFELD
ID_WT_PERIODReporting Period of Electronic Tax Return UMSVDPERNUMC2UMSVDPER
ID_WT_YEARReporting Year of Electronic Tax Return UMSVDYEANUMC4UMSVDYEA
ID_WT_CORRECTIONNumber of correction CORR_NUMBERNUMC1NUM01
ID_WT_FORMCODE30 Characters CHAR30CHAR30CHAR30
ID_WT_RATEWithholding tax rate WT_QSATZDEC7(4) PRZ34
ID_WT_ADDRESSChar255 CHAR255CHAR255CHAR255
ID_WT_SERVICE1Version Number Component CHAR2CHAR2CHAR2
ID_WT_SERVICE2Version Number Component CHAR2CHAR2CHAR2
ID_WT_SERVICE3Version Number Component CHAR2CHAR2CHAR2
ID_WT_SERVICE4Version Number Component CHAR2CHAR2CHAR2
ID_WT_SERVICE5Version Number Component CHAR2CHAR2CHAR2
ID_WT_SERVICE6Version Number Component CHAR2CHAR2CHAR2
ID_WT_ESTPERCPercentage Subject to Withholding Tax QPROZDEC5(2) PRZ32
ID_WT_GROSSAMTNet amount 2 = Invoice amount - VAT ( in Reporting currency) WT_EXCLVATCURR15(2) WERTV8
BE_CONTACT_IDContact Person Name BE_CONTACT_IDCHAR34BE_CONTACT_ID
BE_CONTACT_EMEmail Address of the Contact Person BE_CONTACT_EMCHAR44BE_CONTACT_EM
BE_MINBASEMinimum Base Amount BE_MINBASECURR13(2) BE_MINBASE
BE_REPORTYEARReporting Year in the Withholding Tax Return BE_REPORTYEARNUMC4BE_REPORTYEAR
BE_REPORTDATEDate of Report - Fiche (Belgium) BE_REPORTDATEDATS8DATUM
BE_SEQ_NUMSequential Number for Fiche - Belgium BE_SEQ_NUMCHAR4
BE_CORR_INDICATORCorrection Indicator for Withholding Tax Return BE_CORR_INDICATORCHAR1BE_CORR_INDICATOR
BE_TEST_RUNTest Run Indicator - Belgium BE_TEST_RUNCHAR1
BE_CORR_REFERENCEReference Number for the Correction BE_CORR_REFERENCECHAR6BE_CORR_REFERENCE
BE_NIHILPayment Indicator - Fiche- Belgium BE_NIHILCHAR1
BE_HWAERReporting currency ( local or alternative ) WT_HWAERCUKY5Assigned to domainWAERS
BE_INFO_MULTILong Field Label SCRTEXT_LCHAR40SCRTEXT_L
BE_CONT_MULTIMultiple Company Codes XFELD_BECHAR1XFELD
BE_CONT_COMPANYLeading Company Code BUKRS_BECHAR4Assigned to domainBUKRS
TH_PAYERTax Payer type TH_PAYERNUMC1TH_PAYER

Key field Non-key field



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

As IDWTADD 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 IDWTADD as there is no data to select.

How to access SAP table IDWTADD

Within an ECC or HANA version of SAP you can also view further information about IDWTADD 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!