Skip to main content

Celonis Product Documentation

Supported SAP Ariba API endpoints

When connecting your SAP Ariba instance to the Celonis Platform your method of connection depends on the business object you want to extract. These objects are divided into asynchronous and synchronous APIs, dictating the APIs you use and the tables that are available for each.

  • Asynchronous APIs: With asynchronous APIs, the client sends a request to the server, but the server does not immediately send a response back to the client. Instead, the client is free to perform other actions while waiting for the server to finish processing the request. When the server is ready to send a response, it will do so, and the client can then receive the response. This means that the flow of information between the client and the server is asynchronous and the client is not blocked while waiting for the response.

  • Synchronous APIs: With synchronous APIs, the client sends a request to the server which then immediately sends a response back to the client. The client has to wait for the server to finish processing the request before it can receive the response. This means that the flow of information between the client and the server is synchronous and the client has to wait until it receives a response before it can perform any other actions.

Supported SAP Ariba asynchronous APIs

The SAP Ariba extractor supports the following asynchronous APIs:

  • Procurement

  • Sourcing

  • Analytical reporting

For more information, see: Asynchronous APIs for SAP Ariba.

The listing below for each API shows which tables and columns support filtering the result set based on the specific columns:

The following procurement tables are available:

  • CopyOrder

  • CopyOrderLineItems

  • CopyOrderLineItemsSplitAccountings

  • DirectOrder

  • DirectOrderLineItems

  • DirectOrderLineItemsSplitAccountings

  • ERPOrder

  • ERPOrderLineItems

  • ERPOrderLineItemsSplitAccountings

  • Invoice

  • InvoiceLineItem

  • InvoiceApprovalRequestes

  • InvoiceApprovalRecords

  • InvoiceLineItemSplitAccountings

  • InvoiceReconciliation

  • InvoiceReconciliationLineItems

  • InvoiceReconciliationRecords

  • InvoiceReconciliationApprovalRecords

  • InvoiceReconciliationRequests

  • InvoiceReconciliationExceptions

  • InvoiceReconciliationLineItemsExceptions

  • InvoiceReconciliationTaxDetails

  • InvoiceReconciliationPayments

  • InvoiceReconciliationRejectionReasons

  • InvoiceReconciliationLineItemsSplitAccountings

  • Receipt

  • ReceiptItems

  • ReceiptApprovalRequests

  • ReceiptItemsAssetData

  • Requisition

  • RequisitionApprovalRequests

  • RequisitionLineItems

  • RequisitionApprovalRecords

  • RequisitionLineItemsSplitAccountings

The following sourcing tables are supported:

  • Alternative

  • Answer

  • AuditEntry

  • ContractWorkspace

  • DeclineReason

  • DocumentTask

  • EmailTemplateContent

  • EventSummaryFact

  • InternalContractWorkspace

  • ItemSupplierData

  • Organization

  • Plan

  • ProjectAddin

  • ProjectAuditInfo

  • ProjectGroup

  • RFXBid

  • RFXDocument

  • RFXItem

  • RFXItemValue

  • SavingsAllocationsDetails

  • SavingsFrom

  • SalesContractWorkspace

  • Scenario

  • SourcingProject

  • Task

  • User

  • Workspace

The following analytical reporting tables are supported:

  • ContractAmendmentDetailsFact

  • ContractClauseFact

  • ContractDim

  • ContractFactFact

  • ContractItemFactFact

  • ContractLineItemDocumentFact

  • ContractLineItemFactFact

  • ContractWorkspaceFact

  • EventTypeDim

  • ExpenseSheetFact

  • GeneralContractWorkspaceFact

  • RegionDim

  • ServiceSheetFact

  • TimeSheetFact

Supported SAP Ariba synchronous APIs

The SAP Ariba extractor supports the following synchronous APIs:

  • Catalog content

  • Contract compliance

  • Custom forms

  • Document approval

  • External approval

  • Master data

  • Supplier data

For more information, see: Synchronous APIs for SAP Ariba.

The listing below for each API shows which tables and columns support filtering the result set based on the specific columns:

The following catalog content tables and columns are supported:

Table

Columns that support filtering

Catalogs

ActivatedData, supplierdomain

CatalogsItems

All columns

The following contract compliance tables and columns are supported:

Table

Columns that support filtering

Contracts

CreateDate, LastModified, ApprovedDate, StatusString, ReleaseType, UniqueName, Name, VersionNumber, PaymentTerms

ContractOrganizationIds

ContractsLineItems

ContractRequests

CreateDate, LastModified, ApprovedDate, StatusString, ReleaseType, UniqueName, Name, VersionNumber, PaymentTerms

ContractRequestsOrganizationIds

ContractRequestsLineItems

The following custom form tables and columns are supported:

Table

Columns that support filtering

Forms

status, name, publishedBy

FormsWidgetsMetadata

FormsDocuments

FormsDocumentsData

The following document approval tables and columns are supported:

Table

Columns that support filtering

Changes

changeSequenceId

ChangesApprovers

ChangesRequisitionDetails

ChangesInvoicesDetails

Groups

groupName

PendingApprovable

approvableType, user, passwordAdapter

PendingApprovablesAttachments

PendingApprovablesRequisitionDetails

PendingApprovablesInvoiceDetails

Requisitions

uniqueName

The following external approval tables and columns are supported:

Table

Columns that support filtering

Changes

ApprovableType: ApprovableSubType

ChangesEntityDetails

PendingApprovables

PendingApprovablesAttachments

PendingApprovablesEntityDetails

SAP Ariba applications save master data retrieved from third-party systems in their master data service. This API group allows you to extract the saved master data into Celonis.

The Master Data Retrieval API for procurement supports these master data tables:

  • Account

  • Account Category

  • Account Type

  • Address

  • Asset

  • BankAccountIDType

  • BankAccountType

  • BankIDType

  • BusinessUnit

  • ChargeType

  • ClassificationCodeMap

  • Common Supplier

  • CommodityCode

  • CommodityExportMapEntry

  • Company

  • CompanyCode

  • CostCenter

  • Country

  • Currency

  • CurrencyConversionRate

  • Department

  • GLBusinessUnit

  • GLIndicator

  • GeneralLedger

  • Group

  • IncoTerms

  • InternalOrder

  • ItemCategory

  • Language

  • LocaleID

  • Partitioned Commodity Code

  • PaymentMethodType

  • PaymentTerms

  • PlantPurchaseOrgCombo

  • PreferredSupplierLevel

  • ProcurementUnit

  • Product

  • Project

  • PurchaseGroup

  • PurchaseOrg

  • Region

  • RemittanceLocation

  • SegmentLevel

  • SetID

  • StatisticsCode

  • SubAccount

  • Supplier

  • Supplier location

  • TaxCode

  • UnitOfMeasure

  • User

  • WBSElement

For this API Group not all fields are extracted by default but certain fields need to be added in the Ariba system. Here's how to do this:

  1. Log in to Ariba and select Manage - SM Admin.

  2. In the API Field Configuration, select supplier as Type of data, and Supplier Data API as API Group.

  3. In the section Configurable fields, select the fields that might be missing and click Save.

The extractor will automatically add these fields once enabled in the SAP Ariba system.

Table

Column that support filtering

VendorData

updatedDateFrom, updatedDateTo

VendorDataCertificates

VendorDataWorkspaces

VendorDataWorkspacesSupplierRequest

VendorDataWorkspacesRegistration

VendorDataWorkspacesQualification

VendorDataWorkspacesDisqualification

VendorDataWorkspacesPreferred

VendorDataWorkspacesSegmentation

VendorDataWorkspacesQualificationRequest

VendorDataWorkspacesModularQuestionnaire

VendorDataWorkspacesQuestionnaires

VendorDataWorkspacesQuestionnairesQna