Retrieve contract workspace affected parties.

View-Specific Information

Select

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

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