SAP Knowledge Base Article - Public

2291924 - Reporting on LMS Catalogues

Symptom

  • Required to have a report which can inform you how many items are in the catalog.
  • Required the information for the item which is assigned to the user lies in which catalog.

Environment

SAP SuccessFactors Learning 

Resolution

LMS standard reports do not provide this data.

But you can use the Learning Report Designer (PRD) to build a custom report, below are some information about the tables you can use for your report:

Required to have a report which can inform you how many items are in the catalog: 

  • PA_CATALOG_ITEM, PH_CATALOG_ITEM (History), it will give you the data.

Required the information for the item which is assigned to the user lies in which catalog:

  • PA_STUD_CPNT /  PH_STUD_CPNT which contain data for the individual "free floating" item assignment,
  • PA_STUD_QUAL_CPNT /  PH_STUD_QUAL_CPNT for items added through a Curriculum
  • PA_STUD_PROGRAM / PH _STUD_PROGRAM for items added through a Program

NOTE: there are no details as to which catalog is related to the training assigned in these tables and there is no table which stored which catalog is assigned to a user.

If you are not familiar with developing custom reports, you can contact a partner or our Professional Services team to create one for you.

Keywords

SAP, SF, LMS, Learning, user, Catalog LMS reporting, learning report designer, plateau report designer , KBA , LOD-SF-LMS , Learning Management System , LOD-SF-LMS-REP , Reporting Data , LOD-SF-LMS-CAT , Catalog , Problem

Product

SAP SuccessFactors Learning all versions