Power BI Connector for SAP Ariba Procurement

Build 25.0.9454

UpdateContractAccumulators

Updates contract accumulators for specified transaction documents in the SAP Ariba solution.

Procedure-Specific Information

The following input can accept either a temporary table name or an API JSON aggregate as a value.

  • ContractAccumulators references the Internal_ContractAccumulators.rsd temporary table.

ContractAccumulators Temporary Table Columns

Column NameTypeDescription
MaNumberInCollectionIntUnique number to identify the contract line item number in collection.
MaUniqueNameStringUnique name associated with Master Agreement.
TxnDocLineQuantityDecimalQuantity associated with transaction document line.
TxnDocNumberInCollectionIntUnique number to identify transaction document line item number.
TxnDocLineAmountContractAmountDecimalTransaction document line amount in contract currency.
TxnDocLineAmountContractCurrencyUniqueNameStringTransaction document line amount contract currency unique name.
TxnDocLineAmountContractCurrencyNameStringTransaction document line amount contract currency name.
TxnDocLineAmountProcurementAmountDecimalTransaction document line amount in procurement currency.
TxnDocLineAmountProcurementCurrencyUniqueNameStringTransaction document line amount procurement currency unique name.
TxnDocLineAmountProcurementCurrencyNameStringTransaction document line amount procurement currency name.
TxnDocLineChargeAmountContractAmountDecimalTransaction document line charge amount in contract currency.
TxnDocLineChargeAmountContractCurrencyUniqueNameStringTransaction document line charge amount contract currency unique name.
TxnDocLineChargeAmountContractCurrencyNameStringTransaction document line charge amount contract currency name.
TxnDocLineChargeAmountProcurementAmountDecimalTransaction document line charge amount in procurement currency.
TxnDocLineChargeAmountProcurementCurrencyUniqueNameStringTransaction document line charge amount procurement currency unique name.
TxnDocLineChargeAmountProcurementCurrencyNameStringTransaction document line charge amount procurement currency name.
TxnDocLineDiscountAmountContractAmountDecimalTransaction document line discount amount in contract currency.
TxnDocLineDiscountAmountContractCurrencyUniqueNameStringTransaction document line discount amount contract currency unique name.
TxnDocLineDiscountAmountContractCurrencyNameStringTransaction document line discount amount contract currency name.
TxnDocLineDiscountAmountProcurementAmountDecimalTransaction document line discount amount in procurement currency.
TxnDocLineDiscountAmountProcurementCurrencyUniqueNameStringTransaction document line discount amount procurement currency unique name.
TxnDocLineDiscountAmountProcurementCurrencyNameStringTransaction document line discount amount procurement currency name.
TxnDocLineTaxAmountContractAmountDecimalTransaction document line tax amount in contract currency.
TxnDocLineTaxAmountContractCurrencyUniqueNameStringTransaction document line tax amount contract currency unique name.
TxnDocLineTaxAmountContractCurrencyNameStringTransaction document line tax amount contract currency name.
TxnDocLineTaxAmountProcurementAmountDecimalTransaction document line tax amount in procurement currency.
TxnDocLineTaxAmountProcurementCurrencyUniqueNameStringTransaction document line tax amount procurement currency unique name.
TxnDocLineTaxAmountProcurementCurrencyNameStringTransaction document line tax amount procurement currency name.

Input

Name Type Description
Realm String SAP Ariba realm identifier for the tenant.
Validate Boolean Set validate to true for validation only. By default updates accumulators along with validation.
Action String Action to perform on the contract accumulator.

The allowed values are Requisition:Submitted, Requisition:Withdrawn, Requisition:Denied, Requisition:Edited, Requisition:Approved, Requisition:Canceled, Order:Ordered, Order:Canceled, Receipt:Received, Invoice:Invoiced, Invoice:Reconciled, InvoiceReconciliation:Paid, Approver:Requisition:Edited, PaymentRequest:Canceled.

TxnIdentifier String Transaction identifier for the accumulator update.
TxnDocUniqueName String Unique name of the transaction document.
ContractAccumulators String Array of accumulator data to update for the contract.

Result Set Columns

Name Type Description
Success String Indicates whether or not the operation was successful.
Details String Any extra details on the operation's execution.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454