Retrieve vendor supplier information.

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 '=' comparison operator.

For example, the following query is processed server side:

SELECT * FROM Suppliers WHERE SMVendorId = 'S123456'

Columns

Name	Type	References	Description
SMVendorId [KEY]	String	Vendors.SMVendorId	A unique ID that SAP Ariba assigns automatically.
DeletionIndicator	Bool		Indicator for deletion.
VatLiability	Bool		VAT liability information.
BpKeyMappings	String		Business partner key mappings.
ResponsibleTypeCode	String		Code for the responsible type.
AccountingInformation	String		Accounting information.
PurchasingArrangements	String		Purchasing arrangements information.
IsPurchasingBlocked	Bool		Indicator for whether purchasing is blocked.
PurchasingBlockingReasonCode	String		Reason code for purchasing blocking.
IsPaymentBlocked	Bool		Indicator for whether payment is blocked.
PaymentBlockingReasonCode	String		Reason code for payment blocking.
IsPostingBlocked	Bool		Indicator for whether posting is blocked.
PostingBlockingReasonCode	String		Reason code for posting blocking.