Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

ONESOURCE table configuration for SAP

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.

This article applies to:

  • Product: ONESOURCE Indirect Tax
  • Sub Product: SAP