topic Re: Text table in Application Development and Automation Discussions

Text table

Former Member — Fri, 20 Jul 2007 06:26:52 GMT

Hi Experts ,

I want to create a text table.Can any one please tell me how to create a text table..

Thanks and regards

Sourabh Verma

Re: Text table

Former Member — Fri, 20 Jul 2007 06:33:41 GMT

Create a table with the same key fields (all of them) as your base table and one additional key field for language (Type spras). Define the foreign key relations for each of the key fields. When the pop-up to create the foreign key appears, in the section Semantic Attributes, select the option "Key fields of a text table" for all the key fields. Save and activate the table and it will become the text table of the base table.

Please mark points and close the thread if the solution was useful.

Manoj

Re: Text table

Former Member — Fri, 20 Jul 2007 06:33:44 GMT

Hi..,

In general the text table's name will be "T" attached as the last character for the actual table name...

Check TSTC table ... The text table for this is TSTCT

This Text table contains the Key same as the main table with an Extra field Language as key...

The contents of this table are the texts for the field values....

For example take a field value SE38 in the table TSTC....

The text for this is SBAP Editor !!! This text is maintained in the table TSTCT....

Thanks.

Re: Text table

Former Member — Fri, 20 Jul 2007 06:33:59 GMT

To create a text table just goto SE11 and create table with the same key fields and an additional Key Field SPRAS ( This should be the first key field ). Add a non key field "description" to this table .

Now to enable the linkage of two in te text table create a foreign key relationship to original table with the first key field ( after SPRAS ) and in the cardinality

make it as key field of a text table

<b>

Reward points</b>

Regards

Re: Text table

Former Member — Fri, 20 Jul 2007 06:38:42 GMT

Table A is the text table of table B if the key of A comprises the key of B and an additional language key field (field with data type LANG). Table A can therefore contain explanatory text in several languages for each key entry of B.

To link the key entries with the text, text table A must be linked with table B using a foreign key. Key fields of a text table must be selected for the type of foreign key fields.

Only one text table can be created for a table. When it is activated, the system checks whether another table already has a text foreign key for the specified table.

If a text table exists, it is used at different places in the system to show the text for the key entries in the logon language of the user automatically.

If for example table B is the check table of a field, the existing key entries of table B are displayed as possible input values when F4 is pressed. The explanatory text is also shown in the logon language of the user for each key value.