Excel Add-In for SAP Ariba Source

Build 24.0.9060

Identifications

Retrieve vendor identifications.

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 '=' comparison operator.
For example, the following query is processed server side:
SELECT * FROM Identifications WHERE SMVendorId = 'S123456'

Columns

Name Type References Description
SMVendorId [KEY] String

Vendors.SMVendorId

A unique ID that SAP Ariba assigns automatically.
NumberInCollection [KEY] Int Position of the identification object in the response collection.
IdentificationNumber String Identification number.
ValidFrom Date Validity for identification start date.
ValidTo Date Validity for identification end date.
EntryDate Date Entry date of the record.
Institute String Institute associated with the identification.
IdentificationTypeCode String Code for the type of identification.
CountryCode String Code for the country of the identification.
RegionCode String Code for the region of the identification.

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