You create text tables when you want to store explanatory text in several languages. It is not advisable to store such texts in your primary table. You can make a text table that must comprise the key of the primary table (for more information, see the example below). Every text table must also have an additional language key field (field of data type LANG).
You can create only one text table for each table. The system checks this when you attempt to activate a table with text foreign keys for the corresponding table.
Table Ais a text table of Table Bif the key of Acomprises the key of Band an additional language key field. Table Acan contain explanatory text in several languages for each key entry of B.
To link the key entries with the text, text Table Amust be linked with Table Busing a foreign key. Key fields of a text tablemust be selected for the type of foreign key fields (for more information, see Semantic Attributes of Foreign Keys ). The following figure presents the relations between the fields in Table Band Text table A.
If Table Bis the check table of a field, the existing key entries of Table Bare displayed as possible input values when the input help (F4) is pressed. The explanatory text (contents of the first character-like non-key-field of text Table A) is also displayed in the user's logon language for each key value in Table B. This is explained in the following figure.
Only one text table can be created for Table B. The system checks this when you attempt to activate a table with text foreign keys for B.