2550347 - Can I Convert non reference Field to reference field

SAP Knowledge Base Article - Public

2550347 - Can I Convert non reference Field to reference field

Symptom

We have created field for Item as non reference field and loaded the item data in production. We loaded 17,000 item data and this custom column is populated. Due to client requirements we need to change this custom column from non reference to reference  to make it as dropdown for customer. But the system is not allowing us to make it as reference field now, since the item data is already loaded. Is it still possible to convert non reference field to reference field if it already has records?

Environment

SAP Successfactors Learning Management System - B1708

Reproducing the Issue

1.) As LMS admin create a Custom Column for an item and make it as Non reference (System Admin-Custom Column-Item)

2.) Create an item and make sure that the Custom Column that you created in step 1 has value on it

3.) Once a new item has been created try to change the Custom Column from Non Reference to reference

You will get a validation error

"The custom column cannot be modified to referenced

because certain records already have non-referenced values that would
become invalid"

Cause

This is expected behavior. You cannot change a Non reference field to a reference field if there are already records related to that custom column.

Resolution

You may reach out to our  Professional  services team  (thru your CSM) and they might help you with this.

Or as a workaround

Since you would be aware of the values needed for the
Custom Column, you may create another custom column that is referenced
and add the references to the custom column.

Keywords

The custom column cannot be modified to referenced because certain records already have non-referenced values that would
become invalid; Custom column; Non reference custom column;Reference Custom column , KBA , LOD-SF-LMS-ADM , Admin Tools , Problem

Product

SAP SuccessFactors Learning 1708