Skip to main content

Celonis Product Documentation

Supported API Endpoints and available Tables

Overview over all Endpoints

General Information

Currently, we support nearly all API’s together with all objects available via SAP Ariba’s API’s. Please check out the following overview over all these supported API’s and objects:

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 example from Procurement API for the Requisition object):

41189753.png

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

41189754.png
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

Contracts

ContractOrganizationIds

ContractsLineItems

ContractRequests

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:

Login to Ariba > 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

VendorData

VendorDataCertificates

VendorDataWorkspaces

VendorDataWorkspacesSupplierRequest

VendorDataWorkspacesRegistration

VendorDataWorkspacesQualification

VendorDataWorkspacesDisqualification

VendorDataWorkspacesPreferred

VendorDataWorkspacesSegmentation

VendorDataWorkspacesQualificationRequest

VendorDataWorkspacesModularQuestionnaire

VendorDataWorkspacesQuestionnaires

VendorDataWorkspacesQuestionnairesQna

Document Approval (Procurement Document Approval API)

Table

Changes

ChangesApprovers

ChangesRequisitionDetails

ChangesInvoicesDetails

PendingApprovable

PendingApprovablesAttachments

PendingApprovablesRequisitionDetails

PendingApprovablesInvoiceDetails

External Approval (Strategic Sourcing External Approval API for Sourcing and Supplier Management)

Table

Changes

ChangesEntityDetails

PendingApprovables

PendingApprovablesAttachments

PendingApprovablesEntityDetails

Custom Forms (Procurement Custom Forms API)

Table

Forms

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