Identifying Common Master Data Imports

Commodity Codes are standard classification codes for products and services used to detail where money is spent within a company.

Commodity codes can be used to classify and categorize products and services, drive journal/ledger entries in your ERP system, or default other field values.

There are numerous global standard commodity code classification systems. Some of the most common include:

• United Nations Standard Products and Services Code (UNSPSC)
• North American Industry Classification System (NAICS)
• eClass Standardized Material and Service Classification

UNSPSC codes are pre-loaded into suite-integrated realms, also referred to as system commodity codes.

It is recommended for customers to use the standard list, if possible, but customers can load custom commodity codes as needed. Custom commodity code lists will need to be mapped to UNSPSC codes, and the commodity domain system parameter must be set to custom.

Commodity Codes in realms that have not been suite integrated are imported from the Administration page's Data Import/Export tool.

Configure a CSV file similar to the following for the CommodityCode.csv import:

• Note that the Domain column is all unspsc to match the parameter value.
• The UniqueName is the system's unique ID or name, with the Name being the display name that appears in the user interface.
• ParentUniqueName references the UniqueName of the commodity code above it within the hierarchy. If the commodity code is not part of a hierarchical system, or if it is the top-level parent node in a hierarchical system, this column is blank.
  Note

  The sample data on the Commodity Codes worksheet defines "All" as the top-level parent commodity code. Do not remove this code. It is required, even if you are not defining hierarchical commodity codes.

Commodity Code Mappings are required when using custom commodity code values and transacting over the SAP Business Network, which uses UNSPSC.

Configure a CSV file similar to the following for the CommodityCode.csv import:

• Commodity code mappings are bidirectional, so when you set up mappings, it doesn't matter which domain (custom, unspsc, and so on) you choose for DomainFrom and which you choose for DomainTo.
• The UniqueName, which is the system's unique ID for the commodity code, is required.

Commodity codes and commodity code mappings can be created, edited, and deleted from the system using the user interface instead of data imports through Commodity Code Manager within the Administration menu.

Members of the following system groups can access Commodity Code Manager:

• Customer Administrator
• Purchasing Manager
• Purchasing Agent
• Procurement Manager
• Procurement Agent
• Commodity Code Manager

• To edit a commodity code, search for the value by entering the commodity code ID or Name, and when located, choose Edit.
  • The name, parent, mapping entries, and enablement status can be edited.
  • The domain and ID cannot be edited.
• To create a new mapping, choose Create New.
  • Upon selecting Create New, administrators will be required to input the Domain, ID, and Name.
  • Parent is optional, and the Commodity Code Map Entries tab is where mappings can be assigned:

• Commodity Codes are used as standard classification codes for products and services.
• Some industry commodity lists are United Nations Standard Products and Services Code (UNSPSC), North American Industry Classification System (NAICS), and eClass Standardized Material and Service Classification.
• The default SAP Ariba list uses UNSPSC.
• Customers that choose to use a custom commodity code list need to map their custom values to UNSPSC codes to transact over the network.

Currency conversions, and exchange rates, are important for customers who work internationally with different currencies. Initial exchange rate sets will need to be uploaded to use foreign currencies in events and Strategic Sourcing documents. If exchange rate sets are not uploaded, users will receive an error message if an unmapped currency is selected on their event or project.

In order to run projects in any currency other than the base currency, currency conversion rate mappings must be configured from the specified currency/currencies to the base currency of your site, bilaterally.

Within Manage﹥Administration﹥Event Manager, lies Exchange Rates.

SAP Ariba Strategic Sourcing allows customers to maintain multiple Exchange Rate Sets for Project Owners creating events to choose from.

The exchange rate set, System Currency Conversion Rates, refers to the system rates that are imported under Data Import/Export﹥ Import Currency Conversion Rates.

There are no default values that are imported initially into the system like some other standard master data fields.

Customers will want to import the initial values for the currencies they wish to use, and add new sets and update their system list as needed.

For example, the base currency of your site is the European Euro (EUR).

In order to run a project in Singapore Dollar (SGD), you would need to create a currency conversion rate mapping from SGD to EUR and from EUR to SGD.

1. Find the exchange rate from the base currency (EUR) to the foreign currency (SGD).
2. Find the inverse rate for the same currency (SGD to EUR).
3. Complete a CSV file similar to the below:

4. UTF8
   FromCurrency	ToCurrency	Rate	Date
   SGD	EUR	1.39	Tue Aug 23 00:00:00 PST 2023
   EUR	SGD	0.72	Tue Aug 23 00:00:00 PST 2023

5. Navigate to Manage﹥Administration﹥Site Manager﹥Data Import/Export﹥Data Import/Export﹥Import Currency Conversion Rates.
6. Choose your import operation and upload the CSV file.

• Exchange Rates need to be imported to be able to run events in different currencies.
• Currency Conversion imports can be imported through Site Manager's Data Import page, and found in the Exchange Rates as System Currency Conversion Rates.
• Currency Conversion imports must have two rows for each entry: an entry for CurrencyA to CurrencyB, and then an entry for the inverse rate of CurrencyB to CurrencyA.