1615056 - How to connect to SAP datasources from Crystal Reports?

• Failed to connect to SAP Tables.
• Error when reporting on an SAP BW Query in Crystal Reports.
• Reports returns no data, when connecting to SAP Tables from Crystal Reports.
• Crystal Reports list many different ways to connect to an SAP System, but users are not able to connect.
• How to successfully connect to Tables or Functions from SAP ERP, SAP R/3, SAP ECC, or SAP BW Query in Crystal Reports?

• SAP Crystal Reports 2013
• SAP Crystal Reports 2016 
• SAP Crystal Reports 2020

1. In Crystal Reports, create a new report.
      
2. Select one of the following connection:
• SAP BW MDX Query
• SAP Info sets
• SAP Operational Data Store
• SAP Table, Cluster, or Function
    
3. It fails to connect, or there is no data, or have other issues.

• The SAP Connectivity is included in the default installation of the product on the client side, but in order to successfully connect to an SAP System from Crystal Reports, authorizations needs to be set on the SAP Systems, and functions Crystal Reports uses to connect to the SAP System needs to be loaded on the SAP System. Failing to so will result in a wide range of issues.

• To successfully connect and report from an SAP data source from Crystal Reports:
• Load the SAP Integration Kit Transports to the SAP System.
• Set the required Authorizations on the SAP System for the SAP User that will connect to the SAP System from Crystal Reports.
• Ensure the SAP Gateway allows external application, like Crystal Reports to connect to the SAP System.
         
    
• Load the SAP Integration Kit Transports to the SAP System corresponding to the version of Crystal Reports used:
   
  It is very important to load the correct version of the SAP Integration Kit Transports because the transports load the functions Crystal Reports uses to connect to the SAP System, and if the version of the functions does not correspond to the version of Crystal Reports used, then issue will occur.        
     
1. The SAP Integration Kit Transports that are required to load on your SAP System are located in Crystal Reports product installation and update, therefore unzip the product installation package, or product update, corresponding to the version of Crystal Reports you are currently using.   
                
2. Navigate to the following folder: \Collaterals\Add-Ons\SAP\Transports
     
3. In the folder, the following file contains the versions of the SAP Integration Kit Transports to load on your SAP System: transports_EN.txt
   
   Below is an example of an extract of the content of the file displaying the version of the SAP Integration Kit Transports to load: 
   

   * Open SQL Connectivity transport (K900754.R21 and R900754.R21)
   * Info Set Connectivity transport (K900780.r21 and R900780.r21)
   * Row-level Security Definition transport (K900689.r21 and R900689.r21)
   * Cluster Definition transport (K900690.r21 and R900690.r21)
   * Authentication Helpers transport (K900691.r21 and R900691.r21)
   ...

4. The Transport files to load are located in the following folders: 
      
             \Collaterals\Add-Ons\SAP\Transports\unicode_compatible\cofiles
             \Collaterals\Add-Ons\SAP\Transports\unicode_compatible\data
       
5. Contact your SAP BASIS administrators to request them to load the SAP Integration Kit Transports on the SAP System.
     
   Note:
   You do not have to load all the SAP Integration Kit Transports, but only those required for the type of connectivity used. 
   For more information, see the Transports chapter in the following document:
     
              SAP BusinessObjects Integration for SAP Solutions Installation and Administration Guide
    
   The document is available in the Attachments section below, under the name: xi31_sp5_bip_sap_inst_en.pdf   
       
        
   
   
• Set the required Authorizations on the SAP System for the SAP Users that will connect to the SAP System
   
1. The required Authorizations are listed in the Authorizations chapter of the following document:
    
              SAP BusinessObjects Integration for SAP Solutions Installation and Administration Guide
             
   The document is available in the Attachments section below, under the name: xi31_sp5_bip_sap_inst_en.pdf 
        
   Note: The document was written for an older version of Crystal Reports, but the Authorizations and Transports information remain the same for Crystal Reports 2013, 2016 and 2020
            
2. Request the SAP BASIS Administrator to set the required Authorizations for the SAP Users that will be used to connect to the SAP System.
   
       
    
• Configuring the SAP Gateway
      
• To confirm the SAP Gateway is configured to allow your user, your computer, and external application to communicate with the SAP System, see the following SAP Knowledge Base Article:
         
               1408081 - Basic settings for reg_info and sec_info
       
• SAP Gateway configuration should be performed by the SAP BASIS Administrator, If you have any questions or issues setting security for the SAP Gateway, then create a case for the SAP Gateway support, under the component: BC-CST-GW

• 1921554 - How to verify the version of the SAP Integration Kit Transports loaded on the SAP Netweaver or SAP BW System?
• 2177314 - What are the version of the SAP Integration Kit Transports required for Crystal Reports to connect to an SAP System?
• 3037597 - Where can we find the SAP Integration Kit Transports for Crystal Reports?
• 1345919 - How do you load transports provided within the SAP Integration Kit into SAP BW system

CR, SAP IK , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020