SAP Concur Additional Columns
Answered
Connector name: SAP Concur
Table name:
-
Request ID Mapping: Supporting the SAP Concur Request Associations endpoint to map
RequestIdwith Expense Entries/Reports. -
Destination Country: Exposing
mainDestination.countryCodefor Travel Requests.
Column to add:
-
Request ID Mapping: Supporting the SAP Concur Request Associations endpoint to map
RequestIdwith Expense Entries/Reports. -
Destination Country: Exposing
mainDestination.countryCodefor Travel Requests.
API documentation link: Please check case #405674 or with support engineer Mriganka Bora for more information
Additional details: Please check case #405674 or with support engineer Mriganka Bora for more information
-
Official comment
Hi Ramandeep,
Here are the destination tables for those two endpoints:
1. Attendee Associations v4 →expense_attendee_association(plus a companionexpense_attendee_association_custom_datatable for custom fields). Note we also have an olderentry_attendee_associationtable from the legacy expense flow and the v4 endpoint you linked maps toexpense_attendee_association.
2. Travel Request v4 - Request Resources →travel_requestI'll keep this thread updated with any progress.
Thanks,
Rohan -
As part of Gifts & Hospitality requirements, adding to feature request for bold highlighted end point?
SAP Concur Developer Center | Travel Request v4 - Getting Started
Resource
Description
Request
You can read, create, update or delete a Request and get the list of existing Requests.
Workflow
You can perform action in the approval workflow of a Request (submit, approve, cancel…)
Expected Expense
You can read, create, update or delete an expected expense, and get the list of expected Expenses for a specific Request.
Request Allocation
You can read or update existing allocation for a specific Request.
Request Policy
You can get the list of existing Request policies.
Travel Agency
You can get the description of a Travel Agency office.
Agency Proposals
Ability for Travel Agencies to interact with Concur Request to submit travel itineraries directly into a request.
-
Sorry for multiple updates. Below are our consolidated feature requests. Thanks you!
Expense
Reports
Attendees
Attendee Details
Requests
SAP Concur Developer Center | Travel Request v4 - Request Resources
User Spend
User Identity
Request Associations
Receipts
Request SAP Concur Developer Center | Travel Request v4 - Request Resources
Expected Expense SAP Concur Developer Center | Travel Request v4 - Expected Expense Resources
Request Policy SAP Concur Developer Center | Travel Request v4 - Request Policy Resources
-
Sorry for multiple updates. Below are the updated consolidated feature requests. Thanks you!
Tables
Expense
Reports
Attendees
Attendee Details
Requests
SAP Concur Developer Center | Travel Request v4 - Request Resources
User Spend
User Identity
Request Associations
Receipts
Request SAP Concur Developer Center | Travel Request v4 - Request Resources
Expected Expense SAP Concur Developer Center | Travel Request v4 - Expected Expense Resources
Request Policy SAP Concur Developer Center | Travel Request v4 - Request Policy Resources
-
Hi,
The 4 endpoints (out of 12) that are listed below are already implemented and are live:
Attendee Details: SAP Concur Developer Center | Attendees v4
Requests: SAP Concur Developer Center | Travel Request v4 - Request Resources
User Spend: SAP Concur Developer Center | Spend Extension v4.1
User Identity: SAP Concur Developer Center | Identity v4.1
We are taking a look at the remaining 8 endpoints and will update shortly.
Thanks,
Rohan -
Hi,
Thanks for the update Rohan. I have update our internal team. Once you have latest status on other endpoints, then please let us know.
-
Hi Rohan,
Thank for the update. Please check below comments:-
-
Hi Rohan,
Any update on my previous comment?
-
Attendee Details: SAP Concur Developer Center | Attendees v4 --> is this "attendee_v4" table?
-
User Identity: SAP Concur Developer Center | Identity v4.1 --> Which table is this?
Are additional privileges required?
-
-
Hi Ramandeep,
Sharing my answers for your questions below:
Attendee Details:SAP Concur Developer Center | Attendees v4 : is this "attendee_v4" table? --> Yes
Requests: SAP Concur Developer Center | Travel Request v4 - Request Resources: I see "travel_request" table and not "travel_request_v4" table --> It is named "travel_request"
User Spend: SAP Concur Developer Center | Spend Extension v4.1 : Which table is this? Is it "spend_user" table? I see "spend_user" table and not "spend_user_v4" table --> It is "spend_user"
User Identity: SAP Concur Developer Center | Identity v4.1: Which table is this? --> user table syncs identity v4.1
We also have 2 more endpoints implemented are ready to be used:
Attendees: Attendee Associations v4
We are currently working on implementing the remaining 6 endpoints and I'll keep you updated once they are ready to be used.
Thanks,
Rohan -
-
Hi Rohan,
For SAP Concur Developer Center | Travel Request v4 - Request Resources you mentioned table name is "travel_request". We have this table under replication but as per our team, this is not v4 table. Can you please double check.
Also as requested earlier, please let me know table names for these endpoints:-
-
Attendees: Attendee Associations v4
-
Please sign in to leave a comment.
Comments
11 comments