Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

ONESOURCE table configuration for SAP

Group configuration to work with SAP

In this section we talk about the set-up of groups and how they can streamline your mapping and reduce duplication.

Country Groups

Transaction Code:
/N/IDT/COUNTRY_GROUPS_V
The Country Group table is the first of the tables that you will want to consider doing your own customized configuration of the system and allows you to streamline your other configurations by automatically replicating the same logic for a group of countries at the same time. This can be extremely helpful in the configuration of the region-specific rules where you want to maintain the same consistent table mapping of fields for a large list of possible countries, i.e. Europe, North America, Asia, etc. The use of country groups can dramatically reduce the amount of lines in your mapping and get rid of duplicity across like country set up.
The standard view of this table was set up because we are now sending as part of our setup for Brazil and India, configuration that is using the Country Group “BR” and “IN” in the standard mappings. Other country groups could be possibly configured here if needed to segregate country specific content in the future.
Transaction Code:
/N/IDT/COUNTRY_GROUPS
This view of the table is where you will add your own country group configuration to the table for use in other tables such as field mapping. Example as seen below is not standard content shipped with the product. Your table will be shipped blank when first installed for the first time. You will need to enter any group names you deem needed for your install.

Country Group Assignment

Transaction Code:
/N/IDT/CNTRY_GRP_ASSIG_V
The standard view of the table is displayed below:
Transaction Code:
/N/IDT/CNTRY_GRP_ASSIG
After setting up the country group names in the prior table you are now ready to match a group of two-digit country codes to each of the country group names. In the example that we show here we have mapped several countries to the EU country group, and others their respective country groups. A country can only belong to one country group at a time. If you try to assign a country to more than one country group you will most likely encounter system errors as our program logic is not designed to handle multiple assignments at this time.

Route Groups

Transaction Code:
/N/IDT/ROUTE_GROUP_V
We ship a set of preconfigured route groups to assist in the configurations, mainly in the standard field mappings. The above list of routes is logically grouped into route groups based on common business processes like creating sales order, sales billing, purchasing, LIV, and financial transactions. Additionally, customers can create their own route groupings.
Transaction Code:
/N/IDT/ROUTE_GROUP
As a customer, you can create your own route groupings by adding route and naming a group. In the example above, we have grouped three routes into a logical group of SD.

This article applies to:

  • Product: ONESOURCE Indirect Tax
  • Sub Product: SAP