text table

[Former Member]

what is the advantage to create a text table?

[Former Member]

Text Tables

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

ALso check this thread.

Check this link for text tables.

https://help.sap.com/saphelp_nw04/helpdata/en/cf/21ea9e446011d189700000e8322d00/content.htm

[Former Member]

Say for any master table like

MANDT

DEPARTMENT NUMBER (Primary Key)

DEPARTMENT DESCRIPTION.

So instead of creating only one table along with the description , its better to create one text table like

table 1.

MANDT

DEPARTMENT NUMBER.

Table 2.

MANDT

DEPARTMENT NUMBER

LANGU

DEPARTMENT DESCRIPTION.

wherein table 2 will have all the primary keys of table 1 plus LANGUAGE field. so that whenever you need to maintain the description in different language its easy to maintain using the text table than maintaining in only one table. The searching becomes optimise because of the key.

hope this is helpful.