Excel Add-In for SAP Ariba Source

Build 24.0.9060

AffectedParties

Retrieve contract workspace affected parties.

View-Specific Information

Select

The add-in uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The add-in processes other filters client-side within the add-in.

  • ContractId supports the '=' comparison operator.
For example, the following query is processed server side:
SELECT * FROM AffectedParties WHERE ContractId = 'CW0001'

Columns

Name Type References Description
ContractId [KEY] String

Workspaces.ContractId

ID of the contract.
SystemID [KEY] String The System ID of the affected party.
SmVendorID String A unique ID that SAP Ariba assigns automatically.
Name String The name of the affected party.
IsBlocked Bool Whether this record is blocked.
OrganizationIDs String The organization IDs for the affected party.
AddressName String Name associated with the address.
AddressUniqueName String Unique name associated with the address.
AddressPhone String Phone number associated with the address.
AddressFax String Fax number associated with the address.
AddressLines String Lines in the address.
AddressCity String City in the address.
AddressState String State in the address.
AddressCountry String Country in the address.
AddressPostalCode String Postal code in the address.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060