2392038 - PV_STUD_USER materialized view

SAP Knowledge Base Article - Public

2392038 - PV_STUD_USER materialized view


When trying to access/use the PV_STUD_USER materialized view from a report or the Plateau Report Designer (PRD) tool you get an error message that could say that the table is not valid or does not exists or even get a permissions error.


  • LMS Reports environment
  • Plateau Report Designer (PRD)


Anything that starts with PV_ is a “Plateau View”. In more generic database terms, it’s called a “materialized view”. A materialized view is a database object that contains the results of a query. The FROM clause of the query can name tables, views, and other materialized views. Collectively these objects are called master tables (a replication term) or detail tables (a data warehousing term).

PV_STUD_USER is the user custom fields and pulls from the PV_AP_STUD_USER materialized view. The materialized view is built by the Assignment Profile Synchronization APM and each column is a user custom field (e.g. COL_NUM_110 is user custom column 110).

They are not in the data dictionary since they are technically not tables, and the data in the materialized views exists somewhere else in the tables listed in the dictionary, since they are, in fact, just the result of a “built in” SQL statement."


You will have to schedule the Assignment Profile Synchronization APM to run at least once. After the process has run, you will have access to the PV_STUD_USER view.


Plateau Report Designer PRD BIRT PV_STUD_USER materialized view report , KBA , LOD-SF-LMS-PRD , Plateau Report Designer , LOD-SF-LMS-CON , Connectors , How To


SAP SuccessFactors Learning 1511 ; SAP SuccessFactors Learning 1602 ; SAP SuccessFactors Learning 1605 ; SAP SuccessFactors Learning 1608 ; SAP SuccessFactors Learning 1611 ; SAP SuccessFactors Learning 1702 ; SAP SuccessFactors Learning 1705 ; SAP SuccessFactors Learning 1708 ; SuccessFactors Learning 1502 ; SuccessFactors Learning 1505 ; SuccessFactors Learning 1508