Supported API Endpoints and available Tables
Currently, we support the following APIs together with nearly all objects available via SAP Ariba. Every API Group requires its own data connection in Celonis because for each one separate credentials have to be created.
Asynchronous APIs:
Procurement
Sourcing
Analytical Reporting
Synchronous APIs:
Contract Compliance
Document Approval
Supplier Data
External Approval
Custom Forms
Master Data
Catalog Content
Tip
If you cannot see all of the mentioned tables in your extraction configuration, please see the following section about Standard and Custom View Templates
The response from the Ariba API includes nested tables (see an example from Procurement API for the Requisition object):
 |
This table structure is reflected in the extraction and leads to interdependencies:
 |
The listing below for each API shows which tables and columns support filtering the result set based on the specific columns.
Procurement (Operational Reporting for Procurement API)
Table |
|---|
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 |
Sourcing (Operational Reporting for Sourcing API)
Table |
|---|
Alternative |
Answer |
AuditEntry |
ContractWorkspace |
DeclineReason |
DocumentTask |
EmailTemplateContent |
InternalContractWorkspace |
ItemSupplierData |
Organization |
Plan |
ProjectAddin |
ProjectAuditInfo |
ProjectGroup |
RFXBid |
RFXDocument |
RFXItem |
RFXItemValue |
SavingsAllocationsDetails |
SavingsFrom |
SalesContractWorkspace |
Scenario |
SourcingProject |
Task |
User |
Workspace |
Analytical Reporting (Analytical Reporting API)
Table |
|---|
ContractAmendmentDetailsFact |
ContractClauseFact |
ContractDim |
ContractFactFact |
ContractItemFactFact |
ContractLineItemDocumentFact |
ContractLineItemFactFact |
ContractWorkspaceFact |
EventTypeDim |
ExpenseSheetFact |
GeneralContractWorkspaceFact |
RegionDim |
ServiceSheetFact |
TimeSheetFact |
Contract Compliance (Procurement Contract Compliance API)
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 |
Supplier Data (Supplier Management Supplier Data API with Pagination)
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 Ariba system.
Table | Columns that support filtering |
|---|---|
VendorData | updatedDateFrom, updatedDateTo |
VendorDataCertificates | |
VendorDataWorkspaces | |
VendorDataWorkspacesSupplierRequest | |
VendorDataWorkspacesRegistration | |
VendorDataWorkspacesQualification | |
VendorDataWorkspacesDisqualification | |
VendorDataWorkspacesPreferred | |
VendorDataWorkspacesSegmentation | |
VendorDataWorkspacesQualificationRequest | |
VendorDataWorkspacesModularQuestionnaire | |
VendorDataWorkspacesQuestionnaires | |
VendorDataWorkspacesQuestionnairesQna |
Document Approval (Procurement Document Approval API)
Table | Columns that support filtering |
|---|---|
Changes | changeSequenceId |
ChangesApprovers | |
ChangesRequisitionDetails | |
ChangesInvoicesDetails | |
Groups | groupName |
PendingApprovable | approvableType, user, passwordAdapter |
PendingApprovablesAttachments | |
PendingApprovablesRequisitionDetails | |
PendingApprovablesInvoiceDetails | |
Requisitions | uniqueName |
External Approval (Strategic Sourcing External Approval API for Sourcing and Supplier Management)
Table | Columns that support filtering |
|---|---|
Changes | ApprovableType: ApprovableSubType |
ChangesEntityDetails | |
PendingApprovables | |
PendingApprovablesAttachments | |
PendingApprovablesEntityDetails |
Custom Forms (Procurement Custom Forms API)
Table | Columns that support filtering |
|---|---|
Forms | status, name, publishedBy |
FormsWidgetsMetadata | |
FormsDocuments | |
FormsDocumentsData |
Master Data (Master Data Retrieval API for Procurement)
SAP Ariba applications save master data retrieved from third-party systems in their master data service. This API group allows customers to extract the saved master data into Celonis.
The Master Data Retrieval API for procurement supports these master data entities.
Table |
|---|
User |
Group |
UnitOfMeasure |
LocaleID |
IncoTerms |
ClassificationCodeMap |
Currency |
CurrencyConversionRate |
CommodityCode |
Country |
Language |
Partitioned Commodity Code |
BankAccountType |
Supplier Location |
RemittanceLocation |
BankIDType |
BankAccountIDType |
Supplier |
Common Supplier |
TaxCode |
ProcurementUnit |
Account |
Account Type |
PaymentMethodType |
Address |
PaymentTerms |
CostCenter |
CommodityExportMapEntry |
InternalOrder |
ChargeType |
WBSElement |
GeneralLedger |
Asset |
ItemCategory |
CompanyCode |
GLIndicator |
PurchaseGroup |
PurchaseOrg |
AccountCategory |
PlantPurchaseOrgCombo |
Region |
ChargeType |
Company |
BusinessUnit |
SubAccount |
Product |
Project |
Department |
SetId |
GLBusinessUnit |
StatisticsCode |
PreferredSupplierLevel |
SegmentationLevel |
Department |
Region |
Catalog Content (Catalog Content API)
Table | Columns that support filtering |
|---|---|
Catalogs | ActivatedDate, supplierdomain |
CatalogsItems | All columns |