topic Re: text table in Application Development and Automation Discussions

text table

Former Member — Sun, 03 Feb 2008 14:53:12 GMT

what is the advantage to create a text table?

Re: text table

Former Member — Sun, 03 Feb 2008 19:06:03 GMT

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

Re: text table

Former Member — Mon, 04 Feb 2008 01:30:57 GMT

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.