ODBC Driver for SAP Ariba Source

Build 23.0.8839

AddressWebsites

Retrieve vendor address data websites.

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

Columns

Name Type References Description
SMVendorId [KEY] String

Vendors.SMVendorId

A unique ID that SAP Ariba assigns automatically.
AddressId [KEY] String The ID of the address.
Id [KEY] String The ID of the website.
ValidFrom Date Validity for website start date.
ValidTo Date Validity for website end date.
Url String The website's URL.
UriType String The type of the URI.
IsDefault Bool Indicator for whether this is the default website.

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