Excel Add-In for SAP Ariba Source

Build 24.0.9060

SupplierPurchasingArrangements

Retrieve vendor supplier information purchasing arrangements.

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 SupplierPurchasingArrangements WHERE SMVendorId = 'S123456'

Columns

Name Type References Description
SMVendorId [KEY] String

Vendors.SMVendorId

A unique ID that SAP Ariba assigns automatically.
NumberInCollection [KEY] Int Position of the object in the response collection.
PurchasingGroupDisplayId String Purchasing group display id.
PurchasingOrganizationDisplayId String Purchasing organization display id.
Functions 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.

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