SAP Fiori Application To Display SAP Ariba Requisition Data – Part 3

This is part 3 of the 6 series blog. Please start with Part 1: Introduction to understand the Use case, Solution Architecture, High-Level functionality, and context of this blog series.

This blog series is divided into 6 parts:

Part 1: Introduction

Part 2: SAP Ariba – API Setup

Part 3: SAP Integration Suite – Integration Flows Build

Part 4: Ariba Requisitions Service Application

Part 5: Ariba Requisitions Fiori Application

Part 6: Central Fiori Launchpad Setup

Build Integration Flow for SAP Ariba API

On the Integration Suite Home page, perform the below steps in the same sequence

  1. Click on the Discover icon to display the Discover page
  2. Type SAP Ariba Integration with SAP Ariba APIs in the Search box and click Enter or on the Search icon.
  3. Select SAP Ariba Integration with SAP Ariba APIs in search results to display the details page.

Picture%206

Picture 6

On SAP Ariba Integration with SAP Ariba APIs page, click on Copy link. Select OK and the package gets copied over to the Design –> Packages section.

Picture%207

Picture 7

  1. Click on the Design icon to display the Design screen with the list of all Packages you are working on.
  2. Select the package you copied in the previous step i.e., SAP Ariba Integration with SAP Ariba APIs to display the details of the package.

Picture%208

Picture 8

On SAP Ariba Integration with SAP Ariba APIs screen:

  1. Click on the Artifacts tab
  2. Select Connect SAP Ariba to the SAP Ariba APIs artifact to display the integration flow screen.

Picture%209

Picture 9

On Connect SAP Ariba to the SAP Ariba API integration flow screen, click on Configure to display Configure screen.

Picture%2010

Picture 10

On Configure “Connect SAP Ariba to the SPA Ariba APIs” screen:

  1. Click on the Receiver tab
  2. Provide Address as https://openapi.ariba.com/api/procurement-reporting-details/v2/prod/views/KC_GetRequisitions (This is the URL of the Ariba Custom View Template created in <TBD>)
  3. Click on the More tab

Picture%2011

Picture 11

On the More tab, provide values as specified in the below tables and Click on Save.

Step No. Field Name Value
1 apiKey You would have got it as part of Pre-requisite steps
2 Authorization You would have got it as part of Pre-requisite and used it in Get Bearer Token section
3 Realm You would have used it in Create Custom ViewTemplate section
4 Save Click on Save button

Picture%2012

Picture 12

On Connect SAP Ariba to the SAP Ariba APIs screen, click on the Edit button to activate the edit mode and then perform the below steps in the same sequence.

  1. Select the Parameters box in the integration flow.
  2. On the Content Modifier panel, select the Exchange Property tab.
  3. Provide the Value as &filters={“createdDateFrom”:”2022-05-01T00:00:00Z”,”createdDateTo”:”2022-05-20T00:00:00Z”}
    1. Filter is hard coded here for prototype purposes. In production scenarios, this should be passed on from the filters of the Ariba Requisitions Fiori application.
  4. This value is carried on from the previous step where you configured the value for Realm. You don’t need to change the value now.
  5. Click on Save.

Picture%2013

Picture 13

Build Get Requisitions Integration Flow

On SAP Ariba Integration with SAP Ariba APIs screen, select the Artifacts tab and click on Edit.

Picture%2014

Picture 14

  1. Click on Add dropdown
  2. Select Integration Flow to pop up Add Integration Flow screen

Picture%2015

Picture 15

On Add Integration Flow screen, provide values as specified in the below table and Click on OK.

Step No. Field Name Value
1 Create Select Create
2 Name Get Requisitions
3 ID Auto populated
4 Description Get Requisitions
5 OK Click on the OK button

Picture%2016

Picture 16

Select the Get Requisitions artifact to go to Get Requisitons screen where integration flow will be built.

Picture%2017

Picture 17

On the Get Requisitions screen, click on the Edit button to activate edit mode and continue the creation of the integration flow.

Picture%2018

Picture 18

On Get Requisitions screen,

  1. Click on Sender to display the small circles to the right of Sender.
  2. Click on circle with “–>“.
  3. Drag and drop into Start. Adapter Type screen is displayed.

Picture%2019

Picture 19

On the Adapter Type screen, select HTTPS

Picture%2020

Picture 20

On the HTTPS property sheet, perform the following:

  1. Click on the Connection tab
  2. Provide the Address as /GetRequisitions.
    1. Address should start with a “/”.
  3. Uncheck CSRF Protected

Leave the rest of the fields with default values.

Picture%2021

Picture 21

  1. On the palette, click on Call
  2. Select External Call
  3. Select Request Reply

Picture%2022

Picture 22

  1. On the palette, click on Participant
  2. Select Receiver

Picture%2023

Picture 23

Connect Request Reply to Receiver and select Adapter Type as ProcessDirect.

Picture%2024

Picture 24

On the ProcessDirect property sheet, perform the following:

  1. Click on the Connection tab
  2. Provide the Address as /Ariba/OpenAPI

Leave the rest of the fields with default values.

Picture%2025

Picture 25

  1. On the palette, click on Message Transformers
  2. Select Converter
  3. Select XML to JSON Converter

Picture%2026

Picture 26

On XML To JSON Converter property sheet,

  1. Click on the Processing tab
  2. Uncheck Suppress JSON Root Element
  3. Click on Save
  4. Click on Build and develop Integration Content

Leave the rest of the fields with default values.

Picture%2027

Picture 27

Deploy Integration Flows

  1. On the Design screen, Select SAP Ariba Integration with SAP Ariba APIs package
  2. Click on the Artifacts tab
  3. Click on Actions for Connect SAP Ariba to the SAP Ariba APIs artifact
  4. Select Deploy

Repeat steps 3 and 4 for Get Requisitions artifact to deploy the same.

Picture%2028

Picture 28

Get URL and Authentication Details of Integration Flow

  1. Select Operate and monitor integration scenarios
  2. Select Manage Integration Content –> All to display Integration Content screen

Picture%2029

Picture 29

All the deployed Integrations flows are displayed here along with their Status. Wait till your integration flow changes to Started status.

  1. Select your integration flow to display its details on the right half of the screen.
  2. On the Endpoints tab, copy the integration flow full URL and note it down. This will be required later.

Picture%2030

Picture 30

On BTP Subaccount home screen:

  1. Select Instances and Subscriptions
  2. Select Instances tab
  3. Click on 1 key link to open the Credentials for integration flows

Picture%2031

Picture 31

On the Credentials screen, click on the Form tab. Save values in clientid and clientsecret. They will be required later.

Picture%2032

Picture 32

Testing Integration Flow

Postman is used to test the Get Requisitions integration flow.

  1. Select method as GET
  2. Provide the URL of Get Requisitions EndPoint that you noted down in Get URL and Authentication Details of Integration Flow section
  3. Click on the Authorizations tab
  4. Provide the clientid that you noted down in Get URL and Authentication Details of Integration Flow section
  5. Provide the clientsecret that you noted down in Get URL and Authentication Details of Integration Flow section
  6. Click on the Send button to test the Get Requisitions integration flow
  7. If you receive the response with JSON data from your Ariba realm as shown in the screenshot then your testing was successful.

Picture%2033

Picture 33

Next In Series

Part 4: Ariba Requisitions Service Application

Part 5: Ariba Requisitions Fiori Application

Part 6: Central Fiori Launchpad Setup