SAP Knowledge Base Article - Public

2291924 - Reporting on libraries

Symptom

It is required to have a report which can inform you how many items are in the library, and the information for the item which is assigned to the user lies in which library.

Environment

SAP SuccessFactors Learning 

Resolution

Learning standard reports do not provide this data.

It is possible use the Learning Report Designer (PRD) to build a custom report, below are some information about the tables that can be helpful for the report:

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

  • PA_CATALOG_ITEM, PH_CATALOG_ITEM (History): it gives the data.

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

  • PA_STUD_CPNT /  PH_STUD_CPNT: contains 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.

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

Note: as documented in the KBA 2379690 - Custom Report Development and Support, custom reports troubleshooting and support are beyond Product Support scope. Alternatively, please proceed with the following steps:

  • Use the standards reports from SF Learning system to retrieve the required reporting information;
  • Contact the report developer who built these reports for you or a consultant currently working with you on custom reports;
  • Engage SAP Professional Services via your CSP (see article for more details in the KBA 2149831).

See Also

Keywords

lms, learning, sf, successfactors, user, library, reporting, report, designer, plateau report designer, prd , KBA , LOD-SF-LMS-CRI , Custom Report Issues , LOD-SF-LMS-CAT , Catalog , LOD-SF-LMS , Learning Management System , How To

Product

SAP SuccessFactors Learning all versions