about text table

[Former Member]

what is TEXT TABLE

[Former Member]

Hi,

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

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

Regards

[Former Member]

i want the actual use ? and purpose and at what scenarios abapers use this????

[Former Member]

hi,

Table SMEAL

MANDT CARRID MEALTYPE MEALNUMBER

......Key Fields.....................

Text table SMEALT

MANDT CARRID MEALNUMBER LANGUAGE TEXT

.......Key Fields.............................................

Table SMEAL contains the meals served to the passengers during a flight. The meal names are maintained in table SMEALT.

Table SMEALT is the text table for table SMEAL since the key of SMEALT consists of the key of SMEAL and an additional language key field (field with data type LANG).

Table SMEALT can contain explanatory text in several languages for each key entry of SMEAL.

To link the key entries with the text, the text table SMEALT must be linked with table SMEAL using a

foreign key. Key fields of a text table must be chosen for the type of the foreign key fields.

The foreign key relationship is defined from SMEALT to SMEAL.

Only one text table can be created for a table.

Hope this helps, Do reward.

Edited by: Runal Singh on Mar 6, 2008 2:38 PM

Edited by: Runal Singh on Mar 6, 2008 2:40 PM

[Former Member]

thank you very much, i dun kno how to reward

Edited by: srinivas m on Mar 6, 2008 11:09 AM

[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

Reward if useful

[Former Member]

hi,

ABAP programmers are often suppose to save language depended data within ABAP applications. One of the possible way how to store such a data is to create a text table for transparent table in ABAP dictationary tool (TA code: SE11).

Hope this helps, Do reward.

[Former Member]

HAI Sreenu,

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

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 (contents of the first character-like non-key-field of text table A) is also displayed in the user's logon language for each key value in table B.

Only one text table can be created for table B! The system checks this when you attempt to activate a table with text foreign keys for B.

Regards

Eshwar

[former_member697780]

Hi,

Text table stores descriptions in various languages for each key in the primary table.

Steops:

1. Create a table with Key Fields (ZNCT1).

1.png

2. Create Second Table.

2.png

3. Provide Foreign Key relationship to Key fields.

3.png

4. While providing FK to Id field select ‘Key field of a text table’ in field type.

4.png

5. In Table ZNCT1 in menu bar select Goto – text table