ContractRequestLineItemFormulaPricingGridInfos
Retrieves grid factor information for contract request line items with formula-based 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 [ContractRequestLineItemFormulaPricingGridInfos]
SELECT * FROM [ContractRequestLineItemFormulaPricingGridInfos] 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. |
| NumberInCollection [KEY] | Int | Position of the grid info object in the response collection. | |
| FactorName | String | Factor that this particular grid is representing. | |
| FactorValueType | String | The type of the factor value (String, Boolean, Date).
The allowed values are String, Boolean, Date. | |
| GridName | String | Grid name as loaded from the import. | |
| FactorCellValues | String | List of grid factor and cell values. |