AddressEmailAddresses
Retrieve vendor address data email addresses.
View-Specific Information
Select
The 本製品 uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The 本製品 processes other filters client-side within the 本製品.
- SMVendorId supports the '=' comparison operator.
SELECT * FROM AddressEmailAddresses 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 email address. | |
ValidFrom | Date | Validity for email address start date. | |
ValidTo | Date | Validity for email address end date. | |
Address | String | The email address. | |
IsDefault | Bool | Indicator for whether this is the default email address. | |
UsageDeniedIndicator | Bool | Signifies whether of not the email address can be used for communication. |