SAP Knowledge Base Article - Public

2527341 - Standard report not 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 services and not by the SAP SuccessFactors Learning Technical Support team. If assistance is required, please see KBA 2379690 for more information.

See Also

Keywords

library, report, PA_CATALOG_ITEM, PA_CPNT, PA_CATALOG, custom, prd, standard, available, where, how, create, modify, change , KBA , LOD-SF-LMS-REP , Reporting Data , LOD-SF-LMS , Learning Management System , LOD-SF-LMS-CAT , Catalog , LOD-SF-LMS-ITE , Items , Problem

Product

SAP SuccessFactors Learning all versions