PendingApprovables
List all documents that are pending approval.
View-Specific Information
Select
The server uses the SAP Ariba API to process WHERE clause conditions that are built with the following columns and operators:
- ApprovableType supports the '=' comparison operator.
- Approver supports the '=' comparison operator.
- PasswordAdapter supports the '=' comparison operator.
For example, the following queries are processed server-side:
SELECT * FROM [PendingApprovables]
SELECT * FROM [PendingApprovables] WHERE [ApprovableType] = 'Val1'
SELECT * FROM [PendingApprovables] WHERE [Approver] = 'Val1'
SELECT * FROM [PendingApprovables] WHERE [PasswordAdapter] = 'Val1'
The server processes other filters client-side within the server.
Columns
| Name | Type | References | Description |
| ApprovableId [KEY] | String | Unique identifier of the approvable. | |
| ApprovableUniqueName | String | Unique name of approvable/document. | |
| ApprovableType | String | Type of the approvable/document. | |
| Approver [KEY] | String | Approver for this approvable/document. | |
| String | Email address of approver. | ||
| PasswordAdapter | String | Password adapter for the user. | |
| Description | String | Description about the approvable/document. | |
| Attachments | String | List of attachments. | |
| AssignedDate | Date | Assigned Date of this approvable. | |
| FullUrl | String | URL of the approvable. |