Fetch vendor qualifications. Qualifications covers both qualifications (either supplier qualifications or process qualifications) and preferred category statuses.

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.
• VendorLastUpdateDate supports the '<=,<,=,>,>=' comparison operators.
• VendorRegistrationStatus supports the '=,IN' comparison operators.
• VendorQualificationStatus supports the '=,IN' comparison operators.
• VendorPreferredLevel supports the '=,IN' comparison operators.
• VendorBusinessUnit supports the '=,IN' comparison operators.
• VendorCategory supports the '=,IN' comparison operators.
• VendorRegion supports the '=,IN' comparison operators.

For example, the following queries are processed server side:

SELECT * FROM Qualifications WHERE SMVendorID = 'S123456'

SELECT * FROM Qualifications WHERE ERPVendorId = '1000003560'

SELECT * FROM Qualifications WHERE VendorRegistrationStatus = 'Registered'

SELECT * FROM Qualifications WHERE VendorQualificationStatus = 'Qualified'

SELECT * FROM Qualifications WHERE VendorPreferredLevel = 1

SELECT * FROM Qualifications WHERE VendorBusinessUnit = '408'

SELECT * FROM Qualifications WHERE VendorCategory = '51'

SELECT * FROM Qualifications WHERE VendorRegion = 'USA'

Columns

Name	Type	References	Description
SMVendorId [KEY]	String	Vendors.SMVendorId	A unique ID that SAP Ariba assigns automatically.
ERPVendorId	String		A mandatory ID, which must be unique in combination with the supplier's source system.
NumberInCollection [KEY]	Int		Position of the object in the response collection.
MaterialID	String		Material id.
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.
QualificationStatus	String		Qualification status.
PreferredStatus	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.
ProcessType	String		Process type. For process qualifications, the Process Type field includes the type of the qualification process as defined by process type data in your site.
VendorLastUpdateDate	Datetime		Date of the last update.
VendorRegistrationStatus	String		Registration status of the record.
VendorQualificationStatus	String		Qualification status of the record.
VendorPreferredLevel	Int		Preferred status. A number between 1 and 5. 1 is the highest preferred level and 5 is the lowest.
VendorBusinessUnit	String		A business unit or department ID loaded in your site as master data and used in supplier management projects.
VendorCategory	String		A category ID loaded in your site as master data and used in supplier management projects.
VendorRegion	String		A region code loaded in your site as master data and used in supplier management projects.