Contacts
Fetch all the vendor contact details for the given vendors Ids.
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.
- SMVendorId supports the '=,IN' comparison operators.
- ERPVendorId supports the '=,IN' comparison operators.
- ACMId supports the '=,IN' comparison operators.
SELECT * FROM Contacts WHERE SMVendorId = 'S123456'
SELECT * FROM Contacts WHERE ERPVendorId = '1000005002'
SELECT * FROM Contacts WHERE ACMId = '1000005002'
Columns
Name | Type | References | Description |
SMVendorId [KEY] | String |
Vendors.SMVendorId | The ID that SAP Ariba assigns to the supplier. |
ERPVendorId | String | The ID of the supplier in the integrated ERP system. | |
ANId | String | An ID that SAP Business Network automatically assigns to suppliers when they create accounts. | |
ACMId | String | A unique ID assigned by SAP Ariba that identifies suppliers internally within SAP Ariba applications. | |
SupplierName | String | The name of the supplier. In general, erpVendorId associates a contact with a contact with a supplier. | |
S4UniqueName [KEY] | String | The unique name of the supplier contact in SAP Ariba Strategic Sourcing Suite. | |
FirstName | String | The first name of the supplier contact. | |
LastName | String | The last name of the supplier contact. | |
MiddleName | String | The middle name of the supplier contact. | |
String | The supplier contact's email address. | ||
Telephone | String | The supplier contact's land line telephone number. | |
Title | String | The supplier contact's title. | |
AodObjectId | String | Indicates whether a supplier is private or public. | |
Categories | String | The commodities for which the supplier contact is responsible. | |
MobilePhone | String | The supplier contact's mobile telephone number. | |
Regions | String | The regions for which the supplier contact is responsible. | |
SourceSystem | String | The source system. | |
Type | String | The type of the supplier contact that matches one of the types defined for your site. | |
Locale | String | The ISO code for the supplier contact's language. | |
TimeZoneId | String | The ID of the timezone where the supplier contact is located. | |
Departments | String | The departments associated with the contact, if any. | |
MobileCountryName | String | The country/region of the supplier contact's mobile telephone number. SAP Ariba Supplier Management solutions automatically insert a plus sign (+) before of the country/region code in user interface display and JSON response. | |
TelephoneCountryName | String | The country/region of the supplier contact's land line telephone number. | |
Role | String | The role. | |
TimeUpdated | Datetime | The date and time when the contact was last updated. | |
TimeCreated | Datetime | The date and time when the contact was created. | |
Primary | Bool | A Boolean value that specifies whether or not the supplier contact is the primary contact for the supplier. | |
Active | Bool | A Boolean value that specifies whether the contact is active or deactivated. |