topic Re: Text Tables in Application Development and Automation Discussions

Text Tables

Former Member — Mon, 28 Jan 2008 10:00:38 GMT

HI Experts

What is a text table? Can we create it ? How? How can we utilize it in cheking data consistency issues?

Thanks

~Sid

"Max points are Assured"

Re: Text Tables

Former Member — Mon, 28 Jan 2008 10:03:47 GMT

Hello,


 Text table

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

Cheers,

Vasanth

Re: Text Tables

Former Member — Mon, 28 Jan 2008 10:05:56 GMT

what Exctly text table is:

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.

Regards.

Re: Text Tables

Former Member — Mon, 28 Jan 2008 10:25:53 GMT

Thanks for the reply.

Are we discussing about primary key and foreign key relationship here?

Re: Text Tables

Former Member — Mon, 28 Jan 2008 11:34:46 GMT

Hi,

Those are table where we maintain texts for fields used in the main table. They said about keys bacause text table of a main table is identified using keys.

You can create it as usual tables, but also with a language key to maintain tetxs.

For example ANGT is the Asset catalog text table.

Regards,

Renjith Michael.

Re: Text Tables

Former Member — Mon, 28 Jan 2008 16:54:08 GMT

good

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. Key fields of a text table must be selected here for the type of foreign key fields (see Semantic Attributes of Foreign Keys).

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

thanks

mrutyun^

Re: Text Tables

Former Member — Tue, 29 Jan 2008 04:12:33 GMT

We MAKT as a Text table.

Text table:

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 it is helpful rewards points.

Regards

Pratap.M