Approvals
Query this table for approvals in SAPFieldglass.
View Specific Information
The add-in will use the SAP Fieldglass API to process WHERE clause conditions built with the following columns and operators. The remaining filter criteria is executed client-side within the add-in.
- ModuleId supports the '=' operator.
- WorkItemId supports the '=' operator. This must be used alongside ModuleId.
For example, the following queries are processed server-side:
SELECT * FROM Approvals WHERE ModuleId = '70' SELECT * FROM Approvals WHERE ModuleId = '70' AND WorkItemId = '300'
Columns
| Name | Type | Description |
| Id [KEY] | String | The Id of the approval. |
| ModuleId | String | The Id of the module this approval belongs to. |
| ModuleName | String | The name of the module this approval belongs to. |
| Ref | String | The reference of the approval. |
| Uom | String | The unit of measure of the approval. |
| Name | String | The name of the approval. |
| Amount | Double | The amount of the approval. |
| StartDate | Date | The start date of the approval. |
| EndDate | Date | The end date of the approval. |
| CreateDate | Date | The created date of the approval. |
| CreatorName | String | The name of the approval's creator. |
| UniqueName | String | The unique name of the approval's creator. |
| EmailId | String | The id of the email of this approval. |
| RefVersion | Integer | The ref version of this approval. |
| ValidObject | Boolean | Indicates whether this approval is a valid object or not. |
| WorkerType | String | The type of the worker. |
| WorkerTypeLabel | String | The label of the worker type. |
| SourceLink | String | The source link of the approval. |
| Others | String | An aggregate of other properties for this approval. |
| Status | String | The status of this approval. |
| Details | String | The details of this approval. |
| ActivityID | String | The Id of the approval's activity. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| WorkItemId | String | The WorkItem Id you want to filter approvals with. This must be used in conjunction with ModuleId. |