AuditTrails
Query this table for audit trails in SAPFieldglass.
View Specific Information
The add-in will use the SAP Fieldglass API to process WHERE clause conditions built with the following column and operator. The remaining filter criteria is executed client-side within the add-in.
- Status supports the '=' operator.
For example, the following query is processed server-side:
SELECT * FROM AuditTrails WHERE Status = 'OK'
Columns
| Name | Type | Description |
| Id [KEY] | String | The Id of the audit trail. |
| Category | String | The category of the audit trail. |
| Company | String | The company of the audit trail. |
| Details | String | The details of the audit trail. |
| Status | String | The status of the audit trail.
The allowed values are OK, Error. |
| Type | String | The type of the audit trail. |
| User | String | The user of the audit trail. |
| StartTime | Datetime | The start time of the audit trail. |
| StopTime | Datetime | The stop time of the audit trail. |
| PassportActionType | Integer | The action type of the audit trail's passport. |
| PassportComponentType | Integer | The component type of the audit trail's passport. |
| PassportTransactionId | String | The transaction id of the audit trail's passport. |
| Version | String | The version of the audit trail. |
| Activity | String | The activity of the audit trail. |
| CompanyAttribute | String | The company attribute of the audit trail. |
| DocumentStatus | String | The document status of the audit trail. |
| ClientMessage | String | The client message of the audit trail. |
| ClientReturnCode | Integer | The client return code of the audit trail. |
| CRC32Checksum | String | The CRC32 checksum of the audit trail. |
| DeliveryTime | Integer | The delivery time of the audit trail. |
| DeliveryStatus | String | The delivery status of the audit trail. |
| Duration | Datetime | The duration of the audit trail. |
| Message | Boolean | The message of the audit trail. |
| RecordsFailed | String | The number of the audit trail's failed records. |
| RecordsProcessed | String | The number of the audit trail's processed records. |
| ServerMessage | String | The server message of the audit trail. |
| ServerStatus | String | The server status of the audit trail. |
| UploadFile | String | The uploaded file of the audit trail. |