SAP Knowledge Base Article - Public

1796006 - No SAP Tables listed, when creating a report in Crystal Reports

Symptom

  • No SAP Tables listed.
  • Unable to see SAP Tables in Crystal Reports.
  • When connecting to an SAP System, it does not show any SAP Tables in Crystal Reports.
  • When creating a new report based on an SAP System, it does not list any SAP Tables in the Database Expert in Crystal Reports.

Environment

  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020
          
  • SAP Netweaver 7.4
  • SAP Netweaver 7.5

Reproducing the Issue

  1. In Crystal Reports, create a new report. 
  2. In the "Database Expert", select: "SAP Tables, Cluster, or Function."
  3. Select an SAP System, and click "Next"
  4. Enter the SAP System Client, Username and Password and click "Finish"
  5. Notice it does not show any SAP Tables.

Cause

  • Access to the SAP Tables were retricted on the SAP System, and therefore this is why no SAP Tables were visible in Crystal Reports.

Resolution

  • Uncheck the option "Allow access only to the tables specified above" on the SAP System:
         
    1. Log on to the SAP System from SAP Logon / GUI
          
    2. Go to transaction: /CRYSTAL/RLS
          
    3. If there are no tables selected under the section "Secures Tables", uncheck the option: "Allow access only to the tables specified above"

Keywords

CR, ECC tables not shown, sap table , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

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