SAP Knowledge Base Article - Public

2707316 - To view all database tables within PRD


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.


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.


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


  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


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


SAP SuccessFactors Learning all versions