SAP Knowledge Base Article - Public

2527341 - Standard report available for Items within a Catalog

Symptom

At present there are no standard (out of the box) report in the LMS which returns data for Items assoicated to a Catalog.

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

Environment

SAP SuccessFactors Learning - All Supported Versions

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 you can reference would be PA_CPNT and PA_CATALOG. Some of the fields from PA_CATALOG_ITEM 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 2326249 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.

See Also

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

Keywords

catalog report, PA_CATALOG_ITEM, PA_CPNT, PA_CATALOG , KBA , LOD-SF-LMS-REP , Reporting Data , Problem

Product

SAP SuccessFactors HCM Core 1705