Requisitions
Returns a collection of requisitions.
View-Specific Information
Select
The connector uses the SAP Ariba API to process WHERE clause conditions that are built with the following columns and operators:
- ApprovableId supports the '=,IN' comparison operators.
- UniqueName supports the '=,IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM [Requisitions]
SELECT * FROM [Requisitions] WHERE [ApprovableId] = 'Val1'
SELECT * FROM [Requisitions] WHERE [UniqueName] = 'Val1'
The connector processes other filters client-side within the connector.
Columns
| Name | Type | References | Description |
| ApprovableId [KEY] | String | The unique identifier of the approvable requisition. | |
| UniqueName | String | The identifier that uniquely identifies the requisition. | |
| Title | String | The title of the requisition. | |
| StatusString | String | The current status of the requisition. | |
| Version | Int | The version number of this approvable. | |
| IsPinned | Bool | Indicates whether this approvable is pinned. | |
| LineItemCount | Int | The total count of line items in the requisition. | |
| ActiveApproverCount | Int | The total count of active approvers for this requisition. | |
| ActiveApprovalRequestIds | String | A comma-separated list of active approval request IDs. | |
| Realm | String | The name of the realm the requisition belongs to. | |
| Site | String | The canonical site name. | |
| FullUrl | String | The URL linked to the approvable in the system. | |
| TotalCostAmount | Decimal | The monetary value of the total cost. | |
| TotalCostCurrency | String | The currency of the total cost. | |
| SubmitDate | Datetime | The date when the requester submitted the requisition. | |
| TimeUpdated | Datetime | The most recent timestamp when the requisition was updated. | |
| LastModified | Datetime | The timestamp of the last modification. | |
| RequesterUniqueName | String | The unique technical system name of the requester. | |
| RequesterName | String | The system unique identifier of the requester. | |
| RequesterEmailAddress | String | The email address of the requester. | |
| RequesterPhone | String | The phone number of the requester. | |
| RequesterPasswordAdapter | String | The password adapter mechanism of the requester. | |
| RequesterRealm | String | The realm of the requester. | |
| FirstActiveApproverName | String | The name of the first active approver. | |
| LineItems | String | Line items for this requisition. | |
| Comments | String | Comments on this requisition. | |
| Attachments | String | Attachments on this requisition. | |
| Records | String | Modification records for this requisition. | |
| ApprovalRequests | String | Approval requests for this requisition. | |
| Messages | String | Messages on this requisition. |