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?
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
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.
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.
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