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

SAP Knowledge Base Article - Public

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

Symptom

Cannot find the tables when creating a new report off SAP Tables, Cluster, or Function in Crystal Reports

Reproducing the Issue

  1. Create a new report off: SAP Table, Cluster, or Function. 
    ( This option is only available when the Integration for SAP Solutions is installed )
  2. Logon to SAP
  3. Once connected it doesn't list the tables you are looking for
  • Crystal Reports XI R2
  • Crystal Reports 2008
  • BusinessObjects XI 3.0
  • BusinessObjects XI 3.1
  • Integration for SAP Solutions

Cause

Crystal Reports displays by default the first 8000 objects, therefore it is possible there is more than 8000 objects in the SAP data source and the table 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 to accept the change.
  6. Back to the Database Expert window, right click on the connection and select Refresh

You should now be able to see the tables you are looking for under: DD [Data Dictionary]

Keywords

SAP Integration Kit, Crystal Reports, CR, Cluster Tables , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , How To

Product

Crystal Reports 2008 V0 ; Crystal Reports 2008 V1 ; SAP Crystal Reports XI R2