Excel Add-In for SAP Ariba Source

Build 24.0.9060

CustomerSalesArrangements

Retrieve vendor customer information sales 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 CustomerSalesArrangements 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.
SalesGroupDisplayId String Display identifier for the sales group.
SalesOfficeDisplayId String Display identifier for the sales office.
Functions String Functions associated with the record.
IsMarkedForDeletion Bool Indicator for whether this record is marked for deletion.
SalesAreaRefSalesOrganizationDisplayId String Display identifier for the organization in the sales area reference.
SalesAreaRefDivision String Division in the sales area reference.
SalesAreaRefDistributionChannel String Distribution channel in the sales area reference.
SalesArrangementGroupCode String Code for the sales arrangement group.
SalesArrangementPriceGroupCode String Code for the sales arrangement price group.
CurrencyCode String Code for the currency.
IncotermsTransferLocationName String Name of the Incoterms transfer location.
IncotermsClassificationCode String Code for the Incoterms classification.
SalesBlockForCustomer Bool Sales block information for the customer.
DeliveryPriorityCode String Code indicating delivery priority.
IsDeliveryBlocked Bool Indicator for whether delivery is blocked.
DeliveryBlockedReasonCode String Code indicating the reason for delivery being blocked.
IsDeliveryCombinationAllowed Bool Indicator for whether delivery combination is allowed.
IsDeliveryInChunksAllowed Bool Indicator for whether delivery in chunks is allowed.
MaxCountDeliveryChunks Int Maximum count of delivery chunks allowed.
CompleteDeliveryIsDefined Bool Indicator for whether complete delivery is defined.
IsBillingBlocked Bool Indicator for whether billing is blocked.
BillingBlockedReasonCode String Code indicating the reason for billing being blocked.
IsOrderBlocked Bool Indicator for whether the order is blocked.
OrderBlockedReasonCode String Code indicating the reason for the order being blocked.

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