2465514 - Help identifying tables/columns for recommended programs on an AP

Symptom

I am looking to find the tables/columns that hold data on Assignment Profiles for the following requirements: Associated Items Associated Recommended Items Associated Programs Associated Recommended Programs

Environment

LMS 17021

Resolution

Please query the following:

PA_RECOMMENDED_CPNT_AP

This will show recommended programs that are in an assignment profile

This will not show Program Titles but will show their CPNT_ID

you can then use this CPNT_ID to query PA_PROGRAM

and get other information about the program such as title etc

Keywords

CPNT_ID PA_PROGRAM

, KBA , LOD-SF-LMS-DB , DB Data & Services , How To

Product

SAP SuccessFactors Learning 1702