Table fields translations

janebucik

Does anyone know in which table navision stores translations of table fields. Any advice welcome. :roll:

Luc_VanDyck

They are not stored in a table, but stored in the CaptionML-property of the field.

If you need to view all the captions (eg. for translating purposes), you can use the menu Translate -> Export (when you are in the Object Designer) to export all text-elements.

janebucik

I know that they are stored in CaptionML-property. But is it possible to change the field captions without exporting and importing back translations. I would like to do it via C/AL code and not with importing translations or manualy changing field translations. Field translations must be stored somewhere in one of the hidden system tables,just like table Object or table Field that you can not see through object designer, but you can access them via C/AL code. So I would like to find that magic table that holds these translations.Thx for answer

kine

The caption is in Field table, but you cannot change it. This must be done through designer, object import, language modul import, translation import...

janebucik

Thanx for answer.But, are you sure that the caption of the table fields is really stored in table Field? I think that the reason why you can not make any changes in field Caption is that it may be a flowfield pointing to values of some other table that actually conteins table field translations. Does anybody have more experiences with this stuff?

kine

NO. It is not stored in the table. It is not stored in ANY table. It is virtual table - when you want to see some record, the record is filled from somewhere... for example from table definition...