Skip to main content

Celonis Product Documentation

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):

41189753.png

This table structure is reflected in the extraction and leads to interdependencies:

41189754.png

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

EventSummaryFact

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:

  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 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