Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

Reason for Development

With the existing exporting to excel feature,  the hyperlinks are not exported. The users have to go back to the CRM WebUI to the same point every time they'd like to access the details of the data object.

Overview

 

With the development of this future, the hyperlinks are now exported to Excel. This allows the user to directly access an object by clicking on the hyperlink available in the Excel.

This feature was introduced via SAP Note 2385092 - Direct URL links in Export to Spreadsheet for Excel .

And it is included in the following service packs:

WEBUI 731 SP19

WEBUI 747 SP14

WEBUI 748 SP06

Requirements

For hyperlinks to exported, the following requirements are needed:

  • The access to Clipboard is required.

To enable this in IE, navigate to the Security tab in Settings, click on the "Custom level..." button, under "Scripting" set "Allow Programmatic clipboard access"  to Enabled.

  • ActiveX Controls is required.

So it will only work in Internet Explorer and not in other browsers (such as Firefox, Safari, and Chrome).

  • The objects can be opened in new tab/window. Check that Note 2135300 is implemented and 'LINK_CONTEXT_MENU' = TRUE is set in Business Role Profile.

Testing this feature

To test this feature, please follow these steps

1.Log on the CRM WebUI with business role SALESPRO

2.Go to the Account Management work center and click Accounts under Search, perform a search to return some records

3.Click the Export to Spreadsheet button in the result list view

4.The records are exported to the excel and the hyperlinks are also exported. It is possible to click on the hyperlink in the Excel to open the account directly.

.

Related Content

Related Documents

Related SAP Notes/KBAs

__________________________________________________________________________________________________________

Use this structure to help you compose your contributions for WIKI and at the same time will ensure spelling and grammar.

  • No labels