Delivered SAP tables
For reference below table lists all Thomson Reuters delivered SAP tables.
Configuration Tables
Most of the configuration tables are accessible via the User Menu provided with a few exceptions which are noted.
Table | Description |
/IDT/C_DET_TAX_T | Determination Tax Code |
/IDT/C_FI_CONTRL | FI Control Process: Custom |
/IDT/C_LOG_CONFI | Log Configuration: Custom |
/IDT/C_PROXIES | Configuration for Proxy Call |
/IDT/C_ROLE_OVER | AP Company Role Override and Special Logic |
/IDT/C_TAX_REL | Tax Code Relevancy |
/IDT/C_TAX_TYPE | Determine condition types for taxes |
/IDT/D_ADDR_SURC | Non-partner function address sources |
/IDT/D_ADDR_TYPE | Logical address types for ONESOURCE Tax Determination |
/IDT/D_ADDRESSES | Match address sources to logical addresses types |
/IDT/D_AUTO_JRNY | Automatically processed Journeys for each Route |
/IDT/D_BASE_MAP | Base Maps |
/IDT/D_CASH_DISC | Match SAP tax code to Determination Tax Code for Cash Discounts at time of payment calculations. Note this table is not in standard menu yet. Use SM30 transaction to maintain at this point. |
/IDT/D_CG_ASSIGN | Country group assignment |
/IDT/D_COUNTRY_G | Country groups |
/IDT/D_DET_TAX_T | Determination Tax Type |
/IDT/D_FI_CONTRL | FI process control configuration |
/IDT/D_FIELD_MAP | Configurable field mappings |
/IDT/D_GENERAL | General configuration option values table |
/IDT/D_GRP_BUKRS | List company codes that should use non-grouped tax calc |
/IDT/D_IS_EXEMPT | Configure exempt transactions |
/IDT/D_LOG_CONFI | Log configuration |
/IDT/D_NEG_TTYP | Tax scenarios to negate the tax values |
/IDT/D_PART_SA | Partial Self-Assessment table |
/IDT/D_PLNTS_ABD | Billing documents types that signify a plants-abroad process |
/IDT/D_PROXIES | Configuration for Proxy Call |
/IDT/D_ROLE_OVER | AP company role override |
/IDT/D_ROUTE_GRP | Route - Route Group index |
/IDT/D_ROUTES | Configuration to switch on Routes |
/IDT/D_SEL_ROUTE | Select route for SD and purchasing |
/IDT/V_TAX_FILTE | Tax Filters |
/IDT/D_TAX_REL | Tax Code Relevancy |
/IDT/D_TAX_TYPE | Determine condition types for taxes |
/IDT/D_TXJCD_DEF | Tax Jurisdiction Code Definitions for Country |
/IDT/D_VERSION | IDT Integration Version |
/IDT/D_WSDL | WSDL Data of the Proxy Structure |
/IDT/GM_MVMTTYPE | Maintain Internal Goods Movement Types |
/IDT/S_FI_CONTRL | FI Control Process: Standard |
/IDT/S_LOG_CONFI | Log Configuration: Standard |
/IDT/D_TX_SUM_GP | IDT Tax Summarization Table |
/IDT/V_ADDR_SURC | SAP Non-Partner Function Address Sources: Custom |
/IDT/V_ADDR_TYPE | Determination Address Types: Standard |
/IDT/V_ADDRESSES | Address Mappings: Custom |
/IDT/V_ADR_PRIVA | Address Mappings: Standard |
/IDT/V_AJ_PRIVAT | Auto Processed Journeys for Route: Standard |
/IDT/V_AS_PRIVAT | SAP Non-Partner Function Address Sources: Standard |
/IDT/V_AUTO_JRNY | Auto Processed Journeys for Route: Custom |
/IDT/V_BASE_MAP | Base Mappings: Standard |
/IDT/V_CG_ASSIGN | Country Group Assign Standard |
/IDT/V_CG_ASGN_N | Country Group Assignment View |
/IDT/V_COUNTRY_G | Country Group Standard |
/IDT/V_FM_PRIVAT | Field Mappings: Standard |
/IDT/V_FIELD_MAP | Field Mappings: Custom |
/IDT/V_GENERAL | General Configuration Values |
/IDT/V_GM_MVTYPE | Goods Movement types |
/IDT/V_NEG_TTYP | Negate Tax Types: Standard |
/IDT/V_NEG_TTYPE | Negate Tax Types: Custom |
/IDT/V_PLNTS_ABD | Plants Abroad Billing Type |
/IDT/V_RG_PRIVAT | Route Groups: Standard |
/IDT/V_ROUTE_GRP | Route Groups: Custom |
/IDT/V_ROUTES | Configuration to Switch on Routes |
/IDT/D_PRODUCTS | List of possible products |
/IDT/V_SEL_ROUTE | Select Route for SD and Purchasing Configuration |
/IDT/V_TAX_SUM_C | IDT Tax Summarization Configuration View |
/IDT/V_VERSION | IDT Integration Version |
/IDT/D_WS | WS Security Configuration for Proxy |
/IDT/D_DYN_PROG | Dynamic Program Index |
/IDT/D_ACT_CNTRL | Actual Data Pop-Up Control Configuration Tables |
/IDT/D_DL_CONFIG | Developer Log Configuration: Custom |
/IDT/D_STRUCTS | Data Dictionary objects for Journey source and target structure. This is a behind the scenes table that is not made available through the main menu and is pre-populated with the transport of the system configuration. |
/IDT/D_SR_AD_MAP | Configurable Source address mappings |
/IDT/D_PROXYGRPS | Used to establish the three options for a proxy group code, blank, CL, OP |
Transaction Tables
Transaction tables can hold a considerable amount of data depending on your business processes and system configurations. You should monitor growth of these tables and manage them as part of your archiving and/or purging process.
Route | Description |
/IDT/D_AUDIT_REC | Record of last Determination calculation request messages for document for later use in the audit update call, cancellations, and other processes. Archiving should be tied to your document retention process. |
/IDT/D_AUDIT_STA | Status of messages for audit DB. Archiving can be managed as part of month end close process. |
/IDT/D_LOG | Log for tax calculations based on log configuration settings. Archiving can be managed as part of month end close process. |
/IDT/D_DEV_LOG | Indirect tax interface developers log |
/IDT/D_TAX_DATA | Table that holds additional Tax Data information for a given document in support of invoice printing and downstream processes. This table is tied to the transaction document and should be managed for archiving based on the leading documents archiving. |
/IDT/D_INDIA_STO | Table holds additional tax data information from the outbound invoice on STO process and is temporarily stored and used for the inbound invoice using transaction code J_1IG_INV. |