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 procument 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:
Log in to Ariba and select Manage - SM Admin.
In the API Field Configuration, select supplier as Type of data, and Supplier Data API as API Group.
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 |