SAP Knowledge Base Article - Public

1796006 - Unable to see SAP table object in Crystal Reports 2011 designer while creating a new report.

Symptom

Unable to see SAP table object in Crystal Reports 2011 designer while creating a new report under Database Expert after selecting the available system.

Environment

  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP NetWeaver

Reproducing the Issue

  1. Create new report in Crystal Reports Designer.
  2. In Database Expert select SAP Tables, Cluster, or Function.
  3. Select the Available SAP systems and click Next.
  4. Enter the Client, Username and Password and click Finish.
  5. The tables are not listed under Data Dictionary (DD) option.

Cause

The SAP tables do not have access and hence are not visible in Crystal Reports designer.

Resolution

  1. Log on to SAP system from SAP Logon.
  2. Go to Transaction /CRYSTAL/RLS
  3. If there are no tables selected under Secures tables section, uncheck the check box “Allow access only to the tables specified above”.

Keywords

Crystal Report SAP tables not listed, ECC tables not shown, cr, sap table , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

SAP Crystal Reports 2011 ; SAP Crystal Reports 2011, feature pack 03 ; SAP Crystal Reports 2013