SAP Knowledge Base Article - Public

1374874 - Cannot see SAP tables, clusters or functions in Crystal Reports

Symptom

  • Unable to find an SAP Table, Cluster of Function.
  • No items found, when expending SAP Table, Cluster of Function in Crystal Reports.

Environment

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

Reproducing the Issue

  1. In Crystal Reports, create a new report, and select "SAP Table, Cluster, or Function"
  2. Logon to the SAP System
  3. Once connected it doesn't list the tables, clusters or functions you are looking for.

Cause

  • Crystal Reports displays by default the first 8,000 objects, therefore it is possible there is more than 8000 objects in the SAP data source and the table, cluster of function you are looking for is not listed.

Resolution

  • To view the cluster tables you are looking for, filter the object to display using the Database Options:
    1. When creating a new report, in the Database Expert window, click on SAP Table, Cluster, or Function
    2. Log on to an SAP system.
    3. Once connected, right click on the connection created and select Options
    4. In the Options window, in the Data Explorer area, use the Table name LIKE field to select only a subset of data.
      • Type the full or partial name of the tables you are looking for
      • Use the percentage sign (%) to denote any number of characters
      • Use the underscore (_) to denote one characters
    5. Once done, click OK
    6. Back to the Database Expert window, right click on the connection and select Refresh

Keywords

CR, SAP Integration Kit, Crystal Reports, CR, Cluster Tables , 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