JDBC Driver for SAP Ariba Source

Build 23.0.8839

Contacts

Fetch all the vendor contact details for the given vendors Ids.

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.

  • SMVendorId supports the '=,IN' comparison operators.
  • ERPVendorId supports the '=,IN' comparison operators.
  • ACMId supports the '=,IN' comparison operators.
For example, the following queries are processed server side:
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.
Email 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.

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