BankAccounts
Retrieve vendor bank accounts.
View-Specific Information
Select
The component uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The component processes other filters client-side within the component.
- SMVendorId supports the '=' comparison operator.
SELECT * FROM BankAccounts WHERE SMVendorId = 'S123456'
Columns
Name | Type | References | Description |
SMVendorId [KEY] | String |
Vendors.SMVendorId | A unique ID that SAP Ariba assigns automatically. |
Id [KEY] | String | The ID of the bank account. | |
ValidFrom | Date | Validity for bank account start date. | |
ValidTo | Date | Validity for bank account end date. | |
IBAN | String | The bank account's International Bank Account Number. | |
BankAccount | String | This field contains the number under which the account is managed at the bank. | |
BankNumber | String | The bank key under which the bank data is stored in the appropriate country. | |
BankAccountName | String | Name of the bank account. | |
BankAccountHolderName | String | The name of the bank account holder. | |
BankAccountReference | String | Reference details for the bank account. | |
AlternatePaymentAccount | String | Alternate payment account. | |
AdditionalPaymentReference | String | Additional reference details for payments. | |
BankControlKey | String | A check key for the combination bank number and bank account number. | |
BankCountryCode | String | The country code of the bank account. | |
BankAccountCurrencyCode | String | The currency code of the bank account. |