Excel Add-In for SAP Ariba Source

Build 24.0.9060

BankInfos

Retrieve vendor bank related data.

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 '=,IN' comparison operators.
  • ERPVendorId supports the '=,IN' comparison operators.
  • VendorLastUpdateDate supports the '<=,<,=,>,>=' comparison operators.
  • VendorRegistrationStatus supports the '=,IN' comparison operators.
  • VendorQualificationStatus supports the '=,IN' comparison operators.
  • VendorPreferredLevel supports the '=,IN' comparison operators.
  • VendorBusinessUnit supports the '=,IN' comparison operators.
  • VendorCategory supports the '=,IN' comparison operators.
  • VendorRegion supports the '=,IN' comparison operators.
For example, the following queries are processed server side:
SELECT * FROM BankInfos WHERE SMVendorID = 'S123456'

SELECT * FROM BankInfos WHERE ERPVendorId = '1000003560'

SELECT * FROM BankInfos WHERE VendorRegistrationStatus = 'Registered'

SELECT * FROM BankInfos WHERE VendorQualificationStatus = 'Qualified'

SELECT * FROM BankInfos WHERE VendorPreferredLevel = 1

SELECT * FROM BankInfos WHERE VendorBusinessUnit = '408'

SELECT * FROM BankInfos WHERE VendorCategory = '51'

SELECT * FROM BankInfos WHERE VendorRegion = 'USA'

Columns

Name Type References Description
SMVendorId [KEY] String

Vendors.SMVendorId

A unique ID that SAP Ariba assigns automatically.
ERPVendorId String A mandatory ID, which must be unique in combination with the supplier's source system.
NumberInCollection [KEY] Int Position of the object in the response collection.
BankAccountInternalId String The internal ID of the bank account.
BankAccountStandardId String The standard ID of the bank account.
BankAccountExternalId String The external ID of the bank account.
AccountName String The name of the account.
AccountNumber String The number of the account.
BankBranch String The associated bank branch.
Country String The country code.
Address String Address related data.
VendorLastUpdateDate Datetime Date of the last update.
VendorRegistrationStatus String Registration status of the record.
VendorQualificationStatus String Qualification status of the record.
VendorPreferredLevel Int Preferred status. A number between 1 and 5. 1 is the highest preferred level and 5 is the lowest.
VendorBusinessUnit String A business unit or department ID loaded in your site as master data and used in supplier management projects.
VendorCategory String A category ID loaded in your site as master data and used in supplier management projects.
VendorRegion String A region code loaded in your site as master data and used in supplier management projects.

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