IDWTADD_US SAP (US country specific additional information) Structure details
Description: US country specific additional information
Structure field list including key, data, relationships and ABAP select examples
IDWTADD_US 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 "US country specific additional information" 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_US TYPE IDWTADD_US.
The IDWTADD_US table consists of various fields, each holding specific information or linking keys about US country specific additional information data available in SAP. These include US_REPORT_YEAR (Fiscal Year), US_INFO_1042_10 (Long Field Label), US_CONT_NAME (Name), US_CONT_TELNO (Phone number of person responsible for company area).. 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_US 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_00 | Long Field Label | SCRTEXT_L | CHAR | 40 | SCRTEXT_L | ||||
US_REPORT_YEAR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
US_INFO_1042_10 | Long Field Label | SCRTEXT_L | CHAR | 40 | SCRTEXT_L | ||||
US_CONT_NAME | Name | NAME1 | CHAR | 30 | TEXT30 | ||||
US_CONT_TELNO | Phone number of person responsible for company area | TELE | CHAR | 12 | CHAR12 | ||||
US_INFO_1042_20 | Long Field Label | SCRTEXT_L | CHAR | 40 | SCRTEXT_L | ||||
US_PAYER_NAME | Name | NAME1 | CHAR | 30 | TEXT30 | ||||
US_PAYER_TAXNO | Tax Number 1 | STCD1 | CHAR | 16 | STCD1 | ||||
US_INFO_1042_30 | Long Field Label | SCRTEXT_L | CHAR | 40 | SCRTEXT_L | ||||
US_TRANS_TEST | File type indicator | WT_TEST_FILE | CHAR | 4 | WT_US_TEST_FILE | ||||
US_TRANS_AGENT | Withholding Agent's EIN indicator | WT_EIN_IND | NUMC | 1 | WT_US_EIN_IND | ||||
US_TRANS_NAME | Name | NAME1 | CHAR | 30 | TEXT30 | ||||
US_TRANS_STRAS | House number and street | STRAS_GP | CHAR | 35 | TEXT35 | ||||
US_TRANS_CITY | City | CITY | CHAR | 25 | CITY | ||||
US_TRANS_REGIO | STATE (State, Province, County) | REGIO | CHAR | 3 | Assigned to domain | REGIO | |||
US_TRANS_PSTLZ | Postal Code | PSTLZ | CHAR | 10 | PSTLZ | ||||
US_TRANS_TAXNO | Tax Number 1 | STCD1 | CHAR | 16 | STCD1 | ||||
US_TCC | Transmitter Control | WT_T_CTRL | CHAR | 5 | CHAR5 | ||||
US_INFO_1099_10 | Long Field Label | SCRTEXT_L | CHAR | 40 | SCRTEXT_L | ||||
US_VENDOR_STCD1 | Tax Number 1 | STCD1 | CHAR | 16 | STCD1 | ||||
US_VENDOR_STCD2 | Tax Number 2 | STCD2 | CHAR | 11 | STCD2 | ||||
US_VENDOR_REGIO | STATE (State, Province, County) | REGIO | CHAR | 3 | Assigned to domain | REGIO | |||
US_INFO_1099_20 | Long Field Label | SCRTEXT_L | CHAR | 40 | SCRTEXT_L | ||||
US_HWAER | Reporting currency ( local or alternative ) | WT_HWAER | CUKY | 5 | Assigned to domain | WAERS | |||
US_MIN_FED | Minimum Amount Federal Tax | WT_MINTAX | CURR | 13(2) | WERT7 | ||||
US_MIN_ROYAL | Minimum Base Amount - Royalties | WT_MBASE2 | CURR | 13(2) | WERT7 | ||||
US_MIN_DIVID | Minimum Base Amount - Dividends | WT_MBASE8 | CURR | 13(2) | WERT7 | ||||
US_MIN_DIRECT | Minimum Base Amount - Direct Sales | WT_MBASE9 | CURR | 13(2) | WERT7 | ||||
US_MIN_INT_GEN | Minimum Base Amount - Interest income | WT_MBASE1J | CURR | 13(2) | WERT7 | ||||
US_MIN_INT_BUS | Minimum Base Amount - Interest income for trade and business | WT_MBASE1I | CURR | 13(2) | WERT7 | ||||
US_MIN_G_UNEMPLOY | Minimum Base Amount - Unemployment | WT_MBASE1G | CURR | 13(2) | WERT7 | ||||
US_MIN_G_TAX_REFUND | Minimum Base Amount - State and Local Tax Refund | WT_MBASE2G | CURR | 13(2) | WERT7 | ||||
US_MIN_G_OTH_GRANT | Minimum Base Amount - Other Taxable Grant | WT_MBASE5G | CURR | 13(2) | WERT7 | ||||
US_MIN_G_ATAA_PYMNT | Minimum Base Amount - Other Taxable Grant | WT_MBASE5G | CURR | 13(2) | WERT7 | ||||
US_INFO_1099_30 | Long Field Label | SCRTEXT_L | CHAR | 40 | SCRTEXT_L | ||||
US_TRANS_NAME1 | Name 1 | WT_NAME1 | CHAR | 40 | CHAR40 | ||||
US_TRANS_NAME2 | Name 2 | WT_NAME2 | CHAR | 40 | CHAR40 | ||||
US_TRANS_TCC | Transmitter Control | WT_T_CTRL | CHAR | 5 | CHAR5 | ||||
US_TRANS_TIN | Character Length 11 | CHAR11 | CHAR | 11 | CHAR11 | ||||
US_CONTACT_PERS | Name | NAME1 | CHAR | 30 | TEXT30 | ||||
US_CONTACT_TELNO | Phone number of person responsible for company area | TELE | CHAR | 12 | CHAR12 | ||||
US_CONTACT_EMAIL | E-mail address | WT_EMAIL | CHAR | 35 | CHAR35 | ||||
US_COMP_NAME1 | Name 1 | WT_NAME1 | CHAR | 40 | CHAR40 | ||||
US_COMP_NAME2 | Name 2 | WT_NAME2 | CHAR | 40 | CHAR40 | ||||
US_COMP_STRAS | House number and street | STRAS_GP | CHAR | 35 | TEXT35 | ||||
US_COMP_CITY | City | ORT01 | CHAR | 25 | TEXT25 | ||||
US_COMP_STATE | STATE (State, Province, County) | REGIO | CHAR | 3 | Assigned to domain | REGIO | |||
US_TRANS_POST | Postal Code | PSTLZ | CHAR | 10 | PSTLZ | ||||
US_INFO_1099_40 | Long Field Label | SCRTEXT_L | CHAR | 40 | SCRTEXT_L | ||||
US_PAYER_AGENT | Payer (P) / Transfer Agent (A) | WT_US_PAYER_AGENT | CHAR | 1 | WT_US_AGENT_OR_PAYER | ||||
US_PAYER_NAME1 | Name 1 | WT_NAME1 | CHAR | 40 | CHAR40 | ||||
US_PAYER_NAME2 | Name 2 | WT_NAME2 | CHAR | 40 | CHAR40 | ||||
US_PAYER_CTRL | Payer Name Control | WT_P_CTRL | CHAR | 4 | CHAR4 | ||||
US_PAYER_STRAS | House number and street | STRAS_GP | CHAR | 35 | TEXT35 | ||||
US_PAYER_CITY | City | ORT01 | CHAR | 25 | TEXT25 | ||||
US_PAYER_REGIO | STATE (State, Province, County) | REGIO | CHAR | 3 | Assigned to domain | REGIO | |||
US_PAYER_POST | Postal Code | PSTLZ | CHAR | 10 | PSTLZ | ||||
US_PAYER_TELNO | Phone number of person responsible for company area | TELE | CHAR | 12 | CHAR12 | ||||
US_PAYER_TIN | Character Length 11 | CHAR11 | CHAR | 11 | CHAR11 | ||||
US_INFO_1099_50 | Long Field Label | SCRTEXT_L | CHAR | 40 | SCRTEXT_L | ||||
US_FILE_COMBINE | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
US_FILE_TEST | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
US_FILE_TAPE | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
US_FILE_CORR_IND | Correction File Indicator | WT_CORR_IND | CHAR | 1 | WT_CORR_IND | ||||
US_FILE_TM_NO | Transmitter Media Number | WT_TM_NO | CHAR | 6 | CHAR6 | ||||
US_ALPHA_REPLACE | Alpha Replacement Co | WT_F_ALPHA | CHAR | 2 | CHAR02 | ||||
US_IRS_FNAME | IRS File Name | WT_F_EFILE | CHAR | 15 | CHAR15 | ||||
US_APPL_FILE | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
US_APPL_FNAME | Character field of length 40 | CHAR40 | CHAR | 40 | CHAR40 | ||||
US_LOCAL_FILE | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
US_LOCAL_FNAME | Character field of length 40 | CHAR40 | CHAR | 40 | CHAR40 | ||||
US_AGENT_NAME | Withholding Tax Agent Contact Name | US_1042_AGENT_NAME | CHAR | 45 | CHAR45 | ||||
US_DEPT_TITLE | Withholding Agent's Department Title | US_1042_DEPT_NAME | CHAR | 45 | CHAR45 | ||||
US_INFO_MULTI | Long Field Label | SCRTEXT_L | CHAR | 40 | SCRTEXT_L | ||||
US_CONT_MULTI | Check Box | XFELD_US | CHAR | 1 | XFELD | ||||
US_CONT_COMPANY | Company Code | BUKRS_US | CHAR | 4 | Assigned to domain | BUKRS | |||
US_REC_TRUNC | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
US_MIN_CHECK | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
US_INFO_FILLER | Long Field Label | SCRTEXT_L | CHAR | 40 | SCRTEXT_L | ||||
US_FILLER_PSE | Payment Settlement Entity | US_FILER_PSE | CHAR | 1 | XFELD | ||||
US_FILLER_EPF | Electronic Payment Facilitator | US_FILER_EPF | CHAR | 1 | XFELD | ||||
US_FILLER_TPP | Indicator to check if Filer is TPP | US_FILER_TPP | CHAR | 1 | XFELD | ||||
US_PSE_NAME | Name of the PSE | US_PSE_NAME | CHAR | 30 | TEXT30 | ||||
US_PSE_PHONE | Telephone Number of the PSE | US_PSE_PHONE | CHAR | 12 | CHAR12 | ||||
US_MIN_TRANS | Minimum Number of Transactions | US_MIN_TRANS | NUMC | 3 | US_MIN_TRANS | ||||
US_MIN_AMT | Minimum Amount | US_MIN_AMT | CURR | 13(2) | US_MIN_AMT | ||||
US_POS_PERIOD | Posting period | US_POS_PERIOD | NUMC | 2 | |||||
US_TRANS_PAYMT | Check whether transaction type is payment card | US_TRANS_PAYMT | CHAR | 1 | XFELD | ||||
US_TRANS_TPN | Check whether transaction is third party network | US_TRANS_TPN | CHAR | 1 | XFELD |
Key field | Non-key field |
How do I retrieve data from SAP structure IDWTADD_US using ABAP code?
As IDWTADD_US 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_US as there is no data to select.How to access SAP table IDWTADD_US
Within an ECC or HANA version of SAP you can also view further information about IDWTADD_US and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects