SAP Ariba purchase to pay: see where each order waits

What does Duaer read from SAP Ariba?

Each purchase order is a case, with the supplier, company code, currency and amount. The steps are Requisition created, Order created, Goods received, Invoice posted (invoice reconciliation) and Paid. Canceled or rejected documents are left out. The steps match the purchase to pay template.

How do you connect SAP Ariba to Duaer?

1. In the SAP Ariba developer portal, create an application, request access to the Operational Reporting API for Procurement (synchronous), and get the application key and the OAuth client ID and secret.
2. In Duaer, create an SAP Ariba API credential with the realm, the API host, the OAuth host, the application key, the client ID and the client secret.
3. As an owner or admin, open Data sources, select Add source, choose SAP Ariba under Purchase to pay, choose the credential, select Check connection and confirm.

How often does it read, and how much?

Duaer creates its own reporting views in the realm (named starting with Duaer) and reads requisitions, orders, receipts, invoice reconciliations and payments 31 days at a time; a first read starts two years back and finishes over several runs. Each run makes at most 130 API calls, to stay within Ariba's rate limits. A step is never written twice. Read only.

What are the limits?

• The tables, views, models and fields read follow the vendor's published documentation and are not yet checked against a real system; the first real read may need adjustments.
• Purchase to pay only, and documents of the last two years only.