Retrieve vendor customer information sales 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 CustomerSalesArrangements WHERE SMVendorId = 'S123456'

Columns

Name	Type	References	Description
SMVendorId [KEY]	String	Vendors.SMVendorId	A unique ID that SAP Ariba assigns automatically.
SalesGroupDisplayId [KEY]	String		Display identifier for the sales group.
SalesOfficeDisplayId [KEY]	String		Display identifier for the sales office.
Functions [KEY]	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.