Support for non-English locales while exporting and importing requisitions in Excel format

	English	
Deutsch - Machine Translation Español - Machine Translation Français (France) - Machine Translation Italiano - Machine Translation 日本語 - Machine Translation 한국어 - Machine Translation Português (Brasil) - Machine Translation Русский - Machine Translation 简体中文 - Machine Translation

Release Update 195873

Feature ID

CP-13444

Feature Description

This feature enables buyers using SAP Ariba Buying or SAP Ariba Buying and Invoicing in non-English locales, to successfully export or import requisitions in the Excel format.

Customer Problem

The feature [CP-9209]: Create and manage requisitions using Microsoft Excel (Requisition Import/Export) allows users to use excel but only in the English language. Customers who are from different locales face inconvenience using Excel, plus, the system throws an unexpected error when a user's default language setting is set to the current locale and they try to upload excel in the English language.

Customer Value Proposition

Supporting the requisition import/export feature available in all languages supported by SAP products. Now users can self enable the parameter to support multiple languages and be able to import/export requisitions in the preferred locale as per the default language.

Audience

Buyer

What's New Guide

https://help.sap.com/viewer/2dec32c5e595463db4580020925e544a/cloud/en-US/1e7a69e584c74bdf93aa5250766d78be.html

Feature Enablement

Customer Configured

Applicable Solutions

SAP Ariba Buying
SAP Ariba Buying and Invoicing

Prerequisites

Your administrator must enable the following parameters in Ariba Administrator under Intelligent Configuration Manager> Manage Configurations:

Enable Excel-based requisition import and export (Application.Purchasing.AllowRequisitionImportAndExport)
- For information about the parameter, see Enable Excel-based requisition import and export.
Enable localization for Excel-based requisition import and export (Application.Purchasing.LocalizationForExcelBasedRequisitionImportAndExport)
- For information about the parameter, see Enable localization for Excel-based requisition import and export.

Ensure that the formatter for BigDecimal values is configured based on the locale.

Users who import or export requisitions must be members of the Import Requisitions group

Restrictions

The following fields are used as system identifiers for retrieving requisitions. The column headers in the Excel file for these fields must be in English:
UniqueName: A unique ID of a requisition.
Operation: The operation performed on the requisition. The value must be one of the following:
- New: Specifies that a new requisition must be created.
- Update: Specifies that a requisition must be updated.
- Cancel: Specifies that a requisition must be cancelled.
- Note: If this field is left blank, the buying solution considers this operation as a new requisition import.
OriginatingSystem: The name of the external system from which a requisition is imported. If this field is left blank, the default is <Imported>. This value can be used to search for requisitions on the user interface.
OriginatingSystemReferenceID: The ID of the external system from which the requisition is imported. This value can be used to search for requisitions on the user interface.

Applies To

SAP Ariba Buying 2105
SAP Ariba Buying and Invoicing 2105