Approvals
Query this table for approvals in SAPFieldglass.
View Specific Information
The connector 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 connector.
- 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. |