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.
SELECT * FROM AddressWebsites WHERE SMVendorId = 'S123456'
Columns
Name | Type | References | Description |
SMVendorId [KEY] | String |
Vendors.SMVendorId | A unique ID that SAP Ariba assigns automatically. |
AddressNumberInCollection [KEY] | Int | Position of the address object in the response collection. | |
NumberInCollection [KEY] | Int | Position of the address website object in the response collection. | |
AddressId | String | The ID of the address. | |
Id | 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. |