Zum Inhalt springen
Search the hub

← All suppliers

Finance

SAP Ariba

Procurement: PO, invoice, supplier — Ariba load, PII and spend/cycle measures.

Templates only — grain, filters, custom fields and ownership are firm-specific.

Copy formulas into the KPI Definition Card, then adapt grain and filters.

Example

PO spend

What is purchase order spend volume in the period?

SUM(TotalCost.Amount) FROM purchase_order WHERE OrderedDate IN period
Grain
Purchase order
Fields
PurchaseOrder.TotalCost.Amount, PurchaseOrder.OrderedDate, PurchaseOrder.Supplier.UniqueName
Dimensions
supplier, commodity, company_code, purchasing_org, status

Ariba Procurement/Reporting APIs — TotalCost.Amount + Currency; line-level for commodity.

Adapt: Clarify change orders and canceled POs in/out of the spend definition.

Example

Invoice spend

What is invoice spend in the period?

SUM(TotalCost.Amount) FROM invoice WHERE InvoiceDate IN period AND StatusString NOT IN (Rejected, Canceled)
Grain
Invoice
Fields
Invoice.TotalCost.Amount, Invoice.InvoiceDate, Invoice.StatusString, Invoice.Supplier.UniqueName
Dimensions
supplier, commodity, company_code, status

Consciously choose InvoiceDate vs posted/paid date; PO match via Order.UniqueName.

Adapt: Report non-PO invoices and credit memos separately.

Open PO backlog

What is the open PO backlog?

SUM(open_amount) FROM purchase_order WHERE StatusString IN ('Ordered','Receiving')
Grain
Open purchase order
Fields
PurchaseOrder.StatusString, PurchaseOrder.TotalCost.Amount, PurchaseOrder.UniqueName
Dimensions
supplier, commodity, purchasing_org, status

Open amount = ordered − received/invoiced per tenant rule; whitelist StatusString.

Adapt: Lock snapshot date and aging buckets (0–30/31–60).

Suppliers active

How many suppliers had PO or invoice activity in the period?

COUNT(DISTINCT Supplier.UniqueName) FROM purchase_order OR invoice WHERE date IN period
Grain
Supplier with activity
Fields
PurchaseOrder.Supplier.UniqueName, Invoice.Supplier.UniqueName, PurchaseOrder.OrderedDate
Dimensions
commodity, company_code, purchasing_org

Active = at least one PO or invoice in period — not only master status Approved.

Adapt: Optionally exclude one-time vendors and intercompany from the active set.

Cycle time PO→invoice (days)

How long from PO ordered to invoice?

AVG(DATEDIFF(day, OrderedDate, InvoiceDate)) FROM invoice JOIN purchase_order ON Order.UniqueName
Grain
Matched invoice↔PO
Fields
PurchaseOrder.OrderedDate, Invoice.InvoiceDate, Invoice.Order.UniqueName
Dimensions
supplier, commodity, purchasing_org, company_code

Matched invoices only; treat non-PO and multi-PO invoices separately.

Adapt: Lock median vs average and outlier caps (annual contracts).

Formula overview

Same formulas as a table — copy into KPI cards or SQL drafts.

Label Formula Grain Fields
PO spend SUM(TotalCost.Amount) FROM purchase_order WHERE OrderedDate IN period Purchase order PurchaseOrder.TotalCost.Amount, PurchaseOrder.OrderedDate, PurchaseOrder.Supplier.UniqueName
Invoice spend SUM(TotalCost.Amount) FROM invoice WHERE InvoiceDate IN period AND StatusString NOT IN (Rejected, Canceled) Invoice Invoice.TotalCost.Amount, Invoice.InvoiceDate, Invoice.StatusString, Invoice.Supplier.UniqueName
Open PO backlog SUM(open_amount) FROM purchase_order WHERE StatusString IN ('Ordered','Receiving') Open purchase order PurchaseOrder.StatusString, PurchaseOrder.TotalCost.Amount, PurchaseOrder.UniqueName
Suppliers active COUNT(DISTINCT Supplier.UniqueName) FROM purchase_order OR invoice WHERE date IN period Supplier with activity PurchaseOrder.Supplier.UniqueName, Invoice.Supplier.UniqueName, PurchaseOrder.OrderedDate
Cycle time PO→invoice (days) AVG(DATEDIFF(day, OrderedDate, InvoiceDate)) FROM invoice JOIN purchase_order ON Order.UniqueName Matched invoice↔PO PurchaseOrder.OrderedDate, Invoice.InvoiceDate, Invoice.Order.UniqueName

Tour