SAP Knowledge Base Article - Public

2639687 - How to Restrict the Export to Excel

Symptom

You would like to restrict the Export to Excel action for objects like Opportunities and Leads.

Environment

SAP Hybris Cloud for Customer 1805 and higher versions.

Reproducing the Issue

  1. Go to the Sales work center.
  2. Open the Opportunities view.
  3. The option to Export is available.

Resolution

To hide it, you need to add a Business Action Restriction to the Business Role of the Users you would like to have the option restricted. To do so:

  1. Go to the Administrator work center.
  2. Select Business Roles, under the Users section.
  3. Open Business Role XYZ (XYZ represents the ID of the Business Roles).
  4. Click on View All.
  5. Go to the Fields and Actions tab.
  6. On the Business Action Restrictions section, click on Add Row.
  7. Select the restriction you would like to add.

Currently, we have the following Objects with possibility of restriction for the Export to Excel action:

  • XLS_CRM_ACC_ADD_LIST - Account.
  • XLS_CRM_CONTACT_ADD_LIST - Contact.
  • XLS_CRM_CONTRACT_LIST - Contract.
  • XLS_CRM_LEADMARK_LIST - Lead.
  • XLS_CRM_LEADOPP_WOHO_LIST - Sales Lead.
  • XLS_CRM_LEAN_SALES_ORDER_LIST - Sales Order.
  • XLS_CRM_OPP_LIST - Opportunity.
  • XLS_CRM_QUOTES_LIST - Sales Quote.

If you have the need to restrict the Export to Excel for other objects, you may contact your implementation manager to help with such request or approach directly the SAP Cloud Service Center.

You can find more details about the services offered by Cloud Service Center on https://www.sap.com/services/application-development.html . You can contact Cloud Service Center as follows:

  1. If you are a partner: please use cloudsolutionpartner@sap.com or the Partnerfinder
  2. If you are a customer: please use the little blue box “Contact Us” shown on the very right hand side of https://www.sap.com/services/application-development.html, choose “Contact Us”, choose “Services”, choose “SAP Custom Development” and complete the page

Note: The services of the SAP Cloud Service Center will be charged as packaged services based on fixed prices.

An alternative option may be to check the SAP Customer Influencer Site to submit an idea: https://influence.sap.com/SAPCloudforCustomer.

Keywords

Export to Excel ; Business Action Restriction ; Tickets ; Opportunities ; Sales Quotes ; Sales Leads ; Leads ; Business Role ; Export ; Microsoft Excel , KBA , tickets , business role , export , sales quotes , leads , export to excel , opportunities , sales leads , business action restriction , microsoft excel , LOD-CRM-OPP , Opportunity Management , LOD-CRM-SRP , Service Request Processing , How To

Product

SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions