topic Re: text table in Application Development and Automation Discussions

text table

Former Member — Tue, 05 Feb 2008 08:14:27 GMT

what is the advantage to create a text table?plzz tell

Re: text table

Former Member — Tue, 05 Feb 2008 08:16:43 GMT

· Text Tables :

Table A is a text table of Table B if the key of A comprises the key of B and an additional language key field (field of data type LANG). Table A may 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. If table B is the check table of a field, the existing key entries of table B are displayed as possible input values when the input help (F4) is pressed. The explanatory text also displayed in the user's logon language for each key value in table B.

plz reward if useful

vivek

Re: text table

Former Member — Tue, 05 Feb 2008 08:18:52 GMT

hi ,

Check this

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ea9e446011d189700000e8322d00/frameset.htm

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

Check CAWN table ... The text table for this is CAWNT

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

Reward if helpful

Gaurav J.

Re: text table

Former Member — Tue, 05 Feb 2008 08:19:17 GMT

Hi Srinath,

One of the very useful advantages of a text table is, when you view the main table contents from SE16 then the corresponding texts (in logon language) are picked up and shown in the view.

Hence altought the description column is not part of the main table, it is displayed in the content view from SE16.

Regards,

Aditya