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):
 |
This table structure is reflected in the extraction and leads to interdependencies:
 |
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 |