lisamihal
Occasional Member - Level 2

Export Routing Configuration Mapping List

Hi - 

I am looking for a way to export the Hierarchy Mapping List for Routing Configuration.  We have 218 Hierarchy paths, and it would be super helpful to be able to provide my mangers their list of Invoice Owners.

I am sure a report could be created in Cognos, but I have no idea where to find the fields.

Thanks in advance! 

4 REPLIES 4
KevinD
Community Manager
Community Manager

@lisamihal  There are very few things that can be exported out of SAP Concur itself, so Cognos is the best option. However, Invoice Owner isn't a role within SAP Concur. Any Invoice User can be an Invoice Owner, but someone is only an Invoice Owner if one is assigned to them. 

 

I'm looking in Cognos and it is possible, however there isn't any option to see someone's Invoice Approver. I can only see Approvers for Expense, Travel Request and Cash Advances. So, if everyone's default approver for Expense is also their approver for Invoices, this would work. However, I doubt that is the case at your company, or is it?

 

 


Thank you,
Kevin
SAP Concur Community Manager
Did this response answer your question? Be sure to select “Accept as Solution” so your fellow community members can be helped by it as well.
lisamihal
Occasional Member - Level 2

Thank you Kevin.

I do have a Cognos report that lists my default approvers. 

lisamihal_2-1781703920909.jpeg

 

What I am looking for is where to go to find the Invoice Owner and Hierarchy Path fields from Routing Configuration  so I can create a Cognos report.  Thanks!

KevinD
Community Manager
Community Manager

@lisamihal I'm not finding any Invoice Owner or Hierarchy Path data items in Cognos. 


Thank you,
Kevin
SAP Concur Community Manager
Did this response answer your question? Be sure to select “Accept as Solution” so your fellow community members can be helped by it as well.
samasuraj
Occasional Member - Level 1

Hi  @lisamihal 

 

Topic: Export Routing Configuration Mapping List

 

Please check the below. Hope this helps.

-----

For SAP Concur Invoice, exporting the Routing Configuration Hierarchy Mapping List with all 218 hierarchy paths and assigned Invoice Owners may not be available through a standard export.

 

Recommended approach:

  1. Navigate to Administration → Invoice → Routing Configuration and review the Hierarchy Mapping List for any available export functionality.
  2. In Cognos Intelligence, investigate the Invoice reporting package for hierarchy, organizational unit, and invoice owner fields.
  3. Confirm whether the reporting package exposes routing configuration mappings, rather than only invoice transaction data.
  4. Ask SAP Concur Support whether the mapping list can be extracted through a supported administrative export, API, or backend data request.
  5. If no standard export exists, request a product enhancement rather than manually maintaining 218 hierarchy mappings.

Important: Cognos may expose invoice ownership and approval data without exposing the underlying routing configuration table.

 

My recommendation: Before developing a Cognos report, confirm with SAP Concur Support whether the complete Hierarchy Mapping List is available as a reporting data source.

 

Bottom line: The objective should be a single, reliable export containing Hierarchy Path, Invoice Owner, and Routing Assignment, without manually recreating 218 mappings.

 

 Thanks & Regards

--

Samantha Prathikantam

SF_EC & ECP / SAP Concur Consultant