Export to Spreadsheet
You can create export files, and reuse data that has already been entered, in the WebClient UI. This data is exported to a table processing program, for example, Microsoft Excel. Additionally, you can authorize the export to spreadsheet.
Prerequisites
To disable the authorization for the export to spreadsheet on business role level, you need to make the necessary settings in Customizing for UI Framework
under 
Technical Role Definition
Define Parameters
. With parameter EXPORT_DISABLE and parameter value TRUE you can disable the export.
To disable the export to spreadsheet in your business role, you need to assign function profile PARAMETERS to this business role. You can do so in Customizing for UI Framework
under Business Roles
Define
Business Role
.
Features
You can perform the export to spreadsheet by clicking the icon Export to Spreadsheet
, for example, on the top right of the search result list. The export file with the search results is created in a table processing program, for example, Microsoft Excel, and it
then opens. You can use the standard processing of the table processing program to edit and save the export file.
You can export result lists (for example, to review the exported data) of up to hundreds of result lines. However, if you need to export larger amounts of data, you should use BI-focused extraction functions.
Authorization for Export to Spreadsheet
To authorize the export to spreadsheet, you can use authorization object S_GUI
in SAP GUI. This authorization object is assigned to the authorization role SAP_CRM_UIU_FRAMEWORK
, which is delivered in the SAP standard system.
You can disable the export to spreadsheet for individual users by removing the authorization object. You can also disable the authorization for the export to spreadsheet on business role level in Customizing.
To use this function, you must activate the business function UI Framework (UI_FRW_1
).