Integration Overview
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 Cross-Reference Lookup Table standardizes data across systems by correctly translating values such as document types, tax codes, pricing conditions, and categories. It bridges semantic differences by performing the necessary transformations, enabling customers to maintain mappings without modifying SAP code or rebuilding integration content. This prevents integration failures caused by mismatched or invalid values, ensuring smooth message processing. In essence, the Cross-Reference Lookup Tables serve as translation dictionaries, enabling SAP and Ariba to communicate effectively by converting values from one system to the expected format.
Prerequisites and Learning Goals
In this lesson, you’ll learn how to maintain the Quote Message/Award-specific Cross-Reference Lookup table in the integration project on the Managed Gateway portal. Before starting, 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 Parameters for one or more document types based on your requirements:
- Quote Message for Purchase Order (Doc Type – QuoteMessageOrder)
- Quote Message for Material Contract (Doc Type – QuoteMessageContract)
- Quote Message for Service Contract (Doc Type – QuoteMessageContractServices)
- Quote Message for Service Contract (Doc Type – QuoteMessageContractServices)
- Quote Message for Scheduling Agreement (Doc Type – QuoteMessageSchedulingAgreement)
- Define Cross References for UOM (Unit of Measures)
- Define Cross Reference lookup table for the following document types based on requirements:
- Quote Message for Service Contract (Doc Type – QuoteMessageContractServices)
- Quote Message for Scheduling Agreement (Doc Type- QuoteMessageSchedulingAgreement)
- Assign Realm IDs
- Confirm, test, and deploy the integration project.
Configuration of the Cross-Reference Lookup Table
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 will focus only on the configuration of the Cross-Reference Lookup Table specific to the Quote Message/Award integration. You can define the Lookup Table when creating a project for Ariba Sourcing, or on the My Configuration page.
When you create the project for the first time, you define the Cross-Reference Lookup Table. However, you can still edit the project while it's in the Testing status. You can define the values for both test and production environments.
Follow these steps to maintain the Cross-Reference Lookup Table for Quote Message/Award:
- 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 QuoteMessageSchedulingAgreement (a Quote Message document containing line items for a scheduling agreement).
- Expand the PricingConditions 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.
| Document Type / Name | Lookup Name | Ariba Value | Customer Value |
|---|---|---|---|
| QuoteMessageSchedulingAgreement | PricingConditions | PRICE | For example, PB00. |
| SURCHARGE | For example, ZB00. | ||
| DISCOUNT | For example, RB00. |
Additional Resources
Maintain the Cross Reference Lookup table for QuoteMessageContractServices based on your requirements.
The SAP Integration Suite, Managed Gateway for Spend Management, and SAP Business Network Configuration Guide provide information on setting up the lookup table for different document types supported for Quote Message/Award.
Navigate to Cross References Setup on SAP Integration Suite, Managed Gateway for Spend Management, and SAP Business Network>Setting Up Cross References for SAP Ariba Strategic Sourcing and SAP Ariba Contracts>Setting Up Fields in the Lookup Table. Refer to the tables for QuoteMessageSchedulingAgreement and QuoteMessageContractServices under the Procedure section.
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