SAP Knowledge Base Article - Public

2707316 - To view all database tables within PRD

Symptom

To ensure that as an administrator, you are viewing all the LMS database tables and views which are available to access within PRD.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SAP SuccessFactors Learning

Reproducing the Issue

  1. Connect to Plateau Report Desinger using your VJDBC connection details.
  2. Open an existing report and expand a Data Set. Under the Available Items section expand the Data Source (if necessary) to reveal your Schema.
  3. Expand the Schema and note that some of the tables and views which were expected to be displayed are not available.

Cause

The Preferences options within PRD need to be updated so that all are displayed for your Schema

Resolution

  1. Within PRD, navigate to Window > Preferences > Report Design > Data Set Editor > JDBC Data Set
  2. Note the value for the 'Maximum number of tables in each schema to display:' configuration
  3. Adjust this value to your preference. According to the latest version of the Data Dictionary there are approximately close to 1300 tables and views. Have set this example therefore to 1500 so it should display all.

PRD Tables.jpg

 

See Also

2326249 - How to find the latest version of LMS data dictionary

2379690 - Custom Report Development and Support - LMS

Keywords

PRD. Plateau Report Designer, tables, views, schema, VJDBC, Maximum number of tables in each schema to display, Preferences , KBA , LOD-SF-LMS-PRD , VJDBC Setup or Connection Issues , LOD-SF-LMS-REP , Reporting Data , How To

Product

SAP SuccessFactors Learning all versions