2527341 - What tables should be included in a report to return Catalog information for Learning objects?

SAP Knowledge Base Article - Public

2527341 - What tables should be included in a report to return Catalog information for Learning objects?

Symptom

This KBA covers what tables to query to return Catalog information for Learning objects

Environment

SAP SuccessFactors Learning Management System (LMS)

Cause

There are no standard (out of the box) reports in the LMS that return this data

Resolution

An existing report could be modified (or a new report created) that contains this data using the Plateau Report Designer (PRD):

  • The table that contains this data is the PA_CATALOG_ITEM table
  • Some of the fields that could be useful are:
    • CATALOG_ID
    • SKU
    • NOTACTIVE
    • QUAL_ID (Curriculum ID)
    • CPNT_ID (Item ID)
  • For more information the tables and fields available in the LMS Database, please see KBA 2352735 for the LMS Data Dictionary

Important Note: Custom Reporting is handled by Professional Services and not Customer Support.  If assistance is needed, please see KBA 2379690 for more information.

An Enhancement Request to include this as a standard report in future releases:

See Also

  • KBA 2379690 - Custom LMS Reports
  • KBA 2352735 - LMS Data Dictionary
  • KBA 2365997 - Clarification on Item Fields in LMS Data

Keywords

SF SuccessFactors Learning LMS report catalog catalogue learning item curr curricula curriculum qual cpnt program PRD BIRT find retrieve return oob system standard plateau , KBA , LOD-SF-LMS-REP , Reporting Data , Problem

Product

SAP SuccessFactors HCM Core 1705