Value Help for locale property in *_texts Entity of Entities with localized strings

[SebastianEsch]

Hi CAP Community,

we have different entities in our CAP project (Node.js) where we use localized strings. The locale property of the *_texts entities are defined as String and are not associated with a Locales entity by CAP. This makes maintaining translations for those entities in Fiori Elements apps error prone, as the user can enter anything in the locale field.

Is there a way in CAP to link the locale in the *_texts entities to a dedicated Locale entity? If not, how can we provide a user-friendly way to maintain such translations? Or is the localized String feature only intended for data that is not maintained by end users?

Kind regards,

Sebastian

[SebastianEsch]

We have solved the UI part of the question by just adding the required ValueList annotations for the locale property of the *_texts Entity, pointing to the CAP Entity Languages.

That leaves the database integrity part. Is there any intention to link the "locale" field in the *_texts tables to the Languages entity to add referential integrity to the locale in the translation tables?