Symptom
- Error: 'Logon failed. You do not have the necessary rights to design reports against the SAP system.' or
- Error: 'Login failed. You do not have the necessary rights to design reports against the SAP system.'
- In Crystal Reports when attempting to create a new report off an SAP data source, it displays the error the user does not have necessary rights.
- Other users can connect, refresh and create new report off an SAP data source.
Environment
- SAP Crystal Reports 2013
- SAP Crystal Reports 2016
- SAP Crystal Reports 2020
Reproducing the Issue
- In Crystal Reports, attempt to create a report off an SAP Table, Cluster or Function.
- Select the SAP system to connect to.
- In the SAP Logon window, enter the SAP user name and password.
- It then displays the following error message:
"Logon failed. You do not have the necessary rights to design against the SAP system."
Cause
- User does not have the appropriate authorizations to perform the action requested on the SAP system.
- User may have some of the authorizations, but their role is missing one or more authorizations on the SAP system.
Resolution
- To be able to report off an SAP data source in Crystal Reports, request the SAP System Administrator to set the appropriate authorizations for the user.
For a list of authorizations that are necessary for each type of SAP connection, consult the document:
SAP BusinessObjects Integration for SAP Solutions Installation and Administration Guide
Note: The document is available in the Attachments section below, under the name: xi3-1_bip_sap_install_en.pdf
In the "Authorizations" chapter, there is a description of each authorizations needed for each type of connection and actions.
Note: Even though the document was written for XI 3.1, the information is valid for Crystal Reports 2013, 2016 and 2020.
- In addition to the authorizations specified in the SAP Integration Kit Installation Guide, the following authorizations are required:
- For Authorization object: S_RFC with Field name: RFC_Name.
According to the installation guide the values should be: SYST, /CRYSTAL/OPENSQL- Additionally you will need the value: SUSR as well.
- Additionally you will need the value: SUSR as well.
- For Authorization object: ZSEGREPORT with field name: ACTVT.
According to the installation guide the value is: 02 (Change) - Additionally you will need the value: 01 (Create or generate) as well.
- Note: If the authorization object doesn't exist on your SAP System, ensure you have loaded the SAP Integration Kit Transports for the version of Crystal Reports and SAP Integration Kit you are using. The SAP Integration Kit Transports will load the required functions and authorization objects that are necessary to connect to the SAP System from Crystal Reports.
Keywords
CR, CRYSTAL REPORTS SAP, LOGON FAILED Crystal Reports SAP R/3 OpenSQL Driver Error , SAP ERP, SAP ECC , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem
Product
Attachments
xi3-1_bip_sap_install_en.pdf |