Text Tables

[Former Member]

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"

[Former Member]

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

[Former Member]

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.

[Former Member]

Thanks for the reply.

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

[Former Member]

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.

[Former Member]

hi

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^

[Former Member]

Hi

We MAKT as a Text table.

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.

If it is helpful rewards points.

Regards

Pratap.M