SAP Knowledge Base Article - Public

2896847 - Database table the value for Item Classification is stored in

Symptom

Every Item has an associated classification value. In what database table can this value be sourced.

Environment

SAP SuccessFactors Learning - All Supported Versions

Resolution

This value can be found in the PA_I18N_ACTIVE_LOCALE_LABEL table.

To identify it you will need to reference two additional tables. So for the example in this KBA, PB_CLASS_2, you would need to run the following example query to get the 'Instructor-Led' value

Keywords

PA_CPNT, PS_CPNT_CLASSIFICATION, PA_I18N_ACTIVE_LOCALE_LABEL, Item Classification, Classification
 
, KBA , LOD-SF-LMS-REP , Reporting Data , LOD-SF-LMS-DB , DB Data & Services , How To

Product

SAP SuccessFactors Learning all versions

Attachments

Pasted image.png