Retrieve vendor supplier information purchasing arrangements.

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.

For example, the following query is processed server side:

SELECT * FROM SupplierPurchasingArrangements WHERE SMVendorId = 'S123456'

Columns

Name	Type	References	Description
SMVendorId [KEY]	String	Vendors.SMVendorId	A unique ID that SAP Ariba assigns automatically.
PurchasingGroupDisplayId [KEY]	String		Purchasing group display id.
PurchasingOrganizationDisplayId [KEY]	String		Purchasing organization display id.
Functions [KEY]	String		Functions.
IsMarkedForDeletion	Bool		Is marked for deletion.
CurrencyCode	String		Currency code.
CalculationSchemaCode	String		Calculation schema code.
ClassificationCode	String		Classification code.
IncotermsClassificationCode	String		Incoterms classification code.
IncotermsTransferLocationName	String		Incoterms transfer location name.
IsPurchasingBlocked	Bool		Is purchasing blocked.
PurchasingBlockingReasonCode	String		Purchasing blocking reason code.
IsAutoGenerationOfPurchaseOrdersAllowed	Bool		Is auto generation of purchase orders allowed.