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
- 2090228 - How to Submit Ideas for SAP SuccessFactors Products
- There's a topic about a potential custom report for it in the SAP SuccessFactors Learning Custom Report Exchange Discussions. Note that you need to be a member of the community to access the link.
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