Enhancements to smart imports from Excel

	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 192891

Feature ID

SS-15030

Feature Description

This feature enables you to create content for an RFP event by importing data from an unstructured Excel file that contains multiple sheets including sheets for items, questions and requirements. This feature introduces the following enhancements, too:
• Support for UOM, historical and reserve pricing
• Improvement to predictions and mapping of content
• Enhanced review and confirmation flows for content mapping
• Options to download sample Excel files for single-sheet import, multi-sheet import, and material master import

Customer Problem

Smart excel import allows buyers to easily create line items based on unstructured Excel files. However, it was not possible to use the feature to create questions nor requirements, and some aspects of the line items, such as historical price and unit of measure were not considered by the smart excel import. After creating the line items users had to manually add and change information to complete the tender.

Customer Value Proposition

Now, customers can efficiently upload both line items, questions and requirements using a single excel file, which may have multiple sheets. They can also upload more line-item level details such as unit of measure and historic price without having to manually edit those details for every single line item. This implies a significant amount of time saved.

Audience

Buyer

What's New Guide

https://help.sap.com/docs/SAP_Ariba/978b7e36451a4c2c85321a3ef6f3a7e5/7c70a0f45c4a4b51a6d30dd67be0cd79.html?locale=en-US&state=PRODUCTION&version=cloud

Feature Enablement

Automatically On

Feature at a Glance: Enhancements to smart imports from Excel (SS-15030)

Applicable Solutions

SAP Ariba Strategic Sourcing Suite

SAP Ariba Sourcing

Prerequisites

Before you start using the smart import from unstructured Excel files to create line items for RFP events, you must complete the following tasks:

(Note: you must be a member of both the SV Enrichment Manager group and the Customer Administrator group, access to this group must be approved by SAP Ariba)

Restrictions

Unstructured Excel file-based import is supported only for the locale EN.
Unstructured Excel file-based import is not supported for sites connecting through Russia Data Center.
Unstructured Excel file-based import is not supported for the following types of events:
- Auctions
- RFI events
- Large-capacity events
Excel files of only .xls or .xlsx formats are supported for import of line-item content to an RFP event.

The following items are not supported for import from the unstructured Excel file:
Sections

- Multiple tables on the same sheet
- Mix of content (terms, question, requirements) in the same table
- Formulas
- The content to be imported from the unstructured Excel file should be in a simple table format. Data in complex tables are not supported for import from unstructured Excel file.

Note: A simple table contains a maximum of one level of header (row, column, or both), whereas a complex table contains multiple levels of headers (rows, columns, or both). A complex table may also contain merged or straddled cells.

- Importing content from an Excel file to an event replaces any content that was already added to the event.

Applies To

SAP Ariba Sourcing 2102
SAP Ariba Strategic Sourcing Suite 2102