ContractRequestLineItemAdvancedPricingTierSteps
Retrieves tiered pricing steps for contract request line items with advanced pricing.
View-Specific Information
Select
The connector uses the SAP Ariba API to process WHERE clause conditions that are built with the following column and operators:
- ContractRequestUniqueName supports the '=,IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM [ContractRequestLineItemAdvancedPricingTierSteps]
SELECT * FROM [ContractRequestLineItemAdvancedPricingTierSteps] WHERE [ContractRequestUniqueName] = 'CR10'
The connector processes other filters client-side within the connector.
Columns
| Name | Type | References | Description |
| ContractRequestUniqueName [KEY] | String |
ContractRequests.UniqueName | The unique identifier of the contract request that contains these line items. |
| LineItemNumberInCollection [KEY] | Int |
ContractRequestLineItems.NumberInCollection | Line number within the contract request. |
| PricingTierNumberInCollection [KEY] | Int |
ContractRequestLineItemAdvancedPricingTiers.NumberInCollection | Position of the tier object in the response collection. |
| NumberInCollection [KEY] | Int | Position of the pricing step object in the response collection. | |
| MinTierValue | Decimal | Minimum tier value threshold for this pricing step. | |
| TierValue | Decimal | Tier value (price or percentage) for this pricing step. |