SAP Knowledge Base Article - Public

3421763 - DB table and column details for Item Image and Image URL data

Symptom

Within an Item, admins can populate the Item Image and Image URL details. Where are these details located within the LMS database?



Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SAP SuccessFactors Learning

Resolution

The Image details are stored in the PA_ATTACHMENT table, and the relationship between the attachment and the item is kept in the PA_ATTACHMENT_CPNT_THUMBNAIL table.

The Image URL details are found in the THUMBNAIL_URI column within the PA_CPNT table.

See Also

Keywords

sf, sfsf, lms, learning, administration, admin, image, item, thumbnail, thumbnail image, url, image url, PA_CPNT, PA_ATTACHMENT, PA_ATTACHMENT_CPNT_THUMBNAIL, THUMBNAIL_URI , KBA , LOD-SF-LMS-CRI , Custom Report Issues , LOD-SF-LMS-ITE , Items , LOD-SF-LMS-REP , Reporting Data , How To

Product

SAP SuccessFactors Learning all versions