ODBC Driver for SAP Fieldglass

Build 23.0.8839


Query this table for approvals in SAPFieldglass.

View Specific Information

The 本製品 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 本製品.

  • 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'


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 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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839