ContractRequestForecastedSpendItems

Retrieves items within the forecasted spend breakdown.

View-Specific Information

The connector uses the SAP Ariba API to process WHERE clause conditions that are built with the following column and operators:

ContractRequestUniqueName supports the '=,!=,CONTAINS' comparison operators.

For example, the following queries are processed server-side:

SELECT * FROM [ContractRequestForecastedSpendItems]
SELECT * FROM [ContractRequestForecastedSpendItems] WHERE [ContractRequestUniqueName] = 'CR10'

The connector processes other filters client-side within the connector.


Name	Type	References	Description
ContractRequestUniqueName [KEY]	String	ContractRequests.UniqueName	The unique identifier of the contract request.
NumberInCollection [KEY]	Int		Position of the forecasted spend item object in the response collection.
StartDate	Datetime		Start date of the item.
EndDate	Datetime		End date of the item.
Amount	Decimal		Forecasted amount of the item.
AmountCurrencyName	String		Currency name of the forecasted amount.
AmountCurrencyUniqueName	String		Currency unique name of the forecasted amount.