Retrieve all vendors.

View-Specific Information

Select

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

• SMVendorId supports the '=,IN' comparison operators.
• ERPVendorId supports the '=,IN' comparison operators.
• RegistrationStatus supports the '=,IN' comparison operators.
• QualificationStatus supports the '=,IN' comparison operators.
• LastUpdateDate supports the '<=,<,=,>,>=' comparison operators.
• PreferredLevel supports the '=,IN' comparison operators.
• BusinessUnit supports the '=,IN' comparison operators.
• Category supports the '=,IN' comparison operators.
• Region supports the '=,IN' comparison operators.

For example, the following queries are processed server side:

SELECT * FROM Vendors WHERE SMVendorId = 'S123456'

SELECT * FROM Vendors WHERE RegistrationStatus = 'Registered'

SELECT * FROM Vendors WHERE QualificationStatus = 'Qualified'

SELECT * FROM Vendors WHERE LastUpdateDate > '2018-09-29T12:20:51Z' AND LastUpdateDate < '2019-10-04T12:20:51Z' 

SELECT * FROM Vendors WHERE PreferredLevel = 1

SELECT * FROM Vendors WHERE BusinessUnit = '408'

SELECT * FROM Vendors WHERE Category = '51'

SELECT * FROM Vendors WHERE Region = 'USA'

Columns

Name	Type	References	Description
SMVendorId [KEY]	String		A unique ID that SAP Ariba assigns automatically.
DuplicateSMVendorId	String		Duplicate vendor ID.
ERPVendorId	String		A mandatory ID, which must be unique in combination with the supplier's source system.
ANId	String		The Ariba Network ID.
ACMId	String		A unique ID assigned by SAP Ariba used for identification internally within SAP Ariba applications.
DUNSId	String		Data Universal Numbering System ID.
MasterVendorId	String		The master vendor ID.
Name2	String		Second name field.
Name3	String		Third name field.
Name4	String		Fourth name field.
Creator	String		Creator of the record.
Approved	Bool		Approval status of the record.
SourceSystem	String		Source system of the record.
IndustryCode	String		Code for the industry of the record.
BlockedStatus	String		Blocked status of the record.
RelationshipEstablishedType	String		Type of relationship established.
MainVendorType	Bool		Main vendor type in the record.
IntegratedToERP	String		Indicator for integration with ERP.
RegistrationStatus	String		Registration status of the record.
Qualifications	String		Qualifications associated with the record.
QualificationStatus	String		Qualification status of the record.
TaxInfos	String		Taxation related data.
BankInfos	String		Bank related data.
CompanyCodes	String		Company code related details.
SupplierName	String		Name of the supplier.
PrimarySupplierManager	String		Primary supplier manager.
AlternateSupplierManager	String		Alternate supplier manager.
TransactionalSupplier	Bool		Transactional supplier.
TransactionalSupplierRequestStatus	String		Status of transactional supplier request.
PrimaryContactFirstName	String		First name of the primary contact.
PrimaryContactMiddleName	String		Middle name of the primary contact.
PrimaryContactLastName	String		Last name of the primary contact.
PrimaryContactEmail	String		Email of the primary contact.
AddressLine1	String		Line 1 of the address.
AddressLine2	String		Line 2 of the address.
AddressLine3	String		Line 3 of the address.
AddressCity	String		City in the address.
AddressPOBox	String		PO Box in the address.
AddressRegionCode	String		Region code in the address.
AddressCountryCode	String		Country code in the address.
AddressPostalCode	String		Postal code in the address.
FormOfAddressCode	String		Code for the form of address.
RecordCreatedDate	Datetime		The creation date of the record.
LastIntegrationState	String		Last integration state of the record.
LastConfirmationState	String		Last confirmation state of the record.
LastReviewDate	Datetime		Date of the last review.
LastStatusChangeDate	Datetime		Date of the last status change.
LastUpdateDate	Datetime		Date of the last update.
PreferredLevel	Int		Preferred status. A number between 1 and 5. 1 is the highest preferred level and 5 is the lowest.
BusinessUnit	String		A business unit or department ID loaded in your site as master data and used in supplier management projects.
Category	String		A category ID loaded in your site as master data and used in supplier management projects.
Region	String		A region code loaded in your site as master data and used in supplier management projects.