SAP Knowledge Base Article - Public

2527341 - Standard report available for items within a library

Symptom

At present, there is no standard (out of the box) report in Learning which returns data for items associated to a library.

This KBA covers which table(s) to query to return library information for Learning objects when creating a custom report.

Environment

SAP SuccessFactors Learning

Resolution

An existing report could be modified (or a new report created) that contains this data using the Plateau Report Designer (PRD). The main table that contains this data is the "PA_CATALOG_ITEM". Other tables that can be referenced would be the "PA_CPNT" and "PA_CATALOG". Some of the fields from the "PA_CATALOG_ITEM" that could be useful are:

  • CATALOG_ID
  • SKU
  • NOTACTIVE
  • QUAL_ID (Curriculum ID)
  • CPNT_ID (Item ID)

For more information on the tables and fields available in the Learning database, please see KBA 2326249 for the Learning Data Dictionary.

Important Note: Learning custom Reports are handled by the SAP team that delivers Professional Services and not by the SAP SuccessFactors Learning Product Support team. If assistance is needed, please see KBA 2379690 for more information.

See Also

This question was asked in SAP SuccessFactors Community, where a sample Learning custom report is available to download and review. Note that you will have to be a member of the community to access this link.

2090228 - How to Submit Ideas for SAP SuccessFactors Products

Keywords

catalog, library, report, PA_CATALOG_ITEM, PA_CPNT, PA_CATALOG, custom, prd, standard , KBA , LOD-SF-LMS-REP , Reporting Data , LOD-SF-LMS , Learning Management System , LOD-SF-LMS-CAT , Catalog , Problem

Product

SAP SuccessFactors HCM Core 1705