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.
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. |