Configuring Integration Specifications
The Cross-Reference Lookup Table in the Managed Gateway integration project maps values between SAP backend and SAP Ariba solutions when data formats, codes, or terminology differ. Its primary purpose is to ensure accurate, consistent, and meaningful data exchange by translating and aligning data values between SAP ERP and SAP Ariba solutions for seamless integration.
The Lookup Table standardizes data across systems, translating values like document types, tax codes, pricing conditions, and categories correctly. It bridges semantic differences by performing the necessary transformations. Customers can maintain mappings without modifying SAP code or rebuilding integration content, preventing integration failures caused by mismatched or invalid values and ensuring smoother message processing.
In essence, the Cross-Reference Lookup Tables act as a translation dictionary, helping SAP and Ariba communicate effectively by converting values from one system to the expected format of the other.
In this lesson, you’ll learn to maintain the Request for Quotation-specific Cross-Reference Lookup Table in the integration project on the Managed Gateway portal. Before starting this lesson, you should already be able to:
- Enable the Managed Gateway from your SAP Ariba Strategic Sourcing site or realm and create an integration project.
- Choose Product = Ariba Sourcing in the Basic Information of the integration project.
- Define connection information to establish connectivity between the Managed Gateway and your SAP on-premise system.
- Define Cross Reference Parameter for Request for Quotation (Doc Type – QuoteRequest).
- Define Cross References for UOM (Unit of Measures).
- Define Cross Reference Lookup Table for Request for Quotation (Doc Type – QuoteRequest).
- Assign Realm IDs.
- Confirm, test and deploy the integration project.
All these activities are discussed in the course Deep-dive into SAP Integration Suite managed gateway for spend management and SAP Business Network of the Learning Journey Administering SAP Integration Suite, managed gateway for Spend Management and SAP Business Network.
In this lesson, we focus on configuring the Cross-Reference Lookup Table for the Request for Quotation integration.
To complete the configuration, define values for the fields you want to map in the Lookup Table when creating a project for Ariba Sourcing or on the My Configuration page.
You can define Lookup Table values when creating a project for the first time or edit the project while it’s in the Testing status. You can define values for both test and production environments.
Note
Quote Request Matching Type: There are two solutions for the Request for Quotation integration:
- Quote Automation
- Strategic Sourcing
Based on your subscription, SAP Business Network routes the RFQ document to either SAP Business Network Discovery (Quote Automation) or the SAP Ariba Strategic Sourcing site (Strategic Sourcing). In both scenarios, the cXML structure of the QuoteRequest message remains the same. For Quote Automation, defining the QuoteRequestMatchingType is mandatory to determine which suppliers will bid. Maintain a mapping between the Quote Request Matching Type and the specific SAP document types used to create RFQs.
Although this mapping is not relevant to the SAP Ariba Strategic Sourcing flow, since it uses the same cXML structure, maintain it in the Cross Reference Lookup Table. This Lookup Table is also applicable for customers using Automated RFQ processing with SAP Business Network and SAP Business Network Discovery. If you don’t maintain this mapping, Ariba Network will reject the QuoteRequest document.
Follow these steps to maintain the Cross-Reference Lookup Table for Request for Quotation (RFQ):
- Navigate to the Managed Gateway for Spend&Network portal > Create or edit the Integration Project created for integration with Ariba Sourcing > Traverse to the Cross Reference Configuration Lookup Table tab.

- From the Select to add document Type field dropdown, select QuoteRequest.

- Expand the QuoteRequestMatchingType entry dropdown and maintain the mappings based on your business requirements.
- Once all the necessary entries are maintained, choose the Save and Close button.
For guidance, refer to the table provided in this lesson.

When you define mappings for the Ariba Value (cXML UNUOM Value) as public, the RFQ will be published to all suppliers on SAP Business Network, allowing them to submit responses/bids.
When you define mappings for the Ariba Value (cXML UNUOM Value) as approvedVendorOnly, the RFQ will be published only to suppliers approved by the Buyer, who can submit responses/bids.
When you define mappings for the Ariba Value (cXML UNUOM Value) as invitationOnly, the RFQ will be published only to suppliers invited by the Buyer, who can submit responses/bids.
Ariba Value (cXML UNUOM Value) is defined by SAP Ariba administrators, while Customer Value is defined by you. When creating RFQs in the SAP system to send to SAP Ariba Strategic Sourcing, use only the corresponding SAP document types defined in the Cross Reference Lookup Table in the Customer Value column.
All suppliers you want to invite for bidding must exist in SAP Business Network, regardless of the Ariba Value (cXML UNUOM Value) you choose.
| Document Type / Name | Lookup Name | Ariba Value | Customer Value |
|---|---|---|---|
| QuoteRequest | QuoteRequestMatchingType | public | For example, AN. |
| approvedVendorOnly | For example, PRI. | ||
| invitationOnly | For example, DIR. |
Further Learning
To learn about maintaining the Cross-Reference Lookup Table in the Managed Gateway project, refer to the learning Journey, Administering SAP Integration Suite, managed gateway for spend management and SAP Business Network:
- Course: Deep-dive into SAP Integration Suite managed gateway for spend management and SAP Business Network
- Unit: Creating a Project in SAP Integration Suite, managed gateway for spend management and SAP Business Network
- Lesson: Defining Cross References for Parameters, UOM Mappings, Lookup Values, and Realm ID