TDV Adapter for SAP Concur

Build 22.0.8462

ReportComments

Read the comments entered on the expense report header, or expenses of an existing expense report.

Table Specific Information

Select

The adapter uses the SAP Concur APIs to process filters that refer to ReportId, UserId, and ContextType. The adapter processes other filters client-side within the adapter.

All 3 filters are required to query ReportComments. If ReportId is not specified, the adapter will query the Reports table to retrieve the Id values. If ContextType is not specified, the default value will be TRAVELER. The UserId value should either be specified in the query or in the UserId connection property.

These are some example queries:

SELECT * FROM ReportComments
SELECT * FROM ReportComments WHERE UserId = '4b32882d-29t3-3f88-a738-c299ae3212'
SELECT * FROM ReportComments WHERE UserId = '4b32882d-29t3-3f88-a738-c299ae3212' AND ReportId IN ('288DG832423A4E5B6C4', '177DG832635A4E5B6D5')
SELECT * FROM ReportComments WHERE UserId = '4b32882d-29t3-3f88-a738-c299ae3212' AND ReportId IN ('288DG832423A4E5B6C4', '177DG832635A4E5B6D5') AND ContextType = 'PROXY'

Columns

Name Type References Description
Comment String The comments input on the report by all users.
AuthorFirstName String The comment author's first name.
AuthorLastName String The comment author's last name.
AuthorMiddleInitial String The comment author's middle initial.
CreationDate Datetime The UTC datetime when the comment was created on the report or expense.
ExpenseId String The unique identifier of the expense.
IsAuditorComment Boolean If true, this attribute represents whether this comment has been authored by an auditor.
IsLatest Boolean If true, this attribute represents the latest comment by the user.
StepInstanceId String The unique identifier of the step instance.
CreatedForEmployeeId String The unique identifier of the employee the comment was created on behalf of.
CreatedForEmployeeFirstName String The first name of the employee the comment was created on behalf of.
CreatedForEmployeeLastName String The last name of the employee the comment was created on behalf of.
CreatedForEmployeeMiddleInitial String The middle initial of the employee the comment was created on behalf of.
ReportId String The unique identifier of the report that is being read.

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
UserId String The unique identifier of the SAP Concur user. Query the Identity table to retrieve this value.
ContextType String The access level of the SAP Concur user, which determines the form fields they can view/modify. Supported values: TRAVELER, PROXY. Default value is TRAVELER.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462